|
Последние активные темы форума |
|
mysqli_stmt_param_count
(PHP 5) mysqli_stmt_param_count (no version information, might be only in CVS) stmt->param_count -- Returns the number of parameter for the given statement
DescriptionПроцедурный стиль: int mysqli_stmt_param_count ( mysqli_stmt stmt ) Объектно-ориентированный стиль (property): class mysqli_stmt { int param_count } mysqli_stmt_param_count() returns the number of parameter
markers present in the prepared statement.
Возвращаемые значенияreturns an integer representing the number of parameters.
Примеры
Пример 1. Объектно-ориентированный стиль
<?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
();
?>
|
|
Пример 2. Процедурный стиль
<?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
);
?>
|
|
Результат выполнения данного примера:
|