How do I echo this?

Question

When I echo this:

<?php echo $photo->votesCount ?>

I get

[{"photo_id":1,"votes":2}]

How do I display the votes (2)?

Here's a vardump of the object: http://pastebin.com/ddAkRk4c

If I type:

<?php print_r( $photo->votesCount )?>

I get this: http://pastebin.com/ZfE76WmB

The complete view:

2   @foreach($photos as $photo)                                                        
3   <li class='photo'>
4     <img src="{{URL::to('/')}}/uploads/{{$photo->name}}" width="150">                
5     <div>
6       <a href="{{route('photos.show',$photo->id)}}">{{ $photo->name }}</a>
7       <?php $photo_array = json_decode($photo);
8       echo $photo_array->votes; ?>
9     </div>
10   </li>
11   @endforeach

Part of the Controller logic:

 $photos = Photo::where('period_id', $currentPeriod)
                   ->with('votesCount')
                   ->get();
 return view('home', ['uploaded' => $uploaded, 'photos' => $photos, 'period' => $currentPeriod]);

Model:

  public function votes()
  {
      return $this->hasMany('App\Vote');
  }

  public function votesCount()
  {           
    return $this->votes()
      ->selectRaw('photo_id, count(*) as votes')
      ->groupBy('photo_id');
  }

it would be nice if someone with actual Laravel knowledge could answer - there has to be a Laravel way to access the values, all the answers so far seem like dirty workarounds — cypherabe, Oct 27 '15 at 11:12

score 3 · Accepted Answer · answered Oct 27 '15 at 12:06

3

There is no need for your second method votesCount. You have defined a hasMany relationship for the votes and if you query them you only get the votes for the photo-id.

To get the count of the votes do the following in your view:

$photo->votes->count();

And your controller should look like this:

$photos = Photo::where('period_id', $currentPeriod)
                   ->with('votes')
                   ->get();

answered Oct 27 '15 at 12:06

Tim

5,893
3
35
64

Is there an easy way to sort the photos by vote count ? Maybe in the query? – Alexander Oct 27 '15 at 12:36
Take a look at this answer on how to modify your collection like you described: http://stackoverflow.com/a/24208979/261713 – Tim Oct 27 '15 at 12:42

Imtiaz Pabel · Answer 2 · 2015-10-27T12:06:32.987

0

echo like this

<?php echo $photos->votesCount->votes ?>

edited Oct 27 '15 at 12:06

answered Oct 27 '15 at 10:56

Imtiaz Pabel

5,307
1
19
24

Then I get Undefined property: Illuminate\Database\Eloquent\Collection::$votesCount – Alexander Oct 27 '15 at 10:57

cre8 · Answer 3 · 2015-10-27T11:34:02.570

0

<?php echo $photos->votesCount->votes ?>

but you can also write

{{ echo $photos->votesCount->votes; }}

edited Oct 27 '15 at 11:34

answered Oct 27 '15 at 10:58

cre8

13,012
8
37
61

Then I get Undefined property: Illuminate\Database\Eloquent\Collection::$votesCount – Alexander Oct 27 '15 at 11:00

ArtisanBay · Answer 4 · 2015-10-27T11:13:16.273

0

Try this:

Since it is a JSON array json_decode the array and echo the value

$photo_array = json_decode($photos->votesCount);
echo $photo_array['votes'];

Hope this is helpful.

edited Oct 27 '15 at 11:13

answered Oct 27 '15 at 11:04

ArtisanBay

1,001
11
16

score 0 · Answer 5 · answered Oct 27 '15 at 11:08

0

Your $photos->votesCount returns a string, you have to convert it to an array like so:

$str = $photos->votesCount //gets the string
$arr = json_decode($str, true)[0]; //convert it to an array
echo $arr['votes'];

OR as an object

$str = $photos->votesCount //gets the string
$obj = json_decode($str)[0]; //convert it to an object
echo $obj->votes;

answered Oct 27 '15 at 11:08

NaijaProgrammer

2,892
2
24
33

I get Undefined offset: 0 (for both answers) – Alexander Oct 27 '15 at 11:10
just do away with the `[0]` part. – NaijaProgrammer Oct 27 '15 at 11:10
Then I get for the second : Trying to get property of non-object And for the first one I get : Undefined index: votes – Alexander Oct 27 '15 at 11:14

Silencio · Answer 6 · 2015-10-27T11:22:57.270

0

i succesfully tested like this and had it echo 2:

$str = '[{"photo_id":1,"votes":2}]';
$arr = json_decode($str, true); //convert it to an array
echo $arr[0]["votes"];

so it shoud work for you like this

$str = '$photo->votesCount';
$arr = json_decode($str, true); //convert it to an array
echo $arr[0]["votes"];

if this doesnt work try to change the first line to

$str = (string)$photo->votesCount;

edited Oct 27 '15 at 11:22

answered Oct 27 '15 at 11:19

Silencio

175
8

I get Undefined offset: 0 – Alexander Oct 27 '15 at 11:20
made a minor edit please try it out again and tell me if it worked. – Silencio Oct 27 '15 at 11:24

Legionar · Answer 7 · 2015-10-27T11:56:46.373

0

Since it is a JSON array, json_decode the array and echo the value:

$photo_array = json_decode($photos->votesCount, true);
echo $photo_array[0]['votes'];

Don't forget to add second attribute true in json_decode - refer to manual.

So the whole code:

<?php
  foreach ($photos as $photo) {
    echo "<li class='photo'>";
      echo "<img src='{{URL::to(\'/\')}}/uploads/{{$photo->name}}' width='150'>";
      echo "<div>";
        echo "<a href='{{route(\'photos.show\', $photo->id)}}'>{{ $photo->name }}</a>";
        $photo_array = json_decode($photo, true);
        echo $photo_array[0]['votes'];
      echo "</div>";
    echo "</li>";
  }
?>

edited Oct 27 '15 at 11:56

answered Oct 27 '15 at 11:40

Legionar

7,472
2
41
70

I think, there is one more index with 0. What you get when you insert between that two lines this: `print_r($photo_array);`? – Legionar Oct 27 '15 at 11:45
Array ( [0] => Array ( [photo_id] => 1 [votes] => 2 ) ) – Alexander Oct 27 '15 at 11:47
Undefined offset: 0. Also there's a foreach so I'm changing $photos to $photo in your code (and in every other that answered here :P) – Alexander Oct 27 '15 at 11:49
If `print_r` returned that, then `$photo_array[0]['votes']` will work... you must have error elsewhere. – Legionar Oct 27 '15 at 11:50
If I remove that part of the code then my view loads normally without showing the vote count. You can come on my teamviewer if you don't believe me :) – Alexander Oct 27 '15 at 11:53
You had another error there: `@foreach($photos as photo)` has to be `@foreach($photos as $photo)` !! – Legionar Oct 27 '15 at 11:53
I don't think I typed that anywhere? :( I just copied your whole code block and I got this: Undefined offset: 0 – Alexander Oct 27 '15 at 11:56
I still get Undefined offset: 0 – Alexander Oct 27 '15 at 11:59
Of course you get, because in your question you wrote wrong `$photo` and `$photos`, now I can see that... – Legionar Oct 27 '15 at 12:01
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/93486/discussion-between-legionar-and-lextoc). – Legionar Oct 27 '15 at 12:02

Toan Tran · Answer 8 · 2015-10-27T11:51:55.620

-1

The votesCount is an array. So just echo it like this

<?php echo $photos->votesCount['votes'] ?>

edited Oct 27 '15 at 11:51

answered Oct 27 '15 at 11:00

Toan Tran

54
3

How do I echo this?

8 Answers8