public function getSome($whereClause = '1 = 1') { $sql = <<<SQL SELECT id , primaryContactId , companyId , applicationStatusId , lastStatusChange , urgency , created , updated , nextActionDue , nextAction , positionTitle , location , url FROM job WHERE {$whereClause} ORDER BY nextActionDue DESC SQL; $stmt = $this->_dbh->prepare($sql); if (!$stmt) { throw new ControllerException('Failed to prepare SELECT statement. (' . $this->_dbh->error . ') ' . $sql); } if (!$stmt->execute()) { throw new ControllerException('Failed to execute SELECT statement. (' . $this->_dbh->error . ')'); } $stmt->bind_result($id, $primaryContactId, $companyId, $applicationStatusId, $lastStatusChange, $urgency, $created, $updated, $nextActionDue, $nextAction, $positionTitle, $location, $url); $models = array(); while ($stmt->fetch()) { $model = new JobModel(); $model->setId($id); $model->setPrimaryContactId($primaryContactId); $model->setCompanyId($companyId); $model->setApplicationStatusId($applicationStatusId); $model->setLastStatusChange($lastStatusChange); $model->setUrgency($urgency); $model->setCreated($created); $model->setUpdated($updated); $model->setNextActionDue($nextActionDue); $model->setNextAction($nextAction); $model->setPositionTitle($positionTitle); $model->setLocation($location); $model->setUrl($url); $models[] = $model; } return $models; }