Topic: Integration with

I was trying to integrate in FA.

Facing this error. May be some JS is conflicting. Can anyone help?

Re: Integration with

Basically I don't have idea about gridphp. But it looks the entire fa html content comes in the alert.. So it looks you are looking the js wrong way.

Subscription service based on FA
HRM CRM POS batch Themes

Re: Integration with

Lightweight AjaxCRUD is superb to integrate too.

Re: Integration with

Hello all,
I was able to integrate this.
Download and add it to the root folder of FA.

Copy the following code in the page where you want to show the Grid and set the $path_to_root with respect to the location of file.

 * PHP Grid Component
 * @author Abu Ghufran <> -
 * @version 2.0.0
 * @license: see license.txt included in package
 $page_security = 'SA_OPEN';
 include($path_to_root . "/includes/");


// include and create object
include_once ($path_to_root."/gridphp/lib/inc/jqgrid_dist.php");

$server = $db_connections[user_company()]['host'];
$user = $db_connections[user_company()]['dbuser'];
$password = $db_connections[user_company()]['dbpassword'];
$database = $db_connections[user_company()]['dbname'];

$db_conf = array(
                    "type"         => 'mysqli',
                    "server"     => $server,
                    "user"         => $user,
                    "password"     => $password,
                    "database"     => $database

$g = new jqgrid($db_conf);

$grid["rowNum"] = 10; // by default 20
$grid["sortname"] = 'id'; // by default sort grid by this field
$grid["caption"] = "Invoice Data"; // caption of grid
$grid["autowidth"] = false; // expand grid to screen width
$grid["multiselect"] = true; // allow you to multi-select through checkboxes
$grid["form"]["position"] = "center";
$grid["shrinkToFit"] = false;


                        "add"=>true, // allow/disallow add
                        "edit"=>true, // allow/disallow edit
                        "delete"=>true, // allow/disallow delete
                        "view"=>true, // allow/disallow delete
                        "rowactions"=>true, // show/hide row wise edit/del/save option
                        "search" => "advance", // show single/multi field search condition (e.g. simple or advance)
                        "showhidecolumns" => false

$g->select_command = "SELECT * FROM dimensions where id < 85";

$g->table = "dimensions";

// this db table will be used for add,edit,delete
$g->table = "invheader";

// pass the cooked columns to grid

// generate grid output, with unique grid name as 'list1'
$out = $g->render("list1");
page(_($help_context = "Dimensions"), false);
echo '<div style="margin:10px">';
echo $out;

Re: Integration with

In order to get GridPHP work in FA as expected I needed to comment out following line in

// html_cleanup($_REQUEST);

What could be the adverse affect of this?

Re: Integration with

This is just html decoding ,

Is there any more detail like what happens when you try it html clean

Subscription service based on FA
HRM CRM POS batch Themes