调用Codeigniter[重复]中的未定义方法mysqli_result::result()

Question

我已运行此code以显示数据库表中的所有列。

    public function autorun()
  {
    $mysql_query = "show columns from store_accounts";
    $query = $this->db->simple_query($mysql_query);
    foreach ($query->result() as $row) {
      $column_name = $row->Field;
      echo $column_name; exit;
    }
  }

但它给了我那个错误。

调用未定义的方法mysqli_result::result()

Answer 1

试试看，simple_query只会根据您的查询返回true或false

public function autorun() {
        $mysql_query = "show columns from store_accounts";
        $query = $this->db->query($mysql_query);
        foreach ($query->result() as $row) {
            $column_name = $row->Field;
            echo $column_name.'<p>';
        }
        die;
    }