[SOLVED] Can you upload images directly to MySQL?

[aim25]

Well i was just wondering if there was any way to actually upload the image to the database, and opposed to putting the image somewhere else and recording its url and other info in a table.

[Wildbug]

Sure, you can put the data in a PHP variable and INSERT it into a MySQL BLOB column as you would normally.  Use mysql_real_escape_string() to escape anything that would break the query.

 

$image = file_get_contents('image location...'); // or from $_FILES or whatever
mysql_query(sprintf('INSERT INTO images (image) VALUES ("%s")',mysql_real_escape_string($image));

 

That simple example should work.