ThinkPHP query statements and usage of related queries-PHP Tutorial-php.cn

ThinkPHP query statements and usage of related queries

不言

Release： 2023-03-30 17:08:02

Original

1454 people have browsed it

This article mainly introduces the usage of ThinkPHP query statements and related queries, and common query methods in the form of examples, including techniques such as arrays as query conditions and object methods for querying. Friends in need can refer to it

The examples in this article describe the usage of ThinkPHP query statements and related queries. Share it with everyone for your reference. The details are as follows:

In the thinkphp framework page, we can directly spell sql query statements to implement database query read and write operations. Here is an example to illustrate this.

In addition to string query conditions for ordinary queries, array and object query conditions are very commonly used, and these are necessary for basic queries.

1. Use arrays as query conditions

$User = M("User"); //实例化User对象
$condition[&#39;name&#39;] = &#39;thinkphp&#39;; // 把查询条件传入查询方法
$User->where($condition)->select();

Copy after login

2. Use object mode to query. You can use any object. Here we take the stdClass built-in object as an example.

$User = M("User"); // 实例化User对象
// 定义查询条件 $condition = new stdClass();
$condition->name = &#39;thinkphp&#39;;  // 查询name的值为thinkphp的记录
$User->where($condition)->select(); //  上面的查询条件等同于 where(&#39;name="thinkphp"&#39;) 使用对象方式查询和使用数组查询的效果是相同的，并且是可
带where条件的普通查询

Copy after login

1. String form

$user=M(&#39;user&#39;);
$list=$user->where(&#39;id>5 and id<9&#39;)->select();
$list=$user->where($data)->select();

Copy after login

2. Array format

$user=M(&#39;user&#39;);
$list=$user->where(array(&#39;username&#39;=>&#39;www.jb51.net&#39;))->select();
$list=$user->where($data)->select();

Copy after login

3. Object format

$user=M(&#39;user&#39;);
$a=new stdClass();
$a->username=&#39;www.jb51.net;
$list=$user->where($a)->select();

Copy after login

Associative query between two tables:

$M_shopping = M(&#39;Shops&#39;); 
$M_product = M(&#39;Product&#39;); 
$list_shops = $M_shopping->join(&#39;as shops left join hr_product as product on shops.product_id = product.p_id&#39;) 
->field(&#39;product.p_id,product.p_name,shops.product_amount,shops.product_id&#39;) 
->where("shops.user_cookie=&#39;".$_COOKIE[&#39;hr_think_userid&#39;]."&#39;") 
->group(&#39;shops.id&#39;) 
->select();

Copy after login

Interval query

$user=M(&#39;user&#39;);
$data[&#39;id&#39;]=array(array(&#39;gt&#39;,20),array(&#39;lt&#39;,23),&#39;and&#39;);
$list=$user->where($data)->select();

Copy after login

Combined query

$user=M(&#39;user&#39;);
$data[&#39;username&#39;]=&#39;pengyanjie&#39;;
$data[&#39;password&#39;]=array(&#39;eq&#39;,&#39;pengyanjie&#39;);
$data[&#39;id&#39;]=array(&#39;lt&#39;,30);
$data[&#39;_logic&#39;]=&#39;or&#39;;
$list=$user->where($data)->select();
dump($list);

Copy after login

Compound query

$user=M(&#39;user&#39;);
$data[&#39;username&#39;]=array(&#39;eq&#39;,&#39;pengyanjie&#39;);
$data[&#39;password&#39;]=array(&#39;like&#39;,&#39;p%&#39;);
$data[&#39;_logic&#39;]=&#39;or&#39;;
$where[&#39;_complex&#39;]=$where;
$where[&#39;id&#39;]=array(&#39;lt&#39;,30);
$list=$user->where($data)->select();

Copy after login

Associated query of three data tables

$M_shopping = M(&#39;Shops&#39;);
$M_product = M(&#39;Product&#39;);
$M_proimg = M(&#39;Product_image&#39;);
$list_shops = $M_shopping->join(&#39;as shops left join hr_product as product on shops.product_id = product.p_id left join
hr_product_image as productimgon productimg.p_id = product.p_id&#39;)->fiel(&#39;productimg.pi_url,product.p_id,product.p_name,shops.product_amount,shops.product_id,product.am_id,
product.p_procolor,product.p_price,product_amount*p_price as totalone&#39;)->where("shops.user_cookie=&#39;".$_COOKIE[&#39;hr_think_userid&#39;]."&#39;")
->group(&#39;shops.id&#39;)->select();

Copy after login

Query conditions of the data table
① The following is a direct query The conditions are placed in where, which makes it easier to write the conditions

$m_test = M("Product");
$productmeaage = $m_test->where("p_id=&#39;$proid&#39;")->select();

Copy after login

② In addition to the above method, there is also an array method

$M_product = M(&#39;Product&#39;);
$map[&#39;pid&#39;] = $proid;
$p_result = $M_product->where($map)->select();

Copy after login

The above is the entire content of this article, I hope it will be helpful to everyone Learning will be helpful. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

ThinkPHP’s association model

##Query language commonly used in ThinkPHP

The above is the detailed content of ThinkPHP query statements and usage of related queries. For more information, please follow other related articles on the PHP Chinese website!