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 database abstraction layer to help you with that (adodb for 
 example)
 
 function fireSQL( $driver )
 {
 
 // establish the connection to the database using the specified driver
 
 // read SQL from the file (probably tokenizing it into sql statements)
 
 // feed the sql into the connection
 
 }
 
 -ahmed
 
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php

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]:
 
 
  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 want
  to
  run this file using php's mssql and oracle(oci) functions.
  any idea pls.
 
  thanks.
  babu
 
 
 
  -
  How much free photo storage do you get? Store your holiday snaps for FREE
  with Yahoo! Photos. Get Yahoo! Photos
 
 
  
 
  This message has been delivered to the Internet by the Revenue Internet
  e-mail service
 
  *
 
  --
  PHP General Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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( $driver )
{

// establish the connection to the database using the specified driver

// read SQL from the file (probably tokenizing it into sql statements)

// feed the sql into the connection

}

-ahmed

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 - Accenture [EMAIL PROTECTED]: 



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 want 
to

run this file using php's mssql and oracle(oci) functions.
any idea pls.

thanks.
babu



-
How much free photo storage do you get? Store your holiday snaps for FREE
with Yahoo! Photos. Get Yahoo! Photos




This message has been delivered to the Internet by the Revenue Internet 
e-mail service


*

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php







--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 want to
run this file using php's mssql and  oracle(oci) functions.
any idea pls.

thanks.
babu



-
How much free photo storage do you get? Store your holiday snaps for FREE
with Yahoo! Photos. Get Yahoo! Photos




This message has been delivered to the Internet by the Revenue Internet e-mail 
service

*

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 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 want 
 to
 run this file using php's mssql and oracle(oci) functions.
 any idea pls.
 
 thanks.
 babu
 
 
 
 -
 How much free photo storage do you get? Store your holiday snaps for FREE
 with Yahoo! Photos. Get Yahoo! Photos
 
 
 
 
 This message has been delivered to the Internet by the Revenue Internet 
 e-mail service
 
 *
 
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php