Update image in database using PHP

Question

I need to add a photo update function.

HTML form:

<form action="scripts/setImage.php" method="post"> 
  <h3>Set my image:</h3>
  Choose photo:<br><br>
  <input type="file" name="file"><br>
  <input type="submit" value="Sumbit">      
</form>

PHP:

$file = $_POST['file'];
if (isset($_POST['file'])) {
    $db->UPDATE("UPDATE users SET image = LOAD_FILE('$file') WHERE id = $idLogged");
}

And this doesn't work ;/ I think I can't use $_POST with files. I tried also $_FILES but it doesn't work as well.

In the db you only store the name of the imageand or link to the image. If you want to store the image in the db, the field must ba a BLOB type. Normally the image is stored as a file on your server. — Grumpy
– Grumpy, Commented Dec 10, 2019 at 9:34
And check documentation - php.net/manual/en/features.file-upload.post-method.php — Dmitry Leiko
– Dmitry Leiko, Commented Dec 10, 2019 at 9:37
Grumpy, it's blow type. And I have images in databases but can't update it — programmer001
– programmer001, Commented Dec 10, 2019 at 9:37

Piyush Shukla · Accepted Answer · 2019-12-10 09:49:23Z

5

<form action="scripts/setImage.php" method="post" enctype="multipart/form-data"> 
    <h3>Set my image:</h3>
    Choose photo:<br><br>
    <input type="file" name="file"><br>
    <input type="submit" value="Sumbit">      
</form>

<?php
    $file =addslashes(file_get_contents($_FILES['file']['tmp_name']));
    if (isset($file)) {
        $db->UPDATE("UPDATE users SET image = '$file' WHERE id = $idLogged");
    }
?>

edited Dec 10, 2019 at 9:49

answered Dec 10, 2019 at 9:41

Piyush Shukla

2542 silver badges12 bronze badges

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

3 Comments

programmer001 Over a year ago

I did it and NULL is set to database

programmer001 Over a year ago

Yes, it works. Why did you need to add "addlashes" and "file_get_contents"?

Piyush Shukla Over a year ago

file_get_contents() for get image contents and addlashes for ignore special characters for the time of updating data in table.

Collectives™ on Stack Overflow

Update image in database using PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related