in form,
- i'm fetching value database, based on input , display in dropdown.
- now, using selected value dropdown want update database preassigned query.
so far, i'm able fetch data in dropdown. i'm not able update db using selected value. when submit, not see errors database not updated. i'm new php, not familiar functions. code below:
<?php $conn = oci_connect("xxx", "xx", "xx"); if (!$conn) { $m = oci_error(); echo $m['message'], "\n"; exit; } $query = "select orders_id,tracking_number table orders_id = :order_bv"; $stid = oci_parse($conn, $query); if (isset($_post['order'])) { $order = $_post['order']; } //$row = oci_fetch_array($stid, oci_assoc); /* if (!$row) { //include ('error_page.php'); exit("the order " . $order . " invalid. please check , try again" ); } */ oci_bind_by_name($stid, ':order_bv', $order); oci_execute($stid); if (isset($_post['updatetr'])) { $conn2 = oci_connect("xxx", "xx", "xx"); if (!$conn2) { $m = oci_error(); echo $m['message'], "\n"; exit; } $query2 = "update table set ship_to_str_dlvr_status='y' tracking_number = :updtr_bv"; $stid2 = oci_parse($conn2, $query2); $updtr = $_post['updtr']; oci_bind_by_name($stid2, ':updtr_bv', $updtr); oci_execute($stid2, oci_commit_on_success); oci_free_statement($stid2); oci_close($conn2); } ?> <!doctype html> <html> <head> <meta charset="utf-8" /> <title>form</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> </head> <body class="blurbg-false" style="background-color:#ebebeb"> <!-- start formoid form--> <link rel="stylesheet" href="form-solid-blue.css" type="text/css" /> <script type="text/javascript" src="jquery.min.js"></script> <form action="<?php echo htmlentities($_server['php_self']); ?>" method="post"> <div class="title"> <h2></h2> <h2>tracking & receiving</h2> </div> <div class="element-input"> <label class="title"></label> <div class="item-cont"> <input class="small" type="text" name="store" placeholder="store #"/> <span class="icon-place"></span> </div> </div> <div class="element-input"> <label class="title"></label> <div class="item-cont"> <input class="medium" type="text" name="userid" placeholder="userid"/> <span class="icon-place"></span> </div> </div> <div class="element-input"> <label class="title"></label> <div class="item-cont"> <input class="large" type="text" name="order" placeholder="order number"/> <span class="icon-place"></span> </div> </div> <div class="submit"> <input type="submit" name="send" value="send"/> </div> <div class="element-separator"> <hr> <h3 class="section-break-title">tracking numbers</h3> </div> <div class="element-multiple"> <label class="title"></label> <div class="item-cont"> <div class="large"> <?php echo '<select data-no-selected="nothing selected" name="updtr" multiple="no">'; while ($row = oci_fetch_array($stid, oci_assoc)) { $data[] = $row; } foreach ($data $value) { //echo "<option value=\"option_1\">" . $value['tracking_number'] . "</option>"; echo "<option value="<?php $value['tracking_number']; ?>"><?php echo $value['tracking_number']; ?></option>"; //echo "selected = 'selected'"; } echo '</select>'; oci_free_statement($stid); oci_close($conn); ?> <span class="icon-place"></span> </div> </div> </div> <div class="submit"> <input type="submit" name="updatetr" value="submit"/> </div> </form> <script type="text/javascript" src="formoid-solid-blue.js"></script> </body> </html>
