PHP website

[sfzpilot]

Hi everyone,

 

I am new to website development and I am making a webpage where I would like to have a login for members. I know how to do, thats the easy part. But These members will have records; let me explain: once they login, and do, for example, 1.3 hours of work, they will say where they worked and how long they worked (in a form). Then when they submit this form, I, or another moderator, would either accept or deny it. Then an automated email would get sent out to them and let them know what happened (if it passed, or got denied). If it got passed, the amount of time would be logged in their "logbook." It may have something to do with a MYSQL database. Any help would be appreciated. Thanks!

[andrewgarn]

What your asking is in multiple parts, you should make one part work first, then try the next.

 

submit form - feeds post data -> php -> insert query -> mysql database

 

you could have a field in the table the form is adding to called "verified" or something, which is default to No.

 

Then then moderator could accept the record by changing the verified to Yes.

 

using select queries the data could then be echoed onto the page for a logbook type thing, including and using a WHERE command you could display only verified hours in the logbook.

 

e.g.

 

SELECT * from hour_table WHERE verified = 'Yes' AND employee = 'John Smith';