Hello all, I am a new member of this forum, nice to meet you all. I am new at PHP, but I am familiar with the concept, I made some websites (using cms) back in the day. Now I am working on a new project for my company and during my free time want to make it reality.
The idea is to make a website where logged in user can fill a data, this data then is stored in some database and based on that data excel reports can be done.
There are 200 cars being used by the drivers each day and after working day I want them to log in to the website (using unique username) and choose a car from the drop down list, fill up the date, how many miles they have traveled and how much fuel they bought. So basically 3 or 4 variables. Then this data goes to somekind of database. And then I can pull out the reports, for example “A REPORT on total miles driven on September” etc…
I hope You get the idea.
I know I need to learn a lot. Perhaps anyone can suggest some literature, articles?
What tools will I need to set up the system? MySQL, PHP my admin, PHPExcel?
Basically website must have these features:
- Ability to generate multiple users with different permissions
- Ability to store data in one database.
- Ability to pull out Excel reports based on the data arrays.