PHP + InterBase - Help ce shte poludeq :-(

1 отговора 57 прегледа
#1

PHP + InterBase - Help ce shte poludeq :-(

Znachi PHP-to si bachka t.e. slojil sym mu add-in za da ima vgradenite funkcii za InterBase obache se poluchava neshto mnogo stranno. Imam sledniq primeren source:
<?PHP
.....
8. $database = 'Test.gdb';
9. $table1 = 'myBLOB';
10. $db_user = 'SYSDBA';
11. $db_pass = 'masterkey';
12. $host = 'Local Server';
13. $query1 = "SELECT * FROM $table1";
14. $connection = ibase_connect($host,$db_user,$db_pass) or die ("Cannot comunicate with the DataBase");
15. ibase_select_db($database);
16. $result = ibase_query($query1);
....
?>
kato go pusna dava slednata greshka:
Warning: InterBase: I/O error for file "D:\SAMBAR44\BIN\LOCAL SERVER" Error while trying to open file The system cannot find the file specified. in D:\sambar44\docs\IBTest.php on line 14
Cannot comunicate with the DataBase

Izglejda neshto ne e nared s nastroikite na InterBase-a ama ne moga da razbera kakvo. Ako izklucha IB Server-a mi kazva ce go nqma t.e. syobshtenieto e drugo!
Pri mySQL kato si mu sloja na $host='localhost'; vsichko si e OK, zashto obache stava taka pri IB???

Отговор
в отговор на Alien #2

Ochevadnoto vinagi se zabelqzva trudno :-(

Okazva se, ce analogiqta mejdu mySQL i IB ne vodi do dobri rezultati :-)
eto korigiraniq rabotesht source:
//$database = 'Test.gdb';
$table1 = 'myBLOB';
$db_user = 'SYSDBA';
$db_pass = 'masterkey';
$host = '/Program Files/Borland/InterBase/bin/Test.gdb';
$query1 = "SELECT * FROM $table1";
$connection = ibase_connect($host,$db_user,$db_pass) or die ("Cannot comunicate with the DataBase");
//ibase_select_db($database);
$result = ibase_query($query1);

Отговор