| 123456789101112131415161718192021222324252627282930313233343536373839404142 | <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Model_Customer2 extends Lin_Model {	function __construct(){	parent::__construct();	$this->load->database();	$this->table = 'customer2';    $this->load_table('customer2');}    /** 通过名称查找 */	public function get_name($name)	{		return  $this->find("name = '$name'");	}	public function get_data($name,$email,$address)	{		return  $this->find("name = '$name' or email = '$email' or address = '$address'");	}	public function get_email($email)	{		return  $this->find("email = '$email'");	}	public function get_address($address)	{		return  $this->find("address = '$address'");	}	public function get_excel($titledata,$filename)	{		require_once "./data/excel/PHPExcel/IOFactory.php";		$objPHPExcel = new \PHPExcel();        $objPHPExcel->setActiveSheetIndex(0);        $dataArray = $titledata;        $objPHPExcel->getActiveSheet()->fromArray($dataArray, null, 'A1');		header('Content-Type: application/vnd.ms-excel');        header('Content-Disposition: attachment;filename='.$filename);        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');        $objWriter->save('php://output');        $objPHPExcel->disconnectWorksheets();			}}  //end class
 |