I cannot insert image fileinto my mysql.

Anon

I cannot insert image file into my mysql.
and Id=0.
please help. thanks

spider_man

Ok, what's EXACTLY your problem?

Anon

I donot store image in my mysql and following:

$res=MYSQL_CONNECT("localhost","root","setup66");
mysql_select_db("binary_data",$res);
$data = addslashes(fread(fopen("$form_data", "r"), filesize("$form_data")));
$result="insert into binary_data(description,bin_data,filename,filesize,filetype)values('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')";
$res=mysql_query($result,$res);
$id= mysql_insert_id();
print "This file has the following Database ID: $id";

spider_man

Ok.

I didn't really needed the password.
Well, I see you are overwriting your conection handler $res with the query, I could be that.
When you are developing a script, try to test it gradually.
I mean, after you open the connection, try testing the variable, if it's false, then display the mysql error with the mysql_error function, try displaying the $data variable, etc.
And don't forget to watch for the php generated errors.
If these aren't much descriptive, then raise the verbose level in the pnp.ini file.

Hope it helped, now go get that code running!

Anon

rmdir wrote:

I donot store image in my mysql and following:

$res=MYSQL_CONNECT("localhost","","");
mysql_select_db("binary_data",$res);
$data = addslashes(fread(fopen("$form_data", "r"), filesize("$form_data")));
$result="insert into binary_data(description,bin_data,filename,filesize,filetype)values('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')";
$res=mysql_query($result,$res);
$id= mysql_insert_id();
print "This file has the following Database ID: $id";

spider_man

Analize the results from this.

$conn=mysql_connect("localhost","","");
if (!$conn)
{
echo mysql_error();
exit
}

mysql_select_db("binary_data",$conn);

$data = addslashes(fread(fopen("$form_data", "r"), filesize("$form_data")));

echo $data;

$result="insert into binary_data(description,bin_data,filename,filesize,filetype)values('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')";

echo $result;

$res=mysql_query($result,$conn);

if (!$res)
{
echo mysql_error();
exit
}

$id= mysql_insert_id();
print "This file has the following Database ID: $id";