Are you running php3 or php4? 'foreach' was added in php4, which might
explain your error. If you're running php3, try replacing that line with:
while(list($key,$email) = each($emails)) {
I don't know if this works in php3 or not, but would be worth a shot.
Rupert L. Hussey wrote:
> Hi Chris
> I get the following error when I try your script:
> Parse error in e:\myserver\www\maildump\dump2.php on line 3
>
> Here is a copy of the script I am using...this may help some. An additional
> problem it has is that it is limited to 30 entries. Which is probably not
> efficient if you have a few hundred email address to transfer.
>
> Rupert
>
> ----------- It is GNU Licensed so no sweat ---------------------------
> <html>
> <head>
> <title>MyCSV-Dump for PHP</title>
> </head>
> <body bgcolor=ffffff>
>
> <?
> /* script configuration */
> $dbname= "news"; // define database name
> $datetime = strftime('%d%m%Y'); // dateformat
> $filename_input = "addresses.txt"; // filename of input CSV file
> $filename_output = $dbname . ".sql"; // sample output filename:
> "test_16062001.sql"
> $debug_input = "yes"; // yes = show file input
> $debug_output = "yes"; // yes = show generated SQLquery
> $seperator = ";"; // symbol used as CSV field seperator
>
> /* output html page header */
> $htmlheader = "<pre>";
> $htmlheader .= "# MyCSV-Dump for PHP 1.0<BR>";
> $htmlheader .= "# by Thomas Fröhlich ([EMAIL PROTECTED])<BR>";
> $htmlheader .= "# ------------------------------------------------<BR>";
> $htmlheader .= "# Dumping data for table '" . $dbname . "' from file '" .
> $filename_input . "'<BR>";
> $htmlheader .= "</pre><PRE>";
> echo $htmlheader;
>
> /* read file */
> $fcontents = file ($filename_input);
>
> /* process each single line */
> while (list ($line_num, $line) = each ($fcontents)) {
>
> /* debug info (input) */
> if ($debug_input == 'yes') {
> echo "<br><b>Line $line_num:</b> " . htmlspecialchars($line) .
> "<br>";
> }
>
> /* seperate line into array */
> $without_space = trim (chop ($line));
> $ln = explode ($seperator, $without_space);
>
> /* construct SQL query (max 30 entries - add more if you wish) */
> $sqlquery = 'INSERT INTO ' . $dbname . ' VALUES ('; // INSERT INTO test
> VALUES("1","0","abc");
> if ($ln[0]) { $sqlquery .= ',"' . $ln[0] . '"'; }
> if ($ln[1]) { $sqlquery .= ',"' . $ln[1] . '"'; }
> if ($ln[2]) { $sqlquery .= ',"' . $ln[2] . '"'; }
> if ($ln[3]) { $sqlquery .= ',"' . $ln[3] . '"'; }
> if ($ln[4]) { $sqlquery .= ',"' . $ln[4] . '"'; }
> if ($ln[5]) { $sqlquery .= ',"' . $ln[5] . '"'; }
> if ($ln[6]) { $sqlquery .= ',"' . $ln[6] . '"'; }
> if ($ln[7]) { $sqlquery .= ',"' . $ln[7] . '"'; }
> if ($ln[8]) { $sqlquery .= ',"' . $ln[8] . '"'; }
> if ($ln[9]) { $sqlquery .= ',"' . $ln[9] . '"'; }
> if ($ln[10]) { $sqlquery .= ',"' . $ln[10] . '"'; }
> if ($ln[11]) { $sqlquery .= ',"' . $ln[11] . '"'; }
> if ($ln[12]) { $sqlquery .= ',"' . $ln[12] . '"'; }
> if ($ln[13]) { $sqlquery .= ',"' . $ln[13] . '"'; }
> if ($ln[14]) { $sqlquery .= ',"' . $ln[14] . '"'; }
> if ($ln[15]) { $sqlquery .= ',"' . $ln[15] . '"'; }
> if ($ln[16]) { $sqlquery .= ',"' . $ln[16] . '"'; }
> if ($ln[17]) { $sqlquery .= ',"' . $ln[17] . '"'; }
> if ($ln[18]) { $sqlquery .= ',"' . $ln[18] . '"'; }
> if ($ln[19]) { $sqlquery .= ',"' . $ln[19] . '"'; }
> if ($ln[20]) { $sqlquery .= ',"' . $ln[20] . '"'; }
> if ($ln[21]) { $sqlquery .= ',"' . $ln[21] . '"'; }
> if ($ln[22]) { $sqlquery .= ',"' . $ln[22] . '"'; }
> if ($ln[23]) { $sqlquery .= ',"' . $ln[23] . '"'; }
> if ($ln[24]) { $sqlquery .= ',"' . $ln[24] . '"'; }
> if ($ln[25]) { $sqlquery .= ',"' . $ln[25] . '"'; }
> if ($ln[26]) { $sqlquery .= ',"' . $ln[26] . '"'; }
> if ($ln[27]) { $sqlquery .= ',"' . $ln[27] . '"'; }
> if ($ln[28]) { $sqlquery .= ',"' . $ln[28] . '"'; }
> if ($ln[29]) { $sqlquery .= ',"' . $ln[29] . '"'; }
> $sqlquery .= ');';
> $sqlquery .= "\n"; // new line
>
> /* debug info (output) */
> if ($debug_output == 'yes') {
> echo $sqlquery;
> }
>
> /* save SQL query to file (append) */
> if(file_exists($filename_output)) { // if file exists, only append sql
> query
> $save = fopen ($filename_output, "a");
> fputs($save, $sqlquery);
> flock($save,3);
> fclose($save);
> $save_status = "append";
> }
> else { // if file does not exist, write a txt header first
> $sqlheader = "# MyCSV-Dump for PHP 1.0\n";
> $sqlheader .= "# written by [EMAIL PROTECTED]\n";
> $sqlheader .= "# --------------------------------------\n\n\n\n";
> $sqlheader .= "#\n";
> $sqlheader .= "# Dumping data for table '" . $dbname . "'\n";
> $sqlheader .= "#\n\n\n";
>
> $save = fopen ($filename_output, "a");
> fputs($save, $sqlheader . $sqlquery);
> flock($save,3);
> fclose($save);
> $save_status = "newfile";
> }
>
> }
>
> echo "</PRE>";
> /* output success information */
> if ($save_status == "append") {
> echo "<font color=green><B>DONE:</B> Data has been appended to existing
> file: <B>" . $filename_output . "</B>";
> }
> if ($save_status == "newfile") {
> echo "<font color=green><B>DONE:</B> Data has been written to new file:
> <B>" . $filename_output . "</B>";
> }
> ?>
>
> </body>
> </html>
>
>
> ------snip!-------------------------------------
>
>
>
>
>
> "Chris Hobbs" <[EMAIL PROTECTED]> wrote in message
> news:<[EMAIL PROTECTED]>...
>
>>How about this:
>>
>><?php
>>$emailstring = "[EMAIL PROTECTED];[EMAIL PROTECTED];[EMAIL PROTECTED]";
>>@emails = explode(";", $emailstring);
>>foreach($emails as $email) {
>> echo "INSERT INTO news VALUES('$email');\n";
>>}
>>?>
>>
>>Rupert wrote:
>>
>>
>>>Ok, this is my issue - hope someone can help. Suppose I also need to
>>>
> get
>
>>>this out of the way too - I am a Newbie (god..I hate that word...but
>>>
> it's
>
>>>true.....grin!)
>>>
>>>Anyway, I have a list of email address that I want to dump into a
>>>
> database
>
>>>called (news) - eg.
>>>[EMAIL PROTECTED]
>>>[EMAIL PROTECTED]
>>>[EMAIL PROTECTED]
>>>[EMAIL PROTECTED]
>>>etc..
>>>I separated them with (;'s) like so - [EMAIL PROTECTED]; [EMAIL PROTECTED];
>>>[EMAIL PROTECTED]; [EMAIL PROTECTED]; etc..
>>>(I suppose I could use commas instead - no prob there)
>>>This is what I want to accomplish:
>>>Each email address is a separate entry that needs to be downloaded into
>>>
> the
>
>>>database.
>>>Just like this:
>>># --------------------------------------------------------
>>>#
>>># Table structure for table 'news'
>>>#
>>>CREATE TABLE news (
>>>email char(255) NOT NULL,
>>>PRIMARY KEY (email),
>>>UNIQUE email (email)
>>>);
>>>#
>>># Dumping data for table 'news'
>>>#
>>>INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
>>>INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
>>>INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
>>>INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
>>>INSERT INTO news VALUES ( 'etc..');
>>>------------------------------------------------------------
>>>I have a script that gets me to this point:
>>>INSERT INTO news VALUES (,"[EMAIL PROTECTED]"," [EMAIL PROTECTED]","
>>>[EMAIL PROTECTED]","[EMAIL PROTECTED]","etc..");
>>>But that is not what I want. I can attach the script for analysis or if
>>>anyone has a better idea. I would appreciated it very
>>>much. Thanks..
>>>Rupert
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>--
>>Chris Hobbs Silver Valley Unified School District
>>Head geek: Technology Services Coordinator
>>webmaster: http://www.silvervalley.k12.ca.us/~chobbs/
>>postmaster: [EMAIL PROTECTED]
>>
>>
>
--
Chris Hobbs Silver Valley Unified School District
Head geek: Technology Services Coordinator
webmaster: http://www.silvervalley.k12.ca.us/~chobbs/
postmaster: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
