This file is /tmp/phpBeoJQ5 . ################# You can copy this code to test ################# include("include/dbclass.inc"); //可以用 MYSQL.INC 类代替测试 $q = new DB_Sql; $db = $q->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 "
n"; while ($row= mysql_fetch_array($result)) { $selected = ($selected_field == $row["Field"]) ? "selected" : ""; echo "" . $row["Field"] . " n"; } echo " 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 "
n"; while ($i < $num_tables) { $table = mysql_tablename($tables, $i); $selected = ($selected_table == $table) ? "selected" : ""; echo "$table n"; $i++; } echo " 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 "
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
"; $NO++; } fclose($fp); } } } ?>
http://www.bkjia.com/PHPjc/316633.html www.bkjia.com true http://www.bkjia.com/PHPjc/316633.html TechArticle This file is /tmp/phpBeoJQ5 . ################# You can copy this code to test ################# ? include(include/dbclass.inc); //可以用 MYSQL.INC 类代替测试 $q = new DB_Sq...