[RESOLVED] Store Image URL or Path in DB

jwilley

Hi all,
So i've been racking my brain on this all day and I know there is an easy answer to this... I am trying to basically setup a file upload system that only I will be able to access so I can upload photo's AND staff bio's to a database. I underswtand completely how to setup and get the database working for just text and how to call it up, etc using Dreamweaver MX 2004's PHP MySQL utilities, but I am really struggling on how to get the image path into the database with it. I would in theory like to have the bio enter page also have the ability to handle the file upload as well and then have it send the URL to the db for that id. So here are my issues:

1) Setting up a file upload that sendt the photo to a filesystem folder AND also SENDS the absolute path to the database that matches the bio of the staff member being entered...

well, that's basically the only issue. I can't find anything that spells out how to upload the path of the photo to the database... any tutorials or code help would be greatly appreciated. I know this is easy PHP but i'm struggling on this one..

Thanks,
Jonathan

bastien

make it simple, store all images in the same folder, then all you need to store is the file name which is available thru $_FILES['formFieldName']['name']

then when referencing the images you just hardcode the path to the images folder and append the name

jwilley

not sure how to put it all together and get all of the info to the DB but I will work on it! Any other help would be greatly appreciated..

jwilley

So how do i pass the PATH to the database with the bio info?

bastien

you don't....your image code should look like this (when showing the image)


while ($rows=mysql_fetch_array($result))
{
  $img = $rows['image_name'];
  echo "<img src=\"../path/to/$img\">";
  //.... rest of your bio code
}

jwilley

Thanks for the help... I was able to devise a system that stores the URL of the photo in a new database table and then when I input the rest of the bio information I can pic the photo from a dynamic dropdown menu to add to that story. Seems to work at this point. Maybe not the best way to do it but hey, it's all good!

Jon