how do i insert objects into db from php

[jwandrews]

Hello, I am trying to insert pictures users can upload into a DB, here is my code:

$handleF = fopen("eric3.gif", 'r');
$handleF = fread($handleF, filesize("eric3.gif"));
$handleF = addslashes($handleF);
$query2="Insert into Pics (CDDBNumber, FrontCover) VALUES ($CDDBNumber, '$handleF')";
$result = odbc_do($link, $query2);

What am i missing? (obviousely my connection and link statements are above this)

[ptbsG_Man]

youn need to have ' ' around each of you values

[gyash]

open file in binary mode..

$handleF = fopen("eric3.gif", 'rb');

[OhLordy]

How good is MySQL for handling binary data?
I heard that it was far quicker and used less space to use MySQL to store a link to a file location for binary stuff, is this true or am I just being led astray? :-)
Cheers
Rob

[zingbats]

it really does depend on the size of the file. If you are using small gif files, then MySQL is ok, however, if you are using larger files, it is best to use links 😃