Kristjan Kirpu Kristjan Kirpu - 1 year ago 70
MySQL Question

Getting all tables inside a database using Laravel 4

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
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.

Answer Source
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
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download