I can't upload picture to MySQL database:
What is wrong with my script:
I use PHP & MySQL database.
After submiting form my script says that everything is OK, but in database I
see that a picture is not uploaded.(date, size, name, type are inputed, but
data is not!).
Table:
CREATE TABLE pictures (
picture_id int(11) DEFAULT '0' NOT NULL,
name varchar(30) NOT NULL,
date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
pic_data mediumblob NOT NULL,
pic_size int(11) DEFAULT '0' NOT NULL,
pic_type varchar(30) NOT NULL,
PRIMARY KEY (picture_id)
);
My PHP page:
<?php
include_once("db_mysql.php");
class pictures_db extends DB_Sql
{
var $Host="localhost";
var $Database="sajt";
var $User="root";
var $Password="";
}
$aErrors=False;
if (!empty($PicFile_name))
{
if ( ($PicFile_type == "image/gif") ||
($PicFile_type == "image/pjpeg") ||
($PicFile_type == "image/jpeg"))
{
$aFile=fopen($PicFile, "rb");
$aFileContents=addslashes(fread($aFile, filesize($PicFile)));
fclose($aFile);
$aDB=new pictures_db();
$aSQL="select(max(picture_id) + 1) as new_id from pictures";
$aDB->query($aSQL);
if ($aDB->next_record() )
{
$aNewID=$aDB->f("new_id");
}
if(empty($aNewID) == True)
{
$aNewID=1;
}
$aSQL="insert into pictures (picture_id, name, ".
"date, pic_data, ";
$aSQL .="pic_size, pic_type) values ($aNewID, ".
"'$PicName', ";
$aSQL .= "NOW(), '$aFileContents', '$PicFile_size', ".
"'$PicFile_type' )";
print($aSQL);
$aDB->query($aSQL);
if ($aDB->Errno != 0)
{
$aErrors = True;
}
}
else
{
$aErrors= True;
}
}
else
{
$aErrors = True;
}
if ($aErrors == False)
{
print("OK");
}
else
{
print("ERROR!!!");
}
?>
---------------------
---------------------
Šurovski Dejan
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
