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. Quote 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? Quote 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 (edited) 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 Edited October 19, 2012 by cyberRobot Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.