<?php
    
$dbhost="localhost";
$dbusuario="root";
$dbpassword="7891235";
$db="inase";

	//$conexion = mysql_connect($dbhost, $dbusuario, $dbpassword);	
	$mysqli = new mysqli($dbhost,$dbusuario,$dbpassword,$db,3306);

	if (mysqli_connect_errno()) {
    	  printf("La conexion con el servidor de base de datos fallo: %s\n", mysqli_connect_error());
    	  exit();
	}

	$sql = "SELECT * FROM vistainaseasp";	
	$resultado = $mysqli->query($sql);

	if($resultado->num_rows > 0 ){

		require_once 'Classes/PHPExcel/PHPExcel.php';
		require_once 'Classes/PHPExcel/PHPExcel/IOFactory.php';

		$objPHPExcel = new PHPExcel();

		$objPHPExcel->getProperties()->setCreator("Supapel")
    	        	->setLastModifiedBy("Supapel")
   	        	->setTitle("Reporte IQR")
   	        	->setSubject("Reporte INASE")
   	        	->setDescription("Reporte Eventos")
                	->setKeywords("reporte Eventos") 
   	        	->setCategory("Reporte excel"); 

		$tituloReporte = "Reporte Eventos";
                $titulosColumnas = array('ID', 'Name', 'Code');		

		$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:G1');
		
		$objPHPExcel->setActiveSheetIndex(0)
   			->setCellValue('A1',$tituloReporte)
    	        	->setCellValue('A3',$titulosColumnas[0]) 
    	        	->setCellValue('B3',$titulosColumnas[1])
    	        	->setCellValue('C3',$titulosColumnas[2]);


		$i = 4;
		while ($fila = $resultado->fetch_array()){
		$objPHPExcel->setActiveSheetIndex(0)
   			->setCellValue('A'.$i,'1')
    	        	->setCellValue('B'.$i,'DAVID') 
    	        	->setCellValue('C'.$i,$fila['Code']);	
     		$i++;
		}

		 
		header('Content-Type: application/vnd.ms-excel');
		header('Content-Disposition: attachment;filename="Reporte.xls"');
		header('Cache-Control: max-age=0');
		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
		$objWriter->save('php://output');
		exit;	
	}


?>