為什么我到處的數據表總是不全，老是在第六條斷掉？
為什么我到處的數據表總是不全，老是在第六條斷掉？
$dir=dirname(__FILE__);//查找當前腳本所在路徑
require?$dir."/db.php";//引入mysql操作類文件
require?$dir."/PHPExcel/PHPExcel.php";//引入PHPExcel
$db=new?db($phpexcel);//實例化db類?連接數據庫
$objPHPExcel?=?new?PHPExcel();//實例化PHPExcel類?等同于在桌面上新建一個excel
for?($i=1;$i<=3;$i++){
????if?($i>1){
????????$objPHPExcel->createSheet();//創建新的內置表
????}
????$objPHPExcel->setActiveSheetIndex($i-1);//把新創建的sheet設定為當前活動sheet
????$objSheet=$objPHPExcel->getActiveSheet();//獲取當前活動sheet
????$objSheet->setTitle($i."年級");//給當前活動sheet起個名稱
????$data=$db->getDataByGrade($i);//查詢每個年級的學生數據
????$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分數")->setCellValue("C1","班級");//填充數據
????$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
你是不是查詢數據的sql有limit
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());//連接數據庫 ????????mysql_select_db($config['database'],$this->conn)?or?die(mysql_errno());//選擇數據庫 ????????mysql_query("set?names?".$config['charset'])?or?die(mysql_errno());//設定mysql編碼 ????} ????/*? ?????*根據傳入sql語句?查詢mysql結果集? ?????*/ ????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; ????} ????/*? ?????*?根據傳入年級數?查詢每個年級的學生數據 ?????*/ ????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
沒人知道嗎。。。。