Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $con = Propel::getConnection(DATABASE_NAME);
- $sql = "SELECT books.* FROM books
- WHERE NOT EXISTS (SELECT id FROM review WHERE book_id = book.id)";
- $stmt = $con->createStatement();
- $rs = $stmt->executeQuery($sql, ResultSet::FETCHMODE_NUM);
- $books = BookPeer::populateObjects($rs);
- $c = new Criteria();
- $c->add(DiscussreplyPeer::ID, $myId);
- $pager = new sfPropelPager();
- $pager->setCriteria($c);
- $pager->setPeerMethod('getReplies');
- public static function getReplies(Criteria $c) {
- $map = $c->getMap();
- $replyId = $map[DiscussreplyPeer::ID]->getValue();
- $con = Propel::getConnection(DATABASE_NAME);
- $sql = "select p.disrepid, p.subject, p.body, c.disrepid as disrepid1, c.subject as subject1, c.body as body1 from discusreply as p, discusreply as c where p.distopid=? and (c.disrepid = p.parentid or c.parentid = p.distopid) order by p.disrepid ASC";
- $stmt = $con->prepareStatement($sql);
- $stmt->setString(1, $replyId);
- $rs = $stmt->executeQuery();
- $results = array();
- while ($rs->next()) {
- // for example
- $results['disrepid'] = $rs->getInt('disrepid');
- }
- return $results;
- }
- $c = new Criteria();
- $c->addJoin(discusreply::DISREPID, discusreply::PARENTID, Criteria::INNER_JOIN);
- $c->clearSelectColumns();
- $c->addSelectColumn(discusreplyPeer::Disrepid);
- ...
- $c->add(discusreplyPeer::DISTOPID, $this->id, Criteria::EQUAL);
- ...
- $c->addAscendingOrderByColumn(discusreply::DISREPID);
- $sql = "SELECT ...";
- $dbh = Propel::getConnection([DB]);
- $sth = $dbh->createStatement();
- $res = $sth->executeQuery($sql, ResultSet::FETCHMODE_NUM);
Add Comment
Please, Sign In to add comment