Re: [PHP] How do I dump a blob or text into a mySQL Database?

Dan Anderson wrote:
> I'm trying to split up a file and dump it into a mySQL database BLOB.
> Wherever I run the query:
>
> mysql_query("INSERT INTO table (field) VALUES ('{$buffer}')");
>
> Nothing ever shows up in the table -- whethere field is a text or a blob
> and whether I dump in text or binary. Oddly enough when I run the query
> I get no error, and can print it and run it through a mySQL terminal,
> and it works.
>
> Anyone have any ideas?

Is $buffer empty? I would start there.

- Brad

On Monday, July 14, 2003, 8:51:22 PM, Brad wrote:

BP> Dan Anderson wrote:
>> I'm trying to split up a file and dump it into a mySQL database BLOB.
>> Wherever I run the query:
>>
>> mysql_query("INSERT INTO table (field) VALUES ('{$buffer}')");
>>
>> Nothing ever shows up in the table -- whethere field is a text or a blob
>> and whether I dump in text or binary. Oddly enough when I run the query
>> I get no error, and can print it and run it through a mySQL terminal,
>> and it works.
>>
>> Anyone have any ideas?

BP> Is $buffer empty? I would start there.

I would also look at serialize()


--
Regards,
Burhan Khalid
phplist[at]meidomus[dot]com
http://www.meidomus.com