Advertisement
Guest User

Untitled

a guest
Apr 1st, 2015
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. create table Food_Item(
  2. Fooditem_ID number(10) primary key,
  3. Food_item_name varchar2(12),
  4. Menu_ID number(10),
  5. price number(5,2),
  6. day_available varchar2(50),
  7. time_available varchar2(18),
  8. discount_percentage varchar2(3),
  9. start_date date,
  10. deadline date,
  11. E_ID number(10),
  12. CONSTRAINT fk_cf_id FOREIGN KEY (E_ID) REFERENCES Chef(E_ID),
  13. CONSTRAINT fk_menuID FOREIGN KEY (Menu_ID) REFERENCES Menu(Menu_ID)
  14. );
  15.  
  16. <?php // File: anyco.php
  17. require('anyco_ui.inc.php');
  18. // Create a database connection
  19. $conn = oci_connect('system','123','localhost/orcl');
  20. ui_print_header('FoodItemList');
  21.  
  22.  
  23. do_query($conn, 'SELECT Fooditem_ID,Food_item_name,price,discount_percentage,start_date,deadline FROM Food_Item');
  24. ui_print_footer(date('Y-m-d H:i:s'));
  25. // Execute query and display results
  26. function do_query($conn, $query)
  27. {
  28. $stid = oci_parse($conn, $query);
  29. $r = oci_execute($stid,OCI_DEFAULT);
  30. print '<table border="1">';
  31. print '<tr>';
  32. print '<td>Food_ID<td>Food_Name<td>Price(tk)<td>Discount<td>Dis_start date<td>Dis_finish date';
  33. while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS))
  34. {
  35. print '<tr>';
  36. foreach ($row as $item)
  37. {
  38. print '<td>'.
  39. ($item!== null ? htmlentities($item) : '&nbsp;').'</td>';
  40. }
  41. print '</tr>';
  42. }
  43. print '</table>';
  44. }
  45.  
  46.  
  47. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement