Please Help !! File upload with PHP 5

[Jesuz]

I'm using PHP 5, mySql 5 and Apache2

I'm trying to write a page with a file upload field so the user can put the file up to the server, in the mean time I'd like to save that full path to my DB. So I can show that URL link then user can click on that link to open the file.

Any advice? Now I can just put the file to server but don't know how to save URL to DB.

I want my page to be like this
http://examples.codecharge.com/CCSExamplePack2/FileUpload/FileUpload.php

Thanks guys

[bpat1434]

Have you seen this?

[Jesuz]

bpat1434 wrote:

Have you seen this?

Yep!! but most of the explanation is about the code generated by CodeCharge Studio :queasy:

[samudasu]

Basically this is what you can do. I wouldn't recommend putting the full url into the database. If you happen to change servers then you'll have to make changes to the database. Instead you can just store the photo name "example.jpg" and then add that on to the path in your html.

if (move_uploaded_file($source, $destination)) { // if the file is uploaded successfully
    $photo = basename($destination); // get photo name without the full path 
    connect to database here  // self explanatory
    select database here   // self explanatory
    do the query:  // insert into tablename values ('id', '$photo');
}
print "<img src=\"http://yourhost.com/images/$photo\" />";