<?php
session_start();

$db_host = "localhost";
$db_user = "root";
$db_pass = "thhdfhhfh";
$db_name = "users";

     try {
       $time = date('Y-m-d h:i:s');
       $username = $_SESSION['username'];

     $db_conn = new PDO("mysql:host={$db_host};dbname={$db_name}",$db_user,$db_pass);
     $db_conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

 $stmt = $db_conn->prepare("UPDATE users SET lastlogin = :lastlogin, logincount = :logincount + :add WHERE username = '$username'");
 $stmt->bindParam(':lastlogin', $time);
 $stmt->bindParam(':add', 1);
 $stmt->execute();
   session_destroy();
   header('location:index.php');


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


?>