Upload Image to Database and Server using HTML,PHP and MySQL

-
Image Uploading is very easy there are two ways you can upload the image either to the database or in the server as you like. In this tutorial we use both ways to upload and display the image. All you need to have knowledge of HTML, PHP and MySQL.




To Upload The Image In Database it takes only three steps:-
  1. Make a HTML form to upload the image
  2. Connect to the database and store image
  3. Displaying the Image


Step 1.Make a HTML form
We make a HTML form with post method and save it with a name upload.html
<html>
     <body>
  
  <form method="POST" action="getdata.php" enctype="multipart/form-data">
   <input type="file" name="myimage">
   <input type="submit" name="submit_image" value="Upload">
  </form>

     </body>
</html>

We submit the data from this HTML form to getdata.php where the image is going to store in the database.


Step 2.Connect To Database and Store Image
In this step we have to connect to the database to store the image in database. You can connect to any database from which you want to get the data. In this we use sample database named " demo ".
<?php
$host = 'localhost';
$user = 'root';
$pass = ' ';

mysql_connect($host, $user, $pass);

mysql_select_db('demo');
?>

To store the image into database you have to use blob datatype of your image column in your table. MySQL uses BLOB to store binary data and images is also a binary data. You can use any kind of BLOB TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB as per the size of your image.
<?php

$imagename=$_FILES["myimage"]["name"]; 

//Get the content of the image and then add slashes to it 
$imagetmp=addslashes (file_get_contents($_FILES['myimage']['tmp_name']));

//Insert the image name and image content in image_table
$insert_image="INSERT INTO image_table VALUES('$imagetmp','$imagename')";

mysql_query($insert_image);

?>


Step 3.Displaying the stored Images from database
To display images you have to make two files one is to fetch the image from database and second one is to display the image.

This is fetch_image.php file
<?php

header("content-type:image/jpeg");

$host = 'localhost';
$user = 'root';
$pass = ' ';

mysql_connect($host, $user, $pass);

mysql_select_db('demo');

$name=$_GET['name'];

$select_image="select * from image_table where imagename='$name'";

$var=mysql_query($select_image);

if($row=mysql_fetch_array($var))
{
    $image_name=$row["imagename"];
    $image_content=$row["imagecontent"];
}
echo $image;

?>

Now we want to display the image we make another file display_image.php.
<html>
     <body>
  
  <form method="GET" action=" " >
   <input type="file" name="your_imagename">
   <input type="submit" name="display_image" value="Display">
  </form>

     </body>
</html>


<?php

$getname = $_GET[' your_imagename '];

echo "< img src = fetch_image.php?name=".$getname." width=200 height=200 >";

?>


To Upload The Image In Server it takes only three steps:-
  1. Make a HTML form to upload the image
  2. Store image path to database and store the image to your server or directory
  3. Displaying the Image


Step 1.Make a HTML form
You can use same HTML form as
<html>
     <body>
       
     <form method="POST" action="store_image.php" enctype="multipart/form-data">
         <input type="file" name="myimage">
         <input type="submit" name="submit_image" value="Upload">
     </form>

     </body>
</html>

MySql Table 







Step 2.Storing image to the Server
In this step we get the image and store the image in directory and store the path of the image with name in database.

This is store_image.php file
<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$dbname='demo';

$conn=mysqli_connect($host, $user, $pass, $dbname);

//mysql_select_db('demo');

$upload_image=$_FILES["myimage"][ "name" ];

$folder="images/".$upload_image;

move_uploaded_file($_FILES["myimage"]["tmp_name"], "$folder".$_FILES["myimage"]["name"]);

$insert_path="INSERT INTO image_table(imagename, imagecontent) VALUES('$folder','$upload_image')";

$var=mysqli_query($conn, $insert_path);

?>


Step 3.Displaying the Images
To display images you have to get the file name and file path from the database.

This is display_image.php file (to display only one, the last image)
<?php

$host = 'localhost';
$user = 'root';
$pass = '';
$dbname='demo';

$conn=mysqli_connect($host, $user, $pass, $dbname);

//mysql_select_db('demo');

$select_path="select * from image_table";

$var=mysqli_query($conn, $select_path);

while($row=mysqli_fetch_array($var))
{
    $image_name=$row["imagename"];
    $image_path=$row["imagecontent"];

    echo "img src=".$image_path."/".$image_name." width=100 height=100";
}


?>
<html>
<head><title>Display image from database</title></head>
<body>
<p>hello</p>
<?php
echo '<img src="'.$image_path."/".$image_name.'"/>';
//echo <img src=.$image_path."/".$image_name.>;
?>
</body>
</html>

 This is display_image.php file (to display all the images)
<?php

$host = 'localhost';
$user = 'root';
$pass = '';
$dbname='demo';

$conn=mysqli_connect($host, $user, $pass, $dbname);

//mysql_select_db('demo');

$select_path="select * from image_table";

$var=mysqli_query($conn, $select_path);
?>
<html>
<head><title>Display image from database</title></head>
<body>
<p>hello</p>
<?php

while($row=mysqli_fetch_array($var))
{
    $image_name=$row["imagename"];
    $image_path=$row["imagecontent"];

    //echo "img src=".$image_path."/".$image_name." width=100 height=100";
    echo '<img src="'.$image_path."/".$image_name.'" width=200px; height=100px;/>';
}

//echo '<img src="'.$image_path."/".$image_name.'"/>';
//echo <img src=.$image_path."/".$image_name.>;
?>
</body>
</html>

That's all, this is how to upload image to database or in a directory with the help of HTML, PHP and MySQL. You can customize this code further as per your requirement. And please feel free to give comments on this tutorial.

Comments

Post a Comment

Popular posts from this blog

Script For Login, Logout and View Using PHP, MySQL and Bootstrap

-
Image
I am assuming here that you are familiar with HTML and CSS. I have commented the code with the necessary information in the major part of the code. So you can understand easily. I have also attached the source code so you can download it and use it. Let's start. Note: I have updating this article on my personal blog. The following are the points we will be learn in this article: Creating Database in phpmyadmin. Create connection with MySQL database. Insert, delete and view data from MySQL database. Some Bootstrap components. Sessions in PHP. Files and IDE: Registration Login Logout Welcome Admin_login View_users Db_conection Delete.php I am using PHPStorm for the coding and Bootstrap framework for front end development. Create Database: Create Tables: Create columns in Users table: Crate Admin Table: Create Admin Columns: Registration.php: <html>   <head lang= "en" >      ...
Read more

Hyperledger Development with in 10 days — Day 6

-
Image
Chaincode Development Introduction For the first five days, we have seen the concepts of Hyperledger fabric and various components of it. We have started our own network, deployed the simple smart contract. We have done transactions, we transferred data privately. In this part we are going to look into Chaincode development aka smart contract development for Hyperledger Fabric. We know that chaincode is running in different docker container once it is instantiated on channel isolating from the peers. Typically smart contract is the business logic agreed by the members to execute with consensus. However within the same network multiple many chaincode might be running on different channels. “Without appropriate permissions a chaincode cannot invoke another chaincode”. Various levels of Chaincodes There are two perspective on chaincodes. First, the perspective of the developer who is developing blockchain application — Chaincode for developers Second, the bl...
Read more

Insert CheckBox and Radio button Data in MySQL Database Using PHP

-
Image
MY-SQL Code CREATE DATABASE IF NOT EXISTS databasename; CREATE TABLE students( student_name varchar(255) NOT NULL, student_email varchar(255) NOT NULL, student_contact varchar(255) NOT NULL, student_address varchar(255) NOT NULL, stars varchar(25) NOT NULL, sports varchar(25) NOT NULL, gender text(25) NOT NULL, )     Download Code     LIVE DEMO   page- formelements.php   php code <?php $connection = mysqli_connect("localhost", "root", "","formdatainsert"); // Establishing Connection with Server //$db = mysql_select_db("colleges", $connection); // Selecting Database from Server if(isset($_POST['submit'])){ // Fetching variables of the form which travels in URL $name = $_POST['name']; $email = $_POST['email']; $contact = $_POST['contact']; $address = $_POST['address']; $sports=implode(' , ',$_POST['sports']); $star=implode(' , ',$_POST['star']); ...
Read more