[edit] Last updated: Fri, 17 May 2013

mysqli_stmt::close

mysqli_stmt_close

(PHP 5)

mysqli_stmt::close -- mysqli_stmt_close — Closes a prepared statement

Descrição

Estilo orientado à objeto

bool mysqli_stmt::close ( void )

Estilo procedural

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.

Parâmetros

stmt: Procedural style only: A statement identifier returned by mysqli_stmt_init().

Valor Retornado

Retorna TRUE em caso de sucesso ou FALSE em caso de falha.

Veja Também

mysqli_prepare() - Prepare an SQL statement for execution

add a note User Contributed Notes mysqli_stmt::close - [1 notes]

down

daniel dot kipp at web dot de ¶

7 years ago


if you are repeating an statement in an loop using bind_param and so on inside it for a larger operation. i thougt id would be good to clean it with stmt->close. but it broke always with an error after aprox. 250 operations . As i tried it with  stmt->reset it worked for me.

add a note