mysqli_stmt::$param_count
mysqli_stmt::$param_count
mysqli_stmt_param_count
(PHP 5, PHP 7)
mysqli_stmt :: $ param_count - mysqli_stmt_param_count - 返回给定语句的参数个数
描述
面向对象的风格
int $mysqli_stmt->param_count;
程序风格
int mysqli_stmt_param_count ( mysqli_stmt $stmt )
返回准备好的语句中存在的参数标记的数量。
参数
`stmt`
仅过程风格:由mysqli_stmt_init()返回的语句标识符。
返回值
返回一个表示参数数量的整数。
例子
Example #1 Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world"
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error()
exit(
}
if ($stmt = $mysqli->prepare("SELECT Name FROM Country WHERE Name=? OR Code=?")) {
$marker = $stmt->param_count;
printf("Statement has %d markers.\n", $marker
/* close statement */
$stmt->close(
}
/* close connection */
$mysqli->close(
?>
Example #2 Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world"
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error()
exit(
}
if ($stmt = mysqli_prepare($link, "SELECT Name FROM Country WHERE Name=? OR Code=?")) {
$marker = mysqli_stmt_param_count($stmt
printf("Statement has %d markers.\n", $marker
/* close statement */
mysqli_stmt_close($stmt
}
/* close connection */
mysqli_close($link
?>
上面的例子会输出:
Statement has 2 markers.