API tools faq
paste
Guest User

Untitled

a guest
Nov 3rd, 2017
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.64 KB | None | 0 0
raw download clone embed print report
  1. <form action="/config/php/insert_opp.php" method="post">
  2. <div class="panel-body">
  3. <div class="well">
  4. <div class="row">
  5. <div class="col-sm-12">
  6. <div class="well" id="well_3">
  7. <h2><b>Oppskrift</b></h2>
  8. <p><i>Her kan du lage dine egene
  9. oppskrifter.</i></p>
  10. </div>
  11. </div>
  12. </div>
  13. </div>
  14. <div class="well">
  15. <div class="row">
  16. <div class="col-sm-4">
  17. <input class="input_1" type="text"
  18. id="oppskrift_navn" placeholder="Navn" name="navn">
  19. </div>
  20. <div class="col-sm-4">
  21. <input class="input_1" type="text"
  22. id="antall" placeholder="Antall" name="antall">
  23. </div>
  24. <div class="col-sm-4">
  25. <input class="input_1" type="text"
  26. id="holdbarhet" placeholder="Holdbarhet" name="holdbar">
  27. </div>
  28. </div>
  29. <br>
  30. <div class="row">
  31. <div class="col-sm-12">
  32. <textarea class="input_2" id="beskrivelse"
  33. placeholder="Fremgangsmetode" name="fremgang"></textarea>
  34. </div>
  35. </div>
  36. </div>
  37. <div class="well">
  38. <div class="row">
  39. <div class="col-sm-12">
  40. <div class="well" id="well_2">
  41. <h4><b>Allergener</b></h4>
  42. <p><i>Kryss ut hvilke allergener
  43. oppskriften inneholder</i></p>
  44. </div>
  45. </div>
  46. </div>
  47. <div class="row">
  48. <div class="col-sm-3">
  49. <div class="well" id="well_1">
  50. <input type="checkbox" id="byg"
  51. name="byg">&ensp;Bygg<br>
  52. <input type="checkbox"
  53. id="autraliannøtter" name="autraliannøtter">&ensp;Autraliannøtter<br>
  54. <input type="checkbox" id="bløtdyr"
  55. name="bløtdyr">&ensp;Bløtdyr<br>
  56. <input type="checkbox" id="cashewnøtter"
  57. name="cashewnøtter">&ensp;Cashewnøtter<br>
  58. <input type="checkbox" id="fisk"
  59. name="fisk">&ensp;Fisk<br>
  60. <input type="checkbox" id="havre"
  61. name="havre">&ensp;Havre<br>
  62. </div>
  63. </div>
  64. <div class="col-sm-3">
  65. <div class="well" id="well_1">
  66. <input type="checkbox" id="hvete"
  67. name="hvete">&ensp;Hvete<br>
  68. <input type="checkbox" id="lupin"
  69. name="lupin">&ensp;Lupin<br>
  70. <input type="checkbox" id="mandler"
  71. name="mandler">&ensp;Mandler<br>
  72. <input type="checkbox" id="melk"
  73. name="melk">&ensp;Melk<br>
  74. <input type="checkbox" id="peanøtter"
  75. name="peanøtter">&ensp;Peanøtter<br>
  76. <input type="checkbox" id="pekannøtter"
  77. name="pekannøtter">&ensp;Pekannøtter<br>
  78. </div>
  79. </div>
  80. <div class="col-sm-3">
  81. <div class="well" id="well_1">
  82. <input type="checkbox"
  83. id="pistasienøtter" name="pistasienøtter">&ensp;Pistasienøtter<br>
  84. <input type="checkbox" id="rug"
  85. name="rug">&ensp;Rug<br>
  86. <input type="checkbox" id="selleri"
  87. name="selleri">&ensp;Selleri<br>
  88. <input type="checkbox" id="sennep"
  89. name="sennep">&ensp;Sennep<br>
  90. <input type="checkbox" id="sesamfrø"
  91. name="sesamfrø">&ensp;Sesamfrø<br>
  92. <input type="checkbox" id="skalldyr"
  93. name="skalldyr">&ensp;Skalldyr<br>
  94. </div>
  95. </div>
  96. <div class="col-sm-3">
  97. <div class="well" id="well_1">
  98. <input type="checkbox" id="soya"
  99. name="soya">&ensp;Soya<br>
  100. <input type="checkbox" id="spelt"
  101. name="spelt">&ensp;Spelt<br>
  102. <input type="checkbox" id="sulfit"
  103. name="sulfit">&ensp;Sulfit<br>
  104. <input type="checkbox" id="valnøtter"
  105. name="valnøtter">&ensp;Valnøtter<br>
  106. <input type="checkbox" id="egg"
  107. name="egg">&ensp;Egg<br>
  108. </div>
  109. </div>
  110. </div>
  111. </div>
  112. <div class="well">
  113. <div class="row">
  114. <div class="col-sm-12">
  115. <div class="well" id="well_3">
  116. <div class="table-responsive">
  117. <table class="table table-bordered
  118. table-hover" id="tab_logic">
  119. <thead>
  120. <tr>
  121. <th>#</th>
  122. <th>Varenavn</th>
  123. <th>Mengde</th>
  124. <th>Enhet</th>
  125. <th>Pris</th>
  126. </tr>
  127. </thead>
  128. <tfoot>
  129. <tr>
  130. <td></td>
  131. <td></td>
  132. <td></td>
  133. <td></td>
  134. <td><a id="add_row"
  135. class="btn btn-success pull-right">Add Row</a><a id='delete_row'
  136. class="pull-right btn btn-danger">Delete Row</a></td>
  137. </tr>
  138. </tfoot>
  139. <tbody>
  140. <tr id='addr0'>
  141. <td>
  142. 1
  143. </td>
  144. <td>
  145. <input type="text"
  146. name='name0' placeholder='Varenavn' class="form-control" />
  147. </td>
  148. <td>
  149. <input type="text"
  150. name='mengde0' placeholder='Mengde' class="form-control" />
  151. </td>
  152. <td>
  153. <select
  154. name='enhet0' placeholder='Enhet' class='form-control input-md'>
  155.  
  156. <option>KG</option>
  157.  
  158. <option>GR</option>
  159.  
  160. <option>L</option>
  161.  
  162. <option>DL</option>
  163. </select>
  164. </td>
  165. <td>
  166. <input type="text"
  167. `enter code here`name='pris0' placeholder='Pris' class="form-control" />
  168. </td>
  169. </tr>
  170. <tr id='addr1'></tr>
  171. </tbody>
  172. </table>
  173. </div>
  174. </div>
  175. </div>
  176. </div>
  177. </div>
  178.  
  179. <?php
  180. $servername = "*******";
  181. $username = "***********";
  182. $password = "************";
  183. $db = "*******"
  184.  
  185. // Create connection
  186. $conn = new mysqli($servername, $username, $password, $db);
  187.  
  188. // Check connection
  189. if ($conn->connect_error) {
  190. die("Connection failed: " . $conn->connect_error);
  191. }
  192. echo "Connected successfully";
  193.  
  194. // Query
  195.  
  196. $sql = ("INSERT INTO `oppskrift` (`opp_navn`, `antall`, `holdbarhet`, `besrkivelse`)
  197. VALUES ('$navn', '$antall', '$holdbar', '$fremgang')"
  198. );
  199.  
  200. if ($conn->query($sql) === TRUE) {
  201. echo "New record created successfully";
  202. } else {
  203. echo "Error: " . $sql . "<br>" . $conn->error;
  204. }
  205.  
  206. $conn->close();
  207. ?>
  208.  
  209. CREATE TABLE `oppskrift` (
  210. `id` INT(11) NOT NULL AUTO_INCREMENT,
  211. `opp_navn` VARCHAR(255) NULL DEFAULT NULL,
  212. `antall` VARCHAR(255) NULL DEFAULT NULL,
  213. `holdbarhet` VARCHAR(50) NULL DEFAULT NULL,
  214. `beskrivelse` TEXT NULL,
  215. `pris` VARCHAR(50) NULL DEFAULT NULL,
  216. PRIMARY KEY (`id`)
  217. )
  218. COLLATE='latin1_swedish_ci'
  219. ENGINE=InnoDB
  220. AUTO_INCREMENT=3
  221. ;
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!