예제 #1
0
 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));
 }
예제 #2
0
 /**
  * 将查询的第一条结果返回
  * @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);
 }