Heim  >  Artikel  >  Datenbank  >  将OICQ数据转成MYSQL数据_MySQL

将OICQ数据转成MYSQL数据_MySQL

WBOY
WBOYOriginal
2016-06-01 14:04:53965Durchsuche

OICQ

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);
?>

enctype="multipart/form-data">
value="">
terminated by value="," size=2>


Which table you want to insert ?



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 "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 "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 "

";

$csv_data = fgetcsv($fp, 2000, "$terminated");
$num = count($csv_data);
for ( $c=0; $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 "
";
}

// copy the tmp file for next use
$dest = "/tmp/csv_file.csv";
copy($csv_file,$dest);

echo "n" .
"n" .
"n" .
"

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

$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);
}

}
}
?>

Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn