You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I've created SQL tables for selective options and added the respective lines on loaddata.php file. The syntax is the same as the demo ones (continent and country) except for the data and table names and id. Only the first one works the others make the grid go blank when respective lines are uncommented. What could possibly be wrong?
I belive it's a code error on my database...
$grid->addColumn('id', 'ID', 'integer', NULL, false);
$grid->addColumn('firstname', 'Nome', 'string');
$grid->addColumn('name', 'Sobrenome', 'string');
$grid->addColumn('id_clienttype', 'Tipo de cliente', 'string', fetch_pairs($mysqli, 'SELECT id, name FROM clienttype'), true);
$grid->addColumn('phone', 'Telefone', 'string');
$grid->addColumn('email', 'Email', 'email');
$grid->addColumn('id_seller', 'Assistente comercial', 'string' , fetch_pairs($mysqli, 'SELECT id, name FROM seller'), true);
$grid->addColumn('firstdate', 'Data de abordagem', 'date');
$grid->addColumn('id_packtype', 'Tipo de pacote', 'string' , fetch_pairs($mysqli, 'SELECT id, name FROM packtype'), true);
$grid->addColumn('id_packstate', 'Estado do pacote', 'string' , fetch_pairs($mysqli, 'SELECT id, name FROM packstate'), true);
$grid->addColumn('packdate', 'Data do pacote', 'date');
$grid->addColumn('obs', 'Observações', 'string');
I've created SQL tables for selective options and added the respective lines on loaddata.php file. The syntax is the same as the demo ones (continent and country) except for the data and table names and id. Only the first one works the others make the grid go blank when respective lines are uncommented. What could possibly be wrong?
I belive it's a code error on my database...
$grid->addColumn('id', 'ID', 'integer', NULL, false);
$grid->addColumn('firstname', 'Nome', 'string');
$grid->addColumn('name', 'Sobrenome', 'string');
$grid->addColumn('id_clienttype', 'Tipo de cliente', 'string', fetch_pairs($mysqli, 'SELECT id, name FROM clienttype'), true);
$grid->addColumn('phone', 'Telefone', 'string');
$grid->addColumn('email', 'Email', 'email');
$grid->addColumn('id_seller', 'Assistente comercial', 'string' , fetch_pairs($mysqli, 'SELECT id, name FROM seller'), true);
$grid->addColumn('firstdate', 'Data de abordagem', 'date');
$grid->addColumn('id_packtype', 'Tipo de pacote', 'string' , fetch_pairs($mysqli, 'SELECT id, name FROM packtype'), true);
$grid->addColumn('id_packstate', 'Estado do pacote', 'string' , fetch_pairs($mysqli, 'SELECT id, name FROM packstate'), true);
$grid->addColumn('packdate', 'Data do pacote', 'date');
$grid->addColumn('obs', 'Observações', 'string');
Here is a copy of the sql file in txt format
pharmacu_ema.txt
The text was updated successfully, but these errors were encountered: