API tools faq
paste
Guest User

Untitled

a guest
Nov 30th, 2018
908
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.49 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "pass";
  6. $dbname = "myDB";
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. if (isset($_POST)) {
  16. $file = $_FILES['myfile']['name'];
  17. $type = $_FILES['myfile']['type'];
  18. $file_tmp = $_FILES['myfile']['tmp_name'];
  19. $parser = fopen($file_tmp, 'r');
  20. $data = fread($parser, filesize($file_tmp));
  21. $data = addslashes($data);
  22. echo $_FILES['myfile']['tmp_name'];
  23. }
  24.  
  25.  
  26. $date = date('Y-m-d H:i:s');
  27. $sql = "INSERT INTO `image` (name, mime, data,uploaded_on)
  28. VALUES ('$file','$type','$data','$date')";
  29.  
  30.  
  31.  
  32.  
  33. if ($conn->query($sql) === TRUE) {
  34. echo "New record created successfully";
  35. } else {
  36. echo "Error: " . $sql . "<br>" . $conn->error;
  37. }
  38.  
  39. $conn->close();
  40. ?>
  41.  
  42. <!doctype html> <html> <head>
  43. <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
  44. <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
  45. <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css">
  46. <style type="text/css">
  47. #box {
  48. position: absolute;
  49. top: 10%;
  50. text-align: center;
  51. width: 50%;
  52. left: 25%;
  53. background: rgba(240,240,240,0.8);
  54. border-radius: 12px;
  55. padding: 12px;
  56. box-shadow:2px 2px 6px #888;
  57. }
  58. input[type=text], input[type=email], input[type=tel], select, textarea {
  59. -webkit-transition: all 0.30s ease-in-out;
  60. -moz-transition: all 0.30s ease-in-out;
  61. -ms-transition: all 0.30s ease-in-out;
  62. -o-transition: all 0.30s ease-in-out;
  63. outline: none;
  64. padding: 12px;
  65. border: 1px solid #DDDDDD;
  66. margin-bottom: 12px;
  67. width: 50%;
  68. border-radius: 5px;
  69. cursor: pointer;
  70. }
  71. input[type=text]:focus, input[type=email]:focus, input[type=tel]:focus,textarea:focus {
  72. box-shadow: inset 0 0 5px rgb(50,50,50);
  73. padding: 13px;
  74. border: 1px solid #888;
  75. }
  76. .button {
  77. position: relative;
  78. background: rgb(220,220,220);
  79. border: 1px #888;
  80. padding: 5px;
  81. border-radius: 2px;
  82. box-shadow: 2px 2px 2px #888;
  83. cursor: pointer;
  84. width: auto;}
  85. .button:active {
  86. box-shadow: none;
  87. border:1px #888;
  88. }
  89. /* Removes the clear button from date inputs */
  90. input[type="date"]::-webkit-clear-button {
  91. display: none;
  92. }
  93. /* Removes the spin button */
  94. input[type="date"]::-webkit-inner-spin-button {
  95. display: none;
  96. }
  97. /* Always display the drop down caret */
  98. input[type="date"]::-webkit-calendar-picker-indicator {
  99. color: #2c3e50;
  100. }
  101. /* A few custom styles for date inputs */
  102. input[type="date"] {
  103. appearance: none;
  104. -webkit-appearance: none;
  105. color: #95a5a6;
  106. font-family: "Helvetica", arial, sans-serif;
  107. font-size: 18px;
  108. border:1px solid black;
  109. cursor: pointer;
  110. background:#ecf0f1;
  111. padding:5px;
  112. display: inline-block !important;
  113. visibility: visible !important;
  114. margin-bottom: 12px;
  115. }
  116. input[type="date"], focus {
  117. color: #95a5a6;
  118. box-shadow: none;
  119. -webkit-box-shadow: none;
  120. -moz-box-shadow: none;
  121. }
  122. #logo {
  123. background: url('logo.png') top left no-repeat;
  124. width: 2000px;
  125. height: 200px;
  126. position: fixed;
  127. }
  128. input[type=number] {
  129. width: 35px;
  130. }
  131. input[type=number]::-webkit-inner-spin-button {
  132. opacity: 1;
  133. }
  134. </style>
  135. <script>
  136. $(function(){ var file_data = $("#file").prop("files")[0]; var form_data = new FormData(document.getElementById('box')); // Creating object of FormData class form_data.append("myfile", file_data)
  137.  
  138. $("#upload").click(function(){
  139.  
  140. $.ajax({
  141. url: "upload.php",
  142. type: 'post',
  143. cache: false,
  144. contentType: false,
  145. processData: false,
  146. data: form_data,
  147. error: function (request, status, error) {
  148. $("body").append("<div style='background:rgba(255,0,0,0.8);float:left;position:fixed'>" + request.responseText + "</div>")
  149. }
  150. }).done(function(msg) {
  151. $("body").append("<div style='background:rgba(255,0,0,0.8);float:left;position:fixed'>" + msg
  152. + "</div>")
  153. window.alert(msg);
  154. });
  155. });
  156.  
  157. });
  158.  
  159. function empty() {
  160. var x = document.getElementById("order_num").value;
  161. var y = document.getElementById("cust_name").value;
  162. var z = document.getElementById("phone_num").value;
  163. var a = document.getElementById("cust_email").value;
  164. if (x == "" || y == "" || z == "" || a == "") {
  165. alert("Please fill all the fields ");
  166. return false;
  167. };
  168. }
  169.  
  170.  
  171. </script> </head> <body>
  172. <div id="logo"></div>
  173. <form id="box" enctype='multipart/form-data' method="post" action="connect.php">
  174. <input type="text" id="order_num" name="order_num" placeholder="order number"/>
  175. <br/>
  176. <input type="text" id="cust_name" name="cust_name" placeholder="customer name"/>
  177. <br/>
  178. <input type="tel" id="phone_num" name="phone_num" placeholder="contact number"/>
  179. <br/>
  180. <input type="email" id="cust_email" name="cust_email" placeholder="customer email"/>
  181. <br/>
  182. sent date: <input type="date" id="sent_date" name="sent_date" placeholder="sent date"/>
  183. pickup date: <input type="date" id="pickup_date" name="pickup_date"/>
  184. <br/>
  185. <input type="text" id ="sales_person" name="sales_person" placeholder="sales person"/>
  186. <br/>
  187. Payment: </br>
  188. <input type="text" id ="amount" name="amount" placeholder="amount"/>
  189. <br/>
  190. <input type="text" id="others" name="others" placeholder="others"/>
  191. <br/>
  192. <input type="Text" id="total" name="total" placeholder="total"/>
  193. <br/>
  194. <input type ="text" id ="deposit" name="deposit" placeholder="deposit"/>
  195. <br/>
  196. <input type="text" id="balance" name="balance" placeholder="balance"/>
  197. <br/>
  198. Product details:<br/>
  199. material:
  200. <select id="material" name="material">
  201. <option value="1.6 C/P">1.6 C/P</option>
  202. <option value="2.0 C/P">2.0 C/P</option>
  203. <option value="2.5 C/P">2.5 C/P</option>
  204. <option value="3.0 C/P">3.0 C/P</option>
  205. <option value="5.0 C/P">5.0 C/P</option>
  206. <option value="2.0 F/P">2.0 F/P</option>
  207. <option value="2.5 F/P">2.5 F/P</option>
  208. <option value="3.0 F/P">3.0 F/P</option>
  209. <option value="5.0 F/P">5.0 F/P</option>
  210. <option value="1.6 P/P">1.6 P/P</option>
  211. <option value="2.0 P/P">2.0 P/P</option>
  212. <option value="2.5 P/P">2.5 P/P</option>
  213. <option value="3.0 P/P">3.0 P/P</option>
  214. <option value="others">others</option>
  215. </select>
  216. <br/>
  217. product:
  218. <select id="product" name="product">
  219. <option value="REC">REC</option>
  220. <option value="RET">RET</option>
  221. <option value="REC-H">REC-H</option>
  222. <option value="REC-W">REC-W</option>
  223. <option value="STS">STS</option>
  224. <option value="STD">STD</option>
  225. <option value="DBL">DBL</option>
  226. <option value="DBU">DBU</option>
  227. <option value="TSO">TSO</option>
  228. <option value="ALT">ALT</option>
  229. <option value="TDB">TDB</option>
  230. <option value="GB">GB</option>
  231. <option value="FIL">FIL</option>
  232. <option value="FIS">FIS</option>
  233. <option value="FIC 2 DRAWERS">FIC 2 DRAWERS</option>
  234. <option value="FIC 3 DRAWERS">FIC 3 DRAWERS</option>
  235. <option value="FSS">FSS</option>
  236. <option value="UIS">UIS</option>
  237. <option value="UIL">UIL</option>
  238. <option value="ARS">ARS</option>
  239. <option value="UTE">UTE</option>
  240. <option value="UTC">UTC</option>
  241. <option value="UTS">UTS</option>
  242. <option value="UTT">UTT</option>
  243. <option value="LJB">LJB</option>
  244. <option value="GLGB">GLGB</option>
  245. <option value="BASEMENT BOX">BASEMENT BOX</option>
  246. <option value="TTY">TTY</option>
  247. <option value="ARSP">ARSP</option>
  248. <option value="others">others</option>
  249. </select>
  250. <input type="number" min="0" id="product_qty" name="product_qty" placeholder="qty"/>
  251. <br/>
  252. lock:
  253. <select id="lock" name="lock">
  254. <option value="T">T</option>
  255. <option value="G">G</option>
  256. <option value="S">S</option>
  257. <option value="H">H</option>
  258. <option value="Padlock">Padlock</option>
  259. <option value="no lock">no lock</option>
  260. <option value="other">other</option>
  261. </select>
  262. <input type="number" min="0" id="lock_quantity" name="lock_quantity" placeholder="qty"/>
  263. <br/>
  264. wheels:
  265. <select id="wheels" name="wheels">
  266. <option value="no">no</option>
  267. <option value="yes">yes</option>
  268. </select>
  269. <input type="number" min="0" id="wheels_qty" name="wheels_qty" placeholder="qty"/>
  270. <br/>
  271. <input type="text" id="drawer_slide" name="drawer_slide" placeholder="drawer slide"/>
  272. <input type="number" min="0" id="drawer_slide_qty" name="drawer_slide_qty" placeholder="qty" onclick="javascript: window.alert('qty is in pairs')"/> in pairs
  273. <br/>
  274. freight:
  275. <select id="freight" name="freight">
  276. <option value="no">no</option>
  277. <option value="yes">yes</option>
  278. </select>
  279. <br/>
  280. power coating:
  281. <select id="powder" name="powder">
  282. <option value="no">no</option>
  283. <option value="yes">yes</option>
  284. </select>
  285. <br/>
  286. hinge:
  287. <select id="hinge" name="hinge">
  288. <option value="no">no</option>
  289. <option value="yes">yes</option>
  290. </select>
  291. <input type="number" min="0" id="hinge_qty" name="hinge_qty" placeholder="qty"/>
  292. <br/>
  293. hinge rubber:
  294. <select id="hinge_rubber" name="hinge_rubber">
  295. <option value="no">no</option>
  296. <option value="yes">yes</option>
  297. </select>
  298. <input type="number" min="0" id="rubber_qty" name="rubber_qty" placeholder="qty"/>
  299. <br/>
  300. gas strut:
  301. <select id="gas" name="gas">
  302. <option value="no">no</option>
  303. <option value="yes">yes</option>
  304. </select>
  305. <input type="number" min="0" id="gas_qty" name="gas_qty" placeholder="qty"/>
  306. <br/>
  307. divider:
  308. <select id="divider" name="divider">
  309. <option value="no">no</option>
  310. <option value="yes">yes</option>
  311. </select>
  312. <input type="number" id="divider_qty" name="divider_qty" placeholder="qty"/>
  313. <br/>
  314. shelf:
  315. <select id="shelf" name="shelf">
  316. <option value="no">no</option>
  317. <option value="yes">yes</option>
  318. </select>
  319. <input type="number" id="shelf_qty" name="shelf_qty" placeholder="qty" min="0"/>
  320. <br/>
  321. tags:
  322. <select id="tags" name="tags">
  323. <option value="no">no</option>
  324. <option value="yes">yes</option>
  325. </select>
  326. <br/>
  327. installation:
  328. <select id="installation" name="installation">
  329. <option value="no">no</option>
  330. <option value="yes">yes</option>
  331. </select>
  332. <br/>
  333. <input type="text" id="code_area" name="code_area" placeholder="code and area (outside)"/>
  334. <br/>
  335. <input type="file" id="file" name="myfile" multiple />
  336. <span class="button" id="upload">upload</span>
  337. <br/>
  338. <input type="submit" class="button" onClick="return empty()" >
  339. </form> </body>
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!