RE: [PHP-WIN] Accessing InterBase Database
| From: | Matthias Endler | Date: | Thu, 26 Oct 2000 04:39:33 +0000 |
| Subject: | RE: [PHP-WIN] Accessing InterBase Database | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-3493@lists.php.net to get a copy of this message | ||
Hi Winston,
> Can anyone help me how to connect to Interbase database using PHP? I'm
> running it in windows 98SE and OmniHTTPD webserver.
make sure the php_ibase.dll is enabled in your php.ini. Should look like
this:
extension=php_ibase.dll
(There's a bug in php_ibase.dll bundled with version 4.0.3 win32-binary
distribution. You can connect but nothing else can be done.)
You can get the latest win32 distro at http://www.php4win.de/.
Here's a sample script:
<?
$dbh =
@ibase_connect('/Programme/Borland/test/Test','SYSDBA','secret');
if (!$dbh) die("Database connection failed!");
$sql = "SELECT * FROM tb_test";
$q = ibase_query($dbh,$sql);
if (!$q) die("No results");
while($row = ibase_fetch_object($q)) {
print $row->DF_ID." ".$row->DF_NAME."<br>\n";
// ^^^^^ ^^^^^^^
// Fieldnames should alwas be upper case!
// That's why the example from php.net will never work.
}
@ibase_close($dbh);
?>
Everything else you can find at http://www.php.net/manual/ref.ibase.php
Cheers,
Matthias