Subject Re: [firebird-php] firebird + PDO - what is the status?
Author Yves Glodt
Jochem Maas wrote:
> Yves Glodt wrote:
>
>>Jochem Maas wrote:
>>
>>
>>>hi guys,
>>
>>
>>Hi,
>>
>>
>>>anyone know if firebird/PDO is usuable yet? has anyone tried it
>>>lately? whats you're experience?
>>
>>
>>I played with it a little (partly porting one of my apps to it
>>http://i-man.sf.net), and it seems to work...
>>
>>Take this as example code (or check iman's cvs, the file is /db/pdo.php):
>
>
> did that - quite helpful thanks!
> and I have put a item on my todo list to try out you app!
> I always like to see firebird/php in action :-)

me too, it's just a great DB, if only more people knew about it! :-)

> thanks!
>
>
>>
>>$user = "SYSDBA";
>>$password = "masterke";
>>$test_base = "localhost:d:\i-man.gdb";
>
>
> interesting to see that this dns works - I've had trouble with this
> in the past. (the 'localhost:' prefixed to 'd:')

IIRC it's the only way I could make it work at all...

regards,
Yves

>>$db = new PDO("firebird:dbname=$test_base",$user,$password) or
>>die('Connection failed');
>>
>>
>>foreach ($db->query('select * from iman_content') as $row) {
>> print $row[0].' - '.$row[1].' - '.$row[2]."<br>\n";
>>}
>>
>>
>>
>>
>>
>>>just curious.
>>>
>>>regarding PDO I just noticed a rather informative email by Wez Furlong
>>>regarding PDO in general entitled '[PHP-DB] Re: [PDO] unexpected behaviour'
>>>on the php-db list (from the 9th of July) - someone might find it enlightening.