Hi all,Here my code by use while loop I will show the access number values in form after edit the field name="veh_nos_a" I wanna pass the values into update query via the submit button.
Anyone help to clear this.
have a good day!
While loop code:
- $result2=$link->query("SELECT * FROM `Access_card` where unitentry='$unit_no'");
- echo $result11 = mysqli_query($link,$result2);
- $row = mysqli_fetch_array($result11,MYSQLI_ASSOC);
- while ($row = $result2->fetch_assoc())
- {
- $accessnum = $row['accessnum'];
- ?> class="row">class="col-sm-6">
- "text" name="veh_nos_a" id ='accessnum' value="">
- }
- ?>
- class="col-sm-5">
- class="fw-separator">
- "submit" class="previous-form action-button color-bg" name="paym">
- if(isset($_POST['paym']))
- {
- $access = mysqli_real_escape_string($link, $_POST['veh_nos_a']);
- echo $access;
- for($count = 0; $count
- {
- echo $access;
- }
- $result1="UPDATE `res_veh` SET `unit_no` = '$unit_no', access='$acess ' WHERE unit_no = '$unit_no'";
- if ($link->query($result1) === TRUE)
- {
- echo "Record updated successfully";
- } else {
- echo "Error updating record: " . $link->error;
- }
- }
- else
- {
- echo 'error';
- }
Replies
Know the answer? Post it — somebody with the same question will find it here.