----- Original Message -----
From: "Steve Miller"
> I have text files that have rows of comma-separated
> elements that I want to insert as records into a
> database table. I am trying to upload these csv
> files and read them line-by-line using the php "file"
> function:
Did you notice the php 'fgetcsv()' function - that reads a row of comma
separated variables from a file and puts them into an array...?
$fp = fopen("filename", "r");
while (!feof($fp)) {
$row = fgetcsv($fp);
$query = "INSERT INTO db " .
(field1, field2, field3)
VALUES ('$row[0]', $row[1]," .
"$row[2])";
...etc
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
