/php/default.php

https://bitbucket.org/isanneh/diners-best · PHP · 469 lines · 309 code · 145 blank · 15 comment · 3 complexity · 0d4279b789a6d33b5adcb059884896bb MD5 · raw file 

    

  1. <?php
    2. 

  2. //include 'menu.php';
    3. 

  3. session_start();
    4. 

  4. //Include database connection details
    5. 

  5. include('connect.php');
    6. 

  6. 

  7. $root= "http://foodie.comuv.com/";
    8. 

  8. 

  9. $qry= "SELECT * FROM `images` ";
    10. 

  10. $result = @mysql_query($qry);
    11. 

  11. 

  12. $qry2= "SELECT * FROM `hangouts` ";
    13. 

  13. $result2 = @mysql_query($qry2);
    14. 

  14. 

  15. $qryq= "SELECT * FROM `hangouts` ";
    16. 

  16. $resultq = @mysql_query($qryq);
    17. 

  17. 

  18. $qryp= "SELECT * FROM `images` ";
    19. 

  19. $resultp = @mysql_query($qryp);
    20. 

  20. 

  21. $qryp2= "SELECT * FROM `images` ";
    22. 

  22. $resultp2 = @mysql_query($qryp2);
    23. 

  23. 

  24. $qryp3= "SELECT * FROM `images` ";
    25. 

  25. $resultp3 = @mysql_query($qryp3);
    26. 

  26. 

  27. 	
    28. 

  28. ?>
    29. 

  29. 

  30. 

  31. 

  32. <html>
    33. 

  33. <head>
    34. 

  34. <link rel="stylesheet" type="text/css" href="http://foodie.comuv.com/hm31.css" />
    35. 

  35. <link rel="stylesheet" type="text/css" href="http://foodie.comuv.com/funny.css" />
    36. 

  36. <style type="text/css">
    37. 

  37. 

  38. .rollover img {      display : block;
    39. 

  39.                      width : 100px;
    40. 

  40.                      height : 100px;
    41. 

  41.                       }
    42. 

  42. 

  43. 

  44. 

  45. 

  46. .rollover img:hover {  display : block;
    47. 

  47.                       width : 200px;
    48. 

  48.                       height : 200px;
    49. 

  49.                       }
    50. 

  50. 

  51.  ul
    52. 

  52. {
    53. 

  53. list-style-type:none;
    54. 

  54. margin:0;
    55. 

  55. padding:0;
    56. 

  56. }
    57. 

  57. li
    58. 

  58. {
    59. 

  59. display:inline;
    60. 

  60. }
    61. 

  61. 

  62. #MainWrapper {
    63. 

  63. width:100%;
    64. 

  64. width: 1300px; /* you would need to set this to whatever size you wanted your site to be, which would fix the rest of the content with in that */
    65. 

  65. }
    66. 

  66. 

  67. </style>
    68. 

  68. 

  69. 

  70. 

  71. </head>
    72. 

  72. <body>
    73. 

  73. 

  74. <div id="MainWrapper">
    75. 

  75. 

  76. <div id="header">
    77. 

  77. 

  78. <table width="100%">
    79. 

  79. <tr>
    80. 

  80. <td align="left"><a href="user_registration.php">User Registration</a>
    81. 

  81. <a href="restaurant_registration.php">Restaurant Registration</a></td>
    82. 

  82. <td align="right"><a href="login-form.php">Login</a></td>
    83. 

  83. </tr>
    84. 

  84. </table>
    85. 

  85. 

  86. 

  87. </div>
    88. 

  88. <div id="body">
    89. 

  89. 

  90.     
    91. 

  91.    
    92. 

  92. 

  93. <div id="main">
    94. 

  94. 

  95. 			<div id="content-1">
    96. 

  96. 

  97. 

  98. <?php
    99. 

  99. 

  100. /* <ul align="center">
    101. 

  101. <li><a href=\"user_registration.php\">User Registration</a></li>
    102. 

  102. <li><a href=\"restaurant_registration.php\">Restaurant Registration</a></li>
    103. 

  103. <li><a href=\"login-form.php\">Login</a></li>
    104. 

  104. </ul> */
    105. 

  105. 

  106. echo
    107. 

  107. '<table>
    108. 

  108. <tr>';
    109. 

    110. 

  110. if($result)
    111. 

  111. {
    112. 

  112. $j=0;
    113. 

  113. $total2=mysql_num_rows($result);
    114. 

  114. /*$r=mysql_fetch_assoc($result);
    115. 

  115. $p=$result;
    116. 

  116. $split_results=array_chunk($r, 3, true);*/
    117. 

  117. 

  118. echo
    119. 

  119. '
    120. 

  120. <td valign="top">
    121. 

  121. <table>';
    122. 

  122.    while($row=mysql_fetch_assoc($result))
    123. 

  123. //foreach ($split_results as $row)
    124. 

  124.    {
    125. 

  125. $j++;
    126. 

  126. $qry10= "SELECT * FROM `restaurants` WHERE `Restaurant_Id`='".$row['Restaurant_Id']."'";
    127. 

  127. $result10 = @mysql_query($qry10);
    128. 

  128. $row10=mysql_fetch_assoc($result10);
    129. 

  129.    
    130. 

  130.  
    131. 

  131.  
    132. 

  132. echo
    133. 

  133. '
    134. 

  134. <tr><td> 
    135. 

  135. <div id="cover">
    136. 

  136. <p> <a href=\' '.$row['Food_Url'].' \'> '.$row['Food_Name'].' </a> </p>
    137. 

  137. <a  href=\' '.$row['Food_Url'].' \'> <img border="0" src="'.$row['Image_Url'].'"  alt="Profile Picture" width="160" height="150" />  </a>
    138. 

  138. <p> <a href=\' '.$row10['Profile_Url'].' \'> '.$row10['Restaurant_Name'].' </a>  </p>
    139. 

  139. </div>
    140. 

  140. </td>
    141. 

  141. </tr>
    142. 

  142. 

  143. '; 
    144. 

    145. 

  145.    }
    146. 

  146. 

  147. echo '
    148. 

  148. </td>
    149. 

  149. </table>
    150. 

  150. 

  151. <td valign="top">
    152. 

  152. <table>';
    153. 

  153. $tota=mysql_num_rows($resultp);
    154. 

  154.    while($ro=mysql_fetch_assoc($resultp))
    155. 

  155. //foreach ($split_results as $ro)
    156. 

  156.    {
    157. 

  157. 

  158. $j++;
    159. 

  159. $qry10= "SELECT * FROM `restaurants` WHERE `Restaurant_Id`='".$ro['Restaurant_Id']."'";
    160. 

  160. $result10 = @mysql_query($qry10);
    161. 

  161. $row10=mysql_fetch_assoc($result10);
    162. 

  162.    
    163. 

  163.  
    164. 

  164.  
    165. 

  165. echo
    166. 

  166. '
    167. 

  167. <tr><td> 
    168. 

  168. <div id="cover">
    169. 

  169. <p> <a href=\' '.$ro['Food_Url'].' \'> '.$ro['Food_Name'].' </a> </p>
    170. 

  170. <a  href=\' '.$ro['Food_Url'].' \'> <img border="0" src="'.$ro['Image_Url'].'"  alt="Profile Picture" width="160" height="150" />  </a>
    171. 

  171. <p> <a href=\' '.$row10['Profile_Url'].' \'> '.$row10['Restaurant_Name'].' </a>  </p>
    172. 

  172. </div>
    173. 

  173. </td>
    174. 

  174. </tr>
    175. 

  175. '; 
    176. 

    177. 

  177.    }
    178. 

  178. 

  179. echo '
    180. 

  180. </td>
    181. 

  181. </table>
    182. 

  182. 

  183. <td valign="top">
    184. 

  184. <table>';
    185. 

  185. $tota=mysql_num_rows($resultp2);
    186. 

  186.    while($ro2=mysql_fetch_assoc($resultp2))
    187. 

  187. //foreach ($split_results as $ro2)
    188. 

  188.    {
    189. 

  189. 

  190. $j++;
    191. 

  191. $qry10= "SELECT * FROM `restaurants` WHERE `Restaurant_Id`='".$ro2['Restaurant_Id']."'";
    192. 

  192. $result10 = @mysql_query($qry10);
    193. 

  193. $row10=mysql_fetch_assoc($result10);
    194. 

  194.    
    195. 

  195.  
    196. 

  196.  
    197. 

  197. echo
    198. 

  198. '
    199. 

  199. <tr><td> 
    200. 

  200. <div id="cover">
    201. 

  201. <p> <a href=\' '.$ro2['Food_Url'].' \'> '.$ro2['Food_Name'].' </a> </p>
    202. 

  202. <a  href=\' '.$ro2['Food_Url'].' \'> <img border="0" src="'.$ro2['Image_Url'].'"  alt="Profile Picture" width="160" height="150" />  </a>
    203. 

  203. <p> <a href=\' '.$row10['Profile_Url'].' \'> '.$row10['Restaurant_Name'].' </a>  </p>
    204. 

  204. </div>
    205. 

  205. </td>
    206. 

  206. </tr>
    207. 

  207. '; 
    208. 

    209. 

  209.    }
    210. 

  210. 

  211. echo '
    212. 

  212. </td>
    213. 

  213. </table>
    214. 

  214. 

  215. <td valign="top">
    216. 

  216. <table>';
    217. 

  217. $tota=mysql_num_rows($resultp3);
    218. 

  218.    while($ro3=mysql_fetch_assoc($resultp3))
    219. 

  219. //foreach ($split_results as $ro3)
    220. 

  220.    {
    221. 

  221. 

  222. $j++;
    223. 

  223. $qry10= "SELECT * FROM `restaurants` WHERE `Restaurant_Id`='".$ro3['Restaurant_Id']."'";
    224. 

  224. $result10 = @mysql_query($qry10);
    225. 

  225. $row10=mysql_fetch_assoc($result10);
    226. 

  226.    
    227. 

  227.  
    228. 

  228.  
    229. 

  229. echo
    230. 

  230. '
    231. 

  231. <tr><td> 
    232. 

  232. <div id="cover">
    233. 

  233. <p> <a href=\' '.$ro3['Food_Url'].' \'> '.$ro3['Food_Name'].' </a> </p>
    234. 

  234. <a  href=\' '.$ro3['Food_Url'].' \'> <img border="0" src="'.$ro3['Image_Url'].'"  alt="Profile Picture" width="160" height="150" />  </a>
    235. 

  235. <p> <a href=\' '.$row10['Profile_Url'].' \'> '.$row10['Restaurant_Name'].' </a>  </p>
    236. 

  236. </div>
    237. 

  237. </td>
    238. 

  238. </tr>
    239. 

  239. '; 
    240. 

    241. 

  241.    }
    242. 

  242. 

  243. echo '
    244. 

  244. </td>
    245. 

  245. </table>
    246. 

  246. 

  247. <td valign="top">
    248. 

  248. <table>';
    249. 

    250. 

  250. if($result2)
    251. 

  251. {
    252. 

  252. 

  253. $total=mysql_num_rows($result2);
    254. 

  254. 

  255. while($row2=mysql_fetch_assoc($result2))
    256. 

  256. {
    257. 

  257. 

  258. echo '<tr><td>
    259. 

  259. <div id="cover">';
    260. 

    261. 

  261. $qry3= "SELECT * FROM `hangout_info` WHERE `Hangout_Id`='".$row2['Hangout_Id']."'";
    262. 

  262. $result3 = @mysql_query($qry3);
    263. 

  263. $row3=mysql_fetch_assoc($result3);
    264. 

  264. 

  265. $qry4= "SELECT * FROM `hangout_attendees` WHERE `Hangout_Id`='".$row2['Hangout_Id']."'";
    266. 

  266. $result4 = @mysql_query($qry4);
    267. 

  267. $row4=mysql_fetch_assoc($result4);
    268. 

  268. 

  269. $qry5= "SELECT * FROM `restaurants` WHERE `Restaurant_Id`='".$row2['Restaurant_Id']."'";
    270. 

  270. $result5 = @mysql_query($qry5);
    271. 

  271. $row5=mysql_fetch_assoc($result5);
    272. 

  272. 

  273. $spots_taken=mysql_num_rows($result4);
    274. 

  274. $spots_left=$row2['People']- $spots_taken;
    275. 

  275. 

  276.  echo
    277. 

  277. '
    278. 

  278. <p> <a href=\' '.$row3['Url'].' \'> '.$row2['Title'].' </a>  @ <a href=\' '.$row5['Profile_Url'].' \'> '.$row5['Restaurant_Name'].'  </a>   </p>
    279. 

  279. <p>Date: '.$row2['Month'].' '.$row2['Day'].' '.$row2['Year'].' @ '.$row2['Time'].' </p>
    280. 

  280. 

  281. 

  282. </div>
    283. 

  283. </td>
    284. 

  284. </tr>
    285. 

  285. ';
    286. 

    287. 

  287.  
    288. 

  288. }
    289. 

  289. 

  290. 

  291. 

  292. }
    293. 

  293. else
    294. 

  294. {
    295. 

  295. die('Query failed!');
    296. 

  296. }
    297. 

  297. 

  298. 

  299. 

  300. echo '
    301. 

  301. </td>
    302. 

  302. </table>
    303. 

  303. 

  304. <td valign="top">
    305. 

  305. <table>';
    306. 

    307. 

  307. if($resultq)
    308. 

  308. {
    309. 

  309. 

  310. $total=mysql_num_rows($resultq);
    311. 

  311. 

  312. while($row2=mysql_fetch_assoc($resultq))
    313. 

  313. {
    314. 

  314. 

  315. echo '<tr><td>
    316. 

  316. <div id="cover">';
    317. 

    318. 

  318. $qry3= "SELECT * FROM `hangout_info` WHERE `Hangout_Id`='".$row2['Hangout_Id']."'";
    319. 

  319. $result3 = @mysql_query($qry3);
    320. 

  320. $row3=mysql_fetch_assoc($result3);
    321. 

  321. 

  322. $qry4= "SELECT * FROM `hangout_attendees` WHERE `Hangout_Id`='".$row2['Hangout_Id']."'";
    323. 

  323. $result4 = @mysql_query($qry4);
    324. 

  324. $row4=mysql_fetch_assoc($result4);
    325. 

  325. 

  326. $qry5= "SELECT * FROM `restaurants` WHERE `Restaurant_Id`='".$row2['Restaurant_Id']."'";
    327. 

  327. $result5 = @mysql_query($qry5);
    328. 

  328. $row5=mysql_fetch_assoc($result5);
    329. 

  329. 

  330. $spots_taken=mysql_num_rows($result4);
    331. 

  331. $spots_left=$row2['People']- $spots_taken;
    332. 

  332. 

  333.  echo
    334. 

  334. '
    335. 

  335. <p> <a href=\' '.$row3['Url'].' \'> '.$row2['Title'].' </a>  @ <a href=\' '.$row5['Profile_Url'].' \'> '.$row5['Restaurant_Name'].'  </a>   </p>
    336. 

  336. <p>Date: '.$row2['Month'].' '.$row2['Day'].' '.$row2['Year'].' @ '.$row2['Time'].' </p>
    337. 

  337. 

  338. 

  339. </div>
    340. 

  340. </td>
    341. 

  341. </tr>
    342. 

  342. ';
    343. 

    344. 

  344.  
    345. 

  345. }
    346. 

  346. 

  347. 

  348. 

  349. }
    350. 

  350. else
    351. 

  351. {
    352. 

  352. die('Query failed!');
    353. 

  353. }
    354. 

  354. 

  355. 

  356. 

  357. echo '
    358. 

  358. </td>
    359. 

  359. </table>
    360. 

  360. 

  361. </tr>
    362. 

  362. </table>';
    363. 

    364. 

  364. }
    365. 

  365. 

  366. else
    367. 

  367. {
    368. 

  368. die('Query failed!');
    369. 

  369. }
    370. 

  370. 

  371. 

  372. 

  373. 

  374. 

  375. 

  376. 

  377. ?>
    378. 

  378. 

  379. 

  380. 			
    381. 

  381. </div>
    382. 

  382. 

  383. <?php
    384. 

  384. echo '<div id="footer" >';
    385. 

  385. 

  386. 

  387. 

  388. 

  389. $qry6= "SELECT * FROM `users` ";
    390. 

  390. $result6 = @mysql_query($qry6);
    391. 

  391. 

  392. 

  393. 

  394. 

  395. while($row6=mysql_fetch_assoc($result6))
    396. 

  396. {
    397. 

  397. 

  398. 

  399. 

  400. 

  401. echo '<a  href=\' '.$row6['Profile_Url'].' \'> <img border="0" src="'.$row6['Profile_Image_Url'].'"  alt="Profile Picture" width="50" height="50" />  </a>';
    402. 

  402. 

  403. 

  404. 

  405. 

  406. $Profile_Url= "http://foodie.comuv.com/isanneh.php";
    407. 

  407. $Profile_Image_Url= "http://foodie.comuv.com/user/isanneh/profile_picture.jpg";
    408. 

  408. 

  409. 

  410. 

  411. }
    412. 

  412. 

  413. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    414. 

  414. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    415. 

  415. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    416. 

  416. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    417. 

  417. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    418. 

  418. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    419. 

  419. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    420. 

  420. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    421. 

  421. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    422. 

  422. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    423. 

  423. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    424. 

  424. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    425. 

  425. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    426. 

  426. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    427. 

  427. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    428. 

  428. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    429. 

  429. echo '<a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a>';
    430. 

  430. 

  431. 

  432. 

  433. 

  434. 

  435. echo '</div>';
    436. 

  436. 

  437. 

  438. echo '
    439. 

  439. <table>
    440. 

  440. <tr>
    441. 

  441. <td>
    442. 

  442. <table>
    443. 

  443. <tr><td><a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a></td></tr>';
    444. 

  444. echo '<tr><td><a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" /> </a></td></tr></table>
    445. 

  445. </td>
    446. 

  446. <td>
    447. 

  447. <table> ';
    448. 

  448. echo '<tr><td><a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a></td></tr>';
    449. 

  449. echo '<td><a  href=\' '.$Profile_Url.' \'> <img border="0" src="'.$Profile_Image_Url.'"  alt="Profile Picture" width="50" height="50" />  </a></td></tr>
    450. 

  450. </table>
    451. 

  451. </td>
    452. 

  452. </tr>
    453. 

  453. </table>';
    454. 

  454. ?>
    455. 

  455. 

  456. </div>
    457. 

  457. 

  458. </div>
    459. 

  459. 

  460. 

  461. 

  462. </body>
    463. 

  463. </html>
    464.