為什么我到處的數(shù)據(jù)表總是不全，老是在第六條斷掉？
為什么我到處的數(shù)據(jù)表總是不全，老是在第六條斷掉？
$dir=dirname(__FILE__);//查找當(dāng)前腳本所在路徑
require?$dir."/db.php";//引入mysql操作類文件
require?$dir."/PHPExcel/PHPExcel.php";//引入PHPExcel
$db=new?db($phpexcel);//實(shí)例化db類?連接數(shù)據(jù)庫
$objPHPExcel?=?new?PHPExcel();//實(shí)例化PHPExcel類?等同于在桌面上新建一個(gè)excel
for?($i=1;$i<=3;$i++){
????if?($i>1){
????????$objPHPExcel->createSheet();//創(chuàng)建新的內(nèi)置表
????}
????$objPHPExcel->setActiveSheetIndex($i-1);//把新創(chuàng)建的sheet設(shè)定為當(dāng)前活動sheet
????$objSheet=$objPHPExcel->getActiveSheet();//獲取當(dāng)前活動sheet
????$objSheet->setTitle($i."年級");//給當(dāng)前活動sheet起個(gè)名稱
????$data=$db->getDataByGrade($i);//查詢每個(gè)年級的學(xué)生數(shù)據(jù)
????$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分?jǐn)?shù)")->setCellValue("C1","班級");//填充數(shù)據(jù)
????$j=2;
????foreach?($data?as?$key=>$val){
????????$objSheet->setCellValue("A".$j,$val['username'])->setCellValue("B".$j,$val['score'])->setCellValue("C".$j,$val['class']."班");
????????$j++;
????}
????
}
$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');//生成excel文件
$objWriter->save($dir."/export_1.xls");//保存文件
2015-07-13
你是不是查詢數(shù)據(jù)的sql有l(wèi)imit
2015-07-14
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_errno());//連接數(shù)據(jù)庫 ????????mysql_select_db($config['database'],$this->conn)?or?die(mysql_errno());//選擇數(shù)據(jù)庫 ????????mysql_query("set?names?".$config['charset'])?or?die(mysql_errno());//設(shè)定mysql編碼 ????} ????/*? ?????*根據(jù)傳入sql語句?查詢mysql結(jié)果集? ?????*/ ????public?function?getResult($sql){ ????????$resource?=?mysql_query($sql,$this->conn)?or?die(mysql_errno());//查詢sql語句 ????????$res?=?array(); ????????while?(($row?=?mysql_fetch_assoc($resource))!=false){ ????????????$res[]=$row; ????????} ????????return?$res; ????} ????/*? ?????*?根據(jù)傳入年級數(shù)?查詢每個(gè)年級的學(xué)生數(shù)據(jù) ?????*/ ????public?function?getDataByGrade($grade){ ????????$sql?=?"select?username,score,class?from?user?where?grade=".$grade."?order?by?score?desc"; ????????$res?=?self::getResult($sql); ????????return?$res; ????} }2015-07-13
沒人知道嗎。。。。