Advertisement
Guest User

Untitled

a guest
Jul 28th, 2015
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.08 KB | None | 0 0
  1. <?php
  2. error_reporting(E_ALL);
  3. ini_set('display_errors',1);
  4. include 'dbpass.php';
  5. include 'photoUpload.php';
  6.  
  7.  
  8. $mysqli = new mysqli('oniddb.cws.oregonstate.edu', 'hengs-db', $dbpass, 'hengs-db');
  9. if ($mysqli->connect_errno) {
  10. echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
  11. }
  12. ?>
  13.  
  14. <!DOCTYPE html>
  15. <html>
  16. <head>
  17. <meta charset="UTF-8">
  18. <meta name="viewport" content="width=device-width, initial-scale=1">
  19. <title>Feed The Hungry</title>
  20. <!-- Latest compiled and minified CSS -->
  21. <link rel="stylesheet" href="css/bootstrap.css">
  22. <!-- Include Bootstrap Datepicker -->
  23. <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/css/datepicker.min.css" />
  24. <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/css/datepicker3.min.css" />
  25. <style type="text/css">
  26. #eventForm .form-control-feedback {
  27. top: 0;
  28. right: -15px;
  29. }
  30. </style>
  31. </head>
  32.  
  33. <body>
  34. <div class="navbar navbar-default navbar-static-top" role="navigation">
  35. <div class="container">
  36. <div class="navbar-header">
  37. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
  38. <span class="sr-only">Toggle navigation</span>
  39. <span class="icon-bar"></span>
  40. <span class="icon-bar"></span>
  41. <span class="icon-bar"></span>
  42. </button>
  43. <a class="navbar-brand" href="#">Feed the Hungry</a>
  44. </div>
  45. <div class="navbar-collapse collapse">
  46. <ul class="nav navbar-nav">
  47. <li class="active"><a href="index.html">Home</a></li>
  48. <li><a href="#about">About</a></li>
  49. <li><a href="#contact">Contact</a></li>
  50. <li class="dropdown">
  51. <a href="#" class="dropdown-toggle" data-toggle="dropdown">Dropdown <b class="caret"></b></a>
  52. <ul class="dropdown-menu">
  53. <li><a href="#">Action</a></li>
  54. <li><a href="#">Another action</a></li>
  55. <li><a href="#">Something else here</a></li>
  56. <li class="divider"></li>
  57. <li class="dropdown-header">Nav header</li>
  58. <li><a href="#">Separated link</a></li>
  59. <li><a href="#">One more separated link</a></li>
  60. </ul>
  61. </li>
  62. </ul>
  63. <ul class="nav navbar-nav navbar-right">
  64. <li class="active"><a href="./">Static top</a></li>
  65. <li class="dropdown">
  66. <a href="#" class="dropdown-toggle" data-toggle="dropdown">Login<b class="caret"></b></a>
  67. <ul class="dropdown-menu">
  68. <form style="margin: 0px" accept-charset="UTF-8" action="/sessions" method="post">
  69. <!--Citation: http://mimi.kaktusteam.de/blog-posts/2012/02/login-menu-with-twitter-bootstrap/00-->
  70. <div style="margin:0; padding:0; display:inline">
  71. <input name="utf8" type="hidden" value="&#x2713;" /><input name="authenticity_token" type="hidden" value="4L/A2ZMYkhTD3IiNDMTuB/fhPRvyCNGEsaZocUUpw40=" />
  72. </div>
  73. <fieldset class='textbox' style="padding:10px">
  74. <input style="margin-top: 8px" type="text" placeholder="Username" />
  75. <input style="margin-top: 8px" type="password" placeholder="Passsword" />
  76. <input class="btn btn-primary" name="commit" type="submit" value="Log In" />
  77. </fieldset>
  78. </form>
  79. </ul>
  80. </li>
  81. </ul>
  82. </div><!--/.nav-collapse -->
  83. </div>
  84. </div>
  85.  
  86. <div class="container">
  87. <div class="row">
  88. <div class="col-md-8">
  89. <h1>Submit Food Items</h1>
  90. <div id="formContainer">
  91. <form class="form-horizontal" action="add.php" method="post" enctype="multipart/form-data" role="form">
  92. <div class="form-group">
  93. <label class="col-sm-3 control-label" for="foodType">Food Type</label>
  94. <div class="col-sm-9">
  95. <input name="foodType" class="form-control" id="foodType" type="text" placeholder="Enter Food Type" required>
  96. </div>
  97. </div>
  98. <div class="form-group">
  99. <label class="col-sm-3 control-label" for="servings">Number of Servings</label>
  100. <div class="col-sm-9">
  101. <select class="form-control" name="servingSize" id="servings" placeholder="" required>
  102. <option disabled selected>Enter number of servings</option>
  103. <option value="5">1-5</option>
  104. <option value="10">6-10</option>
  105. <option value="20">10-20</option>
  106. <option value="21">20+</option>
  107. </select>
  108. </div>
  109. </div>
  110. <div class="form-group">
  111. <label for="inputPassword" class="col-sm-3 control-label">Eat By</label>
  112. <div class="col-sm-9">
  113. <div class="form-group">
  114. <div class="col-xs-5 date">
  115. <div class="input-group input-append date" id="datePicker">
  116. <input type="text" class="form-control" name="eatByDate" />
  117. <span class="input-group-addon add-on"><span class="glyphicon glyphicon-calendar"></span></span>
  118. </div>
  119. </div>
  120. </div>
  121. </div>
  122. </div>
  123. <div class="form-group">
  124. <label class="col-sm-3 control-label" for="submitButton">Upload photo</label>
  125. <div class="col-sm-9">
  126. <input type="file" name="fileToUpload" id="fileToUpload" class="">
  127. </div>
  128. </div>
  129.  
  130.  
  131.  
  132. <div class="form-group">
  133. <label class="col-sm-3 control-label" for="submitButton"></label>
  134. <div class="col-sm-9 controls">
  135. <input type="submit" id="submitButton" name="submitFood" class="btn btn-primary">
  136. <input type="reset" id="reset" value="Reset" class="btn btn-defa">
  137. <a href="show.php" class="btn btn-primary btn-lg active" role="button">Inventory List</a>
  138. </div>
  139. </div>
  140. </form>
  141. </div>
  142. </div>
  143. <div class="col-md-4">
  144. <div>
  145. <?php
  146. if(isset($_POST['submitFood'])) {
  147. $eatBy = $_POST['eatByDate']; //retrieve eatByDate string
  148. $eatByDate = date("Y-m-d", strtotime($eatBy)); //reformat and create date object
  149. $currentDate = date("Y-m-d"); //create date object
  150. $currentTime = strtotime($currentDate); //convert date obj to sec since Epoch
  151. $eatByTime = strtotime($eatByDate); //convert date obj to sec since Epoch
  152. $photoURL = uploadPhoto();
  153. if($eatByTime < $currentTime) { //prevent database access if invalid eatBy
  154. echo '<div class="alert alert-danger" role="alert"><span class="glyphicon glyphicon-remove"></span>
  155. Sorry, that date has already passed.
  156. </div>';
  157. } else {
  158. if (!($stmt = $mysqli->prepare("INSERT INTO food_items_available(food_type, servings, eat_by, image_URL) VALUES (?,?,?,?)"))) {
  159. echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
  160. }
  161. if (!$stmt->bind_param("siss", $_POST['foodType'], $_POST['servingSize'], $eatByDate, $photoURL)) {
  162. echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
  163. }
  164. if (!$stmt->execute()) {
  165. echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
  166. } else {
  167. echo '<div class="alert alert-success" role="alert"><span class="glyphicon glyphicon-ok"></span>
  168. Thanks! Food items were successfully submitted!
  169. </div>';
  170. }
  171. $stmt->close();
  172. }
  173. }
  174. ?>
  175. </div>
  176. </div>
  177. </div>
  178.  
  179. <div class="navbar navbar-default navbar-fixed-bottom">
  180. <div class="container">
  181. <p class="navbar-text pull-left">Site Built By "Feed The Hungry"</p>
  182. <!--<a class="navbar-btn btn btn-danger pull-right" href="#contact" data-toggle="modal">Need Help?</a>-->
  183. </div>
  184. </div>
  185. </div>
  186. <!--
  187.  
  188. <div class="modal fade" id="contact" role="dialog">
  189. <div class="modal-dialog">
  190. <div class="modal-content">
  191. <form class="form-horizontal" action="#" method="post" role="form">
  192. <div class="modal-header">
  193. <h4>Contact "Feed The Hungry" Group</h4>
  194. </div>
  195. <div class="modal-body">
  196. <div class="form-group">
  197. <label for="contact-name" class="col-lg-2 control-label">Name:</label>
  198. <div class="col-lg-10">
  199. <input type="text" class="form-control" id="contact-name" placeholder="Full Name">
  200. </div>
  201. </div>
  202.  
  203. <div class="form-group">
  204. <label for="contact-email" class="col-lg-2 control-label">Email:</label>
  205. <div class="col-lg-10">
  206. <input type="email" class="form-control" id="contact-email" placeholder="you@example.com">
  207. </div>
  208. </div>
  209.  
  210. <div class="form-group">
  211. <label for="contact-msg" class="col-lg-2 control-label">Message:</label>
  212. <div class="col-lg-10">
  213. <textarea class="form-control" rows="8"></textarea>
  214. </div>
  215. </div>
  216.  
  217. </div>
  218. <div class="modal-footer">
  219. <a class="btn btn-default" data-dismiss="modal">Cancel</a>
  220. <button class="btn btn-primary" type="submit">Send</button>
  221. </div>
  222. </form>
  223. </div>
  224. </div>
  225. </div>
  226. -->
  227. <script src="https://code.jquery.com/jquery.js"></script>
  228. <script src="js/bootstrap.min.js"></script>
  229. <script src="js/prettify.js"></script>
  230. <script src="js/jquery.js"></script>
  231. <script src="js/bootstrap-datepicker.js"></script>
  232. <script src="//cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/js/bootstrap-datepicker.min.js"></script>
  233. <script language="javascript">
  234. /*$('.dropdown-toggle').dropdown();
  235. $('.dropdown-menu').find('form').click(function (e) {
  236. e.stopPropagation();
  237. });*/
  238. </script>
  239. <script>//http://formvalidation.io/examples/bootstrap-datepicker/
  240. $(document).ready(function() {
  241. $('#datePicker').datepicker({
  242. format: 'mm/dd/yyyy'
  243. })
  244. .on('changeDate', function(e) {
  245. //$('#eventForm').formValidation('revalidateField', 'date');
  246. });
  247.  
  248. /* $('#eventForm').formValidation({
  249. framework: 'bootstrap',
  250. icon: {
  251. valid: 'glyphicon glyphicon-ok',
  252. invalid: 'glyphicon glyphicon-remove',
  253. validating: 'glyphicon glyphicon-refresh'
  254. },
  255. fields: {
  256. name: {
  257. validators: {
  258. notEmpty: {
  259. message: 'The name is required'
  260. }
  261. }
  262. },
  263. date: {
  264. validators: {
  265. notEmpty: {
  266. message: 'The date is required'
  267. },
  268. date: {
  269. format: 'MM/DD/YYYY',
  270. message: 'The date is not a valid'
  271. }
  272. }
  273. }
  274. }
  275. });*/
  276. });
  277. </script>
  278. </body>
  279. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement