hello to all,
I am trying to import db firebird with php using .sql file
code php script:
<?php
$name_file = "firebird.sql";
$adm = fopen($name_file, "r");
$stmt = fread($adm, filesize($name_file));
$host = "localhost:c:\firebird\db\EJEMPLO3.FDB";
$username = 'SYSDBA';
$password = 'masterkey';
$dbh = ibase_connect($host, $username, $password);
$st = ibase_query($stmt);
ibase_close($dbh);
?>
code firebird.sql
CREATE TABLE ADDRESS1
(
CATEGORY INTEGER NOT NULL,
NAME VARCHAR(100) NOT NULL,
KEYINDEX INTEGER NOT NULL,
ADDRESS BLOB SUB_TYPE TEXT SEGMENT SIZE 100,
PRIMARY KEY (KEYINDEX)
);
CREATE TABLE ADDRESS2
(
CATEGORY INTEGER NOT NULL,
NAME VARCHAR(100) NOT NULL,
KEYINDEX INTEGER NOT NULL,
ADDRESS BLOB SUB_TYPE TEXT SEGMENT SIZE 100,
PRIMARY KEY (KEYINDEX)
);
the error is:
Warning: ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 Token unknown - line 10, char 1 CREATE in C:\Archivos de programa\Apache Group\Apache2\htdocs\crearDBfirebird.php on line 10
when exists a single table in .sql file is created, but when it exists 2 or more it shows error,
or import db firebird of another way, the objective is import db firebird using php
thanks in advance,
