API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 18th, 2017
144
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.72 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. $hostname = "localhost:3306";
  4. $database = "Ebo";
  5. $username = "root";
  6. $password = "cccccccccc";
  7.  
  8. $dbhandle = mysqli_connect($hostname, $username, $password)
  9. or die("Unable to connect to MySQL");
  10.  
  11. mysqli_select_db($dbhandle, 'sys');
  12.  
  13. if (isset($_POST['submit'])) {
  14.  
  15. $fordon = $_POST['Fordonsklass'];
  16. $nr = $_POST['Nr'];
  17. $typ = $_POST['Typ'];
  18. $tillverkning = $_POST['Tillverkning'];
  19. $ar = $_POST['Ar'];
  20. $drivmedel = $_POST['Drivmedel'];
  21. $ansvarig = $_POST['Ansvarig'];
  22.  
  23. $sql = "INSERT INTO fordon (fordon, reg/artkl, typ, tillverkning, modell, drivmedel, ansvarig)
  24. VALUES ('$fordon', '$nr', '$typ', '$tillverkning', '$ar', '$drivmedel', '$ansvarig)'";
  25. $success = mysqli_query($dbhandle, $sql);
  26. if (!$success) {
  27. echo "Nope";
  28. } else {
  29. echo "1 record added";
  30. }
  31. }
  32. mysqli_close($dbhandle);
  33. ?>
  34. <!DOCTYPE html>
  35. <html>
  36. <head>
  37. <meta charset="UTF-8">
  38. <title>Ebo - Lägg till maskin</title>
  39. <link rel="shortcut icon" href="img/favicon.ico" type="image/png">
  40. <link rel="stylesheet" href="css/stylesheet.css" media="screen and (min-width: 1610px)" type="text/css">
  41. <link rel="stylesheet" href="css/stylesheetmedium.css" media="screen and (min-width: 1220px) and (max-width: 1610px)" type="text/css">
  42. <link rel="stylesheet" href="css/stylesheetsmall.css" media="screen and (max-width: 1220px)" type="text/css">
  43. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
  44. </head>
  45. <body>
  46. <div id="header">
  47. <div id="logga">
  48. <a href="start.php">
  49. <img src="img/favicon.ico" alt="logga">
  50. </a>
  51. </div>
  52. <div class="redig"><a id="loggaut" href="index.php">Logga Ut</a></div>
  53. <br>
  54. <div class="redig"><a href="laggtill.php">Lägg Till</a></div>
  55. <div class="redig"><a href="anstallda.php">Anställda</a></div>
  56. <nav>
  57. <h2>Lägg till maskin</h2>
  58. </nav>
  59. </div>
  60. <div id="content" class="fade">
  61. <form id="add" method="post">
  62. <p>Fordonsklass</p>
  63. <input class="till" type="text" name="Fordonsklass" placeholder="Typ av maskin" value="" maxlength="100" required>
  64. <br>
  65. <p>Reg.nr./ Löpnr.</p>
  66. <input class="till" type="text" name="Nr" placeholder="Registreringsnr eller artikelnr" value="" maxlength="100" required>
  67. <br>
  68. <p>Fabrikat/ Typ</p>
  69. <input class="till" type="text" name="Typ" placeholder="Fabrikat eller typ" value="" maxlength="100" required>
  70. <br>
  71. <p>Tillverkning/ Chassinr./ Mätarst.</p>
  72. <input class="till" type="text" name="Tillverkning" placeholder="Tillverkningsnr eller liknande" value="" maxlength="100">
  73. <br>
  74. <p>Årsmodell</p>
  75. <select class="valj" name="Ar">
  76. <option>Välj år</option>
  77. <option>1995</option>
  78. <option>1996</option>
  79. <option>1997</option>
  80. <option>1998</option>
  81. <option>1999</option>
  82. <option>2000</option>
  83. <option>2001</option>
  84. <option>2002</option>
  85. <option>2003</option>
  86. <option>2004</option>
  87. <option>2005</option>
  88. <option>2006</option>
  89. <option>2007</option>
  90. <option>2008</option>
  91. <option>2009</option>
  92. <option>2010</option>
  93. <option>2011</option>
  94. <option>2012</option>
  95. <option>2013</option>
  96. <option>2014</option>
  97. <option>2015</option>
  98. <option>2016</option>
  99. <option>2017</option>
  100. <option>2018</option>
  101. <option>2019</option>
  102. <option>2020</option>
  103. <option>2021</option>
  104. <option>2022</option>
  105. <option>2023</option>
  106. <option>2024</option>
  107. <option>2025</option>
  108. <option>2026</option>
  109. <option>2027</option>
  110. <option>2028</option>
  111. <option>2029</option>
  112. <option>2030</option>
  113. </select>
  114. <br>
  115. <p>Drivmedel</p>
  116. <select class="valj" name="Drivmedel">
  117. <option>Välj drivmedel</option>
  118. <option>Bensin</option>
  119. <option>Diesel</option>
  120. <option>Biogas</option>
  121. <option>El</option>
  122. </select>
  123. <br>
  124. <p>Ansvarig</p>
  125. <select class="valj" name="Ansvarig">
  126. <option>Välj ansvarig</option>
  127. <option>Kajan</option>
  128. <option>Kontoret</option>
  129. <option>Namn</option>
  130. <option>Namn</option>
  131. </select>
  132. <br>
  133. <p>Garanti</p>
  134. <select class="date" name="gÅr" required>
  135. <option>1</option>
  136. <option>2</option>
  137. <option>3</option>
  138. <option>4</option>
  139. <option>5</option>
  140. <option>6</option>
  141. <option>7</option>
  142. <option>8</option>
  143. <option>9</option>
  144. <option>10</option>
  145. <option>11</option>
  146. <option>12</option>
  147. <option>13</option>
  148. <option>14</option>
  149. <option>15</option>
  150. <option>16</option>
  151. <option>17</option>
  152. <option>18</option>
  153. <option>19</option>
  154. <option>20</option>
  155. <option>21</option>
  156. <option>22</option>
  157. <option>23</option>
  158. <option>24</option>
  159. <option>25</option>
  160. <option>26</option>
  161. <option>27</option>
  162. <option>28</option>
  163. <option>29</option>
  164. <option>30</option>
  165. <option>31</option>
  166. </select>
  167. <select class="date" name="gMån" required>
  168. <option>MÅN</option>
  169. <option>JAN</option>
  170. <option>FEB</option>
  171. <option>MAR</option>
  172. <option>APR</option>
  173. <option>MAJ</option>
  174. <option>JUN</option>
  175. <option>JUL</option>
  176. <option>AUG</option>
  177. <option>SEP</option>
  178. <option>OKT</option>
  179. <option>NOV</option>
  180. <option>DEC</option>
  181. </select>
  182. <select class="date" name="gDag" required>
  183. <option>ÅR</option>
  184. <option>2010</option>
  185. <option>2011</option>
  186. <option>2012</option>
  187. <option>2013</option>
  188. <option>2014</option>
  189. <option>2015</option>
  190. <option>2016</option>
  191. <option>2017</option>
  192. <option>2018</option>
  193. <option>2019</option>
  194. <option>2020</option>
  195. <option>2021</option>
  196. <option>2022</option>
  197. <option>2023</option>
  198. <option>2024</option>
  199. <option>2025</option>
  200. <option>2026</option>
  201. <option>2027</option>
  202. <option>2028</option>
  203. <option>2029</option>
  204. <option>2030</option>
  205. </select>
  206. <br>
  207. <p>Besiktning</p>
  208. <select class="valj" name="Besiktning">
  209. <option>Välj månad</option>
  210. <option>JAN</option>
  211. <option>FEB</option>
  212. <option>MAR</option>
  213. <option>APR</option>
  214. <option>MAJ</option>
  215. <option>JUN</option>
  216. <option>JUL</option>
  217. <option>AUG</option>
  218. <option>SEP</option>
  219. <option>OKT</option>
  220. <option>NOV</option>
  221. <option>DEC</option>
  222. </select>
  223. <br>
  224. <p>Service</p>
  225. <select class="date" name="sÅr" required>
  226. <option>1</option>
  227. <option>2</option>
  228. <option>3</option>
  229. <option>4</option>
  230. <option>5</option>
  231. <option>6</option>
  232. <option>7</option>
  233. <option>8</option>
  234. <option>9</option>
  235. <option>10</option>
  236. <option>11</option>
  237. <option>12</option>
  238. <option>13</option>
  239. <option>14</option>
  240. <option>15</option>
  241. <option>16</option>
  242. <option>17</option>
  243. <option>18</option>
  244. <option>19</option>
  245. <option>20</option>
  246. <option>21</option>
  247. <option>22</option>
  248. <option>23</option>
  249. <option>24</option>
  250. <option>25</option>
  251. <option>26</option>
  252. <option>27</option>
  253. <option>28</option>
  254. <option>29</option>
  255. <option>30</option>
  256. <option>31</option>
  257. </select>
  258. <select class="date" name="sMån" required>
  259. <option>MÅN</option>
  260. <option>JAN</option>
  261. <option>FEB</option>
  262. <option>MAR</option>
  263. <option>APR</option>
  264. <option>MAJ</option>
  265. <option>JUN</option>
  266. <option>JUL</option>
  267. <option>AUG</option>
  268. <option>SEP</option>
  269. <option>OKT</option>
  270. <option>NOV</option>
  271. <option>DEC</option>
  272. </select>
  273. <select class="date" name="sDag" required>
  274. <option>ÅR</option>
  275. <option>2010</option>
  276. <option>2011</option>
  277. <option>2012</option>
  278. <option>2013</option>
  279. <option>2014</option>
  280. <option>2015</option>
  281. <option>2016</option>
  282. <option>2017</option>
  283. <option>2018</option>
  284. <option>2019</option>
  285. <option>2020</option>
  286. <option>2021</option>
  287. <option>2022</option>
  288. <option>2023</option>
  289. <option>2024</option>
  290. <option>2025</option>
  291. <option>2026</option>
  292. <option>2027</option>
  293. <option>2028</option>
  294. <option>2029</option>
  295. <option>2030</option>
  296. </select>
  297. <br>
  298. <p>Servicetillval</p>
  299. <select class="välj" name="intervall/ drifttid">
  300. <option>Välj tillval</option>
  301. <option>Serviceintervall (mån)</option>
  302. <option>Drifttid (h)</option>
  303. </select>
  304. <input class="till" type="text" name="Servicetillval" placeholder="Ange antal timmar/ månader" value="" maxlength="100">
  305. <br>
  306. <a class="sub" href="start.php">Avbryt</a>
  307. <input class="sub" name="submit" type="submit" value="Lägg Till">
  308. </form>
  309. </div>
  310. <div id=footer>
  311. </div>
  312. <script type="text/javascript" src="content.js"></script>
  313. </body>
  314. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!