Laravel php script DB class not found

Question

I'm trying to write a script for laravel that queries my database and fetches tables, but I'm not sure what to include in the file in order to get the DB class to work.

Thus far my code looks like:

$tables = DB::query("SHOW TABLES"); foreach ($tables as $table) { print $table . "\n"; }

I've tried using require "../../vendor/autoload.php" but that doesn't help.

So for instance, the DB class works fine if I call it within a controller, but not if I create a directory, say /application/scripts and create a file test.php . If I try to call DB in that file, the DB class isn't defined (for good reason). I'm wondering what I need to require in that file in order for that class to be defined.

Also, check your error logs for issues, it may be that you haven't configured the connection correctly, or that $db in your example is not defined... you need to include more information that you have done for people to assist without to many "guesses" — ɴᴀᴛᴇ ᴅᴇᴠ
– ɴᴀᴛᴇ ᴅᴇᴠ, Commented May 15, 2013 at 16:14
Is there any reason this can't be done within the normal MVC structure/namespaces of Laravel (i.e. in a model or the controller)? As Sébastien pointed out below, it's probably not worth the time or effort to do it like this.. — ɴᴀᴛᴇ ᴅᴇᴠ
– ɴᴀᴛᴇ ᴅᴇᴠ, Commented May 15, 2013 at 16:46
I'm trying to create an automatic class generator that I can run when I update my tables in the database. And I also need this for rewriting some import scripts I have. — Gavin Sellers
– Gavin Sellers, Commented May 16, 2013 at 1:26

Phill Sparks · Accepted Answer · 2013-05-15 21:22:04Z

3

I would suggest using the Illuminate/Database package (part of Laravel 4). You won't get the DB interface, because that's a special facade provided by the Laravel Framework, but all the query builder functionality is available through the capsule.

Install illuminate/database using composer and then follow the included readme notes (included below for completeness).

Illuminate Database

Usage Outside Of Laravel 4

$config = array(
    'fetch' => PDO::FETCH_CLASS,
    'default' => 'mysql',
    'connections' => array(
        'mysql' => array(
            'driver'    => 'mysql',
            'host'      => 'localhost',
            'database'  => 'laravel',
            'username'  => 'root',
            'password'  => 'password',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),
    ),
);

$capsule = new Illuminate\Database\Capsule($config);

// If you want to use the Eloquent ORM...
$capsule->bootEloquent();

// Making A Query Builder Call...
$capsule->connection()->table('users')->where('id', 1)->first();

// Making A Schema Builder Call...
$capsule->connection()->schema()->create('users', function($t)
{
    $t->increments('id');
    $t->string('email');
    $t->timestamps();
});

answered May 15, 2013 at 21:22

Phill Sparks

21k3 gold badges36 silver badges47 bronze badges

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

1 Comment

Phill Sparks Over a year ago

There's also Capsule which makes this process easier.

coffe4u · Accepted Answer · 2013-05-15 17:02:20Z

1

You do not need to include anything. Laravel will include what it needs and setup the system itself. You are using a variable called $db but it is not defined and means/does nothing. What you are looking for is the DB class. Try this:

$tables = DB::query('SHOW TABLES');
foreach ($tables as $table)
{
    echo $table.PHP_EOL;
}

Also, check out the Fluent DB class documentation: http://laravel.com/docs/database/fluent

answered May 15, 2013 at 17:02

coffe4u

5383 silver badges5 bronze badges

1 Comment

Gavin Sellers Over a year ago

that's what I actually had. That's exactly what isn't working inside the script.

Sébastien Renauld · Accepted Answer · 2013-05-15 16:34:03Z

0

...Isn't it DB::query()? A call to the database engine is through a class, not a variable, for scoping issues.

answered May 15, 2013 at 16:34

Sébastien Renauld

19.8k2 gold badges51 silver badges69 bronze badges

2 Comments

ɴᴀᴛᴇ ᴅᴇᴠ Over a year ago

If he creates a file which isn't in the Laravel namespace then referencing the DB class still won't work... OP want's to know how to include the Laravel DB class inside a file outside the normal Laravel MVC structure.

Sébastien Renauld Over a year ago

That is going to be very difficult and mostly pointless. You'll need to load a very large part of Laravel to get access to the DB wrapper. Might as well just write for L3.

Collectives™ on Stack Overflow

Laravel php script DB class not found

3 Answers 3

Illuminate Database

Usage Outside Of Laravel 4

1 Comment

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Illuminate Database

Usage Outside Of Laravel 4

1 Comment

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related