PHP x Firebird: How to perform a .sql file

bbren123

Hi!

I'd like to importa .sql file with commands such as "CREATE TRIGGER", "SET TERM", and so on.... but exec() function access is forbidden in my hoster.

I'd like to know how can I do this without using "exec()" function.

I saw this functionality in PhpMyAdmin (for mysql), but it uses
"exec()" function as well.

Can anyone help me ?

planetsim

Welcome to the forums 😉

Ok to start off, if you cannot use that you will probably need to upload the file to your server. From there use your script to parse the file and work out where to run queries on. This will be a hard task.

If that isnt to your liking check to see if you can use system();

Sxooter

Not having a clue of the exact nature of how firebird does this, here's what you should be able to do:

Get the sql file on the machine, either by uploading through a php script or using ftp.

Then, read in the file, one line at a time, and feed it to the database through the firebird_query (or whatever it's called) command. In postgresql this will work. I don't know about firebird.

Basic scrupt would be like:

// open files and all that jazz
// open connection to db
while (!feof($fp)){
  $line = fgets($fp,100000);
  $res = ib_query($line);
}

bbren123

Well, I tried doing it. I did a parse in a .sql file and sent through ibase_query. BUT, there is some commands like "ALTER TRIGGER","CREATE TRIGGER", "SET TERM" that ibase_query doesn't understand.

The question is, Why? Is there any function in PHP api for solving this problem?? (Note: I can't use php 5)

Thanks.

Sxooter

Is this .sql file from a dump of a firebirdsql database, or another type of database. SQL dumps are NOT 100% transportable due to differences in designs of things like triggers and stored procedures.

bbren123

Sorry, I think I can't explain the problem correctly.

This .sql file contains a VALID sql for my firebird database.
I just need bring it to my database through a php script.

But I can't do a parse in this file because the php script doesn't understand the commands like triggers , etc.. I dont know why it happens.....

Do you know that functionality in PhpMyAdmin (for mysql) whose .sql file is imported and executed in database through admin panel? Is it, I want do the same, but in the firebird.

Is something like "isql database < file.sql" (I don't remember) at shell. But I've no access priv. to exec() function. So... I need another way for executing this "sql-from-file" in my database.

Thanks a lot!

Sxooter

PHP doesn't NEED to understand the file. It just needs to push it one line at a time through the ib_query function into the database.\

What were the exact errors you got when trying to do that?

Or are things like CREATE TRIGGER macros for isql that can't be interpreted by the backend?

bbren123

Look at my files

at www.liton.com.br/myfiles.zip and you'll understand.

Thank you!