Mysql/php Data Extract For User

[SalientAnimal]

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.

[SalientAnimal]

Can anyone help on this topic please?

[cyberRobot]

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

[White_Lily]

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.