Hello,
how to make a selection request with a condition on a field.
I wanted to do the following query in dhtmlx:
SELECT * FROM mytable WHERE some_my_field=‘toto’ using the methods render_xx of dhtmlxConnector.
Other things, how to retrieve the selected row on the grid and loaded into a form.
thank you for your help.
$sql = "SELECT * FROM mytable WHERE some_my_field='".$_GET["name"]."'";
$grid->render_sql($sql, "id", "fieldA, fieldB");
Other things, how to retrieve the selected row on the grid and loaded into a form.
There is a separate form connector class.
assuming that formdata.php is a form connector with render_table call ( there is no need in custom sql ), the next can be used on the client side
grid.attachEvent("onRowSelect", function(id){
form.load("formdata.php?id="+id);
})
Thank you for your promt response Stanislav !!!
it works properly, it is necessary to use the same logic to make a request
UDATE my_table SET my_field=some_field, my_field=some_field, my_field=some_field WHERE id= my_id ??
other things, is that it is always the instruction:
$form->render_table(“annee”,“id”,“nom,iscurrent,islocked,debut,fin”);
which will be on file formdata.php?id="+id ??
excuse me for my language level.
Normally connecto will try to place all WHERE rules in UPDATE command as well, but you can define a custom sql if necessary