/** * Gets the computers of the asked lab */ public static function GetComputersByLab($lab_id) { $sql = "select * from Computers where LabID = " . $lab_id . " order by X1, Y1;"; $results = DBConnection::ExecuteSelectQuery($sql); $computers = self::GetArrayFromDBTable($results); return $computers; }
public static function Load($user_name, $password) { $user_name = addslashes(stripslashes($user_name)); $password = md5($password); $sql = "select *\n\t\t\t\t\tfrom Users\n\t\t\t\t\twhere\n\t\t\t\t\t\t(UserName = '******') and\n\t\t\t\t\t\t(Password = '******');"; $results = DBConnection::ExecuteSelectQuery($sql); if (count($results) == 0) { return null; } $row = $results[0]; if ($row["DateActivated"] == null) { $date_activated = null; } else { $date_activated = new DateTime($row["DateActivated"]); } $user = new User((int) $row["ID"], $row["UserName"], $row["CsUser"], (int) $row["Warnnings"], $row["ActivationKey"], $date_activated, new DateTime($row["DateAdded"])); return $user; }
public static function GetLabsOccupancy() { $sql = "select\n\t\t\t\t\tLabs.ID as LabID,\n\t\t\t\t\tLabs.Capacity,\n\t\t\t\t\t(\n\t\t\t\t\t\tselect count(Computers.LabID)\n\t\t\t\t\t\tfrom Computers\n\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t(Computers.LabID = Labs.ID) and\n\t\t\t\t\t\t\t((Computers.StatusID = 2) or (Computers.StatusID = 3))\n\t\t\t\t\t) as TotalUsed\n\t\t\t\tfrom Labs;"; $results = DBConnection::ExecuteSelectQuery($sql); return $results; }
<?php ini_set("display_errors", 1); require_once "classes/db_connection.php"; $sql = "select * from Computers;"; $results = null; try { DBConnection::Connect(); $results = DBConnection::ExecuteSelectQuery($sql); } catch (Exception $ex) { } if ($results != null) { foreach ($results as $row) { echo $row["ID"] . $row["ComputerName"] . "<br />"; } } DBConnection::Close(); ?> done.