Banky

Thanks @ ginerjm & jacques.But u guys can do without letting me feel thats d worst piece of code ever written even if it was. I'm a newbie in php who just started out with Google and YouTube resources & u guys r doing a great job of discouraging me.I wrote in here coz I'm not perfect like u guys & have d desire to learn and become better.You guys didnt just wake up one day knowing all u do today. I really don't think the way u just replied is d way to help..but thanks anyway

Thanks for your reply. The thing is those comma separated values were inputs from a multiple-select dropdown from another page, imploded into the same column.Now those values are to be called individually on another form as labels for textarea field so users can fill.So what do u think i should do at this stage please?No solution but to rebuild d database?I will appreciate ur assistance pls

Thanks for your reply. The thing is those comma separated values were inputs from a multiple-select dropdown from another page, imploded into the same column.Now those values are to be called individually on another form as labels for textarea field so users can fill.So what do u think i should do at this stage please?No solution but to rebuild d database?To rebuild the database I will appreciate ur assistance knowing

I'm having a challenge with a mini project i'm working on and have googled for a solution for hours without a headway. Please guys i will appreciate your guidance on this. I have a column in my database table whose contents are generated by exploding a previous form inputs(separated by comma in the table). Now i need to get inputs (from users) for these values using textarea in a form. These inputs will be in arrays depending on the number of contents fetched from the db in the first place and then stored in another column in my table. The issue here is that each time i submit the form i get an undefined index notice for the name of the values in the textarea field,which is test-col []. please see my code below: > <?php $conn = mysqli_connect('localhost', 'root', '', 'myDb'); > $users_id = mysqli_real_escape_string($conn, $_GET['id']); $res = mysqli_query($conn, "SELECT tests FROM bal WHERE users_id = > '$users_id'"); if ($res){ while ($row = > mysqli_fetch_array($res)){ $tests = explode(',', $row['tests']); > foreach($tests as $test){ if ($test =="") { > continue; } echo '<div class="test-res" style="margin-top:10px;"> <form action="" method="post" role="form" > class="form-horizontal"> <div class="form-group"> > <label for= "test-col" class="form-label col-md-2">'.$test.' test</label> > <div class="col-md-10"> > <textarea class="form-control" rows="3" name="test-col[]" placeholder="Test result"> </textarea> > </div> </div> </form> </div>'; '<br /> <br />' ; } } } echo '<form action="" method="post"> <button type="submit" class="btn > btn-success col-md-offset-5" name="sub-res">Send Result</button> > </form>'; ?> > > //to insert textarea values in db <?php if > (isset($_POST['sub-res'])){ $conn = mysqli_connect('localhost', > 'root', '', 'myDb'); foreach ($_POST ['test-col'] as $values){ > $test_results = implode("<br>", $values); } $ins = > mysqli_query($conn, "INSERT INTO bal (results) VALUES > ('$test_results') WHERE users_id = '$users_id'"); if (!$ins){ > die(mysqli_error()); > }else{ echo '<div class="alert alert-success">Successfully sent</div>'; } } > ?>