[RESOLVED] Can I populate a database table from a folder

[ee12csvt]

Hi All,

I am not sure if this can be done or if I need to update my other codes!

I currently have a page to upload an image to the image folder on the server (Only local at the moment). What I want to know is, can I populate a table in my database with the file names of the images I have uploaded to the image folder?

I want to use the information held in the image table when I create an item in another table.

The only other way I can think of doing this is to save the filename in the upload form to the image table. Not sure if this can be done either.

Any guidance would be much appreciated.

Regards,

Phil

[ee12csvt]

Hi Again!

I have done a little bit of research and have got this working, but would like to be able to enter a new name for the file as it is uploaded.

This is the form I am using.

<form enctype="multipart/form-data" action="add.php" method="POST" id="formin">
<table border="0" cellpadding="0" cellspacing="0" id="tablein">
  <tr>
<th>New Filename :</th><td><input type="text" name="filename"></td></tr>
<th>File :</th><td><input type="file" name="photo"></td></tr>
<th>&nbsp;</th>
<td><input type="submit" id="button" value="Add" /></td>
</tr>
</table></form>

There are two entries on the form 'filename' and 'photo'. The photo will hold the information of the uploaded file on my hard drive, but I want to rename the file before it is stored in the image folder on the server to the info entered in 'filename'. Obviously I need the database table to store this new filename instead of the original filename, which is stored in the table using the above code.

Any guidance/help would be much appreciated.

Many Thanks in advance.

Phil

[ee12csvt]

Hi All,

Just to update, I have now got this working as I want. Thanks for looking.