CodeIgniter Forums
database SHOW TABLES - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: database SHOW TABLES (/thread-11508.html)



database SHOW TABLES - El Forum - 09-11-2008

[eluser]Unknown[/eluser]
Hi,

I would like to add an functionality to dbutils for showing all tables for selected database. I'm trying to use similar like in list_databases() function. Data retreived was not contain tables for database. If I try in (SHOW TABLES FROM database_name) phpmyadmin it works properly. Any idea?

Thanks

Marek


database SHOW TABLES - El Forum - 09-11-2008

[eluser]xwero[/eluser]
Maybe the user you added to your database.php config file is not granted to see other databases?


database SHOW TABLES - El Forum - 09-11-2008

[eluser]Unknown[/eluser]
User for mysql database is root, so I suppose ho could do everything Smile.


database SHOW TABLES - El Forum - 09-11-2008

[eluser]xwero[/eluser]
you can use db->list_tables, i did't read your post right the first time.