Specify DB table in laravel query

Question

Im new to laravel, i am trying to query a specific table in my DB. I only have 1 data table and the standard user auth tables. I am getting a error: BadMethodCallException Call to undefined method App\Figures::table().

Model

namespace App;

use Illuminate\Database\Eloquent\Model;

class Figures extends Model
{
   
}

controller

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Figures;

class figuresController extends Controller
    public function figurespag2() {
        $dummyDetails = Figures::table('figures')->where('name', 'batman');
        return view ( 'pagination2.index' )->withUsers($dummyDetails);
       }

route

Route::get ( '/pagination2', 'figuresController@figurespag2' );

I know it's going to be something obvious, but I am new to this.

Kamlesh Paul · Accepted Answer · 2020-08-28 10:33:26Z

1

this is wrong

$dummyDetails = Figures::table('figures')->where('name', 'batman');

Method 1---------- laravel eloquent

Model

namespace App;

use Illuminate\Database\Eloquent\Model;

class Figures extends Model
{
   protected $table = 'figures';
}

Controller

  $dummyDetails = Figures::where('name', 'batman')->get();

and Method 2 ---------- laravel Query Builder

  $dummyDetails = \DB::table('figures')->where('name', 'batman')->get();

edited Aug 28, 2020 at 10:33

answered Aug 28, 2020 at 10:27

Kamlesh Paul

12.5k2 gold badges23 silver badges36 bronze badges

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

1 Comment

insomniac22 Over a year ago

Thank you, this worked. I need to look at models more as I thought the model defines the DB level interaction which I can see is wrong.

VIKAS KATARIYA · Accepted Answer · 2020-08-28 10:31:56Z

1

Use this you not need to define table name

 public function figurespag2() {
        $dummyDetails = Figures::where('name', 'batman')->get();
        return view ( 'pagination2.index' )->withUsers($dummyDetails);
       }

answered Aug 28, 2020 at 10:31

VIKAS KATARIYA

6,0153 gold badges19 silver badges37 bronze badges

1 Comment

insomniac22 Over a year ago

Thank you for the explanation, it helped me to understand the relationship of the model to the query and controller. Thank you.

Waqar Akram · Accepted Answer · 2020-08-28 12:49:49Z

1

First you may need to know laravel model rules.

If you create a table name like "figures" (plural) you need to create its model by Figure (singular).

if you create a table other then this rule then you have to mentioned table name in model like this.
protected $table = "table_name";

you can access table with where condition in controller like this.

  public function figurespag2() {
    $dummyDetails = Figure::where('name', 'batman')->get();
    return view ( 'pagination2.index' )->withUsers($dummyDetails);
   }

Hope this may help you.

edited Aug 28, 2020 at 12:49

answered Aug 28, 2020 at 10:50

Waqar Akram

1176 bronze badges

1 Comment

insomniac22 Over a year ago

Thank you for the additional clarification. I am new to Laravel and its getting used to the MVC approach.

Collectives™ on Stack Overflow

Specify DB table in laravel query

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related