Need a INT from Eloquent. Getting JSON string

Question

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.

If the response is json, then start by json_decoding it

Mark Baker
– Mark Baker

2014-05-13 12:45:30 +00:00
Commented May 13, 2014 at 12:45 — Mark Baker
– Mark Baker, Commented May 13, 2014 at 12:45

Jarek Tkaczyk · Accepted Answer · 2014-05-13 13:35:08Z

2

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.

answered May 13, 2014 at 13:35

Jarek Tkaczyk

81.4k27 gold badges167 silver badges162 bronze badges

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

Comments

Chris G · Accepted Answer · 2014-05-13 12:53:52Z

2

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.

answered May 13, 2014 at 12:53

Chris G

7,0502 gold badges21 silver badges20 bronze badges

4 Comments

Joel Hinz Over a year ago

Beat me to it. :) This is the correct answer, have an upvote.

Chilion Over a year ago

Chris, its not to show in a view, I now display it in a view just to show what it returns. I eventually could do: return $data->id;

Chris G Over a year ago

@Chilion could you edit your question to post more of your code? I'm not really sure what the problem is. I'd be happy to update my answer.

Chilion Over a year ago

Hi Chris, thanks for your answer. I was looking for really getting an INT in return, so the answer of Deczo is exactly what I was needing. Guess my questionskills could use a little update! :)

Collectives™ on Stack Overflow

Need a INT from Eloquent. Getting JSON string

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related