Update image in php and mysql database

Question

I have to update image in php and mysql database. I know I cannot set the value of file type input field but how do I achieve this?

//upload.php
User Image<input type="file" name="image" accept="image/png, image/jpeg, image/ico" value="<?php echo $_GET['image'];?>" />

//upload query

    $id= $_GET['id'];
    $fname=$_GET['fname'];
    $lname=$_GET['lname'];
    $image=$_GET['image'];
  $sql = "UPDATE myGuest SET firstname='$fname', lastname='$lname', image='$image' WHERE id='$id'";  
    if($conn->query($sql))
    {
        echo "<script>alert('Record updated succesfully')</script>";
        header("Refresh:0; url=view.php");
    }
    else{
        echo "Error: ".$sql."<br>".$conn->error;
}

//view.php
<td><a href="update.php?id=<?php echo $row['id']?>&fname=<?php echo $row['firstname']?>&lname=<?php echo $row['lastname']?>&image=<?php echo $row['image']?>">EDIT</a></td>

Note that your query is vulnerable to SQL injections. Consider using prepared statements — Cid
– Cid, Commented Apr 21, 2019 at 18:09
I'm aware...I'm new to php and database connectivity. and this is only my homework. — Uyur99
– Uyur99, Commented Apr 21, 2019 at 18:11
Even for homework, it's always a good habit to get :). Imagine, you want to insert the name O'Bryan, your query will fail because of the single quote — Cid
– Cid, Commented Apr 21, 2019 at 18:12

Rakesh Jakhar · Accepted Answer · 2019-04-21 18:14:39Z

1

The data type should be longblob to insert image in DB.

 $image_content = addslashes(file_get_contents($_FILES['image']['tmp_name']));

Now you can use variable $image_content to insert/update image in DB.

To display the image use

header("Content-type: image/jpg"); 
echo $row['image'];

For more details Follow this

answered Apr 21, 2019 at 18:14

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update image in php and mysql database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related