although this goes without saying but in my petty need for completion, i
feel i must write....there is obviously SO much more that can be done where
i put the mysql_query($qry), whether it be updating, inserting, selecting
etc... but that can be a starting point.
i feel better, thank you for your indulgence. :)
----- Forwarded by Jeffrey N Dyke/CORP/Keane on 06/13/2002 09:30 AM -----
Jeffrey N Dyke
To: <[EMAIL PROTECTED]>
06/13/2002 cc: [EMAIL PROTECTED]
09:00 AM Subject: RE: [PHP-DB] Executing Queries
from a File Using PHP(Document
link: Jeff Dyke)
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
