rendered paste body<?php
/**
* Universities
*
* Class for processing multiple university objects
*
* @author Ben Newbery
* @copyright 2006 Sell Student Universities Ltd
* @version 1.0
* @package ssb
* @access public
*/
class Universities {
/**
* Universities::getAllUniversities
*
* Get all the universities from the database
*
* @static
*/
public static function getAllUniversities() {
$universities = array();
$query = "SELECT * FROM universities";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
$university = new University();
$university->assignData($row["universityName"], $row["universityStatus"], $row["universityID"]);
$universities[] = clone $university;
}
return $universities;
}
/**
* Universities::showFormOotions
*
* Grabs all the universities from the database and outputs form options
*
*/
public static function showFormOptions() {
$universities = self::getAllUniversities();
foreach ($universities AS $university) {
?>
<option value="<?=$university["id"]?>"><?=$university["name"]?></option>
<?
}
}
} // Universities
?>