Hi All.
I cannot figure out why I am getting an error with this code.
ERROR: Uncaught Error: Call to undefined function mysql_query()
CODE:
/////
require_once $this->Ini->path_third . ‘/phpexcel/PHPExcel.php’;
require_once $this->Ini->path_third . ‘/phpexcel/PHPExcel/Writer/Excel2007.php’;
////
$query=sprintf(“SELECT
provider_name as name,
first_name as first,
last_name as last,
provider_active as active
FROM
therapists
LEFT JOIN providerst ON therapists.therapistid = providers.serviceproviderid
WHERE
therapists.therapistid = 906” );
///////
$result1= mysql_query($query) or die(mysql_error());
////
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$rowcount=1;
while($row = mysql_fetch_array($result1)){
$objPHPExcel->getActiveSheet()->SetCellValue(‘A’.$rowcount, $row[‘name’]);
$objPHPExcel->getActiveSheet()->SetCellValue(‘B’.$rowcount, $row[‘first’]);
$objPHPExcel->getActiveSheet()->SetCellValue(‘C’.$rowcount, $row[‘last’]);
$objPHPExcel->getActiveSheet()->SetCellValue(‘D’.$rowcount, $row[‘active’]);
$rowCount++;
}
///////////
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
////////////////////////
// Set properties
$objPHPExcel->getProperties()->setCreator(“Maarten Balliauw”);
$objPHPExcel->getProperties()->setLastModifiedBy(“Maarten Balliauw”);
$objPHPExcel->getProperties()->setTitle(“Office 2007 XLSX Test Document”);
$objPHPExcel->getProperties()->setSubject(“Office 2007 XLSX Test Document”);
$objPHPExcel->getProperties()->setDescription(“Test document for Office 2007 XLSX, generated using PHP classes.”);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle(‘Simple’);
// Save Excel 2007 file
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save(str_replace(’.php’, ‘.xlsx’, FILE));
///
header(‘Content-type: application/vnd.ms-excel’);
header(‘Content-Disposition: attachment; filename=“Therapist_Export.xls”’);
$objWriter->save(‘php://output’);
//////
endCode.
Thanks!