API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 27th, 2015
188
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.61 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include_once ("db.php");
  3. if (isset ($_POST ['save']))
  4. {
  5. $print_r($POST);
  6. $receivedate = date('Y-m-d',strtotime ($_POST ['receivedate']));
  7. $cgdate = date('Y-m-d',strtotime ($_POST ['cgdate']));
  8. $invoicedate = date('Y-m-d',strtotime ($_POST ['invoicedate']));
  9. foreach ($_POST as $key => $value) {
  10. $_POST [$key] = addslashes (strip_tags(trim ($value)));
  11.  
  12. $sql= mysqli_query ($conn, "INSERT INTO tblservice
  13. (receivedate, clientname, clientstreet, clientbl, clientsc, clientap, clientet, clientjud, clientloc, clientphone, clientemail, store, av, functia,
  14. storephone, product, productbrand, productmodel, sn, aspect, accesorii, cgnumber, cgdate, invoicenumber, invoicedate, defect, servunit, servphone,
  15. servadress, servcontact)
  16. VALUES ('{$receivedate}',
  17. '{$_POST['clientname']}',
  18. '{$_POST ['clientstreet']}',
  19. '{$_POST ['clientbl']}',
  20. '{$_POST ['clientsc']}',
  21. '{$_POST ['clientap']}',
  22. '{$_POST ['clientet']}',
  23. '{$_POST ['clientjud']}',
  24. '{$_POST ['clientloc']}',
  25. '{$_POST ['clientphone']}',
  26. '{$_POST ['clientemail']}',
  27. '{$_POST ['store']}',
  28. '{$_POST ['av']}',
  29. '{$_POST ['functia']}',
  30. '{$_POST ['storephone']}',
  31. '{$_POST ['product']}',
  32. '{$_POST ['productbrand']}',
  33. '{$_POST ['productmodel']}',
  34. '{$_POST ['sn']}',
  35. '{$_POST ['aspect']}',
  36. '{$_POST ['accesorii']}',
  37. '{$_POST ['cgnumber']}',
  38. '{$cgdate}',
  39. '{$_POST ['invoicenumber']}',
  40. '{$invoicedate}',
  41. '{$_POST ['defect']}',
  42. '{$_POST ['servunit']}',
  43. '{$_POST ['servphone']}',
  44. '{$_POST ['servadress']}',
  45. '{$_POST ['servcontact']}'
  46. )");
  47. if ($sql) {
  48. echo "Inregistrare Salvata cu Succes!!!";
  49. header ('location:view.php');
  50. }
  51. else {
  52. echo "Eroare Inregistrare";
  53. }
  54. }
  55.  
  56. }
  57. ?>
  58. <?php
  59. include_once ("head.php");
  60. ?>
  61. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  62. <html xmlns="http://www.w3.org/1999/xhtml">
  63. <body>
  64. <div class="container-fluid">
  65. <div class="container-fluid">
  66. <div id="altexlogo">
  67. <a href="index.php">
  68. <img src="assets/images/logo_altex_print.png"; class="img-responsive"; alt="altex logo"; />
  69. </a>
  70. </div>
  71. <div id="mediagalaxylogo">
  72. <a href="index.php">
  73. <img src="assets/images/mediagalaxy.png"; class="img-responsive"; alt="mediagalaxy logo"; />
  74. </a>
  75. </div>
  76. </div>
  77. <div class="container-fluid">
  78. <nav class="navbar-default">
  79. <div class="container">
  80. <div class="navbar">
  81. <ul class="nav navbar-nav navbar-center">
  82. <li class="active"><a href="index.php">Adauga Fisa</a></li>
  83. <li><a href="view.php">Gestionare Fise</a></li>
  84. <li>
  85. <form action="search.php?go" method="post" id="searchform" name="searchform" enctype="multipart/formdata">
  86. <div class="container-fluid">
  87. <input type="text" class="form-control" id="searchbox" name="id" placeholder="Introduceti Numar Fisa">
  88. </div>
  89. </li>
  90. <li>
  91. <div class="form-group">
  92. <input type="submit" value="search" id="searchbutton" name="submit">
  93. </div>
  94. </form>
  95. </li>
  96. </ul>
  97. </div>
  98. </div>
  99. </nav>
  100. </div>
  101. <div class="container-fluid" id="leftfirst">
  102. <form method="post" id="indexform" name="indexform" enctype="multipart/form-data" action="">
  103. <div class="container-fluid">
  104. <h3>Adauga Fisa</h3>
  105. <div class="form-group">
  106. <label for="receivedate">Data Preluare:</label>
  107. <input type="date" class="form-control focusedInput" id="receivedate" name="receivedate" placeholder="Data Preluare" required>
  108. </div>
  109. </div>
  110. <div class="container-fluid">
  111. <h3> Date Client </h3>
  112. <div class="form-group">
  113. <label for="clientname">Nume Client:</label>
  114. <input type="text" class="form-control focusedInput" id="clientname" name="clientname" placeholder="Nume Client" required>
  115. </div>
  116. <div class="form-group">
  117. <label for="clientstreet" >Strada:</label>
  118. <input type="text" class="form-control focusedInput" id="cleintstreet" name="clientstreet" placeholder="Strada" required>
  119. </div>
  120. <div class="form-group">
  121. <label for="clientbl">Bloc:</label>
  122. <input type="text" class="form-control focusedInput" id="clientbl" name="clientbl" placeholder="Bloc" required>
  123. </div>
  124. <p></p>
  125. <div class="form-group">
  126. <label for="clientsc">Scara:</label>
  127. <input type="text" class=" form-control focusedInput" id="clientsc" name="clientsc" placeholder="Scara">
  128. </div>
  129. <div class="form-group">
  130. <label for="clientap">Apartament:</label>
  131. <input type="text" class="form-control focusedInput" id="clientap" name="clientap" placeholder="Apartament" required>
  132. </div>
  133. <div class="form-group">
  134. <label for="clientet">Etaj:</label>
  135. <input type="text" class="form-control focusedInput" id="clientet" name="clientet" placeholder="Etaj">
  136. </div>
  137. <div class="form-group">
  138. <label for="clientjud">Judet/Sector:</label>
  139. <input type="text" class="form-control focusedInput" id="clientjud" name="clientjud" placeholder="Judet/Sector" required>
  140. </div>
  141. <p></p>
  142. <div class="form-group">
  143. <label for="clientloc">Localitate:</label>
  144. <input type="text" class="form-control focusedInput" id="clientloc" name="clientloc" placeholder="Localitate" required>
  145. </div>
  146. <div class="form-group">
  147. <label for="clientphone">Telefon:</label>
  148. <input type="text" class="form-control focusedInput" id="clientphone" name="clientphone" placeholder="Numar telefon" pattern="[0-9]{10}" title="Introduceti numar telefon de forma:07XXXXXXXX sau 02XXXXXXXX" required>
  149. </div>
  150. <div class="form-group">
  151. <label for="clientemail">eMail:</label>
  152. <input type="email" class="form-control focusedInput" id="clientemail" name="clientemail" placeholder="Adresa eMail" title="Introduceti adresa de email de forma:user@example.XX" required>
  153. </div>
  154. </div>
  155. </div>
  156. <div class="container-fluid" id="leftmiddle">
  157. <div class="container-fluid">
  158. <h3> Date Magazin Altex </h3>
  159. <div class="form-group">
  160. <label for="store">Denumirea Unitatii:</label>
  161. <input type="text" class="form-control focusedInput" id="store" name="store" value="Media Galaxy Cluj Polus" placeholder="Media Galaxy Cluj Polus" required>
  162. </div>
  163. <div class="form-group">
  164. <label for="av">Nume reprezentant magazin:</label>
  165. <input type="text" class="form-control focusedInput" id="av" name="av" placeholder="Reprezentant magazin" required>
  166. </div>
  167. <div class="form-group">
  168. <label for="functia">Functia:</label>
  169. <input type="text" class="form-control focusedInput" id="functia" name="functia" placeholder="Functia" required>
  170. </div>
  171. <p></p>
  172. <div class="form-group">
  173. <label for="storephone">Telefon:</label>
  174. <input type="text" class="form-control focusedInput" id="storephone" name="storephone" value="0264275118" placeholder="0264 275 118" pattern="[0-9]{10}" title="Introduceti numar telefon de forma:07XXXXXXXX sau 02XXXXXXXX" required>
  175. </div>
  176. </div>
  177. <div class="container-fluid">
  178. <h3>Date Aparat Predat:</h3>
  179. <div class="form-group">
  180. <label for="productname">Denumire Produs:</label>
  181. <input type="text" class="form-control focusedInput" id="productname" name="product" placeholder="Denumire Produs"required>
  182. </div>
  183. <div class="form-group">
  184. <label for="productbrand">Marca:</label>
  185. <input type="text" class="form-control focusedInput" id="productbrand" name="productbrand" placeholder="Marca/Producator"required>
  186. </div>
  187. <div class="form-group">
  188. <label for="productmodel">Model:</label>
  189. <input type="text" class="form-control focusedInput" id="productmodel" name="productmodel" placeholder="Model"required>
  190. </div>
  191. <div class="form-group">
  192. <label for="sn">Serie:</label>
  193. <input type="text" class="form-control focusedInput" id="sn" name="sn" placeholder="Serial Number" required>
  194. </div>
  195. </div>
  196. <div class="container-fluid">
  197. <h3> Aspect: </h3>
  198. <div class="form-group">
  199. <label for="aspect">Aspect Estetic:</label>
  200. <input type="text" class="form-control focusedInput" id="aspect" name="aspect" placeholder="Aspect Estetic" required>
  201. </div>
  202. <div class="form-group">
  203. <label for="radio">Ambalaj Corespunzator:</label>
  204. <div class="checkbox">
  205. <label> <input type="radio" id="radio" name="optradio" required>Da</label>
  206. </div>
  207. <div class="checkbox">
  208. <label> <input type="radio" name="optradio">Nu</label>
  209. </div>
  210. </div>
  211. </div>
  212. </div>
  213. <div class="container-fluid" id="leftlast">
  214. <div class="container-fluid">
  215. <h3> Accesorii: </h3>
  216. <div class="form-group">
  217. <label for="accesorii">Accesorii ce insotesc aparatul in service:</label>
  218. <textarea type="text" class="form-control focusedInput" rows="3" cols="50" id="accesorii" name="accesorii" placeholder="Accesorii ce Insotesc Aparatul in service"required></textarea>
  219. </div>
  220. </div>
  221. <div class="container-fluid">
  222. <h3> Certificatul de Garantie in Original:</h3>
  223. <div class="form-group">
  224. <label for="cgnumber">Numar:</label>
  225. <input type="text" class="form-control focusedInput" id="cgnumber" name="cgnumber" placeholder="Numar CG">
  226. </div>
  227. <div class="form-group">
  228. <label for="cgdate">Data:</label>
  229. <input type="date" class="form-control focusedInput" id="cgdate" name="cgdate" placeholder="Data CG">
  230. </div>
  231. </div>
  232.  
  233.  
  234. <div class="container-fluid">
  235. <h3> Dovada Cumpararii (Factura fiscala/Bon Fiscal):</h3>
  236. <div class="form-group">
  237. <label for="invoicenumber">Numar:</label>
  238. <input type="text" class="form-control focusedInput" id="invoicenumber" name="invoicenumber" placeholder="Numar Factura/Bon" required>
  239. </div>
  240. <div class="form-group">
  241. <label for="invoicedate">Data:</label>
  242. <input type="date" class="form-control focusedInput" id="invoicedate" name="invoicedate" placeholder="Data Factura/Bon" required>
  243. </div>
  244. </div>
  245. <div class="container-fluid">
  246. <h3> Defect Reclamat:</h3>
  247. <div class="form-group">
  248. <label for="defect">Descrierea Defectului:</label>
  249. <textarea type="text" class="form-control focusedInput" id="defect" name="defect" rows="3" cols="50" placeholder="Defectul Reclamat de Client" required></textarea>
  250. </div>
  251. </div>
  252. <div class="container-fluid">
  253. <h3> Date Unitate Service </h3>
  254. <div class="form-group">
  255. <label for="servunit">Denumirea Unitatii:</label>
  256. <input type="text" class="form-control focusedInput" id="servunit" name="servunit" placeholder="Denumirea Unitatii">
  257. </div>
  258. <div class="form-group">
  259. <label for="servphone">Numar telefon:</label>
  260. <input type="text" class="form-control focusedInput" id="servphone" name="servphone" placeholder="Numar de Telefon S.A." pattern="[0-9]{10}" title="Introduceti numar telefon de forma:07XXXXXXXX sau 02XXXXXXXX">
  261. </div>
  262. <div class="form-group">
  263. <label for="servadress">Adresa:</label>
  264. <input type="text" class="form-control focusedInput" id="servadress" name="servadress"placeholder="Adresa S.A.">
  265. </div>
  266. <p></p>
  267. <div class="form-group">
  268. <label for="servcontact">Persoana de Contact:</label>
  269. <input type="text" class="form-control" id="servcontact" name="servcontact" placeholder="Persoana de Contact">
  270. </div>
  271. </div>
  272. </div>
  273. <div class="container-fluid">
  274. <input type="submit" value="save" id="save" name="save" />
  275. </div>
  276. </form>
  277. </div>
  278. </div>
  279.  
  280. </body>
  281. <footer>
  282. <div id="footer">
  283. <p>Copyright 2015. All rights reserved</p>
  284. </div>
  285. </footer>
  286. </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!