How to Retrieve Image In PHP and PDO


Retrieve Image in php

In this tutorial ,we will learn how to retrieve the image from php and pdo.

First ,we need to create two empty files for php

  • dbconfig.php
  • fetchimg.php

CREATE FILE dbconfig.php:


    $hostname = "localhost";
    $username = "root";
    $password = "";

    try {
        $conn = new PDO("mysql:host=$hostname;dbname=databasename", $username, $password);
        // set the PDO error mode to exception
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        //echo "Database connected successfully";
    } catch(PDOException $e) {
        echo "Database connection failed: " . $e->getMessage();


CREATE FILE fetchimg.php

include 'dbconfig.php';
$result = $conn->prepare("SELECT images FROM images ORDER BY id DESC"); 
$fetch = $result->fetchAll(PDO::FETCH_ASSOC);


<div class="container">
<div class="card">
<div class="row col-md-8 col-md-6">
<div class="card-body">
<?php foreach($fetch as $row){?>
<div class="grid grid-view">
<a href="<?php echo $row['images']; ?>">
<img class="img-thumbnail rounded mx-auto d-block" src="<?php echo $row['images']; ?>" alt="" /></a>
<?php  } ?>

Previous Post Next Post