Creating a timesheet for work using PHP MySQL
- by Justin
I am trying to create a time-sheet for my work. I don't know if getting myself into a lot of work by doing this as I am quiet new to PHP and MYSQL but I do have a good understanding/knowledge
of the two. I want the below fields in my database.
Job
weekPeriod ------A list of weeks Monday Sunday
dateWorked ------List Of dates in the form coming from a database e.g. 1/1/2011
startTime ------List of times from 12:00am11:00pm 30 min intervals e.g. 11:30-12:30
endTime ------List of times from 12:00am11:00pm 30 min intervals e.g. 11:30-12:30
totalHours ------Automated
amount ------Automated based on dayWorked
comments ------Any messages here
I want to be able to fill in some drop down boxes through a form that will then submit all information to my database.
I want the script to know that if the date worked is on a Weekday Mon-Fri e.g. my rate of pay is 30.00ph On a sat it is 35.00ph and on a Sunday it is 40ph
I then want to create a page where i select a particular week and see how many hours i worked and how much i earn and so on.
Please let me know if there is such a program already established or if this is something that requires a bit of time and if I could do it being new to PHP and MYSQL