Page 1 of 1

Help needed when creating time sheet

Posted: Wed May 23, 2018 3:15 pm
by WilliamTaylor1o
I'm creating a timesheet in php, I need a logic to update the database, working as follows
1. Accept employee_id and date, from date to week number, database query with this input as follows
My task3 database contains and id, emp_id, p_name, time, taskdate

Re: Help needed when creating time sheet

Posted: Wed May 23, 2018 11:51 pm
by Christopher
You have one item with a bunch of stuff in it. Can you clarify and break it down more?

1. Form to accept employee_id and "date, from date to week number" (can you clarify the date choices?)

2. Query database for records matching employee_id and date criteria

3. Display results. (What is the difference between employee_id and emp_id? What is p_name? Why separate time and date?)