php excel格式(csv)数据导入导出(示例)
- $fname = $_FILES['MyFile']['name'];
- $do = copy($_FILES['MyFile']['tmp_name'],$fname);
- if ($do){
- echo"导入数据成功
"; - }else{
- echo "";
- }
- ?>
-
- error_reporting(0);//导入CSV格式的文件
- $connect=mysql_connect("localhost","a0530093319","123456") or die("could not connect to database");
- mysql_select_db("a0530093319",$connect) or die (mysql_error());
- $fname = $_FILES['MyFile']['name'];
- $handle=fopen("$fname","r");
- while($data=fgetcsv($handle,10000,",")){
- $q="insert into test (code,name,date) values ('$data[0]','$data[1]','$data[2]')";
- mysql_query($q) or die (mysql_error());
- }
- fclose($handle);
- ?>
-
用php将数据库导出成excel，测试成功。
测试代码：
- $DB_Server = "localhost";
- $DB_Username = "root";
- $DB_Password = "";
- $DB_DBName = "ishop";
- $DB_TBLName = "oi_mall_payment";
- $savename = date("YmjHis");
- $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect.");
- mysql_query("Set Names gbk"); $file_type = "vnd.ms-excel";
- $file_ending = "xls";
- header("Content-Type: application/$file_type;charset=big5");
- header("Content-Disposition: attachment; filename=".$savename.".$file_ending");
- //header("Pragma: no-cache");
- $now_date = date("Y-m-j H:i:s");
- $title = "数据库名:$DB_DBName,数据表:$DB_TBLName,备份日期:$now_date";
- $sql = "Select * from $DB_TBLName";
- $ALT_Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database");
- $result = @mysql_query($sql,$Connect) or die(mysql_error());
- echo("$title\n");
- $sep = "\t";
- for ($i = 0; $i < mysql_num_fields($result); $i++){
- echo mysql_field_name($result,$i)."\t";
- }
- print("\n");
- $i = 0;
- while($row = mysql_fetch_row($result)){
- $schema_insert = "";
- for($j=0; $jif(!isset($row[$j]))
- $schema_insert .= "NULL".$sep;
- elseif ($row[$j] != "")
- $schema_insert .= "$row[$j]".$sep;
- else
- $schema_insert .= "".$sep;
- }
- $schema_insert = str_replace($sep."$", "", $schema_insert);
- $schema_insert .= "\t";
- print(trim($schema_insert));
- print "\n";
- $i++;
- }
- return (true);
- ?>
|
收藏
