php - Flash Builder/php/mysql 函数

Question

我正在尝试在 Flash Builder 中使用 php 函数...但是，该函数的返回值是意外的...一个空白的 [] (对象)而不是数组。其功能是:

public function getAllAuctions($search) {

        $stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename WHERE name LIKE ?");      
        $this->throwExceptionOnError();

        mysqli_stmt_bind_param($stmt, 'i', $search);        
        $this->throwExceptionOnError();


        mysqli_stmt_execute($stmt);
        $this->throwExceptionOnError();

        $rows = array();

        mysqli_stmt_bind_result($stmt, $row->id, $row->name);

        while (mysqli_stmt_fetch($stmt)) {
          $rows[] = $row;
          $row = new stdClass();
          mysqli_stmt_bind_result($stmt, $row->id, $row->name);
        }

        mysqli_stmt_free_result($stmt);
        mysqli_close($this->connection);

        return $rows;
    }

综上所述...我期待收到一个数组，一个 mysql 搜索查询的结果；而是接收一个空白对象:[]有什么想法吗？

Answer 1

问题出在绑定(bind)参数部分:mysqli_stmt_bind_param($stmt, 'i', $search); ....它应该是:mysqli_stmt_bind_param($stmt, 's', $search);