Forum Moderators: coopster

Message Too Old, No Replies

webapp time recording system

record and calculate time

         

dubhfearchat

2:57 pm on Jul 3, 2009 (gmt 0)

10+ Year Member



hello everybody,

I am trying to build a time recording system using phpmyadmin and would like some help.. I have a few pages built the easy ones..
I would like to be able to select from a calender todays date and current time and have this Information stored in my datebase so that I can calculate the time an employee has spent on a project. so far I can select my project and select an employee and this info with a start time will be stored in my timesheet table but this not good enough I would perfer to dispaly a calender and have the employee select todays date and start then the end time of the project.

any comments are welcome

thanks

jatar_k

4:29 pm on Jul 3, 2009 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld dubhfearchat,

there's no reason you can't make it that way. You have made more of a statement than posed a question so I am not sure exactly what you need. There are a bunch of calendar scripts around that allow you to do what you want for selecting dates. If you need to switch it completely to be oriented towards your employees then you would need some type of login system for them. That would allow you to get the employee data and they could select the date info.

hth

dubhfearchat

5:45 pm on Jul 3, 2009 (gmt 0)

10+ Year Member


thanks for yr reply jatar_k.. you make it seem very simple I have spent the the last 6yrs of my life as a 3d artist so I don't have much experince with this code scripting stuff.. I shuold have typed some ? aswell...

yes calender scripts sounds like what I need.. do you know where can I find a good one that the code is compatible with phpmyadmin?

also I have a table called projects with the project details stored in this how do I display the project name with the start date and end date using a calander and then store that information in timesheet table?

thanks

jatar_k

2:31 pm on Jul 7, 2009 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



sorry I'm slow on the response

as for a good calendar script, it's all up to personal taste, a good place for all kinds of scripts is [hotscripts.com...]

as far as how to do this stuff specifically, you need to familiarize yourself with mysql/php and go from there.

There are some links in our library [webmasterworld.com] that should help, particularly this one which links to a bunch

Learning PHP - Books, Tutorials and Online Resources [webmasterworld.com]

dubhfearchat

4:43 pm on Jul 8, 2009 (gmt 0)

10+ Year Member



thanks jatar_k will have a look over that stuff and hopefully I will become an expert.