php

Image Upload With Preview Using PHP’s PDO And jQuery

With PHP we can upload various files to the server depending on the given requirements and specifications. In this tutorial, we shall look at how to upload image to the server and store the path in our database.

So let’s begin!

First, let us create our database connection:

 <?php
 defined('BASEPATH') OR exit('No direct script access allowed');
 $host = 'localhost';
 $user = 'root';
 $password = '';
 $dbname = 'test';
 $dsn = '';
try{
     $dsn = 'mysql:host='.$host. ';dbname='.$dbname;
$pdo = new PDO($dsn, $user, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); }catch(PDOException $e){
     echo 'connection failed: '.$e->getMessage();
 }
 ?>

Next, we create our table called images. Here we’re adding both the image name and the image file.

CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `image_name` varchar(300) NOT NULL,
  `image_file` text NOT NULL,
  `date_time` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Next, we create a form that with which we can upload our file.

<form action="index.php" method="post"  enctype="multipart/form-data">
<div>
<label for="title">Image title</label>
<input id="title" name="image_name" required="required" type="text" aria-required="true" aria-invalid="false">
</div>
<div class="form-group">
<div id="preview-container-imageThre">
<button required type="button"  id="upload-dialog-three">Choose Image</button><br /><br />
<input require type="file" id="file" name="file" accept="image/jpg,image/png" style="display:none" required="required"/>
<img id="preview-image-three" style="display:none" />
</div>
</div>
<div>
<button id="payment-button" type="submit" name="sub">
Add
</button>
</div>
</form>

Next, we will write our Javascript code that will preview our image using jQuery. Don’t forget to add your jQuery cdn dependency.

Create Login and registration form using PDO

Add Upload Preview Using jQuery

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
let _PREVIEW_URL;

/* Show Select File dialog */document.querySelector("#upload-dialog-three").addEventListener('click', function() {
    document.querySelector("#file").click();
});

/* Selected File has changed */document.querySelector("#file").addEventListener('change', function() {
    // user selected file
    var file = this.files[0];

    // allowed MIME types
    var mime_types = [ 'image/jpeg', 'image/png' ];
    
    // validate MIME
    if(mime_types.indexOf(file.type) == -1) {
        alert('Error : Incorrect file type');
        return;
    }

    // validate file size
    if(file.size > 5*1024*1024) {
        alert('Error : Exceeded size 2MB');
        return;
    }

    // validation is successful

    // replace upload dialog button text
    document.querySelector("#upload-dialog-three").textContent = 'Replace image';

    // object url
    _PREVIEW_URL = URL.createObjectURL(file);

    // set src of image and show
    document.querySelector("#preview-image-three").setAttribute('src',         _PREVIEW_URL);
    document.querySelector("#preview-image-three").style.display = 'inline-block';
    });
    </script>
 <?php 
define('BASEPATH', true);
require './database.php';

   $exists = "";

if(isset($_POST['sub'])){
     try {
            $dsn = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
            $dsn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            
            $title = $_POST['image_name'];
            $target_file = "";
         
             $target_dir = "./images/"; //set your folder path
            $target_file = $target_dir . basename($_FILES["file"]["name"]);
            $uploadOk = 1;
            $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
            move_uploaded_file($_FILES["file"]["tmp_name"], $target_file) ;
            
             $target_file = 'https://yourdomain.com/'.$target_file;
             
             $sql = "SELECT COUNT(image_file) AS num FROM images WHERE image_file = :image_file"; //check if file exists
         $stmt = $pdo->prepare($sql);

         $stmt->bindValue(':image_file', $target_file);
         $stmt->execute();
         $row = $stmt->fetch(PDO::FETCH_ASSOC);

         if($row['num'] > 0 ){
           //Show Bootstrap alert. Optional here
            $exists = '<div class="col-sm-6 alert alert-danger alert-dismissible fade show" role="alert" style="margin: 0 auto">
                     
                      <p><span class="fa fa-exclamation-triangle"></span> This image already exists.</p>
                      <span><span class="fa fa-lightbulb-o fa-warning"></span> Hint: Rename image</span>
                    </div>';
        }else{
             
              $stmt = $dsn->prepare("INSERT INTO images (image_name, image_file) 
                VALUES (:image_name, :image_file)");
                $stmt->bindParam(':image_name', $title);
                $stmt->bindParam(':image_file', $target_file);
                
                 if($stmt->execute()){
    echo '<script>alert("New image added the Gallery successfully.")</script>';
     
   }else{
       echo '<script>alert("An error occurred")</script>';
   }
        }
            
     }catch(PDOException $e){
          $error = "Error: " . $e->getMessage();
    echo '<script type="text/javascript">alert("'.$error.'");</script>';
     }
}
?>

Congratulations!

You have successfully uploaded your image to the server.

Recent Posts

What Exactly is Docker?

Imagine moving to a new apartment. Instead of disassembling your furniture, rebuilding pipes, and rewiring…

3 days ago

Event Delegation in JavaScript

Imagine you’re the principal of a large school. Every day, students (like buttons, links, or…

4 days ago

The DRY Concept (Don’t Repeat Yourself)

You know that thing you do? Where you copy a chunk of code, paste it…

1 week ago

What Truly Makes a Great Software Developer

We've all seen them. The developers who seem to effortlessly untangle complex problems, whose code…

1 week ago

How to Filter Vulgar Words in React Native

If you're building a social, chat, or comment-based mobile app using React Native, protecting your…

2 weeks ago

How to Build Faster Mobile Apps With Native Wind Library

The Cross-Platform ImperativeLet's face it: building separate iOS and Android apps wastes resources. React Native…

3 weeks ago