PHP Image upload - spot the error [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 3 months ago.

Improve this question

I have a small problem with my PHP image upload code, I`m not getting the correct file name to be saved to my MySQL database.

Please tell me what im doing wrong.

PHP:

// Upload File to Directory
$code = md5(time());
$image = $_FILES['userfile']['name'];
$imagename = $code.$image;
$uploaddir = '../_gallery/' . $imagename;
$uploadfile = $uploaddir . basename($_FILES['userfile']['name']);
move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile);

MySQL query:

$sql="UPDATE b_events 
      SET ename = '$event_name', 
          edescription = '$event_description', 
          edate = '$event_date', 
          etime = '$event_time', 
          ecost = '$event_cost', 
          eimage = '$imagename' 
      WHERE id = '$update'";
$result=mysql_query($sql);

what result do you expect to get and what result are you getting ? — DonSeba
– DonSeba, Commented Jul 20, 2012 at 10:49
Im getting the file name, trying to rename it with md5, file is uploaded correctly with new name, but not to the database. — user1540512
– user1540512, Commented Jul 20, 2012 at 10:52
Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — Madara's Ghost
– Madara's Ghost, Commented Jul 20, 2012 at 10:55

M_A_K · Accepted Answer · 2012-07-20 10:52:53Z

1

you need to insert this name to your database becuase you upload file into directory by this name

or by assigning values to new variable

$sql="UPDATE b_events 
          SET ename = '$event_name', 
              edescription = '$event_description', 
              edate = '$event_date', 
              etime = '$event_time', 
              ecost = '$event_cost', 
              eimage = '$uploadfile' 
        WHERE id = '$update'";

OR

  $file_name =basename($_FILES['userfile']['name'];

$sql="UPDATE b_events 
          SET ename = '$event_name', 
              edescription = '$event_description', 
              edate = '$event_date', 
              etime = '$event_time', 
              ecost = '$event_cost', 
              eimage = '$file_name' 
        WHERE id = '$update'";

answered Jul 20, 2012 at 10:52

M_A_K

3783 silver badges17 bronze badges

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

5 Comments

user1540512 Over a year ago

Im still getting only the file name "image.jpg", it hould be something like "0fec90395c188efea02300c1dabf7950image.jpg".

M_A_K Over a year ago

ok u need to use this variable for insertion $imagename which you make by concatenation of md5 and file

user1540512 Over a year ago

tried that on my post, not working, not getting the full name to be inserted to the database, just that the file uploads 100% correctly with the name change and not the the database itself.

user1540512 Over a year ago

Used variable $uploadfile and now working correctly by uploading the renamed file to the directory and saving the file name to the database.

user1540512 Over a year ago

I have it solved, is there a way to resize the image though the code above? need it resized.

Collectives™ on Stack Overflow

PHP Image upload - spot the error [closed]

1 Answer 1

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Related