sseeley Posted August 2, 2009 Share Posted August 2, 2009 Hi, I have created the following code to try and create an excel file. However I am getting an error on line 4 'Parse error: syntax error, unexpected ':' in /home/mypcguy2/public_html/accounts/excelTest.php on line 4' Would anyone be able to help me with this error? Many thanks <?php require_once “excel.php”; $filename = “theFile.xls”; $export_file = “xlsfile://tmp/”.$filename; $fp = fopen($export_file, “wb”); if (!is_resource($fp)) { die(”Cannot open $export_file”); } // typically this will be generated/read from a database table $assoc = array( array(”First name” => “Mattias”, “IQ” => 250, array(”First name” => “Tony”, “IQ” => 100, array(”First name” => “Peter”, “IQ” => 100, array(”First name” => “Edvard”, “IQ” => 100); fwrite($fp, serialize($assoc)); fclose($fp); header (”Expires: Mon, 26 Jul 1997 05:00:00 GMT”); header (”Last-Modified: ” . gmdate(”D,d M YH:i:s”) . ” GMT”); header (”Cache-Control: no-cache, must-revalidate”); header (”Pragma: no-cache”); header (”Content-type: application/x-msexcel”); header (”Content-Disposition: attachment; filename=\”" . $filename . “\”" ); header (”Content-Description: PHP/INTERBASE Generated Data” ); readfile($export_file); exit; ?> Link to comment https://forums.phpfreaks.com/topic/168533-solved-excel-file-error/ Share on other sites More sharing options...
Bricktop Posted August 2, 2009 Share Posted August 2, 2009 Hi sseeley, export_file = “xlsfile://tmp/”.$filename; appears to be the culprit here, you've essentially commented out the text after the //. Are you sure you need // in there? Would export_file = “xlsfile:/tmp/”.$filename; not work? Link to comment https://forums.phpfreaks.com/topic/168533-solved-excel-file-error/#findComment-889045 Share on other sites More sharing options...
sseeley Posted August 2, 2009 Author Share Posted August 2, 2009 Thanks for your help, but still geting the same error...? Link to comment https://forums.phpfreaks.com/topic/168533-solved-excel-file-error/#findComment-889053 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.