PHP Bluz\Db Db::fetchOneの例

fetchOne() public method

Example of usage $db->fetchOne("SELECT COUNT(*) FROM users");

public fetchOne ( string $sql, array $params = [] ) : string
$sql	string	SQL query with placeholders "SELECT * FROM users WHERE name = :name AND pass = :pass"
$params	array	params for query placeholders (optional) array (':name' => 'John', ':pass' => '123456')
return	string

コード例 #1

ファイル: DbTest.php プロジェクト: dezvell/mm.local

 /**
  * fetchOne
  */
 public function testFetchOne()
 {
     $result = $this->db->fetchOne("SELECT COUNT(*) FROM test");
     $this->assertEquals(42, $result);
 }