Laravel 4 pulling data from database

Question

I have table called 'players'. I want to pull every player from the database, or simply select players that have in column 'online' = 1. I want to display their name (column 'name') in 'players' table.

Here's what I've tried:

    public function online()
{
  $results = Player::with('online')->find(1)
  return View::make('aac.test')->with('results', $results);
}

also tried:

    public function online()
{
  $results = DB::select('select * from players where level = 1');
  return View::make('aac.test')->with('results', $results);
}

None of them works.

Antonio Carlos Ribeiro · Accepted Answer · 2013-07-25 15:03:22Z

3

Try this:

public function online()
{
  $results = Player::where('online', 1)->get('name');
  return View::make('aac.test')->with('results', $results);
}

To display it using blade:

<ul>
    @foreach($results as $result)
        <li>
            {{$result->name}}
        </li>
    @endforeach
</ul>

edited Jul 25, 2013 at 15:03

answered Jul 25, 2013 at 14:36

Antonio Carlos Ribeiro

87.9k22 gold badges220 silver badges205 bronze badges

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

13 Comments

dynamitem Over a year ago

It works now, so I need to include the get method or w/e it is for working pulling data? Also how could I only display their name? Should I do something like this? <?php foreach($results->players as $player):?> <?php echo $player->name ?> <?php endforeach;?>

Antonio Carlos Ribeiro Over a year ago

You already have your list of players in that collection. Just edited to show you how.

Antonio Carlos Ribeiro Over a year ago

stackoverflow.com/users/1508618/alexander-cogneau proposed to use pluck('name') to retrieve just the name column from your table, but I think that pluck() just return the first record, but you can also do it using get('name') or get(array('id','name)). Edited.

dynamitem Over a year ago

hi, sorry for disturbing, I would like to ask you a question. How could I say when there's no players online (no id's of 1 in column 'online) There is no players online. ?

Antonio Carlos Ribeiro Over a year ago

if empty($results) then you have no records of online users.

|

iori · Accepted Answer · 2014-11-22 04:54:00Z

0

public function online()
{
  $results = Player::where('level','=','1')->get();
  return View::make('aac.test')->with('results', $results);
}

To display it using blade:

<ul>
    @foreach($results as $result)
        <li>
            {{$result->name}}
        </li>
    @endforeach
</ul>

answered Nov 22, 2014 at 4:54

iori

3,54615 gold badges50 silver badges79 bronze badges

Collectives™ on Stack Overflow

Laravel 4 pulling data from database

2 Answers 2

13 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

13 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related