11-18-2016, 06:02 PM
Well I'm back, and having a hell of a time figuring out what I'm doing haha. My inexperience with PHP is showing and I have no idea how to get what I want done...done. I haven't coded with this stuff in 5-6 years so I'm quite out of touch.
Basically, I'm just looking for some help on getting a single function done. Once I figure that out, I'm confident I can take it from there and run with it. I just need help with the basics to get me started.
So for one, I need to add another row/column (I think?) to your database where I can log times when a button is pressed. I have no idea how to do that, but I plan on trying in phpMyAdmin to see how that works out. Problem is I don't know what options to use...I just know that I need to be able to store timestamps in it.
Second, I don't know what an example code would look like to set that timestamp into the DB for that relevant user. I've tried Google and my other team member tried coding something from scratch himself and we both are failing to figure out how to keep any DB entries made by a user stuck to that user's session.
I'm trying to make something like a time clock but not really...it will evolve into tracking breaks of team members as a whole, showing realtime who is on break and for how long they've been on break, give reports to myself and the other supervisor about often people are up out of their desks, etc.
Basically, I'm just looking for some help on getting a single function done. Once I figure that out, I'm confident I can take it from there and run with it. I just need help with the basics to get me started.
So for one, I need to add another row/column (I think?) to your database where I can log times when a button is pressed. I have no idea how to do that, but I plan on trying in phpMyAdmin to see how that works out. Problem is I don't know what options to use...I just know that I need to be able to store timestamps in it.
Second, I don't know what an example code would look like to set that timestamp into the DB for that relevant user. I've tried Google and my other team member tried coding something from scratch himself and we both are failing to figure out how to keep any DB entries made by a user stuck to that user's session.
I'm trying to make something like a time clock but not really...it will evolve into tracking breaks of team members as a whole, showing realtime who is on break and for how long they've been on break, give reports to myself and the other supervisor about often people are up out of their desks, etc.