You are here:

MySQL/Attendance based on Login Time

Advertisement


Question
Hi Stuart,

I have prepared a database to capture Login Time and logout time for People to use across several units. Every one from Team will open the database to capture the time.

Now I need to update the table with present or absent automatically when they login the system , and also
For example, If an employee is absent and when supervisor opens the admin Form, it should ask about every employee whether he is planned leave or unplanned leave in msgbox.
if he click Yes then it should update planned leave in database for that employee.
 Is that possible ?

Answer
Dear Sir

Yes all of this is possible, This however would be a little to much for me to put in here as I would end up writing the code and this is only ment to be for answering questions.


updating the database when a user logs in is simple, with regards to the supervisor logging in I assume that he or she would be the last to login? and once logged in I would suggest presenting the supervisor with a jQuery dynamic popup form showing a list of staff that have not logged in as of yet and have a checkbox next to each name to give the option of planned leave. on the form submit the jQuery popup box would disappear.


If you would like help writing this then please let me know

MySQL

All Answers


Answers by Expert:


Ask Experts

Volunteer


stuart gregory

Expertise

PHP html, xhtml, css coding and MySQL

Experience

My experiance is all first had as I am web developer and I have, and do build many websites all using php and mysql. This ranges from building a simple search engine to secure php login scripts. Some websites like http://www.web-application-development.info are complete database driven websites.

Organizations
I have a large number of websites which I host and maintain, such as. http://www.webreger.com http://www.universalscience.co.uk http://www.modellingelectronics.co.uk

Education/Credentials
Web application development. (Open University) BSC Honers Computing and development (Open University)

©2016 About.com. All rights reserved.