如何在mysql PHP中插入用户登录日期时间[关闭]

Question

I am beginner in PHP and I would like to store the users login time in another table called LoginHistory, I don't know how to write a query. Can u help me on that please?

<?php
include_once "conn.php";

if (!isset($_SESSION)) {
session_start();
}
if ($_SERVER['REQUEST_METHOD'] == "POST") {
if (empty($_POST["mobile_no"]) && empty($_POST["log_password"])) {
echo '<script>alert("Both Fields are required") </script>';
}
$sql = "select * from Users where Mobile='" . $_POST['mobile_no'] . "' and 
Password='" . md5($_POST['log_password']) . "'";
if ($result = mysqli_query($conn, $sql)) {
$rowcount = mysqli_num_rows($result);
}
if ($rowcount > 0) {
$row = $result->fetch_assoc();
$_SESSION["userId"] = $row['Id'];
$_SESSION["ConstituencyId"] = $row['ConstituencyId'];
$succmsg = "Login Success";
header("location:user-login-welcome.php");
} else {
$errmsg = "Invalid Username / Password..";
}
}
?>

Answer 1

In your login success condition just add your insert code to insert date in another table

if ($rowcount > 0) {
    $row = $result->fetch_assoc();
    $_SESSION["userId"] = $row['Id'];
    $_SESSION["ConstituencyId"] = $row['ConstituencyId'];
    $succmsg = "Login Success";
   // Add your login time insert code like below
    $date = date('Y-m-d H:i:s');
    mysql_query("INSERT INTO `table` (`dateposted`) VALUES ('$date')");
    header("location:user-login-welcome.php");
}

You can change datetime, Check the date time manual of PHP