RE: [PHP-DB] Executing Queries from a File Using PHP From: Jeffrey_N_Dyke <email protected>
Date: 06/13/02

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: <brucev <email protected>>
                    06/13/2002 cc: php-db <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: <php-db <email protected>>
                    <brucev <email protected> 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:phplist <email protected>]
Sent: Wednesday, June 12, 2002 11:34 PM
To: php-db <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