public function test_queryFrist() { $sql = 'insert into tb_unittest(c1) values (100)'; $ret = DBMysqlNamespace::execute($this->handle, $sql); $ret = DBMysqlNamespace::execute($this->handle, $sql); $this->assertEquals($ret, TRUE); $sql = 'select id,c1 from tb_unittest'; $ret = DBMysqlNamespace::queryFirst($this->handle, $sql); $this->assertEquals($ret, array("id" => 1, "c1" => 100)); }
/** * 将查询的第一条结果返回 * @param[in] handle $handle, 操作数据库的句柄 * @param[in] string $sql, 具体执行的sql语句 * @return FALSE表示执行失败, 否则返回执行的结果, 结果格式为一个数组,数组中每个元素都是mysqli_fetch_assoc的一条结果 */ public function queryFirst($sql) { assert($this->_handle); return DBMysqlNamespace::queryFirst($this->_handle, $sql); }