[boskyvora]

Hi There,

I need a script to upload images to my MySQL server. Can anyone help me or guide me, n tell me where i can find it?

Regards,
Bosky

[DuEy]

well the mysql database would need a Blob field for a start. Code is something like this (after uploaded to server)

PHP Code:

<?

$file = fopen("image.jpg", "r");

$image = addslashes(fread($file, filesize("image.jpg")));

$con = mysql_connect("localhost","nick","ihateperl");

mysql_select_db("database");

$query = 'INSERT INTO `images` (`image`) VALUES (\''.$image.'\');';

mysql_query($query) or die(mysql_error());

fclose($file);

?>

something like that.

[phpkid]

Mostly, it's not good idea to store image file contents directly in MySQL server.

Check out if you can you do away with storing path of the image file instead.

Regards,
JD