Here’s the $_SESSION method.

RE: Method 1.
I recognize there are potential issues with using $_REQUEST. Hence, the name of the variable.

IN RE: whether the parameter is passed, that should handled correctly by the following code, shouldn’t it be?

$jvs_user_id = $_REQUEST[‘jvs_user_id’] ;
$param1 = (isset($jvs_user_id)) ? $jvs_user_id : $USER->id ;
..
$grid->setUrl(‘grid_center.php?jvs_user_id=’.$param1);

On the first execution, the $_REQUEST should not have the jvs_user_id value, but the $USER->id, set by the Moodle environment, should be set. This is then assigned to $param1 and passed to the $_GET variable.

On the 2nd execution at invocation, as a result, the $_REQUEST will have the variable value set and will be used to set the $param1 variable

$grid->SelectCommand = ‘SELECT id, ‘ .
..
‘FROM mdl_centerstatus ‘ .
“WHERE user_id = ” . $param1 ;

When I generate my own log file and store the resulting SQL statement to it, on the second call, it is properly structured with the WHERE clause. And, when I bring that into phpMyAdmin, the query returns the correct row.

However, this is what I get in the jqGrid.log file:

Executed 1 query(s) – 2015-05-18 13:30:40
Array
(
[0] => Array
(
[time] => 2015-05-18 13:30:40
[query] => SELECT id, user_id, cohort_id, cohort_name, date_course_complete, gospel_pres_prv_yr, gospel_pres_m_1, gospel_pres_m_2, gospel_pres_m_3, gospel_pres_m_4, gospel_pres_m_5, gospel_pres_m_6, gospel_pres_tot_m_6, preg_test_prv_yr, preg_test_m_1, preg_test_m_2, preg_test_m_3, preg_test_m_4, preg_test_m_5, preg_test_m_6, preg_test_tot_m_6, commit_prv_yr, commit_m_1, commit_m_2, commit_m_3, commit_m_4, commit_m_5, commit_m_6, commit_tot_m_6, complete_date_m_6, grant_date FROM mdl_centerstatus WHERE user_id = ? ORDER BY cohort_name asc LIMIT 0, 10
[data] => Array
(
[0] =>
)

[types] =>
[fields] =>
[primary] =>
[input] =>
)

)

It appears to me that the SQL statement is executed only once.

Why is that?