Beispiel #1
0
    public function getSome($whereClause = '1 = 1')
    {
        $sql = <<<SQL
SELECT id
     , agencyCompanyId
     , companyName
     , companyAddress1
     , companyAddress2
     , companyCity
     , companyState
     , companyZip
     , companyPhone
     , companyUrl
     , created
     , updated
  FROM company
 WHERE {$whereClause}
 ORDER
    BY companyName
SQL;
        $stmt = $this->_dbh->prepare($sql);
        if (!$stmt) {
            throw new ControllerException('Failed to prepare SELECT statement. (' . $this->_dbh->error . ')');
        }
        if (!$stmt->execute()) {
            throw new ControllerException('Failed to execute SELECT statement. (' . $this->_dbh->error . ')');
        }
        if (!$stmt->bind_result($id, $agencyCompanyId, $companyName, $companyAddress1, $companyAddress2, $companyCity, $companyState, $companyZip, $companyPhone, $companyUrl, $created, $updated)) {
            throw new ControllerException('Failed to bind to result: (' . $this->_dbh->error . ')');
        }
        $models = array();
        while ($stmt->fetch()) {
            $model = new CompanyModel();
            $model->setId($id);
            $model->setAgencyCompanyId($agencyCompanyId);
            $model->setCompanyName($companyName);
            $model->setCompanyAddress1($companyAddress1);
            $model->setCompanyAddress2($companyAddress2);
            $model->setCompanyCity($companyCity);
            $model->setCompanyState($companyState);
            $model->setCompanyZip($companyZip);
            $model->setCompanyPhone($companyPhone);
            $model->setCompanyUrl($companyUrl);
            $model->setCreated($created);
            $model->setUpdated($updated);
            $models[] = $model;
        }
        return $models;
    }