Sure... but it's very basic.
Setting up the relationships between columns was all manually done - $line, $line etc. correspond to columns in the input csv. For instance, the 4th column in the source csv was the user's first name...
$out = array();
$file = fopen('memberss.csv', 'r');
$c=0;
while (($line = fgetcsv($file)) !== FALSE) {
$out = $line;
$out = $line;
$out = $line;
$out = $line;
$c++;
}
fclose($file);
fopen('members.sql', 'w');
foreach($out as $o) {
$sql = 'SET updated_at=NOW()';
foreach($o as $key=>$val) {
$sql .= ','.$key.'='.db_input($val);
}
$sql = 'INSERT INTO users '.$sql.';';
fwrite($in, $sql."\n");
}
fclose($in);
This doesn't really take into account removing any escape characters that had been placed into the csv file when it was generated.
