SalientAnimal Posted October 17, 2012 Share Posted October 17, 2012 I have just been given another challenge and am probably going to post a question on the forums again, because quite honestly I have no idea where to start. But I know people dislike you posting if you have no code at all. Maybe you know where I can start? There's basically two things I wanna achieve here: 1. Create a Report Page (Not sure how to make this "Fancy") I want the user to select a date range using a calendar input, and then click on submit. It should then extract the data from the MySQL database to an excel file. (Writing the actual select query I am ok with) 2. To automate an extract from the database. Everyday, at say 06h00 a query should run, to extract current month to date data from the MySQL database, attach it an e-mail it. Any help is greatly appreciated. Link to comment https://forums.phpfreaks.com/topic/269559-mysqlphp-data-extract-for-user/ Share on other sites More sharing options...
SalientAnimal Posted October 19, 2012 Author Share Posted October 19, 2012 Can anyone help on this topic please? Link to comment https://forums.phpfreaks.com/topic/269559-mysqlphp-data-extract-for-user/#findComment-1386304 Share on other sites More sharing options...
cyberRobot Posted October 19, 2012 Share Posted October 19, 2012 For the calendar input, you could look at jQuery's Datepicker: http://jqueryui.com/datepicker/ To run a script on a regular basis, have a look at "cron jobs". https://www.google.com/search?q=cron+job Link to comment https://forums.phpfreaks.com/topic/269559-mysqlphp-data-extract-for-user/#findComment-1386309 Share on other sites More sharing options...
White_Lily Posted October 19, 2012 Share Posted October 19, 2012 With the excel spreadsheet try this set of search results: http://www.google.co.uk/#hl=en&biw=1280&bih=933&sclient=psy-ab&q=writing+data+to+excel+with+php&oq=writing+data+to+excel+with+php&gs_l=hp.3..0i22l2.636519.641765.1.642032.30.19.0.11.11.0.208.2317.7j11j1.19.0.les%3B..0.0...1c.1.ggXsbJEqxW4&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&fp=9cc6ce1e3edfb4fe&bpcl=35466521 Whether this helps I don't know - but it's a start. Link to comment https://forums.phpfreaks.com/topic/269559-mysqlphp-data-extract-for-user/#findComment-1386312 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.