php Image returning blank

Question

I am able to upload an image file path to the database, although when trying to update it, the file name show as blank on the db.

<input type='file' id='image' name='image'>

$target_dir = "assets/img/products/";
$target_file = $target_dir . basename($_FILES["image"]["name"]);
move_uploaded_file($_FILES["image"]["tmp_name"], $target_file);

$img = mysqli_real_escape_string($conn, $target_file)


$sql = "UPDATE products SET image = '$img' WHERE product_ID='$index'";
mysqli_query($conn,$sql) or die(mysqli_error($conn));

Your update query has some errors like the opening quote is not closed plus you are also missing a WHERE clause right? — Nahom Alpha Geek
– Nahom Alpha Geek, Commented May 4, 2018 at 9:15
ah sorry yeah forgot to include the where, and the target file just returns "assets/img/products/" — Gray
– Gray, Commented May 4, 2018 at 9:24
use enctype in "form" tag: <form enctype="multipart/form-data" > — Let's Enkindle
– Let's Enkindle, Commented May 4, 2018 at 9:59

DRC · Accepted Answer · 2018-05-04 09:13:43Z

2

You are probably reposting the same form, and the input [name="image"] is empty, so you update the field with an empty value

You should check if you have any file posted before performing the update on the image field:

if(file_exists($_FILES['iamge']['tmp_name']) && is_uploaded_file($_FILES['image']['tmp_name'])) {  
 // perform update
}

answered May 4, 2018 at 9:13

DRC

5,0582 gold badges23 silver badges36 bronze badges

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

Comments

Let's Enkindle · Accepted Answer · 2018-05-04 09:58:50Z

-1

use enctype in form tag

<form enctype="multipart/form-data" >

edited May 4, 2018 at 9:58

answered May 4, 2018 at 9:51

Collectives™ on Stack Overflow

php Image returning blank

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related