ThinkPHP uses native query to implement associated query left join instance, thinkphpjoin
The example in this article describes the method of ThinkPHP using native query to implement left join of associated query. Share it with everyone for your reference. The details are as follows:
thinkphp provides the join method to implement related queries, but it is very difficult to use. It is more convenient to use the native method, so it is recommended that you use the query method:
Copy code The code is as follows:
$Model = new Model();
$sql = "SELECT a.id, a.attr_name, a.attr_input_type, a.attr_type, a.attr_values, v.attr_value, v.attr_price ".
"FROM hh_typeattr AS a ". "FROM hh_typeattr AS a ".
"LEFT JOIN hh_siteattr AS v ". "LEFT JOIN hh_siteattr AS v ".
"ON v.attr_id = a.id AND v.site_id = '$site_id' ".
"WHERE a.type_id = " . intval($type_id) ." OR a.type_id = 0 ".
"ORDER BY a.listorder, a.attr_type, a.id, v.attr_price, v.id";
$row = $Model->query($sql);
I hope this article will be helpful to everyone’s ThinkPHP framework programming.
http://www.bkjia.com/PHPjc/920614.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/920614.htmlTechArticleThinkPHP uses native query to implement associated query left join example, thinkphpjoin This article tells the example of ThinkPHP using native query to implement associated query left join method. Share it with everyone for everyone...