jber Posted August 24, 2007 Share Posted August 24, 2007 I´d want to pass the result of a mysql to an xls file (excel) , obviously all into my php page. Is it possible? You know, can I pass the results as a whole or do i have to extract each parameter and put it into an xls file ( i have no idea how to do it). Maybe some of you have done it or can give me a clue. Thanks in advance for any help Link to comment https://forums.phpfreaks.com/topic/66537-php-mysql-and-excel/ Share on other sites More sharing options...
MadTechie Posted August 24, 2007 Share Posted August 24, 2007 an easier route would be MySQL to CSV, as excel can open CSV's if you google that it should find a few examples Link to comment https://forums.phpfreaks.com/topic/66537-php-mysql-and-excel/#findComment-333229 Share on other sites More sharing options...
phporcaffeine Posted August 24, 2007 Share Posted August 24, 2007 jber, The reason MadTechie suggested .csv is because its text based and marker deliminated. PHP has two methods called explode() and implode() that would work perfectly for such an application. Quick example for reading a comma deliminated .csv file: <?php //INIT VARS FOR USE LATER $hold = array(); $cnt = 0; //YOU CAN ALSO USE $fileResource = file('path/to/csv'); //BUT IT DEPENDS ON HOW YOUR .CSV IS STRUCTURED BECAUSE file() RETURNS AN ARRAY VS. STRING $fileResource = file_get_contents('path/to/csv'); //THIS WILL TURN $hold INTO AN ARRAY WHO'S VALUES COME FROM $fileResource, SEPARATED BY THE DELIMINATED MARKER (COMMA) $hold = explode(',', $fileResource); foreach ($hold as $value) { $cnt++; echo $cnt . ".) " . $value . "<br />"; } ?> Link to comment https://forums.phpfreaks.com/topic/66537-php-mysql-and-excel/#findComment-333242 Share on other sites More sharing options...
sasa Posted August 24, 2007 Share Posted August 24, 2007 look http://www.phpfreaks.com/forums/index.php/topic,155530.0.html Link to comment https://forums.phpfreaks.com/topic/66537-php-mysql-and-excel/#findComment-333281 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.