Thinkphp Common methods for multi-table joint query _php Example

The table () method or the Join method can be used in thinkphp associated queries (that is, a multiple table union query), as shown in the following example:

1. Native Query Example:

Copy Code code as follows:

$Model = new Model ();
$sql = ' Select A.id,a.title,b.content from Think_test1 as a, think_test2 as B where a.id=b.id '. $map. ' ORDER by a.ID '. $so Rt. ' Limit '. $p->firstrow ', '. $p->listrows;
$voList = $Model->query ($sql);

2, Join () Method Example:

Copy Code code as follows:

$user = new Model (' user ');
$list = $user->join (' Right join user_profile on user_stats.id = User_profile.typeid ');

3, table () Method Example:

Copy Code code as follows:

$list = $user->table (' User_status stats, user_profile profile ')->where (' stats.id = Profile.typeid ')->field (' Stats.id as ID, stats.display as display, profile.title as title,profile.content as content ')->order (' stats.id desc ')- >select ();

More interested in thinkphp related content readers can view the site topics: "thinkphp Introductory Course", "thinkphp Template Operation Skills Summary", "thinkphp Common Methods Summary", "Smarty Template Introductory Course" and "PHP template technology Summary."

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