PHP MySQL Storing a login history

Question

I have an existing PHP MYSQL login system for a site. I want to record the history of every user login including failed attempts.

I want to capture the following data on the history:

username used
Time logged in
Date logged in
Successful - (answerable by yes or no)

How can I do this without changing my entire existing login system?

See http://stackoverflow.com/questions/580534/best-way-to-limit-and-record-login-attempts and http://stackoverflow.com/questions/6357609/limiting-the-number-of-failed-login-attemps — Sukumar, Aug 04 '11 at 08:30

score 6 · Answer 1 · answered Aug 04 '11 at 08:31

6

Create a new table with that info and insert when user logins ...

CREATE TABLE `login_info` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `username` VARCHAR( 50 ) NOT NULL ,
    `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
    `success` ENUM( 'yes', 'no' ) NOT NULL
);

I didn't understand why you need time and date separately ...

answered Aug 04 '11 at 08:31

Mihai Iorga

39,330
16
106
107

I'd recommend indexing the `date` and `username` fields. – Johan Aug 04 '11 at 08:33
i think he meant logged in duration by "time logged in". like, user A was logged in for 4hours and 12 minutes starting at 2:11pm – Kristian Oct 05 '11 at 03:11

score 1 · Answer 2 · answered Aug 04 '11 at 08:40

Looks like you need a basic understanding of OO code as well... Create a new table called login_info with fields as Mihai's answer then assuming your login method is a part of a user class - create a method that will insert a row into this table every time a login is attempted. For example :

class user {
    function login() {
        $this->login_attempt();
        // your login code
    }
    function login_attempt() {
        // insert into your login_info table
    }
}

This keeps your log separate from your login code.

PHP MySQL Storing a login history

2 Answers2

Linked