Chinaunix

标题: 将会员数据生成csv文挡 [打印本页]

作者: phpwzb 时间: 2009-10-14 13:47
标题: 将会员数据生成csv文挡

?php
include './inc/conn.php';
$yesterdaytime = strtotime(date('Y-m-d'))-(3600*24);
$yesterday = date('Y-m-d',$yesterdaytime);
$msg = "0";
/*
$sql_members_row = "SHOW FIELDS FROM trio_members";
$FieldAry = $db->getAll($sql_members_row);
$FieldName = "";
$fnum = count($FieldAry);
for($i=0;$i
$fnum = 26;
$FieldName = "'id';'user_name';'user_real_name';'nic_name';'marry';'profession';'email';'sex';'age';'level';'score';'birthday';'address_id';'province';'city';'county';'address';'mobile_phone';'disable';'reg_time';'last_login';'edit_time';'last_ip';'campaign_id'";
/**************************************************************************/
//home/haier/trioupload/
$sql_count = "select count(*) AS num from trio_members WHERE reg_time.$yesterday." 23:59:59'";
$count = $db->getOne($sql_count);
if($count){
$perpage = 100;//每页记录条数
$page = 1;
$tolpage = @ceil($count / $perpage);
$FieldName = $FieldName."\n";
$filename = "/home/levenepaint/trioupload/members_2009.csv";
if(!$handle = @fopen($filename,"w")){
      $msg = "1";//"Don't Open Or Create File Of ".$filename;
}
if(!@fwrite($handle,$FieldName)){
      $msg = "2";
}

for($page=1; $page=$tolpage; $page++){
      $s_page = ($page-1)*$perpage;
      $sql = '';
      $sql = "SELECT id,user_name,user_real_name,nic_name,marry,profession,email,sex,age,level,score,birthday,address_id,province,city,county,address,mobile_phone,disable,reg_time,last_login,edit_time,last_ip,campaign_id FROM trio_members WHERE reg_time.$yesterday." 23:59:59'";
      $sql .= " limit ".$s_page.",".$perpage;
      $member = $db->getAll($sql);
      for($j=0; $jcount($member); $j++){
         $content = '';
         for($i=0; $i$fnum; $i++){
            if($i==$fnum-1)
                  $content .= "'".$member[$j][$i]."'";
            else
                  $content .= "'".$member[$j][$i]."';";
         }
         $content .= "\n";
         if(!@fwrite($handle,$content)){
            $msg = "3";
         }
      }
}
fclose($handle);
}else{
$msg = "4";
}
echo $result .= $msg;
?>

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/96161/showart_2070115.html

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)