pdo2csv_simple

<?php

try{

    $dbh = new PDO('mysql:host=localhost;dbname=mydb','root','root');
    $data = $dbh->query('SELECT * from users');
    $users = $data->fetchAll(PDO::FETCH_ASSOC);
    $fp = fopen('users.csv','w');
    foreach($users as $line){
        fputcsv($fp, $line);
    }
    fclose($fp);
}catch (PDOException $e) {
    echo $e->getMessage();
}