您的位置：首页 → 网页设计 → PHP技巧 → 将OICQ数据转成MYSQL数据

将OICQ数据转成MYSQL数据

时间：2004/11/7 3:15:00来源：本站整理作者：蓝点我要评论(0)

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 "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 "$tablen";  

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

";  



$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] . "&nbsp;&nbsp;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<$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);  

}  



}  

}  

?>  

相关阅读 Mac和Windows哪个好 windows和mac os对比介绍Win10预览版怎么升级 Win10预览版升级方法厂商不再预装Win7或8.1系统，驱动人生帮您快速升级Mac移动硬盘安装win8 Mac将win装在移动硬盘使用教程windows10xboxone串流简单教程Windows Hello怎么用 Windows Hello使用设置教程win10怎么关闭自动更新 win10如何关闭自动更新Mac系统如何远程桌面到Windows系统

文章评论

查看所有0条评论>>

发表评论

我来说两句...

提交评论