How to upload an image, save it on the server and store its location into a mysql tab

Betty_S

Hallo everyone!

I wont to add php/html code which can do that:

Let the user choose and upload a file (an image), save the file on the server and store its location into a mysql table.

If you have an example code or a link that would be super!

I know how to handle the html part but I have no idea whatsoever what to do with the path I get from the user!😕

Please help me.

Thanks.

wilku

Here's a good example of how to upload images http://forums.devnetwork.net/viewtopic.php?t=41743
For other tutorials you may go to General Help forum FAQ (sticky on top of the forum), where you can find another link to post with tutorials. I think you should be able to find a tutorial for you there somewhere.

Betty_S

thanks

Installer

Basically, like this:

$store_path = 'path/to/storage/dir';
if (is_uploaded_file($_FILE['ul_file']['tmp_name']) && ($_FILES['ul_file']['error'] == UPLOAD_ERR_OK)) {
    echo 'Upload succeeded<br />';
    if (move_uploaded_file($_FILE['ul_file']['tmp_name']), $store_path . $_FILE['ul_file']['name'])) {
        echo 'File move succeeded<br />';
        if (mysql_query("INSERT INTO my_table img_name, img_dir 
                         VALUES ('" . $_FILE['ul_file']['name'] . "', '" . $store_dir . "')";
            echo 'Insert query succeeded<br />';
        } else {
            echo 'Insert query failed<br />';
        }
    } else {
        echo 'File move failed<br />';
    }
} else {
    echo 'Upload failed';
}

For more detail see:
Handling File Uploads
is_uploaded_file(}
move_uploaded_file()
MySQL functions
MySQL Reference ManualEdit: Sorry, I didn't think the post had been replied to, and didn't notice that it had until now.

Betty_S

thanks

bradgrafelman

Don't forget to mark this thread resolved.

theprofession

is it possible to use this to assign an image uploaded by a user?