Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.69 KB | None | 0 0
  1. <?php $connect = mysqli_connect("localhost", "root", "", "testing"); if(isset($_POST["insert"])) {
  2. $file = addslashes(file_get_contents($_FILES["image"]["tmp_name"]));
  3. $query = "INSERT INTO tbl_images(name) VALUES ('$file')";
  4. if(mysqli_query($connect, $query))
  5. {
  6. echo '<script>alert("Image Inserted into Database")</script>';
  7. }}?>
  8.  
  9.  
  10. <!DOCTYPE html><html>
  11. <head>
  12. <title>Webslesson Tutorial | Insert and Display Images From Mysql Database in PHP</title>
  13. <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  14. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
  15. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  16. </head>
  17. <body>
  18. <br /><br />
  19. <div class="container" style="width:500px;">
  20. <h3 align="center">Insert and Display Images From Mysql Database in PHP</h3>
  21. <br />
  22. <form method="post" enctype="multipart/form-data">
  23. <input type="file" name="image" id="image" />
  24. <br />
  25. <input type="submit" name="insert" id="insert" value="Insert" class="btn btn-info" />
  26. </form>
  27. <br />
  28. <br />
  29. <table class="table table-bordered">
  30. <tr>
  31. <th>Image</th>
  32. </tr>
  33. <?php
  34. $query = "SELECT * FROM tbl_images ORDER BY id DESC";
  35. $result = mysqli_query($connect, $query);
  36. $start = 1;
  37. while($row = mysqli_fetch_array($result))
  38. {
  39. echo '
  40. <tr>
  41. <td>
  42. <img src="data:image/jpeg;base64,'.base64_encode($row['name'] ).'" height="200" width="200" class="img-thumnail" />
  43. </td>
  44. </tr>
  45. ';
  46. }
  47. ?>
  48. </table>
  49. </div>
  50. </body></html><script>$(document).ready(function(){
  51. $('#insert').click(function(){
  52. var image_name = $('#image').val();
  53. if(image_name == '')
  54. {
  55. alert("Please Select Image");
  56. return false;
  57. }
  58. else
  59. {
  60. var extension = $('#image').val().split('.').pop().toLowerCase();
  61. if(jQuery.inArray(extension, ['gif','png','jpg','jpeg']) == -1)
  62. {
  63. alert('Invalid Image File');
  64. $('#image').val('');
  65. return false;
  66. }
  67. }
  68. });});</script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement