Storing Images In MySQL

Uploading The Image

Here we get funky and can stick the image into the database.

As with all user input it is vital that it is checked with some sort of sanity checking to be sure we are getting what we asked for.

In this case, we are asking for image files of types that are supported by getimagesize().

First of all, we need to check that when somebody accesses our page the they have POSTed a file. If they have not, we can echo a simple message and if they have, we can call the upload() function that we will create. Please note that this function uses PHP5 exceptions.

<?php
    // check if a file was submitted
    if(!isset($_FILES['userfile'])) {
        echo '<p>Please select a file</p>';
    }
    else
        {
        try {
            upload();
            // give praise and thanks to the php gods
            echo '<p>Thank you for submitting</p>';
        }
        catch(Exception $e) {
            echo $e->getMessage();
            echo 'Sorry, could not upload file';
        }
    }
?>

• Next: The Upload Function

Article History

May 30, 2005

Initial article version

Jan 18, 2008

Updated listing 5 to not include non-existent conf.php