1. 输出所有用户的物品
$uids = sql_fetch_rows("select uid from sys_user");
foreach($uids as $uid)
{
$goodText = $uid["uid"];
$goodNames = sql_fetch_rows("select name from sys_goods where uid = $uid");
foreach(){
$goodText .= "/t".$goodNames["name"];
}
file_put_contents('/yekai/good_data.txt',$goodText."/n",FILE_APPEND);
}
mysql设置字符集格式:
mysql_query("SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary");
2. 转化为Execl文件并打包
需要将上面的txt文件转化为excel文件
iconv函数把utf-8编码的页面转成gb2312:$fileName = iconv("utf-8", "gb2312//IGNORE", $fileName);
function convertTxtToExcel($fileName)
{
$command = "tr -s '/n' '/r/n' < $fileName.txt|tr -s '/t' ','|iconv -c -f utf8 -t gb2312 > $fileName.csv";
system($command);
$command = "rm -f $fileName.txt";
system($command);
}
function zipData()
{
$command = "zip `date +%Y%m%d`.zip *.csv";
system($command);
}
date命令:
date -s 25/11/10 16:00:00
date -s 25/11/10
date -s 16:00:00
date -d yesterday 设置为昨天的日期