Re: [PHP] How to run .sql files using php

2005-07-15 Thread glumtail
Ahmed: It's real perfect! B/R 2005/7/14, Ahmed Saad <[EMAIL PROTECTED]>: > > hi babu > > On 7/13/05, babu <[EMAIL PROTECTED]> wrote: > > i have a set of queries which i have placed them in one .sql file.i want > to run this file using php's mssql and oracle(oci) functions. > > you need a d

Re: [PHP] How to run .sql files using php

2005-07-14 Thread Raffael Wannenmacher
or execute a shell command $ret = `mysql -u[user] -p[password] -h[host] [db_name] < file.sql`; glumtail wrote: I think it's better to split the SQL into pieces line 1: create table line 2: insert into . $sql = 'create table' $sql = 'insert into ...' 2005/7/13, Shaw, Chris - Acc

Re: [PHP] How to run .sql files using php

2005-07-14 Thread Ahmed Saad
hi babu On 7/13/05, babu <[EMAIL PROTECTED]> wrote: > i have a set of queries which i have placed them in one .sql file.i want to > run this file using php's mssql and oracle(oci) functions. you need a database abstraction layer to help you with that (adodb for example) function fireSQL( $dri

Re: [PHP] How to run .sql files using php

2005-07-14 Thread Rory Browne
phpmyadmin On 7/13/05, glumtail <[EMAIL PROTECTED]> wrote: > I think it's better to split the SQL into pieces > line 1: create table > line 2: insert into . > $sql = 'create table' > $sql = 'insert into ...' > > 2005/7/13, Shaw, Chris - Accenture <[EMAIL PROTECTED]>: > > > > > > C

Re: [PHP] How to run .sql files using php

2005-07-13 Thread glumtail
I think it's better to split the SQL into pieces line 1: create table line 2: insert into . $sql = 'create table' $sql = 'insert into ...' 2005/7/13, Shaw, Chris - Accenture <[EMAIL PROTECTED]>: > > > Can you use mysqli_multi_query for mysql in php5? > > hth > > -Original

RE: [PHP] How to run .sql files using php

2005-07-13 Thread Shaw, Chris - Accenture
Can you use mysqli_multi_query for mysql in php5? hth -Original Message- From: babu [mailto:[EMAIL PROTECTED] Sent: 13 July 2005 16:39 To: php-general@lists.php.net Subject: [PHP] How to run .sql files using php Hi , i have a set of queries which i have placed them in one .sql file.i