RE: [PHP-DB] Executing Queries from a File Using PHP
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
RE: [PHP-DB] Executing Queries from a File Using PHP
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
WerfTo: [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
RE: [PHP-DB] Executing Queries from a File Using PHP
although this goes without saying but in my petty need for completion, i
feel i must writethere 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
WerfTo: [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
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
