Home  >  Article  >  Backend Development  >  PHPExcel exports mysql database data_PHP tutorial

PHPExcel exports mysql database data_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 09:44:491038browse

PHPExcel exports mysql database data

Export file using PHPExcel

First of all, take a look at the above article. The writing method is the same, but there are additional database operations in the middle, and there is excel browser output at the end.

Database code (the database configuration file is completed by itself)

<!--?php
/*db.php*/
	require dirname(__FILE__)./dbconfig.php;

	class db{
		public $conn = null;

		public function __construct($config){
			$this--->conn=mysql_connect($config[&#39;host&#39;],$config[&#39;username&#39;],$config[&#39;password&#39;]) or die(mysql_error());
			mysql_select_db($config[&#39;database&#39;],$this->conn) or die(mysql_error());
			mysql_query(set names .$config[&#39;charset&#39;]) 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;
		}
	}

Database export code:

<!--?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[&#39;id&#39;])->setCellValue(B.$j,$value[&#39;user_login&#39;])
					->setCellValue(C.$j,$value[&#39;user_nicename&#39;])->setCellValue(D.$j,$value[&#39;user_email&#39;])
					->setCellValue(E.$j,$value[&#39;sch_name&#39;])->setCellValue(F.$j,$value[&#39;last_login_time&#39;]);
			$j++;
		}
	}

	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,Excel5);
	// $objWriter->save($dir.&#39;/export.xls&#39;); //生成excel文件
	browser_export(Excel5,browser_excel03.xls); //浏览器输出
	$objWriter->save(php://output);

	function browser_export($type, $filename){
		if($type == Excel5){
			header(&#39;Content-Type: application/vnd.ms-excel&#39;); //excel2003
		}else{
			header(&#39;Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet&#39;); //excel2007
		}
		header(&#39;Content-Disposition: attachment;filename=&#39;.$filename.&#39;&#39;);
		header(&#39;Cache-Control: max-age=0&#39;);
	}
	

	

Running screenshot:


www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1047175.htmlTechArticlePHPExcel exports mysql database data Using PHPExcel to export files First, take a look at the above article. The writing method is the same, but there is more in the middle After the database operation, there is also excel browser output...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn