// show first line of the csv file to select dababase table and its fields
echo "<form method=post action=$PHP_SELF>";
$csv_data = fgetcsv($fp, 2000, "$terminated");
$num = count($csv_data);
for ( $c=0; $c<$num; $c++ ) {
$field_name[$c] = $csv_data[$c];
echo $field_name[$c] . " n";
$table_field_name = "field$c";
show_field($db,$table,$c,$$table_field_name);
echo "<br>";
}
// copy the tmp file for next use
$dest = "/tmp/csv_file.csv";
copy($csv_file,$dest);
echo "<input type=hidden name=csv_file value=$dest>n" .
"<input type=hidden name=table value=$table>n" .
"<input type=hidden name=terminated value=$terminated>n" .
"<input type=submit name=submit value=ok></form><p>n";
// when click 'ok' button ,start insert data
if ($submit == "ok") {
$NO = 1;
while ($csv_data = fgetcsv($fp, 2000, "$terminated")) {
//$num = count($csv_data);
for ( $c=0; $c<$num; $c++ ) {
$table_field_name = "field$c";
$first_3 = substr($$table_field_name, 0, 3);
$first_2 = substr($$table_field_name, 0, 2);
$val_tmp = ($first_3 == "fid" || $first_3 == "int"
|| $first_2 == "id") ?
$csv_data[$c] : "'" . $csv_data[$c] . "'";
$val .= $val_tmp . ",";
$var .= $$table_field_name . ",";
}
$val = substr($val, 0, -1);
$var = substr($var, 0, -1);
$query = "INSERT INTO $table ($var) VALUES ($val)";
$val = "";
$var = "";
$q->query($query);
echo "NO. $NO $query<p>";
$NO++;
}
fclose($fp);
}
}
}
?>