Guest User

Untitled

a guest
Jun 24th, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.05 KB | None | 0 0
  1. <table class="cg-nav-wrapper cg-nav-wrapper-row-2" id="tableID" data-role="cg-nav-wrapper">
  2. <tr>
  3. <?php
  4. include 'includes/connection/dbh.inc.php';
  5.  
  6. $categories =array("Agriculture & Food", "Apparel, Textiles & Accessories", "Maintenance & Repair", "Auto & Transportation", "Business & Commercial", "Computer Electronics", "Electronics & Electrical Equipment", "Health & Beauty", "Home, Lights & Construction", "House Cleaning", "House Improvement", "Machinery, Industrial Parts & Tools", "Packaging, Advertising & Office");
  7.  
  8. $len = count($categories);
  9.  
  10.  
  11. for($x = 0; $x < $len; $x++) {
  12.  
  13. $current = $categories[$x];
  14.  
  15. $sql = "SELECT count(company_business_category) AS total FROM businesses WHERE company_business_category ='$current' ";
  16.  
  17. $result = mysqli_query($conn, $sql);
  18.  
  19. $count=mysqli_fetch_assoc($result);
  20.  
  21. $num = $count['total'];
  22.  
  23. if($current=='Agriculture & Food'){
  24. if($num>0){
  25. ?>
  26. <td class="anchor-wrap anchor1-wrap" data-role="anchor1">
  27. <a class="anchor1 anchor-agricuture showSingle click-here agricutureTD" inputtype="checkbox" target="1" data-role="cont" >
  28. <i class="cg-icon"></i>
  29. <span class="desc">
  30. Agriculture & Food
  31. </span>
  32. </a>
  33. </td>
  34.  
  35. <?php
  36. }else{
  37. ?>
  38. <td class="anchor-wrap anchor1-wrap" data-role="anchor1">
  39. <a class="anchor1 anchor-agricuture click-here agricutureTD"
  40. data-role="cont" >
  41. <i class="cg-icon"></i>
  42. <span class="desc">
  43. Agriculture & Food
  44. </span>
  45. </a>
  46. </td>
  47. <?php
  48. }
  49. }
  50.  
  51. else if($current=='Apparel, Textiles & Accessories'){
  52. if($num>0){
  53. ?>
  54. <td class="anchor-wrap anchor2-wrap showSingle apparelTD " target="2" data-role="anchor2">
  55. <a class="anchor2 anchor-apparel click-here apparelTD" data-role="cont" >
  56. <i class="cg-icon"></i>
  57. <span class="desc">
  58. Apparel,Textiles & Accessories
  59. </span>
  60. </a>
  61. </td>
  62. <?php
  63. }else{
  64. ?>
  65. <td class="anchor-wrap anchor2-wrap cl apparelTD" target="2" data-role="anchor2">
  66. <a class="anchor2 anchor-apparel click-here apparelTD" data-role="cont">
  67. <i class="cg-icon"></i>
  68. <span class="desc">
  69. Apparel,Textiles & Accessories
  70. </span>
  71. </a>
  72. </td>
  73. <?php
  74. }
  75. }
  76.  
  77. }
  78. ?>
  79.  
  80. </table> ....
  81.  
  82. $(document).ready(function(){
  83. var target = $('.cg-main').html();
  84. var nothing = '<div class="item util-clearfix targetDiv" data-spm="1" id="div1">' +
  85. '<h3 class="big-title anchor1'+
  86. '404 Nothing Found' +
  87. '</h3>'+
  88. '<div class="sub-item-wrapper util-clearfix">'+
  89. '<div class="sub-item">'+
  90. ''+
  91. '</div>'+
  92. '</div>'+
  93. '</div>';
  94.  
  95. $('.click-here').on('click',function(){
  96.  
  97. var $td = $(this).parent();
  98. $('.click-here').not(this).removeClass("selected");
  99. $td.toggleClass("selected");
  100. });
  101. });
Add Comment
Please, Sign In to add comment