Re[2]: [PHP-WIN] Interbase

Ooops! That's as far as I can go, I don't use interbase. Sorry, Gonzalo. > There are no error messages. But 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. > Gonzalo Vera wrote: >> Any error reports? You could try using \\ in the $host, like: >> $host = "C:\\Upscene Productions\\InterBase Workbench\\Php.gdb"; >> >> Gonzalo. >> >> > I have local InterBase. The code below does not create a table. What I >> > do wrong? >> >> > <?php >> > $host = "C:\Upscene Productions\InterBase Workbench\Php.gdb"; >> > $username = "sysdba"; >> > $password = "masterkey"; >> > $dbh = ibase_pconnect ($host, $username , $password); >> > $stmt = 'CREATE TABLE T1 (P1 INTEGER NOT NULL PRIMARY KEY)'; >> > $query = ibase_prepare($stmt); >> > ibase_execute($query); >> > ibase_free_query($query); >> > ibase_close ($dbh); >> ?>> >> >> -- >> PHP Windows Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> For additional commands, e-mail: php-windows-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net