Importing CSV file, and mod its contents

Anon

Hello!

I'm fairly new to php programming and so I'm not really sure how I should do the following.

I would like to import a CSV file into php that contains rows of user data, such as name, contact num, email, username, etc that would have originally been exported from an excel file.
The imported values would then need to be checked, eg, is the email address of the correct format, and also a random password generated from a username (using md5). Then, when all data has been checked, the whole lot would be fed into a MySQL database.

I have a rough idea of how this should be done, but actually putting this into code is something i'm struggling with.
I presume I would read the CSV into an array, then go through the array applying checks and changes, reporting errors if necessary. Would I be able to identify each row individually?
The array would then have to be inserted into a database matching the right value into the correct database field.

I hope someone can help me as I'm not sure what to do about it. Maybe someone knows of a script that already does this and can point me to it?

Thankyou for your help!

Richard

matto

first read in that file using:
$rows = file("xxxx.csv");

now, $rows is an array with one record per element.

iterate through that array, e.g. using foreach:

foreach($rows as $row)
{

now in each loop, $row contains one of the records.
split the record into its parts:

$fields = explode(',', $row);

fields is now an array with one field per element of the actual record.

iterate through the fields using for:

for($i=0; $i<count($fields); $i++)
{
here you can do the check for validity.
assuming the third field of a csv record is the email address:

if($i == 5)
{
check for validity here; you can change the value if you need.
}

add similar ifs for checking other fields. then close the for.
}

now tie together the insert statement:
$sql = "insert into thetable values(".$fields[0].",'".$fields[2]."' ... ";

execute it!
then close the foreach and let the script process the next row.
}

good luck!

Anon

Cheers for that, I'll give it a go! 🙂