获取mysql中的数据并转化为txt或者excel文档

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 设置为昨天的日期