Daily time record sytem faculty and staff in php

[mheoxe]

hi gud day please help me to my problem -(....i don't know how to create dailytimerecord system in php please please help me...our defense will be on Friday march,16...please help

[Biiim]

You're going to have to describe it better than that.

[mheoxe]

hi gud day please help me to my problem -(....i don't know how to create dailytimerecord system in php please please help me...our defense will be on Friday march,16...please help

hi gud day please help me to my problem -(....i don't know how to create dailytimerecord system in php please please help me...our defense will be on Friday march,16...please help

like u can automatically see your account and profile info in time you login like punchcard...pls urgently needed.

[urtrivedi]

You planning to do it in phpmysql?

[diafol]

March 16. And you haven't started it yet? I don't think you're going to make it. Do you have any code to show?

[mheoxe]

You planning to do it in phpmysql?

Yes Maam/Sir,i think our instructor would give us a chance...removal something like that,i'll show some sample pictures just like this designs i attach some images it's a visualbasic 6 program maybe you can help me do it in PHP but i don't know how to start with the codings please help me about this problem...yesterday was our last defense but i will give it try to submit it to him so he won't fail my grades...

[mheoxe]

March 16. And you haven't started it yet? I don't think you're going to make it. Do you have any code to show?

None Sir,i think our instructor would give us a chance...removal something like that,i'll show some sample pictures just like this designs i attach some images it's a visualbasic 6 program maybe you can help me do it in PHPmysql but i don't know how to start with the codings please help me about this problem...yesterday was our last defense but i will give it try to submit it to him so he won't fail my grades...It's a little bit late i need to submit it as soon as possible Sir...I really need your Help Sir...Thank you for the reply and GodBless Us

[diafol]

Thank you for the reply and GodBless Us

I think He'll have to as I can't see you creating this any time soon if you have absolutely no idea where to start. You're probably talking weeks of work here if you haven't got any experience with PHP.
If this needs to be in next week, I assume you will be failing your grades.

Post any code that you have (PHP not VB) and we'll see how much you have left to do.
No code, no chance.

[t_thakar]

urtrivedi I think this needs to be planned before you do anything

e.g.

how many tables in sql db

what fields do you need

html

css

and queries

php

it takes time!! you will get help if you take an attempt at it

[mheoxe]

i post a databse so you can think what to do...i can't start the program coz i don't know the codings

[diafol]

i post a databse so you can think what to do...i can't start the program coz i don't know the codings

Just wait a minute. You post a db structure and expect the good people at DW to produce code for you? If you don't 'know codings', why are you taking a course where you have to do coding?

Have you thought sbout taking a different course?

[mheoxe]

urtrivedi I think this needs to be planned before you do anything

e.g.

how many tables in sql db

what fields do you need

html

css

and queries

php

it takes time!! you will get help if you take an attempt at it

this is my sample database

[mheoxe]

I KNOW some codings sir but our instructor don't lecture about the exact code in making the system just basic.. he said we can surf in the internet and he didn't taught us about the ryt codes to do the system,all we can do is self resourcing and self study that's how his dealing wd his students...all he do is check and see if our systems was right and running and also if needs some changes...

[veedeoo]

Just my thoughts about your school. I think programming should be systematic, most importantly if it is being teach in academic environment.

Internet is an excellent resources, however the basic foundation of programming should be propagated within the classrooms first, and then external resource can build upon this foundation learned.

About your project,,, here are my say about it. For the daily time record. You script should be able to record or capture the time the faculty and staff logged in the time clock system. Hint: time()... and the time logged for the break time, and time out.. you should be able to capture those hours by the same time ().

For example, faculty log on into the system --> record the time()--> faculty log out --> faculty log on again for his break time to clock out --> faculty log back on again returning from break--> Faculty log back on again for the end of the day --> end of script.

Total hours the faculty members and staffs work during the day

(First hour + second logged in) - (Second Looged in + third logged in) + ( third logged in and final logged out for the day).

Database entry views of your program if scripted based on my visualization

time1,time2,time3,time4...etc.. You can use the truncate function to separate the hours, for your calculation.

How to check for tardiness of the lazy professors.. check if time1 is less than the beginning of the working hours. If time1 is greater than assigned beginning working hours, this faculty or staff is tardy.

How to check if faculty fell asleep while on lunch break.. time2 + time3 . If the sum of the two is greater than the allowed break time, then the faculty or staff ,either overslept or played hooky while on break :), and students are waiting for them facing an empty blackboard.

[Biiim]

I'm completely self taught, I never studied any computer courses. Don't think its the end of the world if you don't get through the course.

To me it seems such a waste of time when you could actually be given a project like that by a company who needs it and will make use of it rather than just being looked at then never used.

I just googled everything

"connect to mysql with php"
"mysqli_connect() does not exist"

Pretty much everything you hit is answered online since php is so widespread, I failed trying to do the same approach on linux they are just incomprehensible.

Being taught you can get a lot of advice from someone who's experienced it all where as I have to learn the hard way, if you really want to make use of the course ask him for help, he's a teacher it's what he's there for.

just going in a week late with a barely done project he's just going to think you don't care.

I would slightly alter the table structure in the file you attached

CREATE TABLE `departments` (
  `dept_id` INT(2) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(60) DEFAULT NULL,
  PRIMARY KEY (`dept_id`)
) ENGINE=INNODB DEFAULT CHARSET=latin1

CREATE TABLE `employees` (
  `employee_id` INT(5) NOT NULL AUTO_INCREMENT,
  `dept_id` INT(2) DEFAULT NULL,
  `first_name` VARCHAR(50) DEFAULT NULL,
  `surname` VARCHAR(80) DEFAULT NULL,
  `telephone` VARCHAR(30) DEFAULT NULL,
  PRIMARY KEY (`employee_id`)
) ENGINE=INNODB DEFAULT CHARSET=latin1

CREATE TABLE `login_times` (
  `login_id` INT(9) NOT NULL AUTO_INCREMENT,
  `employee_id` INT(5) DEFAULT NULL,
  `dept_id` INT(2) DEFAULT NULL,
  `login_of_day` INT(2) DEFAULT NULL,
  `date` DATE DEFAULT NULL,
  `time_in` TIME DEFAULT NULL,
  `time_out` TIME DEFAULT NULL,
  PRIMARY KEY (`login_id`)
) ENGINE=INNODB DEFAULT CHARSET=latin1

CREATE TABLE `schedule_times` (
  `schedule_id` INT(9) NOT NULL AUTO_INCREMENT,
  `employee_id` INT(5) DEFAULT NULL,
  `login_of_day` INT(2) DEFAULT NULL,
  `date_start` DATE DEFAULT NULL,
  `date_end` DATE DEFAULT NULL,
  `time_in` DATETIME DEFAULT NULL,
  `time_out` DATETIME DEFAULT NULL,
  PRIMARY KEY (`schedule_id`)
) ENGINE=INNODB DEFAULT CHARSET=latin1

That way you can have employees with just a single scheduled login or 10+ if you really want it.

The `login_of_day` column may not be needed, just depends how you want to write it you could select how many times that employee has logged in today and add 1 so you can order the login times easily.

I recently had to restructure an expanding table that was over 250 fields and added on 3 columns every time the company did a new service. I got it down to 6 columns but around 50 times more rows, then a separate table where they can now add as many new services as they want and the app is all set to know exactly how to add it to the site.

Its much better to single them out you can do so much more with it, any search on login times you'd have to search 3 fields or more if they decide they need 5 or 6 logins later on.

Try and make each row in a table match a single particle eg. not 3 logins per row, 1 login per row and attach all required data to it eg. the employee id, department id (the employee could move departments later on).

Total time per day would be the sum of the difference between the login and logout of all entries on that day.

SELECT employee_id,`date`,SUM(TIME_TO_SEC(TIMEDIFF(time_out,time_in))) AS  `seconds_logged_in` FROM `login_times` WHERE `date` = '2012-03-19' GROUP BY `employee_id`;

That would give you the time in seconds for each employee on that date. I even googleed mysql time functions to find out about TIME_TO_SEC() and TIMEDIFF(), i've never used them before.

[mheoxe]

Bold Text Here THANKS FOR HELPING OUT GUYS I REALLY APPRECIATE IT SO MUCH THANK YOU AND GODBLESS

[mhinerain]

hi there we are making our Attendance Monitoring System of our school personnel and we want that if they will log in it will automaticaly record in database the log in and log out time and there is a calculation of time and there is a pop up message for them..we are using php mysql language,your help is highly appreciated sir,thank you and God bless.