This file is /tmp/phpBeoJQ5 .
################# You can copy this code to test #################
Database; //define the database
mysql_connect('localhost:3306',$q->User,$q->Password);
?>
``````
```
function show_field($db,$table,$num,$selected_field) {
$result = mysql_db_query($db, "SHOW KEYS FROM $table") or mysql_die();
$primary = "";
while ($row = mysql_fetch_array($result))
if ($row["Key_name"] == "PRIMARY")
$primary .= "$row[Column_name], ";
$result = mysql_db_query($db, "SHOW FIELDS FROM $table");
if (!$result) {
mysql_die();
}
else {
echo "
```
<select name="field$num">n";
while ($row= mysql_fetch_array($result)) {
$selected = ($selected_field == $row["Field"]) ? "selected" : "";
echo "<option "="" $selected="" .="" field"]="" value=" . $row[">" .
$row["Field"] . "</option>n";
}
echo "</select>
```
nn";
}
}
function show_table($db,$selected_table) {
$tables = mysql_list_tables($db);
$num_tables = @mysql_numrows($tables);
if ($num_tables == 0) {
echo "no table yet";
}
else {
$i = 0;
echo "
```
<select name="table">n";
while ($i < $num_tables) {
$table = mysql_tablename($tables, $i);
$selected = ($selected_table == $table) ? "selected" : "";
echo "<option $selected="" value="$table">$table</option>n";
$i++;
}
echo "</select>
```
nn";
}
}
if ($submit) {
if(!empty($csv_file) && $csv_file != "none") {
//$csv_file = stripslashes($csv_file);
$fp = fopen($csv_file, "r");
// show first line of the csv file to select dababase table and its fields
echo "
```
<form action="$PHP_SELF" method="post">";
$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 name="csv_file" type="hidden" value="$dest"/>n" .
"<input name="table" type="hidden" value="$table"/>n" .
"<input name="terminated" type="hidden" value="$terminated"/>n" .
"<input name="submit" type="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);
}
}
}
``````