/** * @param string $whereClause * @see ControllerBase::getSome() */ public function getSome($whereClause = '1 = 1') { $sql = <<<SQL SELECT id , appliesToTable , appliesToId , created , updated , noteText FROM note WHERE {$whereClause} ORDER BY updated SQL; $stmt = $this->_dbh->prepare($sql); if (!$stmt) { throw new ControllerException('Failed to prepare SELECT statement. (' . $this->_dbh->error . ') from this SQL: ' . $sql); } if (!$stmt->execute()) { throw new ControllerException('Failed to execute SELECT statement. (' . $this->_dbh->error . ')'); } $stmt->bind_result($id, $appliesToTable, $appliesToId, $created, $updated, $noteText); $models = array(); while ($stmt->fetch()) { $model = new NoteModel(); $model->setId($id); $model->setAppliesToTable($appliesToTable); $model->setAppliesToId($appliesToId); $model->setCreated($created); $model->setUpdated($updated); $model->setNoteText($noteText); $models[] = $model; } return $models; }