thinkphp Query method Summary, thinkphp Query method _php Tutorial

thinkphp Query method Summary, thinkphp Query method

This paper summarizes the thinkphp query method. Share to everyone for your reference, as follows:

First, the general Query method

1. Use string queries;
Copy the code as follows: $m->where (' id=1 and Name= ' Roge ')->find ();
One drawback of this approach is that when a query field in a datasheet is a string, quotation marks are added to the field values.

2. How to use arrays (recommended)

$data [' name ']= ' ADFA '; $data [' id ']=3; $data [' _logic ']= ' or '; The logical relationship between fields, by default, and the relationship between $m->where ($data)->find ();

Second, expression query

EQ equals;
NEQ is not equal to;
GT greater than;
EGT is greater than or equal to;
LT is less than;
ELT less than equals;
Like fuzzy query;

$data [' id ']=array (' GT ', 6); $data [' Name ']=array (' like ', '%as% '); notlike//$data [' Name ']=array (' like ', Array ('%as% ', '%ts '), ' and '); The default is an or relationship, if you need to explicitly specify $m->where ($data)->select (),//other query between, not between (there are spaces between them), in,not between,

Third, interval query

$data [' ID ']=array (Array (' GT ', 5), array (' LT ', 10)); The default generation is the relationship of and/$data [' ID ']=array (' lt ', 5), Array (' GT ', ' ten '), ' or ') $data [' Name ']=array (' like ', '%d% '), Array (' Like ', '%e% '), ' gege ', ' or '), $m->where ($data)->select ();

Iv. Statistical Enquiry

Count,max, Min, avg, sum
Copy the Code code as follows: $m->max (' id ')
Five, SQL direct query

$m =m (); $result = $m->query ("select * from Think_user where id>1")//query is primarily used to read data $result= $m->execute (" Insert into Think_user (' name ') VALUES (' DFD ') ");//execute for writing data

Read more about thinkphp for more information on this site: "thinkphp Introductory Course" and "thinkphp Common methods Summary"

It is hoped that this article is helpful to the PHP program design based on thinkphp framework.

Articles you may be interested in:

• Thinkphp An instance of an association query
• thinkphp using native query to implement Association query left JOIN instance
• thinkphp data querying and iterating over an array instance
• thinkphp common query and expression query instance analysis
• thinkphp query statement and associated query usage instance
• thinkphp implementing a like Fuzzy query instance
• thinkphp query returns a simple field array method
• Summary of common query languages in thinkphp
• thinkphp Study notes Multi-table query
• thinkphp View Query Detailed
• Common methods of thinkphp multi-table joint query

http://www.bkjia.com/PHPjc/1089930.html www.bkjia.com true http://www.bkjia.com/PHPjc/1089930.html techarticle thinkphp Query Method Summary, thinkphp Query method This article summarizes the thinkphp query method. Share to everyone for your reference, as follows: First, ordinary Query Method 1. Use characters ...

