excel 2007 official download free full version php method to export database to excel

Upload cvs and import it into the database, the test is successful (some codes are not standardized, such as PHP_SELF, which needs to be rewritten as $_SERVER["PHP_SELF"])
PHP code

Copy code The code is as follows:

$fname = $_FILES['MyFile']['name'];
$do = copy($_FILES['MyFile']['tmp_name'],$fname);
if ($do)
{
echo "Import data successfully
";
} else {
echo "";
}
?>

" METHOD="POST">

Import CVS data

error_reporting(0);
//Import files in CSV format
$c 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);
?>
Use php to export the database to excel, The test was completely successful
PHP code www.devdao.com
$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 = "Database name: $DB_DBName, Data table: $DB_TBLName, Backup date: $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("$titlen");
$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);
?>

The above introduces the method of Excel 2007 official download free full version PHP to export the database to excel, including the content of excel 2007 official download free full version. I hope it will be helpful to friends who are interested in PHP tutorials.