Storing Images or Links to them in mysql - help?!

Anon

i need to be able to store images, or link to the images, in mysql. i know how to store data (links) in mysql, but i'd like for the add record form to also upload the image and store it with a file name that is the same as another field on the form, such as the record number or something... not sure how to go about this... thanx in advance.

Anon

I would like to do about the same as you suggest. It continues both this thread and a previous thread I saw in this form about uploading files to the server.

I would like to be able to upload image-files into the database (what filetype would be convenient for this (I think of a BLOB-type)) and to get them from the database.

Like <img src="get_image_from_db (1)">

Thanks very much in advance,

Martijn Weisbeek

Anon

Here's what I use 🙂

function picUpload(){
$conn=mysql_connect($GLOBALS[server],$GLOBALS[uid],$GLOBALS[pwd]);
mysql_select_db($GLOBALS[dbname], $conn);
$data = addslashes(fread(fopen($GLOBALS[form_data], "r"), filesize($GLOBALS[form_data])));
$sql = "UPDATE tablename SET bin_data='$data',filename='$GLOBALS[form_data_name]',filesize='$GLOBALS[form_data_size]',filetype='$GLOBALS[form_data_type]' WHERE nick='$GLOBALS[nick]'";
$doit = mysql_query($sql,$conn);
print "<p>This file has the been uploaded: <b>$GLOBALS[nick]</b>";
MYSQL_CLOSE();
}

Then to show it after ...

$query = "select bin_data,filetype from ops where id=$id";
$result = @($query);

$data = @MYSQL_RESULT($result,0, "bin_data");
$type = @MYSQL_RESULT($result,0, "filetype");

Header( "Content-type: $type");
echo $data;

That should help you out, works great.

Anon

Hmm, I tried about what you suggested.
I also took an example from the PHP-manual.
Together with your example it looked like it made sense.
So I coded what I thought should be it.
However, after uploading to the server and trying it out, it failed on security.
It is not my own server (webspace-provider), so I cannot change things there. Or could I perhaps upload to some other directory than this tmp-directory ?

Warning: SAFE MODE Restriction in effect. The script whose uid is 3253 is not allowed to access /var/tmp/phpv81412 owned by uid 0 in /home/weisbeek/public_html/doaddapp.php3 on line 11

Warning: fopen("/var/tmp/phpv81412","r") - Undefined error: 0 in /home/weisbeek/public_html/doaddapp.php3 on line 11

Thanks in advance,

Martijn Weisbeek
trying to make a nice site that lists the best free software