tmallen Posted November 1, 2007 Share Posted November 1, 2007 I have two scripts, neither of which have been written, that will need to collect user information. They will either write to a flat file or to a MySQL DB, and I need a way for an administrator to grab an Excel file based on this data. First, no more than 100 people are expected to sign up, so flat file is certainly viable. Do you recommend I use DB or flat file? Second, based on your recommendation, how should I go about exporting the user data to an Excel file? There will be about ten form fields per registration to give you an idea. Link to comment https://forums.phpfreaks.com/topic/75687-solved-exporting-db-results-or-flat-file-to-an-excel-file/ Share on other sites More sharing options...
kratsg Posted November 1, 2007 Share Posted November 1, 2007 Excel files can import text flat-files that are tab separated, comma separated, or separated by a common delimiter. IE: comma separated: id,user,password,registered,money,etc,etc2,etc3 tab separated: id user password registered money etc etc2 etc3 other delimiters include : | . || .. |.| (any combination really) id||user||password||registered||money||etc||etc2||etc3 id|.:.|user|.:.|password|.:.|registered|.:.|money|.:.|etc|.:.|etc2|.:.|etc3 //and so on As you can see, as long as you can write to a file with a delimiter, you're fine. Link to comment https://forums.phpfreaks.com/topic/75687-solved-exporting-db-results-or-flat-file-to-an-excel-file/#findComment-382998 Share on other sites More sharing options...
tmallen Posted November 1, 2007 Author Share Posted November 1, 2007 OK, thanks. I'll give it a try. Link to comment https://forums.phpfreaks.com/topic/75687-solved-exporting-db-results-or-flat-file-to-an-excel-file/#findComment-382999 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.