Getting all tables inside a database using Laravel 4

Question

What do I want to achieve?

Get all table names inside a database and echo them using @foreach @endforeach. My database name is demoproject and it has some tables inside it like users, list1, list2, list3 and I need to echo all the tables.

When using var dump I get bool(true) or when echoing I get 1 with this code DB::statement('show tables from demoproject');

Why do I want to do this?

I'm making an admin panel, where I can edit tables and their rows. That's why I need to use @foreach to link them to another page.

I only need to know how I can echo all tables inside that database to continue with this project.

I'm using Laravel 4.

Because I need to encrypt some values using php. And I don't want all admins to edit some rows. Plus I'll be adding descriptions on how to edit/insert values etc.. — Kristjan Kirpu
– Kristjan Kirpu, Commented Oct 18, 2013 at 8:33
Why not? comments intended for clarification. If you don't feel like answering them - just don't answer. — Your Common Sense
– Your Common Sense, Commented Oct 18, 2013 at 8:43

pepper · Accepted Answer · 2014-11-13 15:01:50Z

34

A little bit late, however, you can run $tables = DB::select('SHOW TABLES'); to get all tables.

answered Nov 13, 2014 at 15:01

pepper

1,7722 gold badges18 silver badges35 bronze badges

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

2 Comments

Tommy Nicholas Over a year ago

My only question here is that you wouldn't be able to iterate through this list without already knowing the name of the database I think. It comes back like this: {"Tables_in_notes":"gdocs"},{"Tables_in_notes":"migrations"} So to get a list, you'd have to know the project is called "notes" right?

pepper Over a year ago

@TommyNicholas, it's not a project name, but database name which you can usually get by env('DB_DATABASE')

Mehmet Akif TEZCAN · Accepted Answer · 2023-03-16 23:14:20Z

select * from information_schema.tables where table_schema='database_name'

you can also do this to test or whatnot:

$pdo = DB::connection()->getPdo();
//run queries the normal pdo way

For PGSQL;

    if (config('database.default') == 'pgsql') {
        $database_name = 'laravel';
        $tables = DB::select("SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'");

        foreach ($tables as $table) {
            $tablename = $table->table_name;
            if ($tablename == 'model_has_permissions' || $tablename == 'password_resets'|| $tablename == 'model_has_roles' 
                || $tablename == 'model_has_permissions'|| $tablename == 'role_has_permissions') {
                continue;
            }
                DB::select("
                SELECT setval(pg_get_serial_sequence('$table->table_name' , 'id'), coalesce(max(id)+1, 1), false)
                FROM ".$tablename.";
            ");
            
        }
    }

Damian C · Accepted Answer · 2016-06-12 03:40:23Z

0

I just did this in Laravel 5.2 with Microsoft SQL 2012

$tables = DB::connection('<connection_name')
               ->table('INFORMATION_SCHEMA.TABLES')
               ->select('*')
               ->get();
dd($tables);

answered Jun 12, 2016 at 3:40

Damian C

2,1812 gold badges16 silver badges18 bronze badges

Collectives™ on Stack Overflow

Getting all tables inside a database using Laravel 4

What do I want to achieve?

Why do I want to do this?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

What do I want to achieve?

Why do I want to do this?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related