InterBase troubles
| From: | Sergey Nikiforov | Date: | Thu, 14 Sep 2000 16:11:42 +0000 |
| Subject: | InterBase troubles | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2885@lists.php.net to get a copy of this message | ||
I do not see tables created by PHP in
Interbase WorkBench. I created a table T1 manually,
and populated the table in PHP the code is:
<?php
$host = "C:\\Upscene Productions\\InterBase Workbench\\Php.gdb";
$username = "sysdba";
$password = "masterkey";
$dbh = ibase_pconnect ($host, $username , $password);
$stmt = 'INSERT INTO T1 (P1) VALUES (7)';
$query = ibase_prepare($stmt);
$sth = ibase_execute($query);
$stmt = 'INSERT INTO T1 (P1) VALUES (8)';
$query = ibase_prepare($stmt);
$sth = ibase_execute($query);
$stmt = 'INSERT INTO T1 (P1) VALUES (9)';
$query = ibase_prepare($stmt);
$sth = ibase_execute($query);
$stmt = 'SELECT * FROM T1';
$query = ibase_prepare($stmt);
$sth = ibase_execute($query);
while ($row = ibase_fetch_object ($sth)) {
print $row->P1 . "\n";
}
ibase_free_query($query);
ibase_close ($dbh);
?>
The output is: 7 8 9
But Interbase WorkBench shows nothing. Vice versa : if I populate the
table
in Interbase WorkBench, PHP shows nothing.
They behaved as a different tables.