From: [EMAIL PROTECTED]
Operating system: Win XX
PHP version: 4.0.4pl1
PHP Bug Type: MySQL related
Bug description: Error with inserting a binary data into database
error occured only in PHP compiled as a module on WIn95,98
php from default win installation, no changes in php.ini
tested on many computers
problem occured while inserting images (binary data into database). Functional script
under OS LINUX don't work, because process of importing a binary data (for example gif
image) is stopped when PHP detect some 'special' character.
the same thing happend while trying to open binary data with file functions
good code /tested on Linux and on cgi version of php under win/
create database pokus;
create table pokus(pole blob);
insert.php - it doesnt import whole image!
<?
$subor = "b.gif";
$fp = fopen($subor, "r");
$data = addslashes(fread($fp, filesize($subor)));
fclose($fp);
$data = "insert into pokus values ('$data')";
$conn = mysql_connect("localhost", "root", "root");
$vysledok = mysql_db_query("pokus", $data);
?>
script for showing image
<?
Header("Content-type: image/gif");
$conn = mysql_connect("localhost", "root", "root");
$vysledok = mysql_db_query("pokus", "select * from pokus");
$z = mysql_fetch_array($vysledok);
echo $z[pole];
?>
--
Edit Bug report at: http://bugs.php.net/?id=9274&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
