CODEWITHSUNDEEP
phplaraveleloquent
Chilion
Chilion

Reputation: 4490

Need a INT from Eloquent. Getting JSON string

I have this query:

 static function findIdOnName($pageName){
    return Fanpages::select('id')
                ->where('url', '=', $pageName)
            ->get();
}

Response: (when done print_r)

[{"id":17}]

I just want the INT (in this case 17) I searched the interwebs for it, but I can't find anthing about it. Randomly tried adding ->toString() etc to the query, but so far, no good.

Upvotes: 0

Views: 520

Answers (2)

Jarek Tkaczyk
Jarek Tkaczyk

Reputation: 81147

Your code returns a Collection with a single Model (or multiple models if there are more matching the where clause), while the method you need is pluck:

return Fanpages::where('url', '=', $pageName)->pluck('id');
// returns INT 17

as it returns value for column id of the first row matching WHERE clause.

Upvotes: 2

Chris G
Chris G

Reputation: 7050

If you do not return a view with data, then Laravel will automatically convert your data into json. In order to accomplish what you want you can simply do something like

$data = Fanpages::select('id')->where('url', '=', $pageName)->get();
die($data->id);

However, exiting the application like this isn't recommended. You should either keep the json response and work with that, or send the data to a basic blade template.

Upvotes: 2

Related Questions