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