(PHP 5, PHP 7) Closes a prepared statement bool mysqli_stmt::close ( void ) Object oriented style Procedural style bool mysqli_stmt_close ( mysqli_stmt $stmt ) Closes a prepared statement. mysqli_stmt_close() also deallocates the statement handle. If the current statement has pending or unread results, this function cancels them so that the next query can be executed. Parameters: stm

(PHP 5, PHP 7) Constructs a new mysqli_stmt object mysqli_stmt::__construct ( mysqli $link [, string $query ] ) This method constructs a new mysqli_stmt object. Note: In general, you should use either mysqli_prepare() or mysqli_stmt_init() to create a mysqli_stmt object, rather than directly instantiating the object with new mysqli_stmt. This method (and the ability to directly instantiate mysqli_stmt objects) may be deprecated and remov

(PHP 5, PHP 7) Binds variables to a prepared statement for result storage bool mysqli_stmt::bind_result ( mixed &$var1 [, mixed &$... ] ) Object oriented style Procedural style bool mysqli_stmt_bind_result ( mysqli_stmt $stmt , mixed &$var1 [, mixed &$... ] ) Binds columns in the result set to variables. When mysqli_stmt_fetch() is called to fetch data, the MySQL client/server protocol places the data for

(PHP 5, PHP 7) Binds variables to a prepared statement as parameters bool mysqli_stmt::bind_param ( string $types, mixed &$var1 [, mixed &$... ] ) Object oriented style Procedural style bool mysqli_stmt_bind_param ( mysqli_stmt $stmt , string $types , mixed &$var1 [, mixed &$... ] ) Bind variables for the parameter markers in the SQL statement that was passed to mysqli_prepare(). Note: If data size of a

(PHP 5, PHP 7) Returns whether thread safety is given or not bool mysqli_thread_safe ( void ) Procedural style Tells whether the client library is compiled as thread-safe. Returns: TRUE if the client library is thread-safe, otherwise FALSE.

(PHP 5, PHP 7) Returns the number of warnings from the last query for the given link int mysqli_warning_count ( mysqli $link ) Object oriented style int $mysqli->warning_count; Procedural style Returns the number of warnings from the last query in the connection. Note: For retrieving warning messages you can use the SQL command SHOW WARNINGS [limit row_count]. Parameters: lin

(PHP 5, PHP 7) Used to modify the behavior of a prepared statement bool mysqli_stmt::attr_set ( int $attr, int $mode ) Object oriented style Procedural style bool mysqli_stmt_attr_set ( mysqli_stmt $stmt , int $attr , int $mode ) Used to modify the behavior of a prepared statement. This function may be called multiple times to set several attributes. Parameters: stmt Proc

(PHP 5, PHP 7) Returns the total number of rows changed, deleted, or inserted by the last executed statement int mysqli_stmt_affected_rows ( mysqli_stmt $stmt ) Object oriented style int $mysqli_stmt->affected_rows; Procedural style Returns the number of rows affected by INSERT, UPDATE, or DELETE query. This function only works with queries which update a table. In order to get the number of rows from a SELECT query,

(PHP 5, PHP 7) Used to get the current value of a statement attribute int mysqli_stmt::attr_get ( int $attr ) Object oriented style Procedural style int mysqli_stmt_attr_get ( mysqli_stmt $stmt , int $attr ) Gets the current value of a statement attribute. Parameters: stmt Procedural style only: A statement identifier returned by mysqli_stmt_init().

(PHP 5, PHP 7) Initiate a result set retrieval mysqli_result mysqli::use_result ( void ) Object oriented style Procedural style mysqli_result mysqli_use_result ( mysqli $link ) Used to initiate the retrieval of a result set from the last query executed using the mysqli_real_query() function on the database connection. Either this or the mysqli_store_result() function must be called before the results of a query can be ret