Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Food_Item(
- Fooditem_ID number(10) primary key,
- Food_item_name varchar2(12),
- Menu_ID number(10),
- price number(5,2),
- day_available varchar2(50),
- time_available varchar2(18),
- discount_percentage varchar2(3),
- start_date date,
- deadline date,
- E_ID number(10),
- CONSTRAINT fk_cf_id FOREIGN KEY (E_ID) REFERENCES Chef(E_ID),
- CONSTRAINT fk_menuID FOREIGN KEY (Menu_ID) REFERENCES Menu(Menu_ID)
- );
- <?php // File: anyco.php
- require('anyco_ui.inc.php');
- // Create a database connection
- $conn = oci_connect('system','123','localhost/orcl');
- ui_print_header('FoodItemList');
- do_query($conn, 'SELECT Fooditem_ID,Food_item_name,price,discount_percentage,start_date,deadline FROM Food_Item');
- ui_print_footer(date('Y-m-d H:i:s'));
- // Execute query and display results
- function do_query($conn, $query)
- {
- $stid = oci_parse($conn, $query);
- $r = oci_execute($stid,OCI_DEFAULT);
- print '<table border="1">';
- print '<tr>';
- print '<td>Food_ID<td>Food_Name<td>Price(tk)<td>Discount<td>Dis_start date<td>Dis_finish date';
- while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS))
- {
- print '<tr>';
- foreach ($row as $item)
- {
- print '<td>'.
- ($item!== null ? htmlentities($item) : ' ').'</td>';
- }
- print '</tr>';
- }
- print '</table>';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement