實例一： <?php $filename = 'test'; //導出文件 header("Content-type: application/vnd.ms-excel; charset=utf-8"); Header("Content-Disposition: attachment; filena ...
實例一：
<?php
$filename = 'test';
//導出文件
header("Content-type: application/vnd.ms-excel; charset=utf-8");
Header("Content-Disposition: attachment; filename=".$filename.".csv");
echo "商品名稱,商品編號,商品價格,商品品牌,商品顏色\n";
$arr = [
['貂秋1','dq00001','1000','雕牌','紅色'],
['貂秋2','dq00002','1000','雕牌','藍色'],
['貂秋3','dq00003','1000','雕牌','綠色'],
['貂秋4','dq00004','1000','雕牌','白色']
];
//將數組迴圈遍歷並輸出
foreach ($arr as $item){
echo implode(',',$item)."\n";
}
示例二：
//從資料庫中導出
$conn = mysqli_connect('localhost','root','123456','st0614');//連接資料庫
$filename = 'student';//文件名為student
header("Content-type: application/vnd.ms-excel; charset=utf-8");
Header("Content-Disposition: attachment; filename=".$filename.".csv");
$res = mysqli_query($conn,'select * from student');
echo "ID,姓名,性別,年齡,院系,班級,頭像\n";//表頭
while($row = mysqli_fetch_assoc($res))//獲取資料庫數據
{
$arr[] = $row;
}
foreach ($arr as $item){
echo implode(',',$item)."\n";//輸出
}
//SVN導入資料庫
$file = 'text.txt';
if (isset($_POST['commit'])){
$file = $_FILES['csv'];
$fileName=$file['tmp_name'];
$fp = fopen($fileName,'r');
$i=0;
while ($file_data = fgetcsv($fp))
{
$i++;
if($i==1)
{
continue;//過濾表頭
}else{
$data[$i] = $file_data;
}
}
fclose($fp);
}
<-- ---------請分開--------- -->
//存入資料庫
if (isset($data)){
foreach ($data as $item){
$name = iconv('gb2312','utf-8',$item[1]);
$sql = "insert into student(`name`,`sex`,`age`,`d_id`,`class_id`,`tumble`) values('{$name}',{$item[2]},{$item[3]},{$item[4]},{$item[5]},'{$item[6]}')";
$res = mysqli_query($conn,$sql);
}
if ($res){
echo '上傳成功！';
}else{
echo '上傳失敗！';
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<body>
<form action="" method="post" enctype="multipart/form-data">
csv文件:
<input type="file"name="csv">
<--<button id="btn" onclick="<?php //download(); ?>">下載</button>-->
<input type="submit" name="commit" value="上傳">
</form>
</body>
</html>
