PageRenderTime 49ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/orderpage.php

https://bitbucket.org/ahunting/april-10-projects-5-8
PHP | 350 lines | 303 code | 19 blank | 28 comment | 24 complexity | 23845c4340dc5350cc11e1bfd9884be0 MD5 | raw file
    

  1. <!DOCTYPE html>

    2. 

  2. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"

    3. 

  3.       dir="ltr">

    4. 

  4.   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    5. 

  5.   <head>

    6. 

  6.     <title>Sandwich Shop</title>

    7. 

  7.   </head>

    8. 

  8.   <link rel="stylesheet" type="text/css" href="/style.css" />

    9. 

  9.   <body>

    10. 

  10.     <div style="font-weight: bold; margin-bottom: 20px">Welcome To Whole Foods Sandwich Shop

    11. 

  11.     </div>

    12. 

  12.     <div style="clear:both">

    13. 

  13.       &nbsp;

    14. 

  14.     </div>

    15. 

  15. 

    16. 

  16. <?php

    17. 

  17.   /*

    18. 

  18.   create table orders (

    19. 

  19.   id int not null auto_increment,

    20. 

  20.   total decimal(10,2),

    21. 

  21.   address varchar(100),

    22. 

  22.   pay_type char(5),

    23. 

  23.   card_num int(20),

    24. 

  24.   month int(2),

    25. 

  25.   year int(4),

    26. 

  26.   cvv int(3),

    27. 

  27.   newsletter boolean,

    28. 

  28.   primary key(id)

    29. 

  29.   );

    30. 

  30.   */

    31. 

  31. 

    32. 

  32.   function fill_val($name, $id=0) {

    33. 

  33.     if ($_SERVER['REQUEST_METHOD']=='POST') {

    34. 

  34.       if (empty($_POST[$name])) {

    35. 

  35.         $val="";

    36. 

  36.       }elseif ($id<0) {

    37. 

  37.         if (isset($_POST[$name])) {

    38. 

  38.           $val='1';

    39. 

  39.         }else{

    40. 

  40.           $val='0';

    41. 

  41.         }

    42. 

  42.       }elseif ($id>0) {

    43. 

  43.         $var=$_POST[$name];

    44. 

  44.         $val=$var[$id];

    45. 

  45.       }else{

    46. 

  46.         $val=$_POST[$name];

    47. 

  47.       }

    48. 

  48.     }else{

    49. 

  49.       $val="";

    50. 

  50.     }

    51. 

  51.     return htmlspecialchars($val);

    52. 

  52.   }

    53. 

  53. 

    54. 

  54.   if ($_SERVER['REQUEST_METHOD']=='POST') {

    55. 

  55.     // connect to database

    56. 

  56.     $con = mysql_connect('2011.ispace.ci.fsu.edu', 'amh11u', 'cvrd2n8w');

    57. 

  57.     mysql_select_db('amh11u_sandwiches', $con);

    58. 

  58. 

    59. 

  59.     // retrieve the form

    60. 

  60.     $sandwiches  = $_POST['sandwiches'];

    61. 

  61.     $quantities  = $_POST['quantities'];

    62. 

  62.     $prices      = $_POST['prices'];

    63. 

  63.     $address     = mysql_real_escape_string($_POST['address'], $con);

    64. 

  64.     if (isset($_POST['pay_type'])) $pay_type = $_POST['pay_type'];

    65. 

  65.     $card_num    = mysql_real_escape_string($_POST['card_num'], $con);

    66. 

  66.     $month       = mysql_real_escape_string($_POST['month'], $con);

    67. 

  67.     $year        = mysql_real_escape_string($_POST['year'], $con);

    68. 

  68.     $cvv         = mysql_real_escape_string($_POST['cvv'], $con);

    69. 

  69.     $newsletter  = 0;

    70. 

  70.     if (isset($_POST['newsletter'])) $newsletter=1;

    71. 

  71. 

    72. 

  72.     // check the input is valid

    73. 

  73.     $error=0;

    74. 

  74. 

    75. 

  75.     // check quantity

    76. 

  76.     $total=0;

    77. 

  77.     foreach ($quantities as $quantity) {

    78. 

  78.       if (!empty($quantity)) $total += $quantity;

    79. 

  79.     }

    80. 

  80.     if ($total==0) {

    81. 

  81.       print "<p style=\"color:red;\">You must input the quantity of the sandwiches</p>";

    82. 

  82.       $error++;

    83. 

  83.     }

    84. 

  84. 

    85. 

  85.     // check address

    86. 

  86.     if (empty($address)) {

    87. 

  87.       print "<p style=\"color:red;\">You must input the address</p>";

    88. 

  88.       $error++;

    89. 

  89.     }

    90. 

  90. 

    91. 

  91.     // check pay type

    92. 

  92.     if (empty($pay_type)) {

    93. 

  93.       print "<p style=\"color:red;\">You must input the pay type</p>";

    94. 

  94.       $error++;

    95. 

  95.     }else{

    96. 

  96.       // card number, expire date and cvv must be inputed when pay by credit card

    97. 

  97.       if ($pay_type=='credit') {

    98. 

  98.         if (empty($card_num)) {

    99. 

  99.           print "<p style=\"color:red;\">You must input card number when pay by credit card</p>";

    100. 

  100.           $error++;

    101. 

  101.         }

    102. 

  102.         if (empty($month)) {

    103. 

  103.           print "<p style=\"color:red;\">You must input expire month when pay by credit card</p>";

    104. 

  104.           $error++;

    105. 

  105.         }

    106. 

  106.         if (empty($year)) {

    107. 

  107.           print "<p style=\"color:red;\">You must input expire year when pay by credit card</p>";

    108. 

  108.           $error++;

    109. 

  109.         }

    110. 

  110.         if (empty($cvv)) {

    111. 

  111.           print "<p style=\"color:red;\">You must input cvv when pay by credit card</p>";

    112. 

  112.           $error++;

    113. 

  113.         }

    114. 

  114.       }

    115. 

  115.     }

    116. 

  116. 

    117. 

  117.     if ($error==0) {

    118. 

  118.       // calculate the total pay

    119. 

  119.       $total=0.0;

    120. 

  120.       foreach ($quantities as $id => $quantity) {

    121. 

  121.         if (!empty($quantity)) $total = $total + $prices[$id]*$quantity;

    122. 

  122.       }

    123. 

  123.       // add 7.5% tax

    124. 

  124.       $total = $total + $total * .075;

    125. 

  125. 

    126. 

  126.       // add 1.5% processing fee if pay by credit card

    127. 

  127.       if ($pay_type=='credit') {

    128. 

  128.         $total *= 1.015;

    129. 

  129.       }

    130. 

  130. 

    131. 

  131.       // construct the SQL statement

    132. 

  132.       if ($pay_type=='credit') {

    133. 

  133.         $sql ="INSERT INTO orders(total,address,pay_type,card_num,month,year,cvv,newsletter) ";

    134. 

  134.         $sql.="values($total,'$address','$pay_type',$card_num,$month,$year,$cvv,$newsletter)";

    135. 

  135.       }elseif ($pay_type=='cash') {

    136. 

  136.         $sql ="INSERT INTO orders(total,address,pay_type,newsletter) ";

    137. 

  137.         $sql.="values($total,'$address','$pay_type',$newsletter)";

    138. 

  138.       }

    139. 

  139. 

    140. 

  140.       // execute SQL statement

    141. 

  141.       mysql_query($sql, $con);

    142. 

  142. 

    143. 

  143.       // Is the SQL statment successfully executed?

    144. 

  144.       if (mysql_affected_rows($con)==1) {

    145. 

  145.         print "<p style=\"color:blue;\">Your order:</p>";

    146. 

  146.         print "<table>";

    147. 

  147.         print "<tr><td>sandwich</td><td>&nbsp;</td><td>price</td><td>&nbsp;</td><td>quantity</td></tr>";

    148. 

  148.         foreach ($quantities as $id => $quantity) {

    149. 

  149.           if (!empty($quantity)) {

    150. 

  150.             $sandwich=$sandwiches[$id];

    151. 

  151.             $price   =$prices[$id];

    152. 

  152.             print "<tr><td>$sandwich</td><td>&nbsp;</td><td>$price</td><td>&nbsp;</td><td>$quantity</td></tr>";

    153. 

  153.           }

    154. 

  154.         }

    155. 

  155.         print "</table>";

    156. 

  156.         print "<p style=\"color:blue;\">Total :$".number_format($total,2)."</p>";

    157. 

  157.       }else{

    158. 

  158.         print '<p class="error">Could not submit your order:<br />'

    159. 

  159.               .mysql_error($con).'</p>';

    160. 

  160.         print $sql;

    161. 

  161.       }

    162. 

  162.     }

    163. 

  163. 

    164. 

  164.     // close the connection to database

    165. 

  165.     mysql_close($con);

    166. 

  166.     

    167. 

  167.     print "<hr>";

    168. 

  168.   }

    169. 

  169.   

    170. 

  170. ?>

    171. 

  171. 

    172. 

  172.     <form action="orderpage.php" method="post">

    173. 

  173.     <table>

    174. 

  174.       <tr>

    175. 

  175.         <td>Name:</td>

    176. 

  176.         <td>The Sissy<input type="hidden" name="sandwiches[1]" value="The Sissy" /></td>

    177. 

  177.         <td align="right"><input name="quantities[1]" size="4" value="<?php print fill_val('quantities',1); ?>"/></td>

    178. 

  178.       </tr>

    179. 

  179.       <tr>

    180. 

  180.         <td>Price:</td>

    181. 

  181.         <td>$4.99</td>

    182. 

  182.         <td><input type="hidden" name="prices[1]" value="4.99" /></td>

    183. 

  183.       </tr>

    184. 

  184.       <tr>

    185. 

  185.         <td>Description:</td>

    186. 

  186.         <td colspan="2">Just veggies; no meat on a whole wheat bun</td>

    187. 

  187.       </tr>

    188. 

  188.       <tr>

    189. 

  189.         <td>Calories:</td>

    190. 

  190.         <td colspan="2">450</td>

    191. 

  191.       </tr>

    192. 

  192.       <tr>

    193. 

  193.         <td colspan="3"><hr></td>

    194. 

  194.       </tr>

    195. 

  195.       <tr>

    196. 

  196.         <td>Name:</td>

    197. 

  197.         <td>The Corleone<input type="hidden" name="sandwiches[2]" value="The Corleone" /></td>

    198. 

  198.         <td align="right"><input name="quantities[2]" size="4" value="<?php print fill_val('quantities',2); ?>"/></td>

    199. 

  199.       </tr>

    200. 

  200.       <tr>

    201. 

  201.         <td>Price:</td>

    202. 

  202.         <td>$5.50</td>

    203. 

  203.         <td><input type="hidden" name="prices[2]" value="5.50" /></td>

    204. 

  204.       </tr>

    205. 

  205.       <tr>

    206. 

  206.         <td>Description:</td>

    207. 

  207.         <td colspan="2">Ham and salami with lettuce tomato and onions</td>

    208. 

  208.       </tr>

    209. 

  209.       <tr>

    210. 

  210.         <td>Calories:</td>

    211. 

  211.         <td colspan="2">980</td>

    212. 

  212.       </tr>

    213. 

  213.       <tr>

    214. 

  214.         <td colspan="3"><hr></td>

    215. 

  215.       </tr>

    216. 

  216.       <tr>

    217. 

  217.         <td>Name:</td>

    218. 

  218.         <td>The Mediterranean<input type="hidden" name="sandwiches[3]" value="The Mediterranean" /></td>

    219. 

  219.         <td align="right"><input name="quantities[3]" size="4" value="<?php print fill_val('quantities',3); ?>" ></td>

    220. 

  220.       </tr>

    221. 

  221.       <tr>

    222. 

  222.         <td>Price:</td>

    223. 

  223.         <td>$6.99</td>

    224. 

  224.         <td><input type="hidden" name="prices[3]" value="6.99" /></td>

    225. 

  225.       </tr>

    226. 

  226.       <tr>

    227. 

  227.         <td>Description:</td>

    228. 

  228.         <td colspan="2">Hummus, turkey, tomatoes, and olives on whole wehat</td>

    229. 

  229.       </tr>

    230. 

  230.       <tr>

    231. 

  231.         <td>Calories:</td>

    232. 

  232.         <td colspan="2">500</td>

    233. 

  233.       </tr>

    234. 

  234.       <tr>

    235. 

  235.         <td colspan="3"><hr></td>

    236. 

  236.       </tr>

    237. 

  237.       <tr>

    238. 

  238.         <td>Name:</td>

    239. 

  239.         <td>The Greasy Pizza<input type="hidden" name="sandwiches[4]" value="The Greasy Pizza" /></td>

    240. 

  240.         <td align="right"><input name="quantities[4]" size="4" value="<?php print fill_val('quantities',4); ?>"/></td>

    241. 

  241.       </tr>

    242. 

  242.       <tr>

    243. 

  243.         <td>Price:</td>

    244. 

  244.         <td>$8.00</td>

    245. 

  245.         <td><input type="hidden" name="prices[4]" value="8.00" /></td>

    246. 

  246.       </tr>

    247. 

  247.       <tr>

    248. 

  248.         <td>Description:</td>

    249. 

  249.         <td colspan="2">Meatballs, sauce, pepperoni, and cheese on a white bun</td>

    250. 

  250.       </tr>

    251. 

  251.       <tr>

    252. 

  252.         <td>Calories:</td>

    253. 

  253.         <td colspan="2">1500</td>

    254. 

  254.       </tr>

    255. 

  255.       <tr>

    256. 

  256.         <td colspan="3"><hr></td>

    257. 

  257.       </tr>

    258. 

  258.       <tr>

    259. 

  259.         <td>Name:</td>

    260. 

  260.         <td>The Plain and Simple<input type="hidden" name="sandwiches[5]" value="The Plain and Simple" /></td>

    261. 

  261.         <td align="right"><input name="quantities[5]" size="4" value="<?php print fill_val('quantities',5); ?>"/></td>

    262. 

  262.       </tr>

    263. 

  263.       <tr>

    264. 

  264.         <td>Price:</td>

    265. 

  265.         <td>$5.50</td>

    266. 

  266.         <td><input type="hidden" name="prices[5]" value="5.50" /></td>

    267. 

  267.       </tr>

    268. 

  268.       <tr>

    269. 

  269.         <td>Description:</td>

    270. 

  270.         <td colspan="2">Turkey, lettuce, tomato, and mayo on a wheat bun</td>

    271. 

  271.       </tr>

    272. 

  272.       <tr>

    273. 

  273.         <td>Calories:</td>

    274. 

  274.         <td colspan="2">650</td>

    275. 

  275.       </tr>

    276. 

  276.       <tr>

    277. 

  277.         <td colspan="3"><hr></td>

    278. 

  278.       </tr>

    279. 

  279.       <tr>

    280. 

  280.         <td>Name:</td>

    281. 

  281.         <td>The Porker<input type="hidden" name="sandwiches[6]" value="The Porker" /></td>

    282. 

  282.         <td align="right"><input name="quantities[6]" size="4" value="<?php print fill_val('quantities',6); ?>"/></td>

    283. 

  283.       </tr>

    284. 

  284.       <tr>

    285. 

  285.         <td>Price:</td>

    286. 

  286.         <td>$7.99</td>

    287. 

  287.         <td><input type="hidden" name="prices[6]" value="7.99" /></td>

    288. 

  288.       </tr>

    289. 

  289.       <tr>

    290. 

  290.         <td>Description:</td>

    291. 

  291.         <td colspan="2">Pulled pork, bbq sauce, and cream cheese on a toasted wheat bun</td>

    292. 

  292.       </tr>

    293. 

  293.       <tr>

    294. 

  294.         <td>Calories:</td>

    295. 

  295.         <td colspan="2">1350</td>

    296. 

  296.       </tr>

    297. 

  297.       <tr>

    298. 

  298.         <td colspan="3"><hr></td>

    299. 

  299.       </tr>

    300. 

  300.       <tr>

    301. 

  301.         <td>Name:</td>

    302. 

  302.         <td>The Sub of Insanit<input type="hidden" name="sandwiches[7]" value="The Sub of Insanit" /></td>

    303. 

  303.         <td align="right"><input name="quantities[7]" size="4" value="<?php print fill_val('quantities',7); ?>"/></td>

    304. 

  304.       </tr>

    305. 

  305.       <tr>

    306. 

  306.         <td>Price:</td>

    307. 

  307.         <td>$9.99</td>

    308. 

  308.         <td><input type="hidden" name="prices[7]" value="9.99" /></td>

    309. 

  309.       </tr>

    310. 

  310.       <tr>

    311. 

  311.         <td>Description:</td>

    312. 

  312.         <td colspan="2">The works; all of our toppings on one sandwich</td>

    313. 

  313.       </tr>

    314. 

  314.       <tr>

    315. 

  315.         <td>Calories:</td>

    316. 

  316.         <td colspan="2">2200</td>

    317. 

  317.       </tr>

    318. 

  318.       <tr>

    319. 

  319.         <td colspan="3"><hr></td>

    320. 

  320.       </tr>

    321. 

  321. 

    322. 

  322.   <tr><td>Address</td><td>&nbsp;&nbsp; <textarea name="address" rows="4" cols="50"><?php print fill_val('address'); ?></textarea></td><td></td></tr>

    323. 

  323.   <tr><td>Pay type</td><td>&nbsp;&nbsp; <?php

    324. 

  324.     if (fill_val('pay_type')=='cash') {

    325. 

  325.       print "<input type=\"radio\" name=\"pay_type\" value=\"cash\" checked/>cash";

    326. 

  326.     }else{

    327. 

  327.       print "<input type=\"radio\" name=\"pay_type\" value=\"cash\" />cash";

    328. 

  328.     }

    329. 

  329.     if (fill_val('pay_type')=='credit') {

    330. 

  330.       print "<input type=\"radio\" name=\"pay_type\" value=\"credit\" checked/>credit";

    331. 

  331.     }else{

    332. 

  332.       print "<input type=\"radio\" name=\"pay_type\" value=\"credit\" />credit";

    333. 

  333.     }

    334. 

  334.   ?></td><td></td></tr>

    335. 

  335.   <tr><td>Card number</td><td>&nbsp;&nbsp; <input type="text" name="card_num" size="20" value="<?php print fill_val('card_num'); ?>" /></td><td></td></tr>

    336. 

  336.   <tr><td>Expire mm/yyyy</td><td>&nbsp;&nbsp; <input type="text" name="month" size="2" value="<?php print fill_val('month'); ?>" />/<input type="text" name="year" size="4" value="<?php print fill_val('year'); ?>" /></td><td></td></tr>

    337. 

  337.   <tr><td>CVV</td><td>&nbsp;&nbsp; <input type="text" name="cvv" size="3" value="<?php print fill_val('cvv'); ?>" /></td><td></td></tr>

    338. 

  338.   <tr><td>Subscribe newsletter</td><td>&nbsp;&nbsp; <?php

    339. 

  339.     if (fill_val('newsletter',-1)=='1') {

    340. 

  340.       print "<input type=\"checkbox\" name=\"newsletter\" checked/>";

    341. 

  341.     }else{

    342. 

  342.       print "<input type=\"checkbox\" name=\"newsletter\" />";

    343. 

  343.     }

    344. 

  344.   ?></td><td></td></tr>

    345. 

  345.   <tr><td></td><td>&nbsp;&nbsp; <input type="submit" name="submit" value="order sandwich"/></td><td></td></tr>

    346. 

  346. 

    347. 

  347.     </table>

    348. 

  348.     </form>

    349. 

  349.   </body>

    350. 

  350. </html>

    351. 

  351.