Cannot use object of type mysqli as array [duplicate]

Question

I'm trying to generate a pdf report but instead, I'm getting this error:

Type: Error

Message: Cannot use object of type mysqli as an array

MODEL

function pdf($post_id)
 {
 $result = $this->db->query("SELECT * FROM tb_data_utama WHERE nipBaru='$post_id'");
        return $result;
 }

CONTROLLER

 function getpdf()
    {
        $this->load->model('model_user');
        $this->load->library('pdf');
        $post_id = $this->uri->segment(3);
        $x['data'] = $this->model_user->pdf($post_id);
        $html = $this->load->view('GeneratePdfView', $x, [], true);
        $this->pdf->createPDF($html, 'mypdf', false);
    }

daremachine · Accepted Answer · 2020-01-23 00:59:10Z

0

You need add ->result_array() to run your query !!!
From Docs

The above result() function returns an array of objects. Example: $row->title

$x['data'] = $this->model_user->pdf($post_id)->result_array(); <--- here

answered Jan 23, 2020 at 0:59

daremachine

2,7982 gold badges27 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohit Rathod · Accepted Answer · 2020-01-23 12:52:49Z

0

You can pass simply return array by following

function pdf($post_id)
{
    $result = $this->db->query("SELECT * FROM tb_data_utama WHERE nipBaru='$post_id'");
    return $result->result_array();;
}

answered Jan 23, 2020 at 12:52

Mohit Rathod

1,2131 gold badge22 silver badges36 bronze badges

Comments

Alok Mali · Accepted Answer · 2020-01-23 09:02:11Z

-1

By this $this->db->query() you are only executing the query. Not getting the result. Use one of the various methods to get the result - result() , row_array() , result_array() etc.

In your Model -

function pdf($post_id)
 {
  $result = $this->db->query("SELECT * FROM tb_data_utama WHERE nipBaru='$post_id'");
  return $result->row_array();
 }

In your View use values like that -

echo $data['nipBaru'];

answered Jan 23, 2020 at 9:02

Alok Mali

2,8913 gold badges20 silver badges33 bronze badges

2 Comments

Mohit Rathod Over a year ago

This is a bad practice when you're going to get more than one row in result, it'll give you one record only

Alok Mali Over a year ago

@MacRathod, I used it because the query will return data for only single post respective to the passed post_id

Collectives™ on Stack Overflow

Cannot use object of type mysqli as array [duplicate]

3 Answers 3

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Linked

Related