Hi everyone,
I am currently looking at writing up a simple PHP/MYSQL database for work.. & i'm after some advice as to how I can go about it.
I have installed Xampp etc and I am running the pages I create via http://localhost/something.php.
What I am after is a simple login system, where users can register an account, login, and log the amount of hours they do each day.
They do work for a number of different states/terriroties, so they'd have to be able to select from a dropdown box which state they worked for and the amount of hours for each.
I had a look online and found some scripts 'PHP Login System with Admin feature' See - ( http://www.evolt.org/PHP-Login-System-with-Admin-Features )
So I've tweaked that a little bit and have it all working/talking to the local mySQL database. What I want is when users login to have their OWN page come up.. where they can enter in their data for the day, modify their data for previous days, but not anyone elses. How hard would it be to get a calander in there, that might make things easier. A set of tables that displays the data and generates weekly/monthly totals would also be a good idea.
I also want to have the admin feature set up so that an account with administrative rights can login and be able to print out simple tables or export an excel spreadsheet that contains the total number of hours worked for each State by all. (Adds everybody's information together) .. perhaps being able to select "Week ending" Or "For the month of August" .. so I'd obviously have it connecting into the database and running queries to pull this info out.
It is so very simple to visualise it but I need help as to how I would construct/setup the tables in mySql and what kind of types they will be! Like Varchart etc. Finally, are there any programs, or web resources/forums that will assist me in generating php code, CSS sheets (I plan to create a simple one, with a nav bar across the top, and use the include feature to make all the pages have the same formatting) ? If anybody would be able to take the time to give me a few pointers so that I have more of an idea about how I am going to tackle this I would really appreciate it. I plan to have this running on one of the servers at work so It has to be easily movable without the need to change too many lines in the script.
If you need any more information from me just ask!
Thanks in advance guys . 🙂
