mysqli::stmt_init

mysqli_stmt_init

(PHP 5, PHP 7, PHP 8)

mysqli::stmt_init -- mysqli_stmt_init — 初始化一条语句并返回一个用于mysqli_stmt_prepare(调用)的对象

说明

面向对象风格

mysqli::stmt_init(): mysqli_stmt

过程化风格

mysqli_stmt_init(mysqli $link): mysqli_stmt

分配并初始化一个语句对象用于mysqli_stmt_prepare().

注意:
任何其后调用的mysqli_stmt函数都会失败直到mysqli_stmt_prepare()被调用.

参数

mysql: 仅以过程化样式：由mysqli_connect() 或 mysqli_init() 返回的 mysqli 对象。

返回值

Returns an object.

参见

mysqli_stmt_prepare() - Prepares an SQL statement for execution

add a note

User Contributed Notes 3 notes

down

Jeff C ¶

5 years ago


stmt_init() seems to clear previous (possibly erroneous) results on the DB connection, which means you don't necessarily need to use it but it could make the code more robust.

In a PHPUnit test, I had a sequence of prepared queries on the same connection. One of them fetched a row from a SELECT but didn't keep fetching until it drained the connection, so it left some stale results. When the next query did this:

<?php
$db = $this->getConnection()->getDbConnection();
$preparedQuery = $db->prepare ($query);
?>

the prepare() call generated an error: "Could not prepare query: Commands out of sync; you can't run this command now." Changing to this:

<?php
$db = $this->getConnection()->getDbConnection();
$preparedQuery = $db->stmt_init();
$preparedQuery->prepare ($query);
?>

resolved the problem.

down

mamdo7 at hotmail dot com ¶

8 years ago


you can use $stmt = $mysqli->prepare(); directly without stmt-init() . i think there is no need for stmt-init .

down

-26

Deepak Sati ¶

7 years ago


If your sql query has some errors and you don't use stmt_init() before preparing the statement, you won't get error message for wrong sql query.

add a note

官方地址：https://www.php.net/manual/en/mysqli.stmt-init.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 科技开发编程 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL C/C++ 面试数据库 Golang Git 算法正则表达式操作系统 Redis 互联网 MySql JavaScript 运维软件架构设计 Mac OS 国际 TCP/IP Excel Vim Windows Socket Oracle VR MongoDB 运营 Python MemCache 商业硬件电子设计 nginx 娱乐摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 [PHP] inet_pton/inet_ntop IP地址转换函数 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 PHPMailer设置utf8 PHPMailer字符集CharSet 如何在Composer中为GitLab实例设置访问令牌 array_multisort() 多字段排序 laravel框架查看sql语句方式 [原创]诡异的php-fpm超时问题利用php soap实现web service PHP获取指定函数定义在哪个文件中及行号 php设置cookie为httponly防止xss攻击 PHP5 扩展SOAP 调用 webservice PHP-FPM进程数的设定 PHP7添加redis扩展利用PHP SOAP实现WEB SERVICE ADORecordSet对象 PHPstorm 里面Terminal 不能使用 esc键吗退出编辑模式吗 PHP - mysql_real_escape_string()与mysql_escape_string() 的区别 PHP的Socket通信之UDP篇

略微加速

PHP官方手册 - 互联网笔记

mysqli::stmt_init

mysqli_stmt_init

说明

参数

返回值

参见

User Contributed Notes 3 notes