<?php
include("sql_information.php");
class database{
public function logincheck(){
$db = new MySQLDatabase();
$user_name = $_POST['user_name'];
$password = $_POST['password'];
$sql = "SELECT * FROM user_accounts WHERE name = '$user_name' AND password = '$password'";
$queryresult = $db->query($sql);
$this->userinfo($queryresult);
}
function userinfo($queryresult){
if ($result = $db->fetchArray($queryresult)) {
//var_dump($result);
$answer = $result['id'];
if ($answer == 1){
echo "Welcome {$result['name']} the administrator !";
} elseif ($answer != 1) {
echo "Welcome {$result['name']} the user !";
}
} else {
echo "Wrong User Name &/or Password entered, please go back & retry.";
}
}
}
$dbc = new database();
$dbc -> logincheck();