PHP Nstaeger\CmsPluginFramework\Broker DatabaseBroker::fetchAll示例

示例#1

文件： SubscriberModel.php 项目： nstaeger/wp-post-email-notification

 public function getEmails($offset, $count)
 {
     ArgCheck::isInt($offset);
     ArgCheck::isInt($count);
     $query = sprintf("SELECT email FROM %s ORDER BY id LIMIT %d, %d", self::TABLE_NAME, $offset, $count);
     return $this->database->fetchAll($query);
 }

示例#2

文件： JobModel.php 项目： nstaeger/wp-post-email-notification

 public function getNextJob()
 {
     $query = sprintf("SELECT * FROM %s WHERE next_round_gmt <= '%s' ORDER BY id LIMIT 1", self::TABLE_NAME, Time::now()->asSqlTimestamp());
     return $this->database->fetchAll($query);
 }