Esempi in PHP per ActiveCollab\DatabaseConnection\Connection MysqliConnection::selectFirstCell

Esempio n. 1

File: SelectTest.php Progetto: activecollab/databaseconnection

 public function testSelectFirstCell()
 {
     $this->assertEquals(1, $this->connection->selectFirstCell('writers', 'id', ['`name` = ?', 'Leo Tolstoy']));
     $this->assertEquals(2, $this->connection->selectFirstCell('writers', 'id', ['`name` = ?', 'Alexander Pushkin']));
     $this->assertEquals(3, $this->connection->selectFirstCell('writers', 'id', ['`name` = ?', 'Fyodor Dostoyevsky']));
     $this->assertEquals('Leo Tolstoy', $this->connection->selectFirstCell('writers', 'name', ['`id` = ?', 1]));
     $this->assertEquals('Alexander Pushkin', $this->connection->selectFirstCell('writers', 'name', ['`id` = ?', 2]));
     $this->assertEquals('Fyodor Dostoyevsky', $this->connection->selectFirstCell('writers', 'name', ['`id` = ?', 3]));
 }