PreviousNext
Help > API Functions > SQL Queries & Procedures > i5_free_query
i5_free_query

 

 Frees SQL request result.

 

       bool i5_free_query (resource query)

 

 

Parameters

 

query

Request ID

 

Return

 

True if OK, false if failed. 

 

I5_ERR_PHP_HDLDFT

256

No default connection found.

I5_ERR_PHP_OPTIONSTYPE

259

The type of " I5_OPTIONS_ALIAS" option must be x and not x

I5_ERR_PHP_OPTIONSNUMBER

260

Option number -1 is unknown.

I5_ERR_PHP_TYPEPARAM

262

Type of element x in parameter -1 must be y. Type z was provided.

 

 Details

 

Removes a query type resource (i5_query or i5_execute) from memory

i5_free_query needs only to be called if you fear that your script requires too much memory, when a request returns very large results or if a large requests number are processed and may overload the web server memory. Its use is recommended as cleaner.

All memory resources required by a script are freed as the script ended.

 

Example

 

 

$sql = "SELECT * FROM BIGTABLE";

$query = i5_query($sql);

...

$res = i5_free_query($query);

...

 

See also

 

i5_query

i5_execute

i5_free_file