![]() ![]() $sql = "SELECT pn.created_on, CONCAT( u.firstname,' ', u.lastname) AS created_by, pn.note FROM prop_notes pn LEFT JOIN users u ON pn.created_by = u.user_id " When it gets to the line break, it cuts off the rest of the text. I am exporting data to excel, but run into a problem if the text contains a line break. PS: This is a linux box if that makes a difference. ![]() There it works fine on this new site it bugs out. this same identical script runs 100% fine on another website. However it does not properly tab each field as it should nor go to a new lines as it should instead it stick everything into 1 whole row. So i have this script, it pull data via mysql and inserts it into an excel file. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007') īut excelsheet contain following error.įatal error: Class 'ZipArchive' not found in C:\Program Files\xampp\htdocs\immigration\PHPExcelSourceCode\PHPExcel\Writer\Excel2007.php on line 224īut excelsheet contain this error. Header('Content-Disposition: attachment filename="test.xlsx"') >setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") ![]() >setSubject("Office 2007 XLSX Test Document") GetProperties()->setCreator("Matthew Casperson") ![]() basically, everyone that is in the database, so when a new member is added, they will show up too. I need it so that the results from the database will automatically be filled in. how can I set this up so that $data is all results that are returned from the database that correspond to it?Īrray("firstname" => '$firstname', "lastname" => '$lastname', "age" => '$age')) Ok, so I am not good with arrays, they confuse me. I have export the search result to excel file, but arabic characters not displaying properly in excel file, eventhough i mention the header content type as utf-8 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |