Guest User

Untitled

a guest
Dec 1st, 2018
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.21 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "pass";
  5. $dbname = "myDB";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11. die("Connection failed: " . $conn->connect_error);
  12. }
  13.  
  14. if (isset($_POST)) {
  15. $file = $_FILES['myfile']['name'];
  16. $type = $_FILES['myfile']['type'];
  17. $file_tmp = $_FILES['myfile']['tmp_name'];
  18. $parser = fopen($file_tmp, 'r');
  19. $data = fread($parser, filesize($file_tmp));
  20. $data = addslashes($data);
  21. echo $_FILES['myfile']['tmp_name'];
  22. }
  23.  
  24. $date = date('Y-m-d H:i:s');
  25. $sql = "INSERT INTO `image` (name, mime, data,uploaded_on)
  26. VALUES ('$file','$type','$data','$date')";
  27.  
  28. if ($conn->query($sql) === TRUE) {
  29. echo "New record created successfully";
  30. } else {
  31. echo "Error: " . $sql . "<br>" . $conn->error;
  32. }
  33.  
  34. $conn->close();
  35. ?>
  36.  
  37. $(function(){
  38. var file_data = $("#file").prop("files")[0];
  39. var form_data = new FormData(document.getElementById('box')); // Creating object of FormData class
  40. form_data.append("myfile", file_data)
  41.  
  42. $("#upload").click(function(){
  43. $.ajax({
  44. url: "upload.php",
  45. type: 'post',
  46. cache: false,
  47. contentType: false,
  48. processData: false,
  49. data: form_data,
  50. error: function (request, status, error) {
  51. $("body").append("<div style='background:rgba(255,0,0,0.8);float:left;position:fixed'>"
  52. + request.responseText + "</div>")
  53. }
  54. }).done(function(msg) {
  55. $("body").append("<div style='background:rgba(255,0,0,0.8);float:left;position:fixed'>"
  56. + msg + "</div>")
  57. window.alert(msg);
  58. });
  59. });
  60. });
  61.  
  62. function empty() {
  63. var x = document.getElementById("order_num").value;
  64. var y = document.getElementById("cust_name").value;
  65. var z = document.getElementById("phone_num").value;
  66. var a = document.getElementById("cust_email").value;
  67. if (x == "" || y == "" || z == "" || a == "") {
  68. alert("Please fill all the fields ");
  69. return false;
  70. };
  71. }
Add Comment
Please, Sign In to add comment