{"id":9,"date":"2007-05-11T14:29:14","date_gmt":"2007-05-11T11:29:14","guid":{"rendered":"http:\/\/www.trirand.com\/blog\/?p=9"},"modified":"2011-04-12T21:04:28","modified_gmt":"2011-04-12T18:04:28","slug":"searchdb-plugin","status":"publish","type":"post","link":"http:\/\/www.trirand.com\/blog\/?p=9","title":{"rendered":"Searchdb Plugin"},"content":{"rendered":"

Searchdb<\/strong> is another jQuery plugin. The reason to write this plugin is that I’m a little be “lazy”. Imagine that you have a dynamic table (grid) or report in wich the user will search on many fields with diffrent criteria (equal, less, greater …). Constructing a form is a first problem. You must write so many tags and html code. The second and more importand problem is that I must analyze too much data passed to the server and construct it in a apropriate way in the WHERE clause of the SELECT statement. So, I think – will be possible to pass only one parameter (the search criteria) , which can be directly passed in the WHERE clause? My answer after little thik was – yes this can be done.
\n
\nI use again the best JS library jQuery<\/a> – remember the logo of jQuery – “Write less, do more”. Below is a little guide:<\/p>\n

This plugin creates a form of type condition – field value and return a string with a ready to use WHERE clause. Example: “name like ‘tony%’ and rating >= 1″.<\/p>\n

As usual the function can be placed in the document ready function to any html element.<\/p>\n

$(‘#search1′).searchdb({searchModel: [
\n{label:’Title’,dbname:’message_title’,defval:””, dtype:”S”, dopt:”cn;eq;lt;le;gt;ge;bw;ew”},
\n{label:’Autor’,dbname: ‘author’, dtype:”S”}
\n],
\ncapition: “Search Data Where”,
\nhideonSearch: false,
\ndisableClose: false,
\nonSearch: function(s) {
\nalert(s);
\n}
\n});<\/p>\n

searchModel:<\/strong> array of values which describes the form elements<\/p>\n