Firebird and PHP PDO functions

Dev Shed Forums Sponsor:

February 19th, 2006, 05:49 PM

salbefe

Registered User

Join Date: Feb 2006

Posts: 5

Time spent in forums: 2 h 8 m 32 sec
Reputation Power: 0

Firebird and PHP PDO functions

HI,

I'm trying to connect to a Firebird database using the PHP-PDO functions but I'cant.

The problem is the dns that is used to connecto to.

At PHP.NET there is an example of how to use the firebird driver with PDO:
firebird:User=john;Password=mypass;Database=DATABASE.GDE;DataSource=localhost;Port=3050

If my database is in c:\databases\test.gdb, what should I write to connect to the database?

I've tried :

'firebird:User=SYSDBA;Password=masterkey;Database=c:\databases\test.gdb;DataSource=localhost;Port=30 50';

and other connections string and It does not work.

Thanks in advance.

February 20th, 2006, 05:23 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,906

Time spent in forums: 2 Months 3 Weeks 3 Days 7 h 8 m 35 sec
Reputation Power: 279

This works for me:

php Code:

Original - php Code
<?php try { $dbh = new PDO("firebird:dbname=localhost:C:\\Programmi\\Firebird\\Firebird_2_0\\examples\\empbuild\\EMPLOYEE.FDB", "SYSDBA", "masterkey"); foreach ($dbh->query('SELECT COUNTRY from COUNTRY') as $row) { print_r($row); } $dbh = null; } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "<br/>"; die(); } ?>

<?php
try {
   $dbh = new PDO("firebird:dbname=localhost:C:\\Programmi\\Firebird\\Firebird_2_0\\examples\\empbuild\\EMPLOYEE.FDB", "SYSDBA", "masterkey");
   foreach ($dbh->query('SELECT COUNTRY from COUNTRY') as $row) {
     print_r($row);
   }   
   $dbh = null;  
} catch (PDOException $e) {
   print "Error!: " . $e->getMessage() . "<br/>";
   die();
}
 
?>

Works also with c:\programmi ...

__________________
My blog
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)

March 7th, 2006, 05:17 PM

marshmallow

Registered User

Join Date: Mar 2006

Posts: 1

Time spent in forums: 11 m 51 sec
Reputation Power: 0

Not data for the 1 row

__________________
The firebird database

CREATE TABLE "T_TEST"
(
"INDEX" INTEGER NOT NULL,
"DATE" DATE Default 'NOW' NOT NULL,
"TEXTE" VARCHAR(30) NOT NULL,
PRIMARY KEY ("INDEX")
);

_____________
The index.php

PHP Code:


		
			
<?php



$dsndb = 'firebird:dbname=localhost:test.fdb';

$userdb = 'sysdba';

$passdb = 'password';



try {

    $dbh = new PDO($dsndb, $userdb, $passdb);

    

    $sth = $dbh->prepare('SELECT * from "T_TEST"');

    $sth->execute();



    $result = $sth->fetch(PDO::FETCH_ASSOC);

    print_r($result);

    $result = $sth->fetch(PDO::FETCH_ASSOC);

    print_r($result);



    $dbh = null;



} catch (PDOException $e) {

  echo 'Echec de la connexion : ' . $e->getMessage() . "<br/>";

  die();

}

?>

__________
The result

Array ( [INDEX] => [DATE] => [TEXTE] => )
Array ( [INDEX] => 2 [DATE] => [TEXTE] => Thibault )

Comments on this post

pabloj disagrees: review your code

March 24th, 2006, 08:03 AM

serenityNow

Registered User

Join Date: Mar 2006

Posts: 1

Time spent in forums: 2 m 54 sec
Reputation Power: 0

No data for first row

There is a bug i PDO for Firebird.

see:
http://bugs.php.net/bug.php?id=35386

April 12th, 2006, 09:19 AM

quipo

Contributing User

Join Date: Jul 2002

Posts: 60

Time spent in forums: 1 Day 3 h 34 m 28 sec
Reputation Power: 11

Quote:

Originally Posted by salbefe

I'm trying to connect to a Firebird database using the PHP-PDO functions but I'cant. The problem is the dns that is used to connecto to.

you should try with

PHP Code:


		
			
 $db = new PDO ("firebird:dbname=localhost:C:/path/to/pdotest.fdb", 'userid', 'password');

(notice the "localhost:" part)

Anyway, the PDO_Firebird driver is severely lacking a lot of features. I've posted a test report here:

http://www.alberton.info/php_pdo_firebird_status.html

I'd recommend using the php_interbase extension until the PDO driver is actively maintained again.

Comments on this post

pabloj agrees: Thanks, link added in the sticky section to your information_schema article

May 4th, 2006, 09:25 AM

krovomi

Registered User

Join Date: May 2006

Posts: 4

Time spent in forums: 35 m 56 sec
Reputation Power: 0

Quote:

Originally Posted by marshmallow

PHP Code:


		
			
<?php



$dsndb = 'firebird:dbname=localhost:test.fdb';

$userdb = 'sysdba';

$passdb = 'password';



try {

    $dbh = new PDO($dsndb, $userdb, $passdb);

    

    $sth = $dbh->prepare('SELECT * from "T_TEST"');

    $sth->execute();



    $result = $sth->fetch(PDO::FETCH_ASSOC);

    print_r($result);

    $result = $sth->fetch(PDO::FETCH_ASSOC);

    print_r($result);



    $dbh = null;



} catch (PDOException $e) {

  echo 'Echec de la connexion : ' . $e->getMessage() . "<br/>";

  die();

}

?>

__________
The result

Array ( [INDEX] => [DATE] => [TEXTE] => )
Array ( [INDEX] => 2 [DATE] => [TEXTE] => Thibault )

So, how did you do to skip the first array, because i have the same problem here, and i dunno how to do it.
Thanks

Comments on this post

pabloj disagrees!

May 6th, 2006, 02:54 AM

quipo

Contributing User

Join Date: Jul 2002

Posts: 60

Time spent in forums: 1 Day 3 h 34 m 28 sec
Reputation Power: 11

Quote:

Originally Posted by krovomi

So, how did you do to skip the first array, because i have the same problem here, and i dunno how to do it.

as you could see here [1], it's a bug. While you could retrieve the record (IF the resultset contains more than one record) by reversing the order by clause and fetching the last record returned, it's so hackish that I would NOT consider this option in any case.

Again, I'd recommend using the php_interbase extension until the PDO driver is actively maintained again.

[1] http://bugs.php.net/bug.php?id=35386

May 29th, 2006, 02:28 AM

krovomi

Registered User

Join Date: May 2006

Posts: 4

Time spent in forums: 35 m 56 sec
Reputation Power: 0

And if you have only one record, how did you do to get the result ?
Thanx !

Quote:

Originally Posted by quipo

May 29th, 2006, 03:36 AM

quipo

Contributing User

Join Date: Jul 2002

Posts: 60

Time spent in forums: 1 Day 3 h 34 m 28 sec
Reputation Power: 11

Quote:

Originally Posted by krovomi

And if you have only one record, how did you do to get the result ?

again, don't use the PDO_Firebird extension, it's NOT usable at the current state: http://www.alberton.info/php_pdo_firebird_status.html

Use the php_interbase extension instead.

#10

May 29th, 2006, 03:58 AM

pabloj

Modding: Oracle MsSQL Firebird

Join Date: Jun 2001

Location: Outside US

Posts: 7,906

Time spent in forums: 2 Months 3 Weeks 3 Days 7 h 8 m 35 sec
Reputation Power: 279

Quote:

Originally Posted by krovomi

And if you have only one record, how did you do to get the result ?
Thanx !

Are you FORCED to use PDO with Firebird?

#11

May 30th, 2006, 06:11 AM

krovomi

Registered User

Join Date: May 2006

Posts: 4

Time spent in forums: 35 m 56 sec
Reputation Power: 0

Quote:

Originally Posted by pabloj

Are you FORCED to use PDO with Firebird?

Yes, i'm forced to use PDO with firebird, that's the main reason why i'm a little bit lost.
Anyway, there is no way to move from firebird to php_interbase ? And if yes, how to do it ?
Thanx