[Edward Han]

Hi

Create username, password and lastlog for mysql database. Please advice how I can add the last login DATE everytime when the user login with the username and password?

Thanks!

[NeverMind]

when you check the user's auth info; if the user was authenticated, then do the INSERT INTO query..

[Edward Han]

Hi NeverMind

I am still a newbie therefore kindly show me how to add using PHP?

Thanks!

Edward

[Edward Han]

Hi NeverMind

I tried inserting the date by doing the following but it did not insert the date into the same column as the username with password. Instead it simply adds into a new line without the username and password. How do I make it inserts into the existing user that login?

Please advice. Thanks!

PHP Code:

    require_once("connect.php");

    $username = $_POST['username'];

    $password = $_POST['password'];

    $search_user_query = "SELECT * FROM " . TABLE_NAME . " WHERE `" . USER_NAME . "`='$username' AND `" . PASS_NAME . "`='$password'";

    $search_user_result = @mysql_query($search_user_query);

        $query = mysql_query("insert into TABLE_NAME set date=CURDATE()"); 

[NeverMind]

use the UPDATE not INSERT INTO

PHP Code:

    $username = $_POST['username'];

    $password = $_POST['password'];

    $search_user_query = "SELECT * FROM " . TABLE_NAME . " WHERE `" . USER_NAME . "`='$username' AND `" . PASS_NAME . "`='$password'";

    $search_user_result = @mysql_query($search_user_query);

    $query = mysql_query("UPDATE ". TABLE_NAME ."  SET date=CURDATE() WHERE ". USER_NAME . "='$username'"); 

if you enabled users to have the same username, then make the UPDATE query:

PHP Code:

$query = mysql_query("UPDATE ". TABLE_NAME ."  SET date=CURDATE() WHERE ". USER_NAME . "='$username' AND " . PASS_NAME . "='$password'"); 

[Edward Han]

Hi NeverMind

Thanks! It works great!

Edward

[1jetsam]

I actually use the Datetime thing.

PHP Code:

$yourtable = "CREATE TABLE IF NOT EXISTS " .SQL_PREFIX. "yourtable (

  id int(11) NOT NULL auto_increment,

  datetime datetime NOT NULL default '0000-00-00 00:00:00',

  PRIMARY KEY (id)

)"; 

PHP Code:

$datetime = date("Y-m-d H:i:s",time());

$query = "INSERT INTO " .SQL_PREFIX. "yourtable (datetime)

VALUES ('" .$datetime. "')";

$result = mysql_query($query) or die(mysql_error());