Login Tracker

<?php
$servername = "localhost";
$username = "";
$password = "";
$dbname = "";
$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
$phpdate = strtotime( $mysqldate );
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username,
        $password);

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


    $stmt = $conn->prepare("INSERT INTO logins (date, Name,
ip)
VALUES (:date, :Name, :ip)");
    $stmt->bindParam(':date', $date);
    $stmt->bindParam(':Name', $user);
    $stmt->bindParam(':ip', $ip);


    $date = date("Y-m-d H:i:s");
    $name = $_SESSION['user_last_name'];
    $ip = $_SERVER[REMOTE_ADDR];
    $stmt->execute();

}
catch(PDOException $e)
{
    echo "Error: " . $e->getMessage();
}
$conn = null;
?>