Re: Saving Image in mySQL

I am with Karl on this.

Storing an image in the db is very heavy on lpad times.

Upload the image to a folder with name saved with location
On Mar 19, 2013 11:12 PM, "Karl DeSaulniers" <[email protected]> wrote:

> Hey Ron,
> I don't know how others feel, but I say save yourself a headache and dont
> store the image data, just the url to the image on the server.
>
> image_url – VARCHAR 100
>
> Best,
> Karl
>
>
>
> On Mar 19, 2013, at 3:15 PM, Ron Piggott wrote:
>
>
>> Hi All
>> I don’t understand how to save an image to a mySQL table based on the
>> following form. I am trying to do this using Prepared Statements.  All the
>> fields except the image file itself save in the database.  Right now I have
>> $file as the variable when binding the values.  What should it be?  Ron
>>
>> ===
>> <form action="add_my_image.php" method="post"
>> enctype="multipart/form-data">
>> <label for="file">Filename:</label>
>> <input type="file" name="file"><br>
>> <input type="submit" name="submit" value="submit">
>> </form>
>> ===
>>
>> mySQL table structure:
>> ===
>> reference – INT 10 auto_increment primary
>> caption – VARCHAR 250
>> image_type – VARCHAR 100
>> image_size – INT 10
>> image_name – VARCHAR 100
>> image – LONGBLOB
>> ===
>>
>> Prepared Statement:
>>
>> ===
>> # mySQL query
>>
>>    $query = "INSERT INTO `my_images` ( `reference` , `caption` ,
>> `image_type` , `image_size` , `image_name` , `image` ) VALUES ( NULL ,
>> :caption , :image_type , :image_size , :image_name , :image );";
>>
>> # apply query to Prepared Statement
>>
>>    if($stmt = $dbh->prepare( $query )) {
>>
>> # bind variables
>>
>>        $stmt->bindValue(':caption', 'Test Caption', PDO::PARAM_STR);
>>        $stmt->bindValue(':image_type'**, $_FILES["file"]["type"],
>> PDO::PARAM_STR);
>>        $stmt->bindValue(':image_size'**, $_FILES["file"]["size"],
>> PDO::PARAM_INT);
>>        $stmt->bindValue(':image_name'**, $_FILES["file"]["name"],
>> PDO::PARAM_STR);
>>        $stmt->bindValue(':image', $file, PDO::PARAM_STR);
>>
>> # execute query
>>
>>            if ( $stmt->execute() or die(print_r($stmt->errorInfo()**,
>> true)) ) {
>>
>> # retrieve auto_increment value
>>
>>                $new_record_reference = $dbh->lastInsertId();
>>
>>            }
>>
>>    }
>> ===
>>
>>
>> Ron Piggott
>>
>>
>>
>> www.TheVerseOfTheDay.info
>>
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>