A method for dynamically acquiring table names in Yii operation database _php Example

This article illustrates the method of dynamically acquiring table names for the implementation of YII operation database. Share to everyone for your reference, specific as follows:

Yii gets the name of a table in a library, and the library is unsure of the number of tables, and there is a way to solve it by using the GII to generate files based on a table.

$sqls = "Show tables";
$datebase = Yii::app ()->db_order->createcommand ($SQLS)->queryall ();
Get table name

Here $datebase is all the table names, I currently have 4 libraries, a Web site common to these 4 libraries, sometimes switch back and forth. Db_order is one of the 4 libraries defined in main.php, and the other libraries are DB Db_order db_query db_LOG. Then you can get the data from all the tables in this library. without having to build.

This method is generally used for gaming platform, for example, I currently have a library dedicated to the storage of orders, it is this library erection is db_order at this time I need to be a user of all recharge records (order) to get

More about Yii related content readers can view the site topics: "Yii framework Introduction and common skills Summary", "PHP Excellent Development Framework Summary", "Smarty Template Primer Tutorial", "PHP date and Time usage summary", "PHP object-oriented Programming Program", " Summary of PHP string usage, Introduction to PHP+MYSQL database operations, and a summary of PHP common database operations Tips

I hope this article will help you with the PHP program design based on the YII framework.