Tutorial: How to Update Image in PHP with Demo in MySQL Database with Source Code

Getting Started on How to Update Image in PHP with Demo in MySQL Database

This is a tutorial on How to Update Image in PHP with Demo in MySQL Database. In this tutorial, we are going to update the current Image to a new one. For this tutorial, we are going to use the UPDATE Statement to update the current image in our table. Let’s start with: This is the image that we are going to edit.

Updating Image

Modal Form Field

<div id="delete<?php  echo $id;?>" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-header">
<h3 id="myModalLabel">Update</h3>
</div>
<div class="modal-body">
<div class="alert alert-danger">
<?php if($row['image_location'] != ""): ?>
<img src="uploads/<?php echo $row['image_location']; ?>" width="100px" height="100px" style="border:1px solid #333333; margin-left: 30px;">
<?php else: ?>
<img src="images/default.png" width="100px" height="100px" style="border:1px solid #333333; margin-left: 30px;">
<?php endif; ?>
<form action="edit_PDO.php<?php echo '?tbl_image_id='.$id; ?>" method="post" enctype="multipart/form-data">
<div style="color:blue; margin-left:150px; font-size:30px;">
	<input type="file" name="image" style="margin-top:-115px;">
</div>
</div>
<hr>
<div class="modal-footer">
<button class="btn btn-inverse" data-dismiss="modal" aria-hidden="true">No</button>
<button type="submit" name="submit" class="btn btn-danger">Yes</button>
</form>
</div>
</div>
</div>

Creating Our Database

<?php 
$conn = new PDO('mysql:host=localhost; dbname=upload_image','root', ''); 
?>

Creating Our UPDATE Statement

<?php
 
require_once ('db.php');
 
$get_id=$_REQUEST['tbl_image_id'];
 
move_uploaded_file($_FILES["image"]["tmp_name"],"uploads/" . $_FILES["image"]["name"]);			
$location1=$_FILES["image"]["name"];
 
 
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "UPDATE tbl_image SET image_location ='$location1' WHERE tbl_image_id = '$get_id' ";
 
$conn->exec($sql);
echo "<script>alert('Successfully Updated!!!'); window.location='index.php'</script>";
?>

Output:

Update The Current Image As you can see the current image was updated. How to Update Image in PHP with Demo in MySQL Database.

DEMO

Related Tutorials: Image Upload using Ajax in PHP, How to Upload an Image using AJAX in PHP and MySQLi, Change Image Name When Upload in PHP, How to Upload and Validate an Image File in PHP, Create Captcha Image in PHP, Image Upload Using PDO in PHP,