1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

CheckIN CheckOUT System via php & MySql

Discussion in 'PHP' started by h2waldmann, Aug 8, 2012.

  1. h2waldmann

    h2waldmann New Member

    Joined:
    Aug 8, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi, is it possible to make a CheckIN and CheckOUT systen via php & MySql?

    I want to make for our Club a programm to get how many visitors we have and how long they stay. I alredy have one, but it is in access and looks like sh...

    The steps are simple:
    1st: a visitor come and i press the male or female button
    2nd: then i type the name an email in a formular
    3th: i give the person a locker number. done.

    When the visitor want to go home:
    4th: i press the button checkOUT
    5th: and then the locker number.
    thats it.

    now i want a extra button that show me how many visitors we have
    - today
    - yesterdy
    - last week
    - last month
    - last year

    hope you all undestand what i mean cause my english is not so good.



    best regards
    tomas
     
  2. smohd

    smohd New Member

    Joined:
    Aug 21, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Zanzibar
    Ya that is possible,
    Lest me through some ideas here:
    - In database, you will need some:
    - table for rooms (room no, its status,engaged/not)
    - visitors...
    - daily infos
    - Now after user come, select an empty room and assign him/her. Put information in daily usage info.
    - If goes out, assign the appropriate value.
    - To get current in, just query for count of all active.
    - To get users of the certain day, query for count of the day (you will have field for date in your datbase)
     
  3. pein87

    pein87 New Member

    Joined:
    Aug 6, 2010
    Messages:
    173
    Likes Received:
    47
    Trophy Points:
    0
    Occupation:
    Web Dev
    Location:
    Limbo
    You could get a free time clock script that could handle this. Its easy to implement but you'd need to be able to keep track of the months, and days in each month. Are there a preset number of lockers or are they random numbers? Could you give me more details?
     

Share This Page