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 styleSYNOPSISint$mysqli_stmt->param_count ()DESCRIPTIONProcedural style int mysqli_stmt_param_count (mysqli_stmt $stmt) Returns the number of parameter markers present in the prepared statement.PARAMETERSo $ stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).RETURN VALUESReturns an integer representing the number of parameters.EXAMPLESExample #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 ALSOmysqli_prepare(3). PHP Documentation Group MYSQLI_STMT_PARAM_COUNT(3)
Related Man Pages |
---|
mysqli_stmt_execute(3) - php |
mysqli_stmt_error(3) - php |
mysqli_stmt_store_result(3) - php |
mysqli_stmt_data_seek(3) - php |
mysqli_stmt_num_rows(3) - php |
Similar Topics in the Unix Linux Community |
---|
Please explain the stmt |
stucking when using printf with awk |
foreach variable used in awk (please help!!) |
if stmt argument expected error |
How to extract the sql from file? |