Syntax error when using simple query to database table

Question

I have a very simple setup in Laravel while I'm learning it and I can't figure why I'm getting an error. It's probably something simple I am overlooking.

I can get this:

Route::get('users', function() {
    $users = User::all();
    return View::make('users')->with('users', $users);
});

example on Laravel to work perfectly, displaying this information in a users.blade.php view.

In my database I also have a 'lists' table but when I copy the structure of the code above to try and display my lists I receive the following error.

syntax error, unexpected '::' (T_PAAMAYIM_NEKUDOTAYIM), expecting '('

on line

 $lists = list::all();

My code is as follows routes.php

Route::get('lists', function() {
    $lists = list::all();
    return View::make('lists')->with('lists', $lists);
});

list.php /models

<?php
class List extends Eloquent {}

lists.blade.php /views

@extends('layouts.main')
@section('content')
@foreach($lists as $list)
    <p>{{ $list->name }}</p>
@endforeach
@stop

Any help would be much appreciated. Thanks.

First glance, it looks like List must be capitalized, since that's the name of your object. That is, try $lists = List::all(); — Chris Forrence
– Chris Forrence, Commented Apr 22, 2014 at 17:01
@ChrisForrence Capitalising List::all(); still produces the error. Thanks however — mbklnd
– mbklnd, Commented Apr 22, 2014 at 17:05

Chris Forrence · Accepted Answer · 2014-04-22 17:13:40Z

2

List is a reserved keyword in PHP, so you may not use it as a class name. From the documentation:

These words have special meaning in PHP. Some of them represent things which look like functions, some look like constants, and so on - but they're not, really: they are language constructs. You cannot use any of the following words as constants, class names, function or method names.

Unfortunately, you're going to need to have a different class name, then set your object's table name to 'lists' like such:

class AppList extends Eloquent { protected $table = 'lists'; }

answered Apr 22, 2014 at 17:13

Chris Forrence

10.1k11 gold badges50 silver badges66 bronze badges

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

2 Comments

James Over a year ago

A decent editor usually shows this issue, based on syntax highlighting.

mbklnd Over a year ago

Thanks @ChrisForrence - I'd never have guessed this!

Collectives™ on Stack Overflow

Syntax error when using simple query to database table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related