[RESOLVED] Creating CSV Files from a Loop

[guido28]

Our University is changing email systems and, as a part of the process, each user's address book has to be imported as a csv file. This means the creation of thousands of files, each of which must be named with the unique username of the client.

Can this be done in a for or foreach loop? Could someone suggest the best method for doing this? The addressbook data is currently in tables in a MySQL 5.0database.

Thanks in advance for any assistance.

[Seldaek]

Hey, you may want to have a look at fputcsv(), basically it should look like that:

$user = null;
$req = mysqli_query('SELECT * FROM addressBook GROUP BY user');
while($row = mysqli_fetch_assoc($req)) {
if($user !== $row['user']) {
if($csvFile) fclose($csvFile);
$user = $row['user'];
$csvFile = fopen($user.'.csv', 'w');
}
$fields = array
(
'name' => $row['name'],
'mail' => $row['mail'],
'phone' => $row['phone'],
);
fputcsv($csvFile, $fields);
}

By adjusting the $fields array to fit your needs, it should do what you want.

[guido28]

Thank you for the quick reply.

Would this work in cases where many users will have hundreds or even thousands of records in the addressbook table?

[Seldaek]

I don't see any restriction with it (beyond php's memory usage and max execution time that is)

[guido28]

Thank you very much for your help, Seldaek.