/** * @covers de\detert\sebastian\slimline\db\Handler::fetch */ public function testShouldFetchOneRow() { $sql = 'CREATE TABLE IF NOT EXISTS `foo` (`id` INT(20))'; $this->handler->query($sql); $sql = 'INSERT INTO `foo` VALUES (?), (?)'; $params = array(1, 2); $this->handler->query($sql, $params); $expected = array('id' => 1); $this->assertEquals($expected, $this->handler->fetch("SELECT * from `foo` ORDER BY `id` ASC")); }
/** * @param string $sessionId * * @return string */ public function read($sessionId) { $sql = "SELECT `value` FROM `" . $this->table . "` WHERE `id` = ?"; $result = $this->db->fetch($sql, array($sessionId)); return $result['value'] ?: ''; }