How to allow users to upload to a pictures to a database using php

Question

Hi I need to allow users to upload pictures to a mysql server. Currently I just have my users upload to a folder on my website but this does not allow me to organize there images by most recent?

Here is my php that allows them to upload to a folder on my website:

 if (file_exists("upload/" . $_FILES["file"]["name"]))
  {
  echo $_FILES["file"]["name"] . " already exists. ";
  }
else
  {
  move_uploaded_file($_FILES["file"]["tmp_name"],
  "upload/" . $_FILES["file"]["name"]);
  echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
  }

Thanks

@Pekka웃 Right now when a user uploads a image to my site it puts it into a folder on my site. I want to make it so every time a user uploads an image, it puts the image in a database. Thanks. — bendouglas, Dec 19 '13 at 04:05
http://stackoverflow.com/questions/492549/how-can-i-insert-large-files-in-mysql-db-using-php — JPR, Dec 19 '13 at 05:14
nothing much. you just need to insert you image name in database. — himanshu bhardiya, Dec 19 '13 at 05:37

score 0 · Answer 1 · answered Dec 19 '13 at 05:32

first of all your question is not clear. See for you to store a image in DB just add a record in database table where you store the complete path and the image name in the server. in order to keep your image name unique rename the images by some unique value such as timstamp value.

$ext = split("[/\\.]", $filename) ;
$newname = time().'.';
$path = "upload/";
$target = $target . $newname.$ext;
move_uploaded_file($_FILES['file']['name'], $target);

How to allow users to upload to a pictures to a database using php

1 Answers1