update blob with a url

[LuckySyringe]

I'm using PHP to run a loop of MySQL queries that should update the blobs with small image files, but it doesn't work. I am thinking its because I am running the queries remotely, because the MySQL documentation seems to only upload the files locally, is there any difference?
$fileURL is in the form

[URL unfurl="true"]http://www.host.com/image(x).gif[/URL]

where (x) is 1 - 395 (without parenthesis).

UPDATE $dbTable SET content=LOAD_FILE('$fileURL') WHERE id=$x

-> LuckySyringe

 

[TonyGroves]

The LOAD_FILE path is interpreted at the server, so it must be a path accessible from the server.

Your best solution would be to include the binary data in the query, escaping it appropriately. That's exactly what the mysqldump program does. There might be functions in the PHP database API which are designed for that.

 

[LuckySyringe]

Ok, I will look through the functions in the PHP/MySQL APIs

-> LuckySyringe