Image Upload using PHP and MYSQL

Demo Available Here

Image Upload using PHP and MYSQL download free with source code - You will learn the step-by-step process, that how to upload an image using PHP and MySQL and display an image.

 

1. Create Database and Table

 

create database demo;

//database created 

create table images (

id int NOT NULL AUTO_INCREMENT,

image varchar 100,

Primary Key (id)

);

//table created

 

2. Create HTML Form

 

< form method="POST" action="" enctype="multipart/form-data">

       < input type="file" name="image" value="" />

      < button type="submit" name="upload"> UPLOAD < /button >



< /form >

 

 

***

Give CSS or Bootstrap styling to an HTML form, if you need.

 

3. PHP Code

 

PHP Code for Upload an Image.

 

// Run the connection


$dbc = mysqli_connect("localhost","root","", "demo") 
                   or die ("could not connect to mysql");


// Now you can use the variable $dbc to connect in your queries

// If the upload button is clicked ...


if (isset($_POST['upload'])) {


    $image = $_FILES['image']['name'];

    $tmp_name = $_FILES['image']['tmp_name'];

    $folder = "images/".$image;

    // Get all the submitted data

    $sql = "INSERT into images (image) values ('$image')";

    // Execute query

    mysqli_query($dbc, $sql);

   // Move Uploaded Image in a images folder


   if (move_uploaded_file($tmp_name, $folder)) {

     $msg = "Image uploaded successfully";

     }else{

     $msg = "Failed to upload image";

   }

}

 

****

We can use more validations like a form should be not submitted empty or an image should be in a valid format.

 

PHP Code for Display an Image.

 

//Select data from table


$sql = "SELECT * from images";


// Execute query


$run = mysqli_query($dbc, $sql);

while($row=mysqli_fetch_array($run)){


$row_image = $row['image'];


echo "< img src='images/$row_image' >";


//Display images

}

Download Source Code