/**
* Add user to the database.
*
* @param \model\User $user The user to be added to the database
*/
public function add(User $user)
{
$sqli = $this->database->connect();
$stmt = $sqli->prepare("INSERT INTO `users`(`username`, `password`) VALUES (?, ?)");
if ($stmt === FALSE) {
throw new Exception($sqli->error);
}
$username = $user->getUsername();
$password = $user->getPassword();
$stmt->bind_param('ss', $username, $password);
$stmt->execute();
}
/**
* Update user information
* @param String $username The user that will be updated.
* @param String $info String in JSON-format to be stored in the database.
*/
public function updateUser($username, $info)
{
$sqli = $this->database->connect();
$stmt = $sqli->prepare("UPDATE " . $this->table . " SET " . $this->profileinfoCol . "='" . $info . "' WHERE " . $this->usernameCol . "='" . $username . "'");
if ($stmt === FALSE) {
throw new Exception($sqli->error);
}
$stmt->execute();
}
<?php //require_once($_SERVER['DOCUMENT_ROOT'] . "/kenneth/cs2102_admin/model/admin.php"); //require_once($_SERVER['DOCUMENT_ROOT'] . "/kenneth/cs2102_admin/model/database.php"); //require_once($_SERVER['DOCUMENT_ROOT'] . "/kenneth/cs2102_admin/model/job_applicant.php"); //require_once($_SERVER['DOCUMENT_ROOT'] . "/kenneth/cs2102_admin/controller/admin/authentication/index.php"); require_once $_SERVER['DOCUMENT_ROOT'] . "/cs2102/model/admin.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/cs2102/model/database.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/cs2102/model/job_applicant.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/cs2102/controller/admin/authentication/index.php"; use model\Admin; use model\Database; use model\JobApplicant; session_start(); AuthenticationController::authenticate(); $database = new Database(); $connection = $database->get_connection(); $job_applicants = JobApplicant::get_all_job_applicant($connection); ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Management System</title> <!-- stylesheets --> <link href="../../../stylesheet/reset.css" rel="stylesheet" type="text/css"> <link href="../../../stylesheet/icon.css" rel="stylesheet" type="text/css"> <link href="../../../stylesheet/default.css" rel="stylesheet" type="text/css"> <link href="../../../stylesheet/content.css" rel="stylesheet" type="text/css">
use model\Location;
use model\Nationality;
use model\Industry;
use model\Position;
use model\Employer;
AuthenticationController::authenticate();
?>
<html>
<head>
</head>
<body>
<?php
$database = new Database();
$connection = $database->get_connection();
$admin = Admin::get_admin("*****@*****.**", "dogssocute", $connection);
if (is_null($admin)) {
echo "invalid email or password";
} else {
echo $admin->get_email();
echo "<br />";
echo $admin->get_password();
echo "<br />";
}
$locations = Location::get_all_location($connection);
for ($i = 0; $i < sizeof($locations); $i++) {
echo $locations[$i]->get_name();
echo "<br />";
}
