require_once( 'assets/mysql_connect.php' ); session_start(); if ( isset( $_POST[ 'email' ] ) && isset( $_POST[ 'password' ] ) ) { $email = $_POST[ 'email' ]; $password = $_POST[ 'password' ]; $result = $sql->query( "SELECT * FROM QR_Admin WHERE email = '$email' AND password = '$password' " ); if ( $result->num_rows == 1 ) { $row = $result->fetch_assoc(); $_SESSION[ 'signedin' ] = true; $_SESSION[ 'id' ] = $row[ 'id' ]; $_SESSION[ 'name' ] = $row[ 'name' ]; $sql->query( "UPDATE QR_Admin SET datetime_signedin = NOW() WHERE email = '$email' " ); header( 'Location: dashboard' ); exit(); } else { $error = true; } } if ( $_SESSION[ 'signedin' ] ) { header( 'Location: dashboard' ); exit(); } ?>