CREATE TABLE `test_loq` ( id int(11) PRIMARY KEY AUTO_INCREMENT, page varchar(255) NOT NULL, username varchar(255) NOT NULL, log_time datetime DEFAULT CURRENT_TIMESTAMP, log_action longtext NOT NULL, log_name varchar(255) NOT NULL, user_id int(11) NOT NULL, ip int(11) NOT NULL )class log { CONST ENVIRONMENT = 'developemnt'; private $id; protected $log_action; protected $username; protected $page; protected $ip; protected $log_name; private $user_id; public function __construct(string $log_action, string $username, string $log_name) { if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip = $_SERVER['HTTP_CLIENT_IP']; } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip = $_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip = $_SERVER['REMOTE_ADDR']; } if(!empty($_SESSION['id'])){ $id = $_SESSION['id']; } else { $id = 0; } $this->log_action = $log_action; $this->username = $username; $this->log_name = $log_name; $this->user_id = $id; $this->page = basename($_SERVER['PHP_SELF']); $this->ip = $ip; } public function createAction() { global $conn; if(!$conn) { echo mysqli_error($conn); die; } $sql = "INSERT INTO test_log (`log_action`,`username`,`log_name`,`page`,`user_id`,`ip`) values ('".$this->log_action."','".$this->username."','".$this->log_name."','".$this->page."','".$this->user_id."','".$this->ip."')" ; $sql_query = mysqli_query($conn,$sql); if(!$sql_query){ echo mysqli_error($conn); die; } if(ENVIRONMENT == 'development'){ $_SESSION['msg'] = 'A new log was created ' . $this->log_name; } } }<?php session_start(); include("include/configurationadmin.php"); //include_once('../include/classes/config.inc.php'); $username = $_REQUEST['username']; $password = $_REQUEST['password']; $sql = mysqli_query($conn,"select * from ".$sufix."admin where username='".$username."'") ; // HERE HOW TO LOG ACTION $log = new log("Logging in attempt from $username" , $username ,'Login Attempt' ); $log->createAction(); //SIMPLE AND COOL RIGHT? if(mysqli_num_rows($sql) > 0) { $rows = mysqli_fetch_assoc($sql); if(md5($password) == $rows['password']) { $_SESSION['id'] = $rows['id']; $_SESSION['username'] = $rows['username']; $_SESSION['usertype'] = $rows['type']; mysqli_query($conn,"update ".$sufix."admin set lastlogin='".date('Y-m-d')."' where id = '".$rows['id']."' and username='".$rows['username']."'") ; $domain = ($_SERVER['HTTP_HOST'] != 'localhost') ? $_SERVER['HTTP_HOST'] : false; setcookie('rrdssrdda', $rows['id'], time()+120, '/', $domain, false); header("Location: http://localhost/test/admin-new/dashboard"); exit(); } else { $_SESSION['message']="<div class='alert alert-danger' role='alert'>Invalid userid/password!</div>"; header("Location: http://localhost/test/admin-new/"); exit(); } } else { $_SESSION['message']="<div class='alert alert-danger' role='alert'>Invalid userid/password!</div>"; header("Location: http://localhost/test/admin-new/"); exit(); } ?>