connect_error) {
die ("Connection Failed");
}
$sql = "INSERT INTO brentsweldingadmin.activitylog (username,status,ipaddress) VALUES('".$UserName."','".$Status."','".$IP."');";
if ($conDataBase->query($sql) === TRUE) {
$conDataBase->close();
return;
}
else {
$conDataBase->close();
die("fatal error");
}
}
function Login($UserName, $Password)
{
$ServerName = "localhost";
$ServerUserName = "root";
$ServerPassword = "root";
$dbname = "brentsweldingadmin";
//Create Connection
$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword);
if ($conDataBase->connect_error) {
die ("Connection failed");
}
$user = mysqli_escape_string($conDataBase, $UserName);
$pass = mysqli_escape_string($conDataBase, $Password);
$sql = "select * from brentsweldingadmin.users where username='".$user."' and password='".$pass."';";
$result = mysqli_query($conDataBase, $sql);
$row = mysqli_fetch_array($result, MYSQL_ASSOC);
$count = mysqli_num_rows($result);
if ($count == 1) {
$conDataBase->close();
$_SESSION["adminusername"] = $UserName;
session_write_close();
ActivityLog($UserName);
echo ("");
}
else {
$conDataBase->close();
echo ("Wrong UserName or Password
");
}
}
?>