Can anyone show me a good example of php and SQL to insert a image url into a database, storing image folder?

Question

I just want a good example to follow of how to use php to add an image name or path to that image into a sql database. I'm using a form that uploads a picture among other things, I upload the image fine to a folder, but I want to add the link to the image into my database, nothing seems to work, help?

Maybe I'm just to new to this, but how do I get ahold of the file name itself from the form, and add that name into that database, along with the url. So every different row in the database would have the same url except for the filename

i figured it out, i was trying to .$_POST['$filename']. the value, i just took out the $_POST and set the value to $filename, thanks everyone for your help

Answer 1

$sqlCommand = "INSERT INTO tblImages SET imagePath='$img_path_here'";
mysql_query($sqlCommand);

Answer 2

I would like to request u to try it yourself. And if u get any problem, then ask. If any one of us provided u the code, u will never learn the thing. I give u some hints.
You will need
enctype="multipart/formdata" in the form tag.
On the file u mentioned in action attribute of form tag, you will be using $_FILES. So try to explore this array first. You can try learning this array at http://www.php.net/features.file-upload.

One thing more,
you don't need to store the url in database. Just store the file name. And have this url in some config.php which u should include in every file. You can use the url from there.
Wish u good luck

Answer 3

Something like this?


mysql_connect($server, $user, $pass);
mysql_select_db($dbname);

$sql = "INSERT INTO $table SET path='$path'";
mysql_query($sql);

?>