将会员数据生成csv文挡

phpwzb

               
               
                ?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