Esempi in PHP per Portfolio::query

Esempio n. 1

File: Profile.php Progetto: himmelex/NTW

 function getPortfolioList($offset = 0, $limit = null)
 {
     $qry = 'SELECT portfolio.* ' . 'FROM portfolio ' . 'WHERE owner = %d ' . 'ORDER BY created DESC ';
     if ($offset > 0 && !is_null($limit)) {
         if ($offset) {
             if (common_config('db', 'type') == 'pgsql') {
                 $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
             } else {
                 $qry .= ' LIMIT ' . $offset . ', ' . $limit;
             }
         }
     }
     $portfolio = new Portfolio();
     $cnt = $portfolio->query(sprintf($qry, $this->id));
     return $portfolio;
 }