php执行多条sql语句出错
一段执行多条sql的语句,在本地和命令行下能正常执行,放上服务器后就报错。用了thinkphp, 但本地与服务器代码是一样的,
我猜测是php或mysql设定的问题,但始终没找到。
增加sql语句长度(多打几个a), 报错内容一样。执行单条sql,不论长度如何,能正常执行。
$sql="INSERT INTO gongzhonghao.response (receive,response) VALUES ('aaaaaaaaaaaaaa','aa');I
NSERT INTO gongzhonghao.response (receive,response) VALUES ('bb','bb');
INSERT INTO gongzhonghao.response (receive,response) VALUES ('cc','cc');"
M()->execute($sql);
报错:
命令行 :
回复讨论(解决方案)
我又用pdo试了一下,能正常执行,看来thinkphp有问题。但是,本地与服务器代码全是一模一样的,包括TP的核心代码,都是刚上传的,哪位大侠来帮帮忙。
execute 每次只能执行一条SQL语句吧
出于防止 SQL 攻击的考虑,php 的数据库查询函数不允许一次执行多条指令
这完全是为了你的安全着想,作为例外 mysqli_multi_query 就可以执行多条指令
你说 PDO 可以,我没测试过,不做评论
你的多条 insert 指令本可以这样写的
$sql="INSERT INTO gongzhonghao.response (receive,response) VALUES ('aaaaaaaaaaaaaa','aa'),('bb','bb'),('cc','cc');"
把上面的3句话整合成$sql="INSERT INTO gongzhonghao.response (receive,response) VALUES ('aaaaaaaaaaaaaa','aa'),('bb','bb'),('cc','cc');"
出于防止 SQL 攻击的考虑,php 的数据库查询函数不允许一次执行多条指令
这完全是为了你的安全着想,作为例外 mysqli_multi_query 就可以执行多条指令
你说 PDO 可以,我没测试过,不做评论
你的多条 insert 指令本可以这样写的
$sql="INSERT INTO gongzhonghao.response (receive,response) VALUES ('aaaaaaaaaaaaaa','aa'),('bb','bb'),('cc','cc');"
把上面的3句话整合成$sql="INSERT INTO gongzhonghao.response (receive,response) VALUES ('aaaaaaaaaaaaaa','aa'),('bb','bb'),('cc','cc');"
原来的业务设计里要求一次执行多条不同的sql语句,有可能insert, delete, update都有,上面举例只用了insert。当然分开执行也是可以的,只是我想提高一点效率,不过如果会引起安全问题,还是算了吧。
如果允许一次执行多条指令的话
select * from tbl_name where id=$id
就有可能被篡改为
select * from tbl_name where id= 1; delete from tbl_name
如果 $i = '1; delete form tbl_name'; 的话
当然如果你能对传入的参数严格把关的话,一次执行多条指令也未尝不可
mysqli_multi_query 就是为这个需求专门设计的
php5.5 起,mysql 扩展就列入废止之列了,改用 mysqli 扩展是最佳选择

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

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

Alipay PHP...

Session hijacking can be achieved through the following steps: 1. Obtain the session ID, 2. Use the session ID, 3. Keep the session active. The methods to prevent session hijacking in PHP include: 1. Use the session_regenerate_id() function to regenerate the session ID, 2. Store session data through the database, 3. Ensure that all session data is transmitted through HTTPS.

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

Sending JSON data using PHP's cURL library In PHP development, it is often necessary to interact with external APIs. One of the common ways is to use cURL library to send POST�...
