PHP manuál : function.mysqli-stmt-param-count.html
mysqli_stmt_param_count 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 Procedural style:
int
mysqli_stmt_param_count ( mysqli_stmt stmt )
Object oriented style (property):
class
mysqli_stmt {
int param_count
}
mysqli_stmt_param_count() returns the number of parameter
markers present in the prepared statement.
Return Values
returns an integer representing the number of parameters.
Examples 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 ); ?>
The above example will output:
Webmail
Zaujímavé linky
inzerat.sk - bezplatna inzercia, inzeraty, autobazar, reality
Slovak companies and manufacturers directory Katalog slovenskych firiem a vyrobkov
Suppliers and products directory