Advertisement
bu2chlc

show images from database

Nov 5th, 2019
371
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.68 KB | None | 0 0
  1. <?php
  2. // credentials
  3. $db_user="imageuser";
  4. $db_pass="password";
  5. $db_host="localhost";
  6. $db_name="images";
  7.  
  8. // first I define connection string
  9. $mysqli= mysqli_connect($db_host, $db_user, $db_pass, $db_name);
  10. $sql_query = "SELECT * FROM urls";
  11.  
  12. $result = mysqli_query($mysqli, $sql_query);
  13. if (mysqli_num_rows($result) > 0) {
  14.     // output data of each row
  15.     while($row = mysqli_fetch_assoc($result)) {
  16.        // first print the title and a line break
  17.        echo $row["title"] . '<br>';
  18.        // show the image url wrapped in an IMG tag
  19.        echo '<img src=' . $row["url"] . '>';
  20.        echo '<hr>';
  21.     }
  22. } else {
  23.     echo "0 results";
  24. }
  25. mysqli_close($mysqli);
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement