fm_sql_get_query_status


mixed fm_sql_get_query_status ( int $query_id )


 

Description


Allows you to get the status of a SQL query that was created using fm_sql_execute_on_idle.

 

Parameters


query_id (required)
A query id returned by fm_sql_execute_on_idle.

 

Return


Returns the query array or false if the query id doesn’t exist.

 

Errors


There are no errors for this function.

 

Example 1 - Print status array
print_r(fm_sql_get_query_status(1));
/*
Returns:
Array
(
    [Id] => 1
    [Created] => 2014-01-24 13:32:44
    [Status] => Complete
    [Query] => CREATE TABLE "Employee" (ID INT PRIMARY KEY, "Name"  VARCHAR(60))
    [FileName] => Test
    [Arguments] => Array
		(
		)
    [Completed] => 2014-01-24 13:32:52
    [Error] => 0
    [ErrorDescription] => 
)
*/

Change Log

VersionDescription
3.0.0New function – added to support the new fm_sql_execute_on_idle function.