js使用


var isIE = !-[1,];
if(isIE){
    try{
        var swf1 = new ActiveXObject('ShockwaveFlash.ShockwaveFlash');
        alert('安装了Flash');
    }
    catch(e){
        layer.alert('没有安装Flash');
    }
}
else {
    try{
        var swf2 = navigator.plugins['Shockwave Flash'];
        if(swf2 == undefined){
            layer.alert('没有安装Flash');
        }
        else {
            layer.alert('安装了Flash');
        }
    }
    catch(e){
        layer.alert('没有安装Flash');
    }
}


$db = new Mysql($dbconfig);
$sql = "SELECT * FROM  表名";
$row = $db->GetAll($sql);  // $row 为二维数组
$count = count($row);
for ($i = 2; $i <= $count+1; $i++) {
 $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, convertUTF8($row[$i-2][1]));
 $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, convertUTF8($row[$i-2][2]));
 $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, convertUTF8($row[$i-2][3]));
 $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, convertUTF8($row[$i-2][4]));
 $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, convertUTF8(date("Y-m-d", $row[$i-2][5])));
 $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, convertUTF8($row[$i-2][6]));
 $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, convertUTF8($row[$i-2][7]));
 $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, convertUTF8($row[$i-2][8]));
}