API tools faq
paste
Guest User

Untitled

a guest
Dec 11th, 2018
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.29 KB | None | 0 0
raw download clone embed print report
  1. <div class="section-two">
  2. <div class="row bound-box">
  3. <div class="col-lg-8 col-md-8 col-sm-8 col-lg-offset-2 col-md-offset-2 col-sm-offset-2 main clearfix">
  4. <form id="nl-form" class="nl-form" action="searchpubs.php" method="post">
  5. I feel to visit
  6. <select id="category">
  7. <option value="anywhere" selected>anywhere</option>
  8. <option value="pub">a pub</option>
  9. <option value="nightclub">a nightclub</option>
  10. <option value="brewery">a brewery</option>
  11. <option value="stripclub">a gentleman's club</option>
  12. </select>
  13. <br/>that
  14. <select id="foodDrink">
  15. <option value="food" selected>serves food</option>
  16. <option value="drinks">serves drinks only</option>
  17. </select>
  18. and has
  19. <br/>
  20. <select id="extra">
  21. <option value="poolTable" selected>a pool table</option>
  22. <option value="danceFloor">a dance floor</option>
  23. <option value="tv">tv's</option>
  24. <option value="everything">everything</option>
  25. <option value="anything">anything</option>
  26. </select>
  27. . It's within<br>
  28. <select id="distance">
  29. <option value="anyDistance" selected>any distance</option>
  30. <option value="5">5 km</option>
  31. <option value="10">10 km</option>
  32. <option value="15">15 km</option>
  33. <option value="20">20 km</option>
  34. </select>
  35. from me<br> and is open
  36. <select id="hours">
  37. <option value="late" selected>past 12 a.m.</option>
  38. <option value="allDay">all day</option>
  39. <option value="weekdays">on weekdays</option>
  40. <option value="sundays">on sundays</option>
  41. <option value="anytime">anytime</option>
  42. </select>
  43. <div class="nl-submit-wrap">
  44. <button class="nl-submit" type="submit">Find Your Pub</button>
  45. </div>
  46. <div class="nl-overlay"></div>
  47. </form>
  48. </div><!--column-->
  49. </div><!-- row -->
  50. </div><!--section-two-->
  51.  
  52. <?php
  53.  
  54. //DATABASE CONNECTION INFO BELOW:
  55. $hostname="hostname";
  56. $database="dbname";
  57. $username="myusername";
  58. $password="mypassword";
  59.  
  60. $link = mysql_connect($hostname, $username, $password);
  61. if (!$link) {
  62. die('Connection failed: ' . mysql_error());
  63. }
  64.  
  65. $db_selected = mysql_select_db($database, $link);
  66. if (!$db_selected) {
  67. die ('Can't select database: ' . mysql_error());
  68. }
  69.  
  70. mysql_close($link);
  71.  
  72. ?>
  73.  
  74. <html>
  75. <body>
  76. <div class="section-two">
  77. <div class="row bound-box">
  78. <div class="col-lg-8 col-md-8 col-sm-8 col-lg-offset-2 col-md-offset-2 col-sm-offset-2 main clearfix">
  79. <form id="nl-form" class="nl-form" action="searchpubs.php" method="post">
  80. I feel to visit
  81. <select id="category" name="category">
  82. <option value="anywhere" selected>anywhere</option>
  83. <option value="pub">a pub</option>
  84. <option value="nightclub">a nightclub</option>
  85. <option value="brewery">a brewery</option>
  86. <option value="stripclub">a gentleman's club</option>
  87. </select>
  88. <br/>that
  89. <select id="foodDrink" name="foodDrink">
  90. <option value="food" selected>serves food</option>
  91. <option value="drinks">serves drinks only</option>
  92. </select>
  93. and has
  94. <br/>
  95. <select id="extra" name="extra">
  96. <option value="poolTable" selected>a pool table</option>
  97. <option value="danceFloor">a dance floor</option>
  98. <option value="tv">tv's</option>
  99. <option value="everything">everything</option>
  100. <option value="anything">anything</option>
  101. </select>
  102. . It's within<br>
  103. <select id="distance" name="distance">
  104. <option value="anyDistance" selected>any distance</option>
  105. <option value="5">5 km</option>
  106. <option value="10">10 km</option>
  107. <option value="15">15 km</option>
  108. <option value="20">20 km</option>
  109. </select>
  110. from me<br> and is open
  111. <select id="hours" name="hours">
  112. <option value="late" selected>past 12 a.m.</option>
  113. <option value="allDay">all day</option>
  114. <option value="weekdays">on weekdays</option>
  115. <option value="sundays">on sundays</option>
  116. <option value="anytime">anytime</option>
  117. </select>
  118. <div class="nl-submit-wrap">
  119. <button class="nl-submit" type="submit">Find Your Pub</button>
  120. </div>
  121. <div class="nl-overlay"></div>
  122. </form>
  123. </div><!--column-->
  124. </div><!-- row -->
  125. </div><!--section-two-->
  126. </body>
  127. </html>
  128.  
  129. <?php
  130. mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
  131. error_reporting(E_ALL);
  132. ini_set("display_errors", 1);
  133. // error reporting is now turned on
  134.  
  135. echo "start<br/>";
  136. try {
  137. $mysqli= new mysqli('hostname', 'username', 'password', 'dbname'); // change me please
  138. if ($mysqli->connect_error) {
  139. die('Connect Error (' . $mysqli->connect_errno . ') '
  140. . $mysqli->connect_error);
  141. }
  142. echo "I am connected and feel happy.<br/>";
  143. ?>
  144. <table>
  145. <?php
  146. //http://stackoverflow.com/a/9332766/
  147.  
  148. foreach ($_POST as $key => $value) {
  149. echo "<tr>";
  150. echo "<td>";
  151. echo $key;
  152. echo "</td>";
  153. echo "<td>";
  154. echo $value;
  155. echo "</td>";
  156. echo "</tr>";
  157. }
  158.  
  159.  
  160. ?>
  161. </table>
  162. <?php
  163. // make necessary mysqli queries by BINDING parameters with prepared statements
  164.  
  165. // because even though they are from a drop down box, they can be faked
  166.  
  167. // and sql injection can and will occur by some fool out there
  168.  
  169. //$stmt->close();
  170. $mysqli->close();
  171. } catch (mysqli_sql_exception $e) {
  172. throw $e;
  173. }
  174. ?>
  175.  
  176. start
  177. I am connected and feel happy.
  178. category anywhere
  179. foodDrink drinks
  180. extra poolTable
  181. distance 10
  182. hours late
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!