Upload and Show Image Using PHP/MYSQL


In this tutorial about Upload and Show Image Using PHP/MYSQL, you will learn on how to upload an image in the database and show it in a page after uploading the image.

First, create a database and name it as any name you desire. Then create a table, name it as “photos“.

[sql]CREATE TABLE photos ( photo_id int(11) NOT NULL, photo_link text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;[/sql]

On the index page, put the following codes.

[php]<?php include ‘connection.php’; ?>
<!DOCTYPE html>
<meta charset=”UTF-8″>
<title>Upload Photo in PHP & MYSQL</title>
<h3>Upload and Show Photo in PHP & MYSQL</h3>
if (isset($_GET[‘upload_action’])) {
if ($_GET[‘upload_action’] == “success”) { ?>
<b>Photo Successfully Uploaded</b>
<?php }
<form method=”post” action=”upload.php” enctype=”multipart/form-data”>
<label>Choose Photo:</label><br>
<input type=”file” name=”photo” /><br><br>
<input type=”submit” value=”Upload” />
$photos = $mysqli->query(“SELECT * FROM photos”);
<b><?php echo $photos->num_rows ?></b> total photos uploaded<br><br>
while ($photo_data = $photos->fetch_assoc()) { ?>
<img src=”<?php echo $photo_data[‘photo_link’]; ?>” width=”200px” height=”200px” />
<?php }

Create an “upload.php” file then put the following codes.

include ‘connection.php’;
if ($_FILES[‘photo’][‘name’] != null) {
move_uploaded_file($_FILES[‘photo’][‘tmp_name’], “images/” . $_FILES[‘photo’][‘name’]);
$img_link = “images/” . $_FILES[‘photo’][‘name’];

$upload = $mysqli->query(“INSERT INTO photos (photo_link) VALUES (‘$img_link’)”) or die($mysqli->error);
if ($upload) {
header(“Location: index.php?upload_action=success”);
} else if (!$upload) {
echo $mysqli->error;
} else if ($_FILES[‘photo’][‘name’] == null) {
echo ‘Please choose a photo.’;


If you have any questions or suggestion about Upload and Show Image Using PHP/MYSQL, please feel free to contact us at our contact page.

Looking for more source code? Type your keyword here here!


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.