How to return an object instead of array in Codeigniter?

Question

I meet a question in Codeignter when I try to get an object return, some of controllers codes are

$sql = $this->user_model->userdetail($data);
    if ($sql) {
        echo json_encode(array(
            "status" => "0",
            "message" => "",
            "data" => $sql
    ));
    exit();
}

And the model codes are

function userdetail($data) {
    $id = $data["id"];
    $sql = "select email, name from user where id='".$id."'";
    $query = $this->db->query($sql);
    if ($query->num_rows() > 0) {
        return $query->result_array();
    }
    return $query->num_rows();
}

I can get the result

{
    "status": "0",
    "message": "",
    "data": [
    {
        "email": "[email protected]",
        "name": "lily"
    }
    ]
}

here the data is an array, but it should be an object, the above result should like this

{
    "status": "0",
    "message": "",
    "data": {
        "email": "[email protected]",
        "name": "lily"
    }
}

And I changed return $query->result_array(); to return $query->result_object(); in model code, but it doesn't work, what should I do here? Thanks a lot.

provide what do you have in result and which version of Codeigniter you use — Saeed.Gh
– Saeed.Gh, Commented Jun 16, 2019 at 4:29
@Saeed.Gh v3, btw, from the documents, resualt()===result_object() — Mark
– Mark, Commented Jun 16, 2019 at 4:33

Mark · Accepted Answer · 2019-06-16 04:55:36Z

0

I think I find the reason, in model

return $query->result_array(); // also can be changed to return $query->result_object(); or return $query->result();

They can return array or object, and in controller file

$sql = $this->user_model->userdetail($data);

$sql should be array or object, but actually it return a Multidimensional Arrays like this

return result() or result_object()

Array
(
    [0] => stdClass Object
        (
            [email] => [email protected]
            [name] => lily
        )

)

return result_array()

Array
(
    [0] => Array
        (
            [email] => [email protected]
            [name] => lily
        )

)

it's strange.

answered Jun 16, 2019 at 4:55

Mark

531 silver badge7 bronze badges

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

Comments

M Ikram Zafar · Accepted Answer · 2019-06-16 07:03:04Z

0

In codeigniter $query->result_array(); is used to return result in array Format.

To get result in object format use $query->result(); like

if ($query->num_rows() > 0) {
        return $query->result();
    }

For single row use $query->result_array()

answered Jun 16, 2019 at 7:03

M Ikram Zafar

1501 gold badge3 silver badges13 bronze badges

Comments

weirdo · Accepted Answer · 2019-06-16 17:52:07Z

0

Maybe you need JSON_FORCE_OBJECT in json_encode.

echo json_encode(array(
        "status" => "0",
        "message" => "",
        "data" => $sql), JSON_FORCE_OBJECT);

answered Jun 16, 2019 at 17:52

weirdo

3341 silver badge10 bronze badges

Comments

Saqib Ali · Accepted Answer · 2022-05-16 13:13:16Z

0

Your problem is you are using result_array(). You have to use row() instead, row() function will give you the object instead of array.

The model code:

function userdetail($data) {
    $id = $data["id"];
    $sql = "select email, name from user where id='".$id."'";
    $query = $this->db->query($sql);
    return $query->num_rows() > 0 ? $query->row() : 0;
}

edited May 16, 2022 at 13:13

answered May 16, 2022 at 11:45

Saqib Ali

264 bronze badges

Collectives™ on Stack Overflow

How to return an object instead of array in Codeigniter?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related