The query function is often used in daily development. Today, our PHP Chinese website will take you through the implementation method of the query function and briefly introduce how to use the query function in thinkphp. SQL matching mode 1. Use sql matching mode, you cannot use the operator = or! =, instead use the operator LIKE or NOT LIKE; 2. Use sql matching mode, MYSQL provides 2 kinds of wildcard characters. % represents any number of any characters (including 0) _ represents any single character 3. Using the sql matching mode, if the matching format does not contain any of the above two wildcard characters, the query effect is equivalent to = or! =4. Use sql matching mode. When matching, it is not case-sensitive. #Query users whose username starts with a certain character. #Query users whose username starts with the character 'l': l% SELECT * FROM user WHERE username LIKE 'l%'; #Query the user name with a certain
Introduction: The query function is often used in daily development. Today, our PHP Chinese website will take you through the implementation method of the query function and briefly introduce it in thinkphp. How to use the query function. SQL matching mode 1. Use sql matching mode, you cannot use the operator = or! =, instead use the operator LIKE or NOT LIKE;
Introduction: ThinkPHP is a fast, compatible and simple lightweight domestic PHP development framework. Using the ThinkPHP framework can greatly simplify our development process, saving time. This article is for PHP Chinese to help everyone learn a very important concept in ThinkPHP: namespace.
3. thinkPHP5 introduces traits example code in detail
##Introduction: ThinkPHP 5.0 began to use the trait function (PHP5.4+) as an extension mechanism to easily implement multiple inheritance issues in a class library. Traits is a code reuse mechanism for single-inheritance languages like PHP. Traits are designed to reduce the constraints of single-inheritance languages and allow developers to freely reuse method sets in independent classes within different hierarchies. The semantics of traits and class composition define a way to reduce complexity and avoid the typical problems associated with traditional multiple inheritance and mixins.
4. Share a detailed explanation of an example of login and logout using ThinkPHP
Introduction: This article mainly introduces ThinkPHP Implement login and exit functions
5. Thinkphp5 What you need to know to get started
##Introduction: summary of getting started with thinkphp
6.
Do you know the usage of this keyword in Thinkphp5?
Introduction: PHP has had most of the features of an object-oriented language since 5, and has many more object-oriented features than PHP4. Here we mainly explain three keywords : this, self, parent, it is easier to understand literally, it refers to this, self, father. Let us first establish a few concepts. Where are these three keywords used? Let us briefly explain that this refers to The pointer of the current object (let's use the pointer in C for now), self is the pointer to the current class, and parent is the pointer to the parent class.7.
Detailed explanation of how to apply curd code in Thinkphp
## Introduction: This time I have nothing to do to write down the specific application of curd. Of course, I mainly talk about curd here. What I do is the addition, deletion, modification and query of users. I don’t use the three automatic first class IndexAction extends Action { public function index(){ 8. Summary of commonly used constants and variables in thinkphp
Introduction: This article mainly introduces the system constants and variables commonly used in thinkphp. Friends in need can refer to it ---------------- ------------------------System variables and constants used in templates------------------ --------------------- (1) System variables: Output system variables in the template: including server, env, session, post, get, request, cookie 9. php example-thinkPHP cannot display the verification code reasons and solutions analysis Introduction: This article The article mainly introduces the reasons and solutions for thinkPHP not displaying the verification code, and analyzes the related configuration methods and precautions for thinkPHP regarding verification code display based on specific examples. Friends in need can refer to the following 11. php example-thinkphp implements the attachment upload function 12. php example- Example of thinkPHP+phpexcel realizing excel report output function 13. 2017 laravel and thinkphp comparison 14. thinkphp about the correct understanding and usage of include Introduction: The discussion area provides everyone with a platform for communication in the technical circle. Here you can ask for help with various technical problems, post about recruitment, and complain about your mood. , share the joys and little worries of IT life, come and join us! Let us all create a harmonious new community in TP! 15. Detailed explanation of if usage examples in ThinkPHP Introduction: ThinkPHP's IF tag can be used to define complex conditional judgments, such as: 16. Detailed explanation of the usage of for loop and switch in thinkphp Introduction: 1.for usage 17. Use thinkphp5.0 to obtain information, variables, and binding parameters Introduction: 1. Constructor: The controller class must inherit the thinkController class to use: Method_initialize Code: 18. thinkphp5.0 study notes database operation
Introduction: ThinkPHP has a built-in abstract database access layer that encapsulates different database operations. We only need to use the public The Db class operates without having to write different codes and underlying implementations for different databases. The Db class will automatically call the corresponding database driver for processing. Using PDO method, it currently includes support for Mysql, SqlServer, PgSQL, Sqlite and other databases. 1. After basic usage and configuring the database connection information, we can directly use the database to run native SQL operations, supporting query (query operation) 19. How to delete columns in ThinkPHP ?
Introduction: Some time ago, I published an essay about deleting a column. The function implemented at that time was to delete a piece of information. , this time we will implement batch deletion of columns. What we need to achieve is such an effect: after selecting the batch delete button, all the columns of the page can be selected. This is the implementation of the front-end page. I won’t go into details here. Let’s go directly to the topic: the function of batch deletion. 1. There is also a small point here on the front-end page, that is, the name value of the selection box should be assigned an array of ids, and the value value is the id of the column. 2. We separately 20 in the controller. Briefly introduce the specific differences between ThinkPHP5.0 and ThinkPHP3.2 Introduction: The editor will bring you a brief discussion on the difference between ThinkPHP5.0 version and ThinkPHP3.2 version. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look 21. ThinkPHP+EasyUI example explanation Introduction: Hypothetical database The fields in the accounting data table are: id, code, name, islast. They are the auto-increment primary key, account code, account name, and whether it is the last-level account ("1" indicates the last-level account). Here, recursion is used in the model layer of Thinkphp to build the data required by ComboTree. The code and annotations are as follows:
namespace Home\Model;
use Think\Model;
class AccountModel extends Model{pu 22. What are the configuration types of thinkphp? How to achieve it? Introduction: 1. What are the thinkphp configuration types?
1. In thinkphp, there are 6 configurations. That is, conventional configuration, application configuration, extended configuration, module configuration, scene configuration, and dynamic configuration.
2. The conventional configuration is the system default configuration.
3. Application configuration is the individual configuration of the application developed and created by ourselves.
4. Extension configuration is mainly to implement the configuration used by some extension programs during the development process of our project.
5. Module configuration is the configuration of each module in an application.
6. Scenario configuration is mainly to realize our 23. thinkPHP+phpexcel implements excel report output function example detailed explanation Introduction: This article mainly introduces the excel report output function of thinkPHP+phpexcel, and analyzes the related operation skills of thinkPHP integrating PHPExcel for Excel files based on specific examples. Friends can refer to 24. ThinkPHP+EasyUI ComboTree implementation method of accounting tree menu ##Introduction: The editor below will bring you an article on how to implement the accounting tree menu in ComboTree of ThinkPHP+EasyUI. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look 25. 10 course recommendations about Thinkphp ## Introduction: This article mainly describes the pitfalls encountered in the development process of WeChat applet accessing WeChat payment. It is divided into two major parts, the applet and the backend interface encapsulation. The main contents of this article are as follows: 1. Backend interface encapsulation; 2. Mini program integration; 3. Summary of pitfalls. 1. Backend interface encapsulation is based on ThinkPHP 5 for interface encapsulation. The specific steps are as follows: 1. The official WeChat payment document provides a sample of PHP script WeChat payment, download it; 2. The sample has encapsulated each class, we only need Just add the namespace, create a new directory wxpay under the extend directory of TP5, and put... [Related Q&A recommendations]: javascript - thinkphp parameter is how to pass urlmysql - novice thinkphp mall design problemHow does Thinkphp use nginx (reverse proxy) +Deploy in apache environment? thinkphp3 joint table queryWeChat public platform - thinkphp5 WeChat server configuration problem, why the token cannot be verified
The above is the detailed content of The latest 15 tinhkphp video tutorials. For more information, please follow other related articles on the PHP Chinese website!