API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 2nd, 2013
151
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 12.05 KB | None | 0 0
raw download clone embed print report
  1. <?
  2. $radio = $_GET['radio'];
  3.     // TABLES T BE SEARCHED
  4.     switch ($_GET['radio'])      
  5.     {  
  6. case 1:
  7.  
  8. //A) IF THE USER SELECTED A CATEGORY AND A REGION  
  9. if ($id_cat != 'any' AND $id_reg!='any') {
  10.    
  11. $sql = "SELECT COUNT(*) as total FROM reports AS T1, sector_index_reports AS T2, country_index_reports AS T3 WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ($id_reg) AND (T1.id=T3.id_obiekt)  AND ".$name_clause ;
  12.  
  13. $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports AS T1, sector_index_reports AS T2, country_index_reports AS T3 WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ($id_reg) AND (T1.id=T3.id_obiekt)  AND ".$name_clause." LIMIT" ; }
  14.  
  15. //B)IF THE USER SELECTED ONLY A CATEGORY
  16. else if ($id_cat != 'any' AND $id_reg =='any') {
  17.  
  18. $sql1 = "SELECT COUNT(*) as total FROM reports AS T1, sector_index_reports AS T2  WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ".$name_clause ;
  19.    
  20. $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports AS T1, sector_index_reports AS T2  WHERE
  21. ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ".$name_clause." LIMIT" ;
  22.  
  23.  }     
  24.              
  25. //C)IF THE USER SELECTED ONLY REGION
  26. else if ($id_cat == 'any' AND $id_reg!='any') {
  27.    
  28. $sql1 = "SELECT COUNT(*) as total FROM reports AS T1, country_index_reports AS T3 WHERE  ($id_reg) AND (T1.id=T3.id_obiekt) AND ".$name_clause ;
  29.  
  30. $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports AS T1, country_index_reports AS T3 WHERE  
  31. ($id_reg) AND (T1.id=T3.id_obiekt) AND ".$name_clause." LIMIT" ;
  32.  
  33.  
  34.  }
  35.      
  36. // D)GENERAL SEARCH, NOT APPLYING FILTERS
  37.  
  38. else if ($id_cat == 'any' AND $id_reg == 'any')
  39. {  $sql1 = "SELECT COUNT(*) as total FROM reports WHERE ".$name_clause;
  40.    $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports WHERE ".$name_clause." LIMIT"; }
  41.  
  42.      
  43. break; 
  44. // END FOR MARKET REPORT TITLES OPTIONS        
  45.            
  46. case 2:
  47.  
  48. //A) IF THE USER SELECTED A CATEGORY AND A REGION          
  49. if ($id_cat != 'any' AND $id_reg!='any') {
  50.    
  51. $sql1 = "SELECT COUNT(*) as total FROM swots AS T1, sector_index_reports AS T2, country_index_reports AS T3 WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ($id_reg) AND (T1.id=T3.id_obiekt)  AND ".$name_clause ;
  52.  
  53. $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM swots AS T1, sector_index_reports AS T2, country_index_reports AS T3 WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ($id_reg) AND (T1.id=T3.id_obiekt)  AND ".$name_clause." LIMIT" ;
  54.  
  55.  }
  56.  
  57. //B)IF THE USER SELECTED ONLY A CATEGORY
  58. else if ($id_cat != 'any' AND $id_reg =='any') {
  59.    
  60. $sql1 = "SELECT COUNT(*) as total FROM swots AS T1, sector_index_reports AS T2  WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ".$name_clause ;
  61.  
  62. $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM swots AS T1, sector_index_reports AS T2  WHERE
  63. ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ".$name_clause." LIMIT" ;
  64.  
  65.  
  66.  }     
  67.              
  68. //C)IF THE USER SELECTED ONLY REGION
  69. else if ($id_cat == 'any' AND $id_reg!='any') {
  70.  
  71. $sql1 = "SELECT COUNT(*) as total FROM swots AS T1, country_index_reports AS T3 WHERE ($id_reg) AND (T1.id=T3.id_obiekt) AND ".$name_clause ;
  72.  
  73. $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM swots AS T1, country_index_reports AS T3 WHERE  
  74. ($id_reg) AND (T1.id=T3.id_obiekt) AND ".$name_clause." LIMIT" ;
  75.  
  76. }
  77.  
  78.  
  79. // D)GENERAL SEARCH, NOT APPLYING FILTERS
  80.  
  81. else if ($id_cat == 'any' AND $id_reg == 'any') {
  82.  $sql1 = "SELECT COUNT(*) as total FROM swots WHERE ".$name_clause ;  
  83.  $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM swots WHERE ".$name_clause." LIMIT" ;  
  84.  
  85.  }
  86.  
  87.      
  88. break; 
  89. // END FOR SWOTS OPTIONS       
  90.            
  91.            
  92.  
  93. case 3:
  94.        
  95.             //A) IF THE USER SELECTED A CATEGORY AND A REGION  
  96.             if ($id_cat != 'any' AND $id_reg!='any') {
  97.                 $sql1 = "SELECT COUNT(*) as total FROM reports AS T1, sector_index_reports AS T2, country_index_reports AS T3 WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ($id_reg) AND (T1.id=T3.id_obiekt)  AND ((".$name_clause.") OR (".$description_clause.") OR (".$table_clause."))";
  98.                
  99.                
  100.                 $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports AS T1, sector_index_reports AS T2, country_index_reports AS T3 WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND  ($id_reg) AND (T1.id=T3.id_obiekt)  AND ((".$name_clause.") OR (".$description_clause.") OR (".$table_clause.")) LIMIT ";
  101.             }
  102.             //B)IF THE USER SELECTED ONLY A CATEGORY
  103.             else if ($id_cat != 'any' AND $id_reg =='any') {
  104.                 $sql1 = "SELECT COUNT(*) as total FROM reports AS T1, sector_index_reports AS T2  WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND ((".$name_clause.") OR (".$description_clause.") OR (".$table_clause."))";
  105.                 $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports AS T1, sector_index_reports AS T2  WHERE ($id_cat) AND  (T1.id=T2.id_obiekt) AND ((".$name_clause.") OR (".$description_clause.") OR (".$table_clause.")) LIMIT ";
  106.             }
  107.             //C)IF THE USER SELECTED ONLY REGION
  108.             else if ($id_cat == 'any' AND $id_reg!='any') {
  109.                 $sql1 = "SELECT COUNT(*) as total FROM reports AS T1, country_index_reports AS T3 WHERE  ($id_reg) AND (T1.id=T3.id_obiekt) AND ((".$name_clause.") OR (".$description_clause.") OR (".$table_clause."))";
  110.                 $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports AS T1, country_index_reports AS T3 WHERE  ($id_reg) AND (T1.id=T3.id_obiekt) AND ((".$name_clause.") OR (".$description_clause.") OR (".$table_clause.")) LIMIT ";
  111.             }
  112.             // D)GENERAL SEARCH, NOT APPLYING FILTERS
  113.             else if ($id_cat == 'any' AND $id_reg == 'any')  {
  114.                 $sql1 = "SELECT COUNT(*) as total FROM reports WHERE (".$name_clause.") OR (".$description_clause.") OR (".$table_clause.")";  
  115.                 $sql2 = "SELECT id,name,organizer_id,no_pages,publication_date,price,currency  FROM reports WHERE (".$name_clause.") OR (".$description_clause.") OR (".$table_clause.") LIMIT ";
  116.             }
  117.             break;
  118.            
  119.             // END FOR ALL CONTENT
  120.  
  121.         default:
  122.             trigger_error('SCRIPT UNDER ATTACK, RUN LIKE HELL', E_USER_ERROR);
  123.     }
  124.   // DEBUGGING INFORMATION TO SHOW THE REQUEST DATA AND THE RESULTING QUERY
  125.  
  126.  
  127.  $res = $mysqli->query($sql1);
  128.  
  129.  
  130. // IF mysqli_query() RETURNS FALSE, LOG AND SHOW THE ERROR
  131. if (!$res)
  132. {
  133.     $err
  134.     = "QUERY FAIL: "
  135.     . $sql
  136.     . ' ERRNO: '
  137.     . $mysqli->errno
  138.     . ' ERROR: '
  139.     . $mysqli->error
  140.     ;
  141.     trigger_error($err, E_USER_ERROR);
  142. }
  143. // IF WE GET THIS FAR, THE QUERY SUCCEEDED AND WE HAVE A RESULT OBJECT IN $res
  144. // AND SO WE CAN NOW USE $res IN OTHER MYSQLI FUNCTIONS
  145.  
  146.  
  147. // DETERMINE HOW MANY ROWS OF RESULTS WE GOT
  148. $num     = $res->fetch_assoc();
  149. $total_pages=(int)$num['total'];
  150. $res->free();
  151.  
  152. $num_fmt = number_format($num['total']);
  153. if (!$num)
  154. {
  155.     echo "<br/>QUERY: $sq2 ";
  156.     echo "<br/>FOUND NO DATA ";
  157.     echo PHP_EOL;
  158. }
  159. else
  160. {
  161.     echo "<br/>QUERY: $sql2 ";
  162.     echo "<br/>FOUND $num_fmt ROWS OF DATA ";
  163.     echo PHP_EOL;
  164. }
  165. echo PHP_EOL;
  166.  
  167.  
  168.  
  169.     echo "<TABLE cellspacing=\"3\" border=\"1\" cellpadding=\"8\">\n";
  170.    
  171.     echo "</TR>\n";
  172.  
  173.  
  174. ?>
  175.  
  176. <?php  ///// PAGINATION CODE STARTS
  177.    
  178. $valorpaginacion = "keyword=$url_pagination&categories=$id_cat_paginacion&regions=$id_reg_paginacion&radio=$radio" ;
  179. var_dump($valorpaginacion);
  180. var_dump($keywords);
  181.     // How many adjacent pages should be shown on each side?
  182.     $adjacents = 3;
  183.    
  184.     /* Setup vars for query. */
  185.     $targetpage = "search3.php";    //your file name  (the name of this file)
  186.     $limit = 50;                                //how many items to show per page
  187.     $page = $_GET['page'];
  188.     if($page)
  189.         $start = ($page - 1) * $limit;          //first item to display on this page
  190.     else
  191.         $start = 0;                             //if no page var is given, set start to 0
  192.    
  193.     /* Get data. */
  194.    
  195.    
  196.     /* Setup page vars for display. */
  197.     if ($page == 0) $page = 1;                  //if no page var is given, default to 1.
  198.     $prev = $page - 1;                          //previous page is page - 1
  199.     $next = $page + 1;                          //next page is page + 1
  200.     $lastpage = ceil($total_pages/$limit);      //lastpage is = total pages / items per page, rounded up.
  201.     $lpm1 = $lastpage - 1;                      //last page minus 1
  202.    
  203.    
  204.     $res= $mysqli->query($sql2 .$start.','. $limit);
  205.  
  206.     /*
  207.         Now we apply our rules and draw the pagination object.
  208.         We're actually saving the code to a variable in case we want to draw it more than once.
  209.     */
  210.     $pagination = "";
  211.     if($lastpage > 1)
  212.     {  
  213.         $pagination .= "<div class=\"pagination\">";
  214.         //previous button
  215.         if ($page > 1)
  216.             $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$prev\"><< previous</a>";
  217.         else
  218.             $pagination.= "<span class=\"disabled\"><< previous</span>";   
  219.        
  220.         //pages
  221.         if ($lastpage < 7 + ($adjacents * 2))   //not enough pages to bother breaking it up
  222.         {  
  223.             for ($counter = 1; $counter <= $lastpage; $counter++)
  224.             {
  225.                 if ($counter == $page)
  226.                     $pagination.= "<span class=\"current\">$counter</span>";
  227.                 else
  228.                     $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$counter\">$counter</a>";                   
  229.             }
  230.         }
  231.         elseif($lastpage > 5 + ($adjacents * 2))    //enough pages to hide some
  232.         {
  233.             //close to beginning; only hide later pages
  234.             if($page < 1 + ($adjacents * 2))       
  235.             {
  236.                 for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
  237.                 {
  238.                     if ($counter == $page)
  239.                         $pagination.= "<span class=\"current\">$counter</span>";
  240.                     else
  241.                         $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$counter\">$counter</a>";                   
  242.                 }
  243.                 $pagination.= "...";
  244.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$lpm1\">$lpm1</a>";
  245.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$lastpage\">$lastpage</a>";     
  246.             }
  247.             //in middle; hide some front and some back
  248.             elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
  249.             {
  250.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=1\">1</a>";
  251.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=2\">2</a>";
  252.                 $pagination.= "...";
  253.                 for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
  254.                 {
  255.                     if ($counter == $page)
  256.                         $pagination.= "<span class=\"current\">$counter</span>";
  257.                     else
  258.                         $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$counter\">$counter</a>";                   
  259.                 }
  260.                 $pagination.= "...";
  261.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$lpm1\">$lpm1</a>";
  262.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$lastpage\">$lastpage</a>";     
  263.             }
  264.             //close to end; only hide early pages
  265.             else
  266.             {
  267.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=1\">1</a>";
  268.                 $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=2\">2</a>";
  269.                 $pagination.= "...";
  270.                 for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
  271.                 {
  272.                     if ($counter == $page)
  273.                         $pagination.= "<span class=\"current\">$counter</span>";
  274.                     else
  275.                         $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$counter\">$counter</a>";                   
  276.                 }
  277.             }
  278.         }
  279.        
  280.         //next button
  281.         if ($page < $counter - 1)
  282.             $pagination.= "<a href=\"$targetpage?$valorpaginacion&page=$next\">next >></a>";
  283.         else
  284.             $pagination.= "<span class=\"disabled\">next >></span>";
  285.         $pagination.= "</div>\n";      
  286.     }
  287.  
  288.  
  289.    
  290.         while ($row = $res->fetch_array()) {
  291.    //get the publisher name
  292.  
  293.      $organizerSql = $mysqli->query("SELECT nazwa FROM baza_obiektow_inne WHERE id=" . $row['organizer_id'] . " LIMIT 1");
  294.    $organizer = mysqli_fetch_assoc($organizerSql);
  295.    $pretty_date = date('F Y', strtotime($row['publication_date']));
  296.    echo "<tr>\n";
  297.    $simbolos_reemplazar = array (" ","%","/");
  298.    printf("<td><a href='http://embs-group.com/%s,%s'>%s</a></td>", $row['id'], str_replace( $simbolos_reemplazar, "_", $row['name']), $row['name']);
  299.    printf("<td>%s</td>", $organizer['nazwa']);
  300.    printf("<td>%s</td>", $row['no_pages']);
  301.  printf("<td>%s</td>", $pretty_date);
  302.    printf("<td>%s</td>", $row['price']);
  303.    printf("<td>%s</td>", $row['currency']);
  304.    
  305.    
  306.  
  307.    echo "</tr>\n";
  308.  
  309. }
  310.    
  311.  
  312. echo $pagination?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!