Laravel中Fragmentation DB::table()报错：未定义方法如何解决？

Hey there! Let's break down how to fix that frustrating error first, then we'll cover adding your if/else if logic smoothly.

Troubleshooting the Undefined Method Error #

This error usually pops up when Laravel can't properly resolve the DB facade. Here are the most common fixes, ordered by how likely they are to solve your issue:

• Double-check your use statement
  Make sure at the top of the file where you're using DB::table(), you have the correct import:

  use Illuminate\Support\Facades\DB;
  

  If you accidentally imported a custom DB class from your own project's namespace, that would cause this conflict—so verify the namespace here.

• Verify the DB facade alias
  Open your config/app.php file and look for the aliases array. Ensure there's an entry like this:

  'DB' => Illuminate\Support\Facades\DB::class,
  

  If it's missing, add it. Then clear your config cache to apply the change:

  php artisan config:clear
  

• Clear all Laravel caches
  Sometimes stale caches can mess with facade resolution. Run these commands to wipe everything clean:

  php artisan optimize:clear
  php artisan route:clear
  

• Ensure Laravel's container is initialized (for custom scripts)
  If you're using DB outside a standard Laravel request (like a standalone CLI script), you need to bootstrap the Laravel app first. Add this at the top of your script:

  require __DIR__.'/vendor/autoload.php';
  $app = require_once __DIR__.'/bootstrap/app.php';
  $app->make(Illuminate\Contracts\Console\Kernel::class)->bootstrap();
  

Adding If/Else If Logic Once the Error is Fixed #

Once DB::table() is working again, adding conditional logic is straightforward. Here are two common approaches:

Basic If/Else If Example #

This is great for simple, explicit conditions:

// Let's say you have a condition variable driving the query
$userStatus = request('status'); // Or whatever your condition source is

if ($userStatus === 'active') {
    $users = DB::table('users')
        ->where('status', 1)
        ->get();
} elseif ($userStatus === 'inactive') {
    $users = DB::table('users')
        ->where('status', 0)
        ->get();
} else {
    // Fallback: get all users if no valid condition is provided
    $users = DB::table('users')->get();
}

Cleaner when() Method (Laravel Query Builder) #

For more concise conditional queries, use Laravel's built-in when() method—it keeps your query chain clean:

$userStatus = request('status');

$users = DB::table('users')
    ->when($userStatus === 'active', function ($query) {
        return $query->where('status', 1);
    })
    ->when($userStatus === 'inactive', function ($query) {
        return $query->where('status', 0);
    })
    ->get();

This works exactly like the if/else if structure but keeps your query logic grouped together.

内容的提问来源于stack exchange，提问作者layouteam