Search functionality: loop through all database tables (Laravel)

Question

I'm looking for a way to loop through all my database tables in Laravel in order to add a search functionality to my website.

I guess there should be a way to do this without hardcoding all the table names.

Rickkwa · Accepted Answer · 2015-03-28 16:33:19Z

1

You can do this:

$tables = DB::select("select table_name from information_schema.tables where table_schema='your_database_name'");

Just change your_database_name to your own value. Then you can use the Laravel helper function, array_pluck, to get an array of the table_name values.

array_pluck($tables, 'table_name')

answered Mar 28, 2015 at 16:33

Rickkwa

2,3015 gold badges25 silver badges37 bronze badges

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

1 Comment

RW24 Over a year ago

Thanks for the answer! Is there a way to search in EVERY column without hardcoding every column name?

Collectives™ on Stack Overflow

Search functionality: loop through all database tables (Laravel)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related