public static function getAll()
{
$con = Connection::getConnectionObject()->getConnection();
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$modules = array();
//Make an empty array
$stmt = $con->prepare('SELECT id,code,title,sem_id,credits,gpa FROM module');
$stmt->execute();
$stmt->bind_result($id, $code, $title, $semId, $credits, $gpa);
while ($stmt->fetch()) {
$module = new Module();
$module->id = $id;
$module->setTitle($title);
$module->setCode($code);
$module->setSemId($semId);
$module->setCredits($credits);
$module->setGpa($gpa);
array_push($modules, $module);
//Push one by one
}
$stmt->close();
return $modules;
}
