Image upload and display

kombayn

Hi,
I like to upload image on server and after that to display it within other data.

here is some parts of my submitting form:
<HTML>
<HEAD>
<TITLE>Upload test</TITLE>
</HEAD>
<FORM METHOD=POST ACTION="add1.php3">
<p align="center">
<input type="hidden" name="id" value="NULL">
</p>
<table width="50%" border="1" align="center">
<tr>
<td width="32%">Ime</td>
<td width="68%">
<input type="text" name="ime" size="10">
</td>
</tr>
...
<td width="32%">slika</td>
<td width="68%">

          [COLOR=red]<input type="file" name="imgdata"> [/COLOR]
    </td>
</tr>

</table>
</FORM>

Question:
I can read all other data from input form exept imgdata. I like to store image somewhere on the server and to store in database just path from which I can retreive image later in my result page.
Can anybody provide me some help.
And sorry for my not so good English.
Dejan😕

new7media

Hi there -

If I'm understanding you correctly, your form is working where uploading your file and saving it somewhere on your server is concerned. Also everything you want to save to your database is getting saved there. The problem is that the name of your file is not being saved to the database. Do I have this right?

If so, maybe this code will help you with saving the file's label to your database:

if ($file) { // 
     copy ($file, "/path/to/your/server/directory/$file_name");
     $filename = $file_name;
     unlink ($file);
}

This little bit of script is a quick bit of code that handles moving a file to the server. The $filename variable takes on the name of the just uploaded file.

Now, when you do your table INSERT or UPDATE, just make sure you include $filename along with the rest of your data.

So to INSERT a new record:

$sql = "INSERT INTO your_table (id,text,filename) VALUES (NULL,'$text','$filename')";
mysql_query($sql);

And to UPDATE an existing record:

$sql = "UPDATE your_table SET text='$text', filename='$filename' WHERE id = '$id';
mysql_query($sql);