Amir asked 11 years ago
Hi, I am new user of phpgrid, evaluating it before license purchase.
I have a table with following fields:
id, personname, phone, email, dt
id field is unique auto increment.
dt field is timestamp with default of current_timestamp.
My code looks like this:
$g->table = "salespeople_sp";
$col = array();
$col["title"] = "Name";
$col["name"] = "personname";
$cols[] = $col;
$col["title"] = "Phone";
$col["name"] = "phone";
$cols[] = $col;
$col["title"] = "E-Mail";
$col["name"] = "email";
$cols[] = $col;
$col["title"] = "ID";
$col["name"] = "id";
//$col["viewable"] = false;
$col["hidden"] = true;
$cols[] = $col;
$col["title"] = "Date";
$col["name"] = "dt";
$col["viewable"] = false;
$col["hidden"] = true;
$cols[] = $col;
$g->set_columns($cols);
$out = $g->render("list1");
My problems are:
If I put the code for id column above the code for name column then the grid doesn't render with any value.
I am unable to edit the grid at all.
I am enable to add records. When I press the + button I get the popup with "Add Record" in header and two buttons, Submit & Cancel.
What am I doing wrong here?
Where can I find more examples of code?
Thanks
Amir
Amir answered 11 years ago
I have solved this problem, however I still have another one.
The first field in my grid is defined as follows:
$col = array();
$col["title"] = "active"; // caption of column
$col["name"] = "active"; // grid column name, same as db field or alias from sql
$col["viewable"] = true;
$col["hidden"] = false;
$col["editable"] = true;
$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>'0:No;1:Yes');
$cols[] = $col;
The second field is defined as follows:
$col["title"] = "Name"; // caption of column
$col["name"] = "personname"; // grid column name, same as db field or alias from sql
$col["viewable"] = true;
$cols[] = $col;
There are a few other fields set like the one above.
the problem is that when I try to edit a record, ALL the fields look like they are set to be in select mode.
It is as if the values of the previous field are not reset.
Amir answered 11 years ago
For prosperity and for the same of future searchers, the initialization of each $col must be done per column/field.
If you look at the code above you will see I only have
$col = array();
once and not for every column. Once the above line was entered in the code for each column all the reported issues were resolved.
Vincenzo answered 11 years ago
How you have solved the problem of empty ADD box?
I have the same problem.
Abu Ghufran answered 11 years ago
You need to set each editable column as
$col["editable"] = true;
$cols[] = $col;
