Guest User

Untitled

a guest
Nov 29th, 2017
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. <!DOCTYPE html>
  2.  
  3.  
  4. <body>
  5. <?php
  6. $servername = "mysql.cba.pl";
  7. $username = "mmalewski";
  8. $password = "Haslo123";
  9. $dbname = "mmalewski";
  10.  
  11. // Create connection
  12. $conn = new mysqli($servername, $username, $password, $dbname);
  13. // Check connection
  14. if ($conn->connect_error) {
  15. die("Connection failed: " . $conn->connect_error);
  16. }
  17.  
  18. $idd = $_GET["id"];
  19.  
  20. $sql = "select Zdjecie from DB where id=".$idd;
  21.  
  22. $result = $conn->query($sql);
  23.  
  24. if (mysqli_num_rows($result)==1) {
  25. $row = mysqli_fetch_assoc($result);
  26. $image = $row["Zdjecie"];
  27.  
  28. echo '<img src="data:image/jpeg;base64,'.base64_encode($row['Zdjecie'] ).'"/>';
  29. }
  30. else {
  31. echo "0 results";
  32. }
  33. $conn->close();
  34.  
  35. ?>
  36. </body>
  37. </html>
Add Comment
Please, Sign In to add comment