Accessing part of database table ( predefined SELECT)
Accessing part of database table ( predefined SELECT)
Hi,
I am looking for an ajax call (pushing additional data or connecting href like myteam. php? user=id)so that i can transfer some predefined parameters for 'WHERE' 'key'='value' condition. This is to restrict the access for database table in use depends on user authority.
So the server call will fetching/editing only the selected part for each user. I am NOT looking for server side processing for the same.
[quote]Looking for any modification in php/javascript files that can do an additional " $VALUE AND" for $select string for all queries [/quote] . Suggestion invited please.
I am looking for an ajax call (pushing additional data or connecting href like myteam. php? user=id)so that i can transfer some predefined parameters for 'WHERE' 'key'='value' condition. This is to restrict the access for database table in use depends on user authority.
So the server call will fetching/editing only the selected part for each user. I am NOT looking for server side processing for the same.
[quote]Looking for any modification in php/javascript files that can do an additional " $VALUE AND" for $select string for all queries [/quote] . Suggestion invited please.
This discussion has been closed.
Replies
Allan
Thank you for the quick reply. But still i could not find out how to implement it.
1) If static page:
Suppose my Ajax URL is[quote] browsers.php? 'RenderingEngine'='Gecko' [/quote] ( as seen in editor examples).
I want my server should fetch only those rows where engine=='Gecko' from data base(MySQL).
What is modification i am supposed to do in browsers.php file.
2) onPreSubmit:
[code]
editor = new $.fn.dataTable.Editor( {
"ajaxUrl": "'php/browsers.php'",
"events": {
" onPreSubmit": function (data) {
/// How to pass strings 'engine' and 'Gecko' so that, it should be recognized by the server and only those rows which satisfy the condition WHERE 'engine'='Gecko' to be fetched ////
}
. .........................
}
[/code]
@Allen Please Help.
Regards
Vinod