I woud like to use a temporary table in grid, any example to implement it?
What you can do it to create temporary table using same database connection which phpgrid is using. Now when you use that connection in select_command querying temp table, it will find it and work.
$sql_temp_table = “CREATE TEMPORARY TABLE tableCosts …. “;
$d = new jqgrid();
Now use your normal select query in select_command.
$sqlMain = “SELECT … FROM tableCosts”;
$d->select_command = $sqlMain;
Hope it help.
Abu Ghufran - Dev Team
Grid 4 PHP Framework
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?