Call to undefined method CI_DB_mysqli_result::fetch_assoc() in CodeIgniter [duplicate]

Question

I have following function

function getQuery($sql,$returnType = ''){
    $data = array();
    $result = $this->db->query($sql);
    if($result){
        switch($returnType){
            case 'count':
                $data = $result->num_rows;
                break;
            case 'single':
                $data = $result->fetch_assoc();  //Line 55
                break;
            default:
                if($result->num_rows > 0){
                    while($row = $result->fetch_assoc()){
                        $data[] = $row;
                    }
                }
        }
    }
    if(!empty($data)) {
        return $data;
    }
    return false;
}

When this method is executed following error is returned

Type: Error

Message: Call to undefined method CI_DB_mysqli_result::fetch_assoc()

Line Number: 55

I can't understand why the error is being shown. Please help!!!

Parth Chavda · Accepted Answer · 2017-07-05 09:02:06Z

1

fetch_assoc() is not a method of Codeignetor query builder it's actaullay method of mysqli but you are use "Codeignetor query builder"

for single row use like

$query = $this->db->query("YOUR QUERY");

$row = $query->row();

if (isset($row))
{
        echo $row->title;
        echo $row->name;
        echo $row->body;
}

for multiple row :

$query = $this->db->query("YOUR QUERY");

foreach ($query->result_array() as $row)
{
        echo $row['title'];
        echo $row['name'];
        echo $row['body'];
}

You have to use Below Code

function getQuery($sql,$returnType = ''){
    $data = array();
    $result = $this->db->query($sql);
    if($result){
        switch($returnType){
            case 'count':
                $data = $result->num_rows();
                break;
            case 'single':
                $data = $result->row_array(); // return result as array
                 or
                $data = $result->row(); //  return result as object
                break;
            default:
                $data = $result->result_array(); // result in array
                or
                $data =  $result->result(); // return a objects
        }
    }
    if(!empty($data)) {
        return $data;
    }
    return false;
}

edited Jul 5, 2017 at 9:02

answered Jul 5, 2017 at 8:56

Parth Chavda

1,8291 gold badge24 silver badges31 bronze badges

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

11 Comments

pokemon Over a year ago

Now I am getting Invalid argument supplied for foreach() error

pokemon Over a year ago

I am trying to use it as foreach($info['options'] as $opt)

Parth Chavda Over a year ago

hello Amaan plz refer the codeigniter.com/user_guide/database/results.html you got some basic idea how it's work

pokemon Over a year ago

I have the basic idea but I just want to ask how can I use this line with a 2D array

pokemon Over a year ago

Here I just want to extract the column_value corresponding to the row value 'options'

|

NikuNj Rathod · Accepted Answer · 2017-07-05 08:52:57Z

0

You can try this solution for your problem :

function getQuery($sql,$returnType = ''){
    $data = array();
    $result = $this->db->query($sql);
    if($result){
        switch($returnType){
            case 'count':
                $data = $result->num_rows;
                break;
            case 'single':
                $data = $result->row();  // CodeIgniter return single row 
                break;
            default:
                if($result->num_rows > 0){
                    $data = $result->result(); // CodeIgniter return result object and you can set result_array() get array list
                }
        }
    }
    if(!empty($data)) {
        return $data;
    }
    return false;
}

answered Jul 5, 2017 at 8:52

NikuNj Rathod

1,6381 gold badge19 silver badges29 bronze badges

4 Comments

pokemon Over a year ago

Now its displaying : Cannot use object of type stdClass as array

pokemon Over a year ago

How can I access a field inside $data

Parth Chavda Over a year ago

Nikunj code return a object so you can access for single row $data->first_name it's just exmaple

NikuNj Rathod Over a year ago

yes you can access single row after $data->first_name.

Collectives™ on Stack Overflow

Call to undefined method CI_DB_mysqli_result::fetch_assoc() in CodeIgniter [duplicate]

2 Answers 2

11 Comments

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

4 Comments

Linked

Related