Anonymous

class EmailModel extends CreoleModel
{

#first i called creole

#       function getByDomainEtAPID($FQDN, $APID)
#       {
#           $Query  = "SELECT jmeno,domena,enabled,APID ";
#           $Query .= "FROM redir.email ";
#           $Query .= "WHERE APID = ? ";
#           $Query .= "AND domena = ? ";
#           $Query .= "ORDER BY domena, jmeno asc";
#
#           $stmt = $this->conn->prepareStatement($Query);
#           $stmt->setInt(1, $APID);
#           $stmt->setString(2, $FQDN);
#
#           return ($this->getData($stmt));
#       }

#than i switched to propel

        function getByDomainEtAPID($FQDN, $APID)
        {
            $c = new Criteria();
            $c->add(EmailPeer::DOMENA, $FQDN);
            $c->add(EmailPeer::APID, $APID);
            $results = EmailPeer::doSelect($c);
            foreach($results as $email) {
                $row['jmeno']   = $email->getJmeno();
                $row['domena']  = $email->getDomena();
                $row['enabled'] = $email->getEnabled();
                $row['APID']    = $email->getAPID();
                $data[]=$row;
            }
            return($data);
        }
}