varun asked 11 years ago
Hi,
As per shown in your examples in add/edit,i am able to do,get_dropdown_values("select distinct EmployeeID as k,EmployeeName as v from emptable");
where as i need to customize this,i will be getting Value from URL as $variable=$_GET['EmpAge'];
so,i want to display the above query as "Select distinct EmployeeID as k,EmployeeName as v from emptable where EmpAge='$variable'";
i am not able to put the querystring into this set_dropdown_values,why?
can u provide me assistance of using URL variable in dropdown_value query
Thank u.
Abu Ghufran answered 11 years ago
Checkout faq.
##### Q) How to load grid based on $_POST data from other page?
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.
e.g.
if (!empty($_POST["personid"]))
{
$_SESSION["personid"] = $_POST["personid"];
}
$pid = $_SESSION["personid"];
and use `$pid` in your SQL.
