How to execute native SQL statements in thinkPHP framework-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

How to execute native SQL statements in thinkPHP framework

不言

Jun 07, 2018 pm 05:38 PM

sql statement thinkphp framework Native implement

This article mainly introduces the method of executing native SQL statements in the thinkPHP framework. It analyzes the related operating skills of executing native SQL statements in thinkPHP in the form of examples, and briefly analyzes the difference between the query and execute methods. Friends in need You can refer to the following example

This article describes the method of executing native SQL statements in the thinkPHP framework. Share it with everyone for your reference, the details are as follows:

How to execute native sql statements in thinkphp?

$Model = new Model();//或者 $Model = D(); 或者 $Model = M();
$sql = "select * from `order`";
$voList = $Model->query($sql);

Copy after login

Just need new an empty model to inherit the methods in Model.

Notequery is the query function, execute is the add, delete and modify function

Examples of querying and reading attribute values:

$sql = "select * from goods";
$Model = M();
$result = $Model->query($sql);
foreach ($result as $k=>$val){
$goods_id = $val["goods_id"];
}

Copy after login

tP’s model can support native SQL operations and provides two methods: query and execute. Why does native SQL have to distinguish between two methods? There are two reasons:

1. Different return types

query is used to query , returns the data set , the same as select or findall, so you can directly use the volist tag in the template to output the query query Result

execute is used for write operations,returns the status or the number of records affected

2. Read and write statistics required

In order to facilitate statistics of the current number of data reads and writes, the read and write operations of the database are separated (corresponding to query and execute)

Using native SQL is very simple, we don’t even need Instantiate any model, for example:

1	`$Model` `=` `new` `Model();` `// 实例化一个空模型`

Copy after login

The following methods are equivalent

$Model = D();// 或者 $Model = M();
// 下面执行原生SQL操作
$Model->query(&#39;select * from think_user where status=1&#39;);
$Model->execute(&#39;update think_user set status=1 where id=1&#39;);

Copy after login

If you instantiate a model, you can still perform native SQL operations without being affected, for example :

$User = D(&#39;User&#39;);
$User->query(&#39;select * from think_user where status=1&#39;);
$User->execute(&#39;update think_user set status=1 where id=1&#39;);

Copy after login

In this case, we can simplify the writing of SQL statements, for example:

1 2	`$User->query('select * from __TABLE__ where status=1');` `$User->execute('update __TABLE__ set status=1 where id=1');`

Copy after login

The system will automatically replace __TABLE__ with the data table corresponding to the current model The name and actual data table are determined by the model.

Generally speaking, we use native SQL operations to implement some operations that are difficult to implement with ORM and CURD . In addition, If the SQL is not complicated, the efficiency and coherence of native SQL The difference in operational efficiency is minimal, and the ORM implementation of TP itself is also quite efficient.

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

Related recommendations:

ThinkPHP5 framework simply implements batch query

ThinkPHP3.2 framework uses addAll() to insert batches Data method

thinkPHP5 method of adding content to the database

The above is the detailed content of How to execute native SQL statements in thinkPHP framework. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055523 fails to install in Windows 11?

3 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

3 weeks ago By DDD

Roblox: Dead Rails - How To Tame Wolves

4 weeks ago By DDD

Strength Levels for Every Enemy & Monster in R.E.P.O.

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Roblox: Grow A Garden - Complete Mutation Guide

2 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1658

CakePHP Tutorial

1415

Laravel Tutorial

1309

PHP Tutorial

1257

C# Tutorial

1231

Related knowledge

How to create tables with sql server using sql statement Apr 09, 2025 pm 03:48 PM

How to create tables using SQL statements in SQL Server: Open SQL Server Management Studio and connect to the database server. Select the database to create the table. Enter the CREATE TABLE statement to specify the table name, column name, data type, and constraints. Click the Execute button to create the table.

How to write a tutorial on how to connect three tables in SQL statements Apr 09, 2025 pm 02:03 PM

This article introduces a detailed tutorial on joining three tables using SQL statements to guide readers step by step how to effectively correlate data in different tables. With examples and detailed syntax explanations, this article will help you master the joining techniques of tables in SQL, so that you can efficiently retrieve associated information from the database.

How to judge SQL injection Apr 09, 2025 pm 04:18 PM

Methods to judge SQL injection include: detecting suspicious input, viewing original SQL statements, using detection tools, viewing database logs, and performing penetration testing. After the injection is detected, take measures to patch vulnerabilities, verify patches, monitor regularly, and improve developer awareness.

How to create Mysql database using phpMyadmin Apr 10, 2025 pm 10:48 PM

phpMyAdmin can be used to create databases in PHP projects. The specific steps are as follows: Log in to phpMyAdmin and click the "New" button. Enter the name of the database you want to create, and note that it complies with the MySQL naming rules. Set character sets, such as UTF-8, to avoid garbled problems.

How to use SQL statement insert Apr 09, 2025 pm 06:15 PM

The SQL INSERT statement is used to insert data into a table. The steps include: specify the target table to list the columns to be inserted. Specify the value to be inserted (the order of values must correspond to the column name)

How to check SQL statements Apr 09, 2025 pm 04:36 PM

The methods to check SQL statements are: Syntax checking: Use the SQL editor or IDE. Logical check: Verify table name, column name, condition, and data type. Performance Check: Use EXPLAIN or ANALYZE to check indexes and optimize queries. Other checks: Check variables, permissions, and test queries.

Do mysql need to pay Apr 08, 2025 pm 05:36 PM

MySQL has a free community version and a paid enterprise version. The community version can be used and modified for free, but the support is limited and is suitable for applications with low stability requirements and strong technical capabilities. The Enterprise Edition provides comprehensive commercial support for applications that require a stable, reliable, high-performance database and willing to pay for support. Factors considered when choosing a version include application criticality, budgeting, and technical skills. There is no perfect option, only the most suitable option, and you need to choose carefully according to the specific situation.

How to add columns in PostgreSQL? Apr 09, 2025 pm 12:36 PM

PostgreSQL The method to add columns is to use the ALTER TABLE command and consider the following details: Data type: Select the type that is suitable for the new column to store data, such as INT or VARCHAR. Default: Specify the default value of the new column through the DEFAULT keyword, avoiding the value of NULL. Constraints: Add NOT NULL, UNIQUE, or CHECK constraints as needed. Concurrent operations: Use transactions or other concurrency control mechanisms to handle lock conflicts when adding columns.

See all articles