Hello,

I am having a problem BLOBing a Microsoft Excel file into a database. Here is the code I am using..

$svcSheetHandler = fopen ( $_FILES['svcSheet']['tmp_name'], "r" );
        $svcSheetContent = fread( $svcSheetHandler, $_FILES['svcSheet']['size'] );
        $svcSheetContent = addslashes ( $svcSheetContent );
        fclose ( $svcSheetHandler );

I have used this exact same code many times before with no problems, but this time it does not work. If I remove the BLOB part of it, then the query runs fine. When I try to run the query in MySQL query browser the blob field is not rendered as a string, I can tell because it is not highlighted the normal string color.

I get this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( aid, date, number, xls_data ) VALUES ( 1, STR_TO_DATE('07/07/2007', '%m/%d/%Y'' at line 1

For this SQL:

INSERT INTO  ( aid, date, number, xls_data ) VALUES ( 1, STR_TO_DATE('07/08/2008', '%m/%d/%Y'), 1, "BLOB CODE HERE" )

Here is my table structure:

CREATE TABLE `service_sheets` (
  `ssid` int(10) unsigned NOT NULL auto_increment,
  `aid` int(10) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `number` int(11) default NULL,
  `xls_data` blob NOT NULL,
  `pdf_data` blob NOT NULL,
  PRIMARY KEY  (`ssid`),
  KEY `aid_fk` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

I can post the blob code if it is necessary but it is very long so I decided to leave it out.

I have been working hard at this and I cannot seem to figure out what is wrong.

Thanks in advance for your help,

FuZion

Table name (service_sheets) is missing in mySQL Query.

This works fine.

INSERT INTO service_sheets ( aid, date, number, xls_data ) 
VALUES ( 1, STR_TO_DATE( '07/08/2008', '%m/%d/%Y' ) , 1, "BLOB CODE HERE" )

Hope this helps.

Thats, correct, but that is a mistake on my end. I tend to think less when I get frustrated .

I wrote a few functions to use with mysql.. and in the query function it uses regex to find <table nickname> and it references an array to find the actual table name and replaces it. That is why there was nothing in there. I have, however, been adding it in my queries. I can't believe I forgot it here.. I need to take a break.

Anywho, the error is the same with the table in there.. but it has some of the blob data in there. Could it be the file I'm uploading?

Would it help if I posted a query with the data in it?

Turns out the php file was in DOS format, not UNIX format which was causing some problems. Everything is working fine now.