php_novice2007 Posted August 14, 2007 Share Posted August 14, 2007 Hi, Is it possible to write PHP code to convert a MYSQL table into an excel file and store it on the server so that the user can download it? If so how?? Basically do the export command.. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/64776-solved-making-an-excel-file/ Share on other sites More sharing options...
hitman6003 Posted August 14, 2007 Share Posted August 14, 2007 Use mysql's "SELECT ... INTO outfile" command to create a CSV http://dev.mysql.com/doc/refman/4.1/en/select.html#id3180150 Quote Link to comment https://forums.phpfreaks.com/topic/64776-solved-making-an-excel-file/#findComment-323141 Share on other sites More sharing options...
php_novice2007 Posted August 14, 2007 Author Share Posted August 14, 2007 thanks! Quote Link to comment https://forums.phpfreaks.com/topic/64776-solved-making-an-excel-file/#findComment-323181 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.