php:create report

Question

I want to create report using php. This is file : Some text, 10/07/2010 04:32 Some text, 10/07/2010 04:32 Some text, 12/07/2010 04:32 Some text, 13/07/2010 04:32

Through UI we are entering Start and end date. I have to create report based on that date. How can i do that

Pavel Strakhov · Accepted Answer · 2010-07-16 15:37:31Z

1

Get line from file.
Get date representation using substr and strlen.
Convert date to UNIX time format using strtotime.
Convert entered date to UNIX time format.
Compare two dates using simple < and > conditions.

answered Jul 16, 2010 at 15:37

Pavel Strakhov

40.8k6 gold badges93 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Yell · Accepted Answer · 2010-07-16 15:34:59Z

0

You'll want to build an HTML form with some date fields, either 3 dropdowns or use something like a jQueryUI datepicker.

Don't forget to validate your input!

Then when that's posted, you can create an sql WHERE clause from it. Then you can connect to your database and pull out the data.

Then you have a choice of just looping the data and outputting the list to the screen, and having the user save it as a CSV. Or you can buffer the output using something like ob_start() outputting your data, then assigning it to a variable using ob_get_flush() and then ouputting some CSV headers using header() and passing it out as a file.

Have a google around, there are lots of tutorials for creating CSV files.

answered Jul 16, 2010 at 15:34

David Yell

11.9k13 gold badges64 silver badges102 bronze badges

Collectives™ on Stack Overflow

php:create report

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related