Add form is empty

QuestionsAdd form is empty
Amir asked 6 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;

$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?


5 Answers
Amir answered 6 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 6 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.

Abu Ghufran answered 6 years ago

Thanks for sharing amir.

Vincenzo answered 6 years ago

How you have solved the problem of empty ADD box?

I have the same problem.

Abu Ghufran answered 6 years ago

You need to set each editable column as

$col["editable"] = true;
$cols[] = $col;

Your Answer

14 + 15 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!