Home Web Development PHP Upload Image In PHP With MySQL Database | Web Dev Trick

Upload Image In PHP With MySQL Database | Web Dev Trick

May 11, 2019

17234

Upload Image In PHP, With MySQL Database: Nowadays we are on social networks, and we upload DP Stories etc. Ever wondered how this photo is uploaded in the database. After that, we can see images which are coming out of the database. So, Today we will learn how to upload image in database using PHP & MySQL. Basically, In this tutorial, we will create a form with two inputs. First, for image upload, the second one is to write some text with an image. When someone selects an image write some text & click on the upload button, the image name and text will be upload in MySQL database. And PHP grabs image file and save it in a folder.

You May Also Like

Build a Simple Quiz In PHP | Source Code

Domain Availability Checker In PHP | Get Source Code

More.

Upload Image In PHP Tutorial

Firstly, Create a MySQL database named “image_upload” & create a table named “images”. You can give a custom name for database and tables but, then you have to changes database & table name in PHP file too. If you have good knowledge in PHP then it’s ok Otherwise, just follow my steps.

Create a database named “image_upload” & click on the database you have created now. Then go to SQL menu and paste these code & click on go.

CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `image` varchar(100) NOT NULL,
  `image_text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `images` (

`id` int(11) NOT NULL,

`image` varchar(100) NOT NULL,

`image_text` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Now you have successfully created a database for this program. Now Create a file named “index.php” & a folder named “images” in the same destination where you saved index.php file. Now let me explain some important things about this program: I had created a form with method=”POST” and put on action index.php (action=”index.php”) file. You can create another file for PHP I had put everything in a single file. More info about PHP Method.

Note: Make sure you put enctype=”multipart/form-data” in form. Example ( <form method=”POST” action=”index.php” enctype=”multipart/form-data”> ), And don’t forget to create “images” folder. Otherwise, this program will not work.

Source Code

Open “index.php” file you had created before and paste these codes give below:

<!-- Code By WebDevTrick ( https://webdevtrick.com ) -->
<?php
  $db = mysqli_connect("localhost", "root", "", "image_upload");

  $msg = "";
  if (isset($_POST['upload'])) {
  	$image = $_FILES['image']['name'];
  	$image_text = mysqli_real_escape_string($db, $_POST['image_text']);
  	$target = "images/".basename($image);

  	$sql = "INSERT INTO images (image, image_text) VALUES ('$image', '$image_text')";
  	mysqli_query($db, $sql);

  	if (move_uploaded_file($_FILES['image']['tmp_name'], $target)) {
  		$msg = "Image uploaded successfully";
  	}else{
  		$msg = "Failed to upload image";
  	}
  }
  $result = mysqli_query($db, "SELECT * FROM images");
?>
<!DOCTYPE html>
<html>
<head>
<title>Image Upload</title>
<style type="text/css">

   #content{
   	width: 50%;
   	margin: 20px auto;
   	border: 1px solid #cbcbcb;
   }
   form{
   	width: 50%;
   	margin: 20px auto;
   }
   form div{
   	margin-top: 5px;
   }
   #img_div{
   	width: 80%;
   	padding: 5px;
   	margin: 15px auto;
   	border: 1px solid #cbcbcb;
	    background: #767272;
	   color: white;
   }
   #img_div:after{
   	content: "";
   	display: block;
   	clear: both;
	  
   }
   img{
   	float: left;
   	margin: 5px;
   	width: 300px;
   	height: 140px;
   }
</style>
</head>
<body>
<div id="content">
  <?php
    while ($row = mysqli_fetch_array($result)) {
      echo "<div id='img_div'>";
      	echo "<img src='images/".$row['image']."' >";
      	echo "<p>".$row['image_text']."</p>";
      echo "</div>";
    }
  ?>
  <form  method="POST"  action="index.php" enctype="multipart/form-data">
  	<input type="hidden" name="size" value="1000000">
  	<div>
  	  <input type="file" name="image">
  	</div>
  	<div>
      <textarea 
      	id="text" 
      	cols="40" 
      	rows="4" 
      	name="image_text" 
      	placeholder="What's In Your Mind?"></textarea>
  	</div>
  	<div>
  		<button type="submit" name="upload">Upload</button>
  	</div>
  </form>
</div>
</body>
</html>

<?php

$db = mysqli_connect("localhost", "root", "", "image_upload");

$msg = "";

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

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

$image_text = mysqli_real_escape_string($db, $_POST['image_text']);

$target = "images/".basename($image);

$sql = "INSERT INTO images (image, image_text) VALUES ('$image', '$image_text')";

mysqli_query($db, $sql);

if (move_uploaded_file($_FILES['image']['tmp_name'], $target)) {

$msg = "Image uploaded successfully";

}else{

$msg = "Failed to upload image";

}

$result = mysqli_query($db, "SELECT * FROM images");

<!DOCTYPE html>

<html>

<head>

<title>Image Upload</title>

#content{

width: 50%;

margin: 20px auto;

border: 1px solid #cbcbcb;

}

form{

width: 50%;

margin: 20px auto;

}

form div{

margin-top: 5px;

}

#img_div{

width: 80%;

padding: 5px;

margin: 15px auto;

border: 1px solid #cbcbcb;

background: #767272;

color: white;

}

#img_div:after{

content: "";

display: block;

clear: both;

}

img{

float: left;

margin: 5px;

width: 300px;

height: 140px;

}

</style>

</head>

<body>

<?php

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

echo "<div id='img_div'>";

echo "<img src='images/".$row['image']."' >";

echo "<p>".$row['image_text']."</p>";

echo "</div>";

}

<div>

</div>

<div>

<textarea

id="text"

cols="40"

rows="4"

name="image_text"

placeholder="What's In Your Mind?"></textarea>

</div>

<div>

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

</div>

</form>

</div>

</body>

</html>

That’s It. Now you have successfully created image upload in PHP & MySQL program. This a very basic program, I created this for those people who are beginners and want to learn. In the future, I will share advance PHP programs also. If You have any question or doubt comment down below.

Thanks For Visiting, Keep Visiting.

15 COMMENTS

Suresh May 22, 2019 At 2:39 am

Nice,
Please consider developing a datepicker in php.
Regards
Suresh

Reply
- shaan May 22, 2019 At 2:50 am
  
  Sure I will post soon.
  
  Reply
  - Andy August 30, 2019 At 9:11 am
    
    Hi Shaan
    
    I recently upgraded the server with MySQL 5.7. This caused some issues with uploading files and posting to sql db. When I saw your article I had to try it but, although it uploads the file to the directory it doesn’t post to the db. And there’s no error message. Are you able to shed some light on this.
    
    Reply
RajakaIT June 16, 2019 At 5:42 pm

How to amp blogger website

Reply
priy July 9, 2019 At 12:40 am

I face problem on file location

Reply
- shaan July 9, 2019 At 2:37 am
  
  all images located on Images Folder
  
  Reply
Edmilson August 2, 2019 At 7:37 pm

And how do I display the upload image in PHP?

Reply
- shaan August 3, 2019 At 6:21 am
  
  Try the codes there is also display feature.
  
  Reply
Cerh August 8, 2019 At 10:02 pm

pls Shaan, where do I create the “images” folder since I’m using a theme?

Reply
- shaan August 9, 2019 At 3:52 am
  
  Folder name – “upload”
  
  Reply
  - Cerh August 9, 2019 At 11:13 am
    
    Ok thanks so much
    
    Reply
Raheel Ahmed SIddiqui September 9, 2019 At 6:07 pm

how to update ?

Reply
Jimi Abraham March 12, 2020 At 2:47 pm

really helpful…thanks

Reply
james June 7, 2021 At 5:06 pm

how do you delete an image without having to go into the database? is there a code you could implement to have the option to delete image?

Reply
james June 7, 2021 At 5:07 pm

how can i delete image without going into the database?

Reply