pics?

[infomorelos]

Hi,
can I put images into a MySQL table?
If so, which kind of field would that be?

Thank you in advance

[Oleg Butuzov]

1) Yes you can
2) BLOB

[Elena Mitovska]

One of the ways to insert image:
$data = "";
$userfile = $HTTP_POST_FILES['userfile']['tmp_name'];
//get file
$fp = fopen($userfile, "rb");
while(!feof($fp))
{
$data .= fread($fp, 1024);
}
fclose($fp);

$data = addslashes($data);
$data = addcslashes($data, "\0");

//insert image into database
$Query = "INSERT INTO imagesVALUES(".$item_no.",'$data')";

[Oleg Butuzov]

Helen, you forgot to say "thank you http://php.spb.ru"

he is author of the script =)