Book Image

jQuery 1.3 with PHP

Book Image

jQuery 1.3 with PHP

Overview of this book

To make PHP applications that respond quickly, avoid unnecessary page reloads, and provide great user interfaces, often requires complex JavaScript techniques and even then, if you get that far, they might not even work across different browsers! With jQuery, you can use one of the most popular JavaScript libraries, forget about cross-browser issues, and simplify the creation of very powerful and responsive interfaces ñ all with the minimum of code. This is the first book in the market that will ease the server-side PHP coder into the client-side world of the popular jQuery JavaScript library. This book will show you how to use jQuery to enhance your PHP applications, with many examples using jQuery's user interface library jQuery UI, and other examples using popular jQuery plugins. It will help you to add exciting user interface features to liven up your PHP applications without having to become a master of client-side JavaScript. This book will teach you how to use jQuery to create some really stunning effects, but without you needing to have in-depth knowledge of how jQuery works. It provides you with everything you need to build practical user interfaces for everything from graphics manipulation to drag-and-drop to data searching, and much more. The book also provides practical demonstrations of PHP and jQuery and explains those examples, rather than starting from how JavaScript works and how it is different from PHP. By the end of this book, you should be able to take any PHP application you have written, and transform it into a responsive, user-friendly interface, with capabilities you would not have dreamed of being able to achieve, all in just a few lines of JavaScript.
Table of Contents (16 chapters)
jQuery 1.3 with PHP
Credits
About the Author
About the Reviewers
Preface
Index

Filtering


Of course, no data table is complete without filtering. There's no point having a few million results if you can't narrow it down to a manageable level.

The URL string we're working with includes a number of sSearch parameters: the sSearch parameter itself and an sSearch_0/1/2/3 parameter for each of the table columns. We will only use the main sSearch in this chapter's example.

In our example, we will take the string we're given, and match it against the beginning of the city name field, and if there are exactly two letters, will also match it against the country.

Server-side code

First, we need to set up MySQL's where clause. Add this to the "initialize variables" section of get_data.php:

// { search 
$search_sql=''; 
if(isset($_REQUEST['sSearch']) && ''!=$_REQUEST['sSearch']){ 
  $stext=addslashes($_REQUEST['sSearch']); 
  $search_sql='where '; 
  if(strlen($stext)==2) $search_sql.="ccode='$stext' or "; 
                        $search_sql.="city like '$stext%'"; 
} 
// ...