function findByUsername($username, $dbh)
{
$stmt = $dbh->prepare("select * from " . User::$tableName . " where username = :username;");
$stmt->bindParam(':username', $username);
$stmt->execute();
$row = $stmt->fetch();
$user = new User();
$user->copyFromRow($row);
return $user;
}
function findAll($dbh)
{
$stmt = $dbh->prepare("select * from " . User::$tableName . " order by id");
$stmt->execute();
$result = array();
while ($row = $stmt->fetch()) {
$user = new User();
$user->copyFromRow($row);
$result[] = $user;
}
return $result;
}
<?php
require_once "models/DB.php";
require_once "models/User.php";
// attempt to signup
// case 1: the signup fields are valid
// outcome: save the validated user object to the db, start a session and push
// the user into session, and render the home.php view
// case 2: the signup fields are not valid
// outcome: create a $signup_user with the full_name and username set and
// appropriate error messages, also an empty $login_user object,
// and render the loginform.php view
// find their session or create a new one
session_start();
// copy the form fields in to a new User object
$signup_user = new User();
$signup_user->copyFromRow($_POST);
// validate the object, if success, save and render home view
if ($signup_user->validateWithPassword($_POST['password'], $_POST['password2'], $dbh)) {
$signup_user->saveWithPassword($dbh, $_POST['password']);
$user = $signup_user;
$_SESSION["userId"] = $user->id;
include_once "views/home.php";
} else {
$login_user = new User();
include_once "views/loginform.php";
}
function getUsers($dbh, $field, $upDown)
{
$stmt = $dbh->prepare("select * from " . User::$table_name . " order by " . $field . " " . $upDown . ";");
$stmt->execute();
$result = array();
while ($row = $stmt->fetch()) {
$p = new User();
$p->copyFromRow($row);
$result[] = $p;
}
return $result;
}
