java导出csv小程序_小程序制作笔记-PHP代码之导出excel(csv)

header("Content-type:text/html;charset=utf-8");

$servername = "localhost";

$username = "username";

$password = "password";

$mysqlname = "dbname";

$con = mysqli_connect($servername, $username, $password, $mysqlname);

mysqli_query($con,"set names utf8");

if($month =isset($_GET['months'])?$_GET['months']:''){

$months=$_GET['months'];

$filename = date("Y年m月").'维修工单.csv';

$sql = "select * from repairs where months='$months'";

}elseif($_GET['all']=="all"){

$sql = "select * from repairs";

$filename = '全部维修工单.csv';

}

$res = $con->query($sql);

$str = '宿舍号,维修类别,问题详述,工号,姓名,电话,报修月份,报修日期,工单状态