How To Update Image In PHP With Demo In MySQL Database | Free Source Code

How to Update Image in PHP with Demo in MySQL Database

PHP
how to update image in php with demo

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.

how to update image in php with demo

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 image in php

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,

Download Here
Facebook Comments
https://www.campcodes.com/

This is a free education portal. You can use every source code in your project without asking permission to the author. Share our website to everyone to make our community of programmers grow more.

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published.