Re: [fw-db] Mysqli adapter inserts empty strings

I've tried executing a very basic insert query by using mysqli class
for testing.
Here is the code i've used:

$mysqli = new mysqli('host', 'my-username', 'my-password', 'database');
$mysqli->query("INSERT INTO test(content) VALUES('try try try')");

This works properly. So i need more experiments to find out the
solution. I'll continue trying as i have free time and i'm going to
write my results.

On Mon, Jul 21, 2008 at 1:51 PM, sempsteen <sempsteen@gmail.com> wrote:
> It works on my local computer. I have:
> - PHP 5.2.4
> - MySQL 5.0.51a,
>
> On server INSERT doesn't work properly but i haven't had any issues
> with SELECT. Server configuration is:
> - PHP 5.2.5
> - MySQL 4.1.22
>
> Where do i need to look for a solution?
> Thanks.
>
>
> On Mon, Jul 21, 2008 at 10:05 AM, Maxim Savenko <maxim.savenko@gmail.com> wrote:
>> Yesterday, I tried to change db driver in my project from pdo_mysql to
>> mysqli, and there was the same behavior. All select operations was ok, but
>> no success insertion occured. I use mysql 5.1 and php 5.2.6 + ZF 1.5.2. I
>> noticed that in php.log the 'Unhandled Exception in line 0' string
>> appeared.
>>
>>
>> PS: I think we have found a bug :)
>>
>>
>> 2008/7/21 sempsteen <sempsteen@gmail.com>:
>>>
>>> Hi all,
>>> I'm using Mysqli extension. When i try to insert a data to the
>>> database it always inserts empty strings. I've searched for solution
>>> but couldn't find anything. In PHP documentation it says:
>>> The mysqli extension is designed to work with the version 4.1.3 or
>>> above of MySQL. For previous versions, please see the MySQL extension
>>> documentation.
>>> And my server has MySQL v4.1.22. Do you think this is because of my
>>> MySQL version?
>>> Thanks.
>>>
>>
>>
>>
>> --
>> Good Luck.
>>
>> Maxim Savenko
>> EMail: maxim.savenko@gmail.com
>