Hi!
Have you tried echoing $aFileContents in the same script? Does it
actually contain anything? You may have a problem with reading from the
upload file...
Bogdan
Djurovski Dejan wrote:
> 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
