Grow your CSS skills. Land your dream job.

load image into database table

  • # April 10, 2009 at 9:47 am

    this is my pic.php
    i want to load image into mysql database table how pls any one help me

    <?php
    include_once(‘config.php’);

    //define a maxim size for the uploaded images in Kb
    define ("MAX_SIZE","100");

    //This function reads the extension of the file. It is used to determine if the file is an image by checking the extension.
    function getExtension($str) {
    $i = strrpos($str,".");
    if (!$i) { return ""; }
    $l = strlen($str) – $i;
    $ext = substr($str,$i+1,$l);
    return $ext;
    }

    //This variable is used as a flag. The value is initialized with 0 (meaning no error found)
    //and it will be changed to 1 if an errro occures.
    //If the error occures the file will not be uploaded.
    $errors=0;
    //checks if the form has been submitted
    if(isset($_POST))
    {
    //reads the name of the file the user submitted for uploading
    $image=$_FILES;
    //if it is not empty
    if ($image)
    {
    //get the original name of the file from the clients machine
    $filename = stripslashes($_FILES);
    //get the extension of the file in a lower case format
    $extension = getExtension($filename);
    $extension = strtolower($extension);
    //if it is not a known extension, we will suppose it is an error and will not upload the file,
    //otherwise we will do more tests
    if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))
    {
    //print error message
    echo ‘<h1>Unknown extension!</h1>';
    $errors=1;
    }
    else
    {
    //get the size of the image in bytes
    //$_FILES is the temporary filename of the file
    //in which the uploaded file was stored on the server
    $size=filesize($_FILES);

    //compare the size with the maxim size we defined and print error if bigger
    if ($size > MAX_SIZE*1024)
    {
    echo ‘<h1>You have exceeded the size limit!</h1>';
    $errors=1;
    }

    //we will give an unique name, for example the time in unix time format
    $image_name=time().’.’.$extension;
    //the new name will be containing the full path where will be stored (images folder)
    $newname="images/".$image_name;
    //we verify if the image has been uploaded, and print error instead
    $copied = copy($_FILES, $newname);
    if (!$copied)
    {
    echo ‘<h1>Copy unsuccessfull!</h1>';
    $errors=1;
    }}}}

    //If no errors registred, print the success message
    if(isset($_POST) && !$errors)
    {
    echo "<h1>File Uploaded Successfully</h1>";
    }

    ?>

    <!–next comes the form, you must set the enctype to "multipart/frm-data" and use an input type "file" –>
    <form name="newad" method="post" enctype="multipart/form-data" action="show.php">
    <table>
    <tr><td><input type="file" name="image"></td></tr>
    <tr><td><input name="Submit" type="submit" value="Upload image"></td></tr>
    </table>
    </form>

    # April 28, 2009 at 12:37 pm

    I’m confused. The code you posted is correct and will successfully upload an image (I tried it myself).

    Are you asking how to modify the sample code to put the file in a database instead of the images folder? If so, my response is you shouldn’t; you should never store an image in a database.

    Are you asking how to store the path to the image in the database?

    Please clarify.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

*May or may not contain any actual "CSS" or "Tricks".