API tools faq
paste
tomexsans

Untitled

tomexsans
Feb 22nd, 2012
566
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.92 KB | None | 0 0
raw download clone embed print report
  1. //================My Database===============
  2. /*
  3.  
  4.  
  5. CREATE TABLE IF NOT EXISTS `city` (
  6.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  7.   `Name` char(35) NOT NULL DEFAULT '',
  8.   `CountryCode` char(3) NOT NULL DEFAULT '',
  9.   `District` char(20) NOT NULL DEFAULT '',
  10.   `Population` int(11) NOT NULL DEFAULT '0',
  11.   PRIMARY KEY (`ID`),
  12.   KEY `CountryCode` (`CountryCode`)
  13. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4083 ;
  14.  
  15.  
  16. */
  17.  
  18. // ============================= Country.php ========================
  19.  mysql_connect('localhost', 'root', '')or die(mysql_error());
  20. mysql_select_db('testdb');
  21. $page = 1;  // The current page
  22. $sortname = 'id';    // Sort column
  23. $sortorder = 'asc';  // Sort order
  24. $qtype = '';     // Search column
  25. $query = '';     // Search string
  26.  
  27. // Get posted data
  28.     if (isset($_POST['page'])) {
  29. $page = mysql_real_escape_string($_POST['page']);
  30. }
  31. if (isset($_POST['sortname'])) {
  32. $sortname = mysql_real_escape_string($_POST['sortname']);
  33. }
  34. if (isset($_POST['sortorder'])) {
  35. $sortorder = mysql_real_escape_string($_POST['sortorder']);
  36. }
  37. if (isset($_POST['qtype'])) {
  38. $qtype = mysql_real_escape_string($_POST['qtype']);
  39. }
  40. if (isset($_POST['query'])) {
  41. $query = mysql_real_escape_string($_POST['query']);
  42. }
  43. if (isset($_POST['rp'])) {
  44. $rp = mysql_real_escape_string($_POST['rp']);
  45. }
  46.    
  47. // Setup sort and search SQL using posted data
  48.     $sortSql = "order by $sortname $sortorder";
  49.     $searchSql = ($qtype != '' && $query != '') ? "where $qtype = '$query'" : '';
  50.    
  51. // Get total count of records
  52.     $sql = "select count(*)
  53.     from city
  54.     $searchSql";
  55.     $result = mysql_query($sql);
  56.     $row = mysql_fetch_array($result);
  57.     $total = $row[0];
  58.    
  59. // Setup paging SQL
  60.     $pageStart = ($page-1)*$rp;
  61.     $limitSql = "limit $pageStart, $rp";
  62.    
  63. // Return JSON data
  64.     $data = array();
  65.     $data['page'] = $page;
  66.     $data['total'] = $total;
  67.     $data['rows'] = array();
  68.     $sql = "select *
  69.     from city
  70.     $searchSql
  71.     $sortSql
  72.     $limitSql";
  73.     $results = mysql_query($sql);
  74.     while ($row = mysql_fetch_assoc($results)) {
  75.     $data['rows'][] = array(
  76.     'id' => $row['ID'],
  77.     'cell' => array($row['CountryCode'], $row['Name'], $row['District'], $row['Population'])
  78.     );
  79.     }
  80.     echo json_encode($data);
  81.  
  82. //============================ Index.php ========================================
  83.  
  84. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  85. <html>
  86. <head>
  87. <link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/themes/base/jquery-ui.css" type="text/css" />
  88.     <script type="text/javascript" src="https://www.google.com/jsapi"></script>
  89.     <script type="text/javascript">
  90.         google.load("jquery", "1.7.1");
  91.         google.load("jqueryui", "1.8.16");
  92.     </script>
  93.     <script type="text/javascript" src="js/flexigrid.js"></script>
  94.     <link rel="stylesheet" type="text/css" href="css/flexigrid.css">
  95. </head>
  96. <body>
  97.     <script type="text/javascript">
  98.         /*
  99.         $(document).ready(function(){
  100.             alert("jQUery Is Good");
  101.         });
  102.         */
  103.     </script>
  104.    
  105.     <script type="text/javascript">
  106.         $("#flex1").flexigrid({
  107.     url: 'country.php',
  108.     dataType: 'json',
  109.     colModel : [
  110.         {display: 'Country Code', name : 'CountryCode', width : 40, sortable : true, align: 'center'},
  111.         {display: 'City', name : 'Name', width : 180, sortable : true, align: 'left'},
  112.         {display: 'District', name : 'District', width : 120, sortable : true, align: 'left'},
  113.         {display: 'Population', name : 'Population', width : 130, sortable : true, align: 'left', hide: true},
  114.         ],
  115.     buttons : [
  116.         {name: 'Add', bclass: 'add'},
  117.         {name: 'Delete', bclass: 'delete'},
  118.         {separator: true}
  119.         ],
  120.     searchitems : [
  121.         {display: 'Country Code', name : 'CountryCode'},
  122.         {display: 'City', name : 'Name', isdefault: true}
  123.         ],
  124.     sortname: "ID",
  125.     sortorder: "asc",
  126.     usepager: true,
  127.     title: 'Countries',
  128.     useRp: true,
  129.     rp: 15,
  130.     showTableToggleBtn: true,
  131.     width: 700,
  132.     height: 200
  133.     });  
  134.    
  135.     </script>
  136.    
  137.     <div id="flex1"></div>
  138.  
  139.  
  140. </body>
  141. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!