Hello,
How to set a composite primary key for a "All in One" approach (grid defined in JS file, and data using jqGridEdit Class in php file) ?
Please, for me a composite primary key of a table T, is a elementary primary key that is defined with some fields belong to this table T !
Here is my test, but i get no data and cannot use the CRUD operations :
In my JS file i have this lines code:
...
colModel":[
{"name":"index","index":"index","label":"index"}, // <= THAT'S JUST THE INDEX OF MY TABLE
{"name":"user","index":"user","label":"user","key":true}, // <= A PART OF MY COMPOSITE PRIMARY KEY
{"name":"pwd","index":"pwd","label":"pwd","key":true}, // <= A PART OF MY COMPOSITE PRIMARY KEY
{"name":"state","index":"state","label":"state","key":true}, // <= A PART OF MY COMPOSITE PRIMARY KEY
... <= AND SO ON
"url":"mygrid_crud.php",
"datatype":"json",
"jsonReader":{repeatitems:false},
"editurl": "mygrid_crud.php",
"prmNames":{"id":"index"} // <= WHAT I NEED TO WRITE HERE ???
...
In my php file (mygrid_crud.php) :
...
$grid = new jqGridEdit($conn);
$query = "SELECT * FROM mytable WHERE user='$user' and pwd='$pwd' and state='$state'..."; // <= SELECT * it's ok or i need to specify all fields i need ?
$grid->SelectCommand = $query;
$grid->dataType = "json";
$grid->table = 'mytable';
$grid->setPrimaryKeyId('index'); // <= WHAT I NEED TO WRITE HERE ???
...
$grid->editGrid();
Please, say me what is wrong, and how to do to set a composite primary key in this approach !?
Thank you so much for tour responses.