You should use …

if (!empty($_POST['from_date']))
{
$formate_from_date = explode('-', $_POST['from_date']);
$_SESSION['formatted_from_date'] = $formate_from_date[2].'-'.$formate_from_date[1].'-'.$formate_from_date[0];
}

Otherwise, the session variable will reset everytime.

This has solved the problem. Thank you so much 🙂

Hi Abu,

I have a similar problem. I'm posting, depending on input, one or more variables, with which I'm doing a select on a database table.

if($_POST['month']) { $date_end = $_POST['month']; } else { $date_end = date('Y-m-d'); }

Then the results (unique invoice numbers) are saved in an array.

$sql_re = "SELECT No FROM MyDatabase.MyTable WHERE (date_format(ServiceEnd, '%Y-%m') = date_format('$date_end', '%Y-%m')) ORDER BY No";
array_push($MyArray, $no);
In the select statement for the parent grid is a where clause with an comparison to the array with the invoice numbers.

$g->select_command = "SELECT DocNo FROM MyDatabase.MySecondTable WHERE No IN('".implode("','",$MyArray)."')";

I'm going the way round with the session, but nothing happens. Still only the first grid call(with default values in the select) is displayed, no matter which dates I changed. When hardcoded the stuff works.
Any idea?

regards

Michael

Try following code just before the $date_end setting.

if (!empty($_POST["month"]))
{
$_SESSION["month"] = $_POST["month"];
}
$month= $_SESSION["month"];

if($month) { $date_end = $month; } else { $date_end = date('Y-m-d'); }

Hi Abu,

no I don't think so.

$sql_re = "SELECT No FROM MyDatabase.MyTable WHERE (date_format(ServiceEnd, '%Y-%m') = date_format('$date_end', '%Y-%m')) ORDER BY No";
array_push($MyArray, $no);

The array with my invoice numbers is properly built after every POST and before the first grid stuff in my script. But the grid only does ONE selection, it ignores the posted data and the updated array.

$g->select_command = "SELECT DocNo FROM MyDatabase.MySecondTable WHERE No IN('".implode("','",$MyArray)."')";

I'm doin the session stuff before the grid select, after I read your note here, but it won't help.

session_start();
$_SESSION['MyArray'] = $MyArray;
$MyArray = $_SESSION["MyArray"];

The grid just doesn't refresh after the post. grmmpff

regards

Michael

The session work need to be done for the $_POST variables.

The grid is loaded with 2 server calls.

1) load the columns of grid.
2) do an ajax call, to load data of grid.

Now, if you want to pass data from external form, it is available for step1. But not there in 2nd ajax call, as it is not posted.
Solution is to put the POST variable in session and use it from session for step2.