sql count function returning object as output in laravel

Question

I'm passing value from laravel model to blade, am getting [object Object] as output. I want number or array.

Model:

public static function count($data){
  $post_id = $data->a;  
  $count_value=DB::select('select count(*) as count FROM pp_like WHERE  post_id= ?', [$post_id]); 
  return (array)$count_value[0];
}

blade-js:

res.success(function(data, status, headers, config) {
  alert(data);
});

I'm not sure what data argument represents. What you get if you replace alert(data); with alert(JSON.stringify(data));? — user6586783
– user6586783, Commented Aug 23, 2016 at 6:28
If you find my help useful, consider upvoting and accepting my answer. — user6586783
– user6586783, Commented Aug 23, 2016 at 6:37

user6586783 · Accepted Answer · 2016-08-23 06:37:03Z

1

Your data argument is parsed JSON object. If you know the exactly name of the property you want to access, you can use data.property where property contains the value you are looking for. However, if you are not sure what data contains, you can replace alert(data); with alert(JSON.stringify(data)); to see the properties of your object.

answered Aug 23, 2016 at 6:37

user6586783

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

Comments

Himanshu Raval · Accepted Answer · 2016-08-23 07:01:18Z

0

change your query to

 $count =  DB::table('pp_like')->where('post_id','=',$post_id)->count();
 return $count;

now you will get number as result.

answered Aug 23, 2016 at 7:01

Himanshu Raval

8119 silver badges21 bronze badges

Collectives™ on Stack Overflow

sql count function returning object as output in laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related