all you have to do is put one query per line in the file, it may be hard to
read, but who cares.
and then it is as simple as.
$contents = file("sql.txt"); //file function reads file into array
while (list ($qry)) = each($contents)) {
mysql_query($qry);
}
Just a thought....
Jeff
"Bruce Vander
Werf" To: <[EMAIL PROTECTED]>
<brucev@cyberl cc:
ink.com> Subject: RE: [PHP-DB] Executing Queries
from a File Using PHP
06/13/2002
08:39 AM
Please respond
to brucev
Thanks. Since it would take me forever to write, and I don't know thing
well
enough to make sure I have all the possibilities covered, I was hoping
there
was some source code somewhere I can use.
--Bruce
-----Original Message-----
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 11:34 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Executing Queries from a File Using PHP
On Thursday 13 June 2002 10:48, Bruce Vander Werf wrote:
> Is there a PHP routine anywhere to execute a series of MySQL queries in a
> text file?
>
> I know how to do this via the command line or by using PHPMyAdmin, but I
> need to do it in my own PHP script, and some of the queries span more
than
> one line.
There are no built-in functions to do so. You need to read in the file
yourself, parse it appropriately then send the queries to mysql.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Thank you for observing all safety precautions.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
