PHPExcel导出mysql数据库数据

下面是脚本之家 jb51.cc 通过网络收集整理的代码片段。

脚本之家小编现在分享给大家，也给大家做个参考。

    <?php  
    /*db.php*/  
        require dirname(__FILE__)."/dbconfig.php";  
      
        class db{  
            public $conn = null;  
      
            public function __construct($config){  
                $this->conn=mysql_connect($config['host'],$config['username'],$config['password']) or die(mysql_error());  
                mysql_select_db($config['database'],$this->conn) or die(mysql_error());  
                mysql_query("set names ".$config['charset']) or die(mysql_error());  
            }  
      
            public function getResult($sql){  
                $resource = mysql_query($sql,$this->conn) or die(mysql_error());  
                $res = array();  
                while(($row=mysql_fetch_assoc($resource))!=false){  
                    $res[] = $row;  
                }  
                return $res;  
            }  
      
            public function getUserinfo(){  
                $sql = "。。。";  
                $res = self::getResult($sql);  
                return $res;  
            }  
        }  

    <?php  
        $dir = dirname(__FILE__);  
        require $dir."/db.php";  
        require $dir."/PHPExcel.php";  
      
        $db = new db($phpexcel);  
        $objPHPExcel = new PHPExcel();  
      
        for($i=0; $i<3; $i++){  
            if($i>0){  
                $objPHPExcel->createSheet();  
            }  
            $objPHPExcel->setActiveSheetIndex($i);  
            $objSheet = $objPHPExcel->getActiveSheet();  
            $data = $db->getUserinfo();  
      
            $objSheet->setCellValue("A1","编号")->setCellValue("B1","登陆名")  
                    ->setCellValue("C1","昵称")->setCellValue("D1","电子邮箱")  
                    ->setCellValue("E1","学校")->setCellValue("F1","最后登陆时间");  
      
            $j = 2;  
            foreach ($data as $key => $value) {  
                # code...  
                $objSheet->setCellValue("A".$j,$value['id'])->setCellValue("B".$j,$value['user_login'])  
                        ->setCellValue("C".$j,$value['user_nicename'])->setCellValue("D".$j,$value['user_email'])  
                        ->setCellValue("E".$j,$value['sch_name'])->setCellValue("F".$j,$value['last_login_time']);  
                $j++;  
            }  
        }  
      
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel5");  
        // $objWriter->save($dir.'/export.xls'); //生成excel文件  
        browser_export("Excel5","browser_excel03.xls"); //浏览器输出  
        $objWriter->save("php://output");  
      
        function browser_export($type,$filename){  
            if($type == "Excel5"){  
                header('Content-Type: application/vnd.ms-excel'); //excel2003  
            }else{  
                header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); //excel2007  
            }  
            header('Content-Disposition: attachment;filename="'.$filename.'"');  
            header('Cache-Control: max-age=0');  
        }  
          
      
          

以上是脚本之家(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得脚本之家网站内容还不错，欢迎将脚本之家网站推荐给程序员好友。

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!