function printResults($name, $cols, $data) { $attributes = array(); while ($row = OCI_Fetch_Array($cols, OCI_NUM)) { $attributes[] = $row[0]; } echo "<br>INSERT NEW<br>(enter value for each attribute)"; printInsertFields($name, $attributes); echo "<br>UPDATE<br>(search for the row to change, then choose attribute to change and enter new value)<br>"; printUpdateFields($name, $attributes); echo "<br>DELETE<br>(search for the row to delete)<br>"; printDeleteFields($name, $attributes); echo "<br>DATA FROM TABLE " . $name . "<br>"; printTable($attributes, $data); }
<?php for ($it = 0; $it < $numbaggages; $it++) { echo "Enter the weight of bag " . number_format($it + 1) . ":\r\n\t\t\t<input type='number' name='weight{$it}' id='baggages' step='any' style='width:60px' min='0'>Kg<br>"; } ?> </table> <button type="submit" class="pure-button pure-button-primary" name="finalsubmit">Submit</button> </form> <?php } // Connect Oracle... if ($db_conn) { if (array_key_exists('numbaggages', $_POST)) { //echo "I am in insertsubmit<br>"; setcookie('numbaggages', $_POST['numbaggages']); printInsertFields($_POST['numbaggages']); } if (array_key_exists('finalsubmit', $_POST)) { //echo "I am in finalsubmit<br>"; for ($i = 0; $i < $_COOKIE['numbaggages']; $i++) { // echo "For".$i; //Getting the values from user and insert data into the table //set default status to checked in executePlainSQL("\r\n\t\t\t\t\tinsert into has_B values \r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\tbid_sequence.nextval,\t\t\r\n\t\t\t\t\t\t\t\t" . $_COOKIE['cid'] . ",\t\r\n\t\t\t\t\t\t\t\t3,\r\n\t\t\t\t\t\t\t\t" . $_POST['weight' . $i] . ",\r\n\t\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s', time()) . "'\r\n\t\t\t\t\t\t\t)\r\n\t\t\t\t"); OCICommit($db_conn); // Last location executePlainSQL("insert into last_location \r\n\t\t\t\t\tselect bid_sequence.currval as bid, a.code\r\n\t\t\t\t\tfrom Airport a\r\n\t\t\t\t\twhere a.city = '" . $_COOKIE['depcity'] . "' and a.country = '" . $_COOKIE['depcountry'] . "'"); OCICommit($db_conn); //delete cookie setcookie('numbaggages', null, 0); ?>