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

Version	Description
3.0.0	New function – added to support the new fm_sql_execute_on_idle function.