PHP Nette\Database Context::fetch示例

fetch() public method

Shortcut for query()->fetch()

public fetch ( $sql, $params ) : Nette\Database\Row
return	Nette\Database\Row

示例#1

文件： Uzivatele.php 项目： stanley89/piratskelisty

 public function get($identity)
 {
     if (\is_numeric($identity)) {
         return $this->database->fetch("SELECT * FROM " . self::TABLE_NAME . " WHERE " . self::COLUMN_ID . "=?;", $identity);
     } else {
         return $this->database->fetch("SELECT * FROM " . self::TABLE_NAME . " WHERE " . self::COLUMN_IDENTITY . "=?;", $identity);
     }
 }

示例#2

文件： Rss.php 项目： stanley89/piratskelisty

 public function getItemByLinkChannel($link, $channel_id)
 {
     return $this->database->fetch("select *" . " from rss_items" . " where link=?" . " and rss_channel_id=?;", $link, $channel_id);
 }

示例#3

文件： Upload.php 项目： stanley89/piratskelisty

 public function get($id)
 {
     return $this->database->fetch("SELECT * FROM upload WHERE id = ?;", $id);
 }

示例#4

文件： Clanky.php 项目： stanley89/piratskelisty

 public function getHodnoceniByIp($id, $ip)
 {
     return $this->database->fetch("SELECT * FROM hodnoceni WHERE clanek_id=? and ip=?;", $id, $ip);
 }

示例#5

文件： Kategorie.php 项目： stanley89/piratskelisty

 public function getByUrl($url)
 {
     return $this->database->fetch("SELECT * FROM kategorie WHERE url=?;", $url);
 }