Help needed on creating a timesheet

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
brayann36
Forum Newbie
Posts: 2
Joined: Tue Nov 19, 2013 12:21 am

Help needed on creating a timesheet

Post by brayann36 »

i am creating a timesheet in php , i need a logic to update the database , the working is as follows
1. accept employee_id and date , from date get week number , query database with this input as follows
my database task3 contains and id , emp_id , p_name , time , taskdate

Code: Select all

mysql_query("SELECT
  p_name,
  SUM(IF(DAYOFWEEK(taskdate) = 2, `time`, 0)) AS `MO`,
  SUM(IF(DAYOFWEEK(taskdate) = 3, `time`, 0)) AS `TU`,
  SUM(IF(DAYOFWEEK(taskdate) = 4, `time`, 0)) AS `WE`,
  SUM(IF(DAYOFWEEK(taskdate) = 5, `time`, 0)) AS `TH`,
  SUM(IF(DAYOFWEEK(taskdate) = 6, `time`, 0)) AS `FR`,
  SUM(IF(DAYOFWEEK(taskdate) = 7, `time`, 0)) AS `SA`,
  SUM(IF(DAYOFWEEK(taskdate) = 1, `time`, 0)) AS `SU`
FROM task3
WHERE e_id = '$r' AND WEEK(`taskdate`,-1) ='$week'
GROUP BY p_name ");
this is returned through ajax onto my page , and then i can change date and get the result ,(check the attachments)

i want to update the textboxes , this is my issue , i need a logic to get left-mist coloumn project_name and top coloumn date .

table is created in php , with textboxes and values set to those coming from database ,
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Help needed on creating a timesheet

Post by Christopher »

Post the part of the code you want help with.
(#10850)
Post Reply