php man page for mysqli_stmt_param_count

Query: mysqli_stmt_param_count

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

MYSQLI_STMT_PARAM_COUNT(3)						 1						MYSQLI_STMT_PARAM_COUNT(3)

mysqli_stmt::$param_count - Returns the number of parameter for the given statement

       Object oriented style

SYNOPSIS
int$mysqli_stmt->param_count ()
DESCRIPTION
Procedural style int mysqli_stmt_param_count (mysqli_stmt $stmt) Returns the number of parameter markers present in the prepared statement.
PARAMETERS
o $ stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
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 ", 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. ", $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 ", 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. ", $marker); /* close statement */ mysqli_stmt_close($stmt); } /* close connection */ mysqli_close($link); ?> The above examples will output: Statement has 2 markers.
SEE ALSO
mysqli_prepare(3). PHP Documentation Group MYSQLI_STMT_PARAM_COUNT(3)
Related Man Pages
maxdb_stmt_param_count(3) - php
mysqli_stmt_data_seek(3) - php
mysqli_stmt_error_list(3) - php
mysqli_stmt_sqlstate(3) - php
mysqli_stmt.bind_result(3) - php
Similar Topics in the Unix Linux Community
foreach variable used in awk (please help!!)
if stmt argument expected error
If statement is not working in KSH
Printf statement
How to extract the sql from file?