php - ajax pagination if condition running both url when page is clicked -
i have dropdown different client each client has different page,so when select first client , press button go selected client page show data pagination ,my problem starts here select next client , press button go the selected client page show data pagination,when click first 1 2 3...last pagination button perform both url url first page , second page,can 1 know fix ,thanks code :
<script type="text/javascript"> $(document).ready(function(){ $("#clientbutton").on("click", function() { var clientid=$("#client").val(); function loading_show(){ $('#loading').html("<img src='image/loading.png'/>").fadein('fast'); } function loading_hide(){ $('#loading').fadeout('fast'); } function loaddata(page){ loading_show(); if(clientid == a){ $.ajax({ type: "post", url:"clientnetworkpricelist/yourfile.php", data: "page="+page+"&title="+clientid, success: function(msg) { $("#container").ajaxcomplete(function(event, request, settings) { loading_hide(); $("#container").html(msg); }); } }); } else if(clientid == b){ $.ajax({ type: "post", url:"clientnetworkpricelist/your1.php", data: "page="+page+"&title="+clientid, success: function(msg) { $("#container").ajaxcomplete(function(event, request, settings) { loading_hide(); $("#container").html(msg); }); } }); } else{ $.ajax ({ type: "post", url:"clientnetworkpricelist/yourfile2.php", data: "page="+page+"&title="+clientid, success: function(msg) { $("#container").ajaxcomplete(function(event, request, settings) { loading_hide(); $("#container").html(msg); }); } }); } } loaddata(1); // first time page load default results $('#container .pagination li.active').live('click',function(){ var page = $(this).attr('p'); loaddata(page); }); $('#go_btn').live('click',function(){ var page = parseint($('.goto').val()); var no_of_pages = parseint($('.total').attr('a')); if(page != 0 && page <= no_of_pages){ loaddata(page); }else{ alert('enter page between 1 , '+no_of_pages); $('.goto').val("").focus(); return false; } }); }); }); </script> php
<?php $client_id = $_post['title']; if($client_id!=""){ $page = $_post['page']; $cur_page = $page; $page -= 1; $per_page = 100; $previous_btn = true; $next_btn = true; $first_btn = true; $last_btn = true; $start = $page * $per_page; $sql_selectsupplier = "select * supplierprice join `$client_id` b b.`net_id` = a.`supp_price_id` order `country` asc limit $start, $per_page"; //print $sql_selectsupplier; $result1 = mysql_query($sql_selectsupplier); //print "query". $query; while($rows=mysql_fetch_array($result1)) { echo ' <td style="width:69px" class=" '.$rows["net_id"].'">'.$rows["clientid"].'</td> <td style="width:101px" id="cph_gridview1_clientid" class=" '.$rows["net_id"].'">'.$rows["region"].'</td> <td style="width:119px" id="cph_gridview1_country" class=" '.$rows["net_id"].'">'.$rows["country"].'</td> ' ; echo '</tr>'; } /* --------------------------------------------- */ $query_pag_num = "select count( * ) count supplierprice join `$client_id` b b.`net_id` = a.`supp_price_id` order `country` asc"; //print $query_pag_num; $result_pag_num = mysql_query($query_pag_num); $row = mysql_fetch_array($result_pag_num); $count = $row['count']; $no_of_paginations = ceil($count / $per_page); /* ---------------calculating starting , endign values loop----------------------------------- */ if ($cur_page >= 7) { $start_loop = $cur_page - 3; if ($no_of_paginations > $cur_page + 3) $end_loop = $cur_page + 3; else if ($cur_page <= $no_of_paginations && $cur_page > $no_of_paginations - 6) { $start_loop = $no_of_paginations - 6; $end_loop = $no_of_paginations; } else { $end_loop = $no_of_paginations; } } else { $start_loop = 1; if ($no_of_paginations > 7) $end_loop = 7; else $end_loop = $no_of_paginations; } /* ----------------------------------------------------------------------------------------------------------- */ $msg .= "<div class='pagination'><ul>"; // enabling first button if ($first_btn && $cur_page > 1) { $msg .= "<li p='1' class='active'>first</li>"; } else if ($first_btn) { $msg .= "<li p='1' class='inactive'>first</li>"; } // enabling previous button if ($previous_btn && $cur_page > 1) { $pre = $cur_page - 1; $msg .= "<li p='$pre' class='active'>previous</li>"; } else if ($previous_btn) { $msg .= "<li class='inactive'>previous</li>"; } ($i = $start_loop; $i <= $end_loop; $i++) { if ($cur_page == $i) $msg .= "<li p='$i' style='color:#fff;background-color:#006699;' class='active'>{$i}</li>"; else $msg .= "<li p='$i' class='active'>{$i}</li>"; } // enable next button if ($next_btn && $cur_page < $no_of_paginations) { $nex = $cur_page + 1; $msg .= "<li p='$nex' class='active'>next</li>"; } else if ($next_btn) { $msg .= "<li class='inactive'>next</li>"; } // enable end button if ($last_btn && $cur_page < $no_of_paginations) { $msg .= "<li p='$no_of_paginations' class='active'>last</li>"; } else if ($last_btn) { $msg .= "<li p='$no_of_paginations' class='inactive'>last</li>"; } $goto = "<input type='text' class='goto' size='1' style='margin-top:-1px;margin-left:60px;'/><input type='button' id='go_btn' class='go_button' value='go'/>"; $total_string = "<span class='total' a='$no_of_paginations'>page <b>" . $cur_page . "</b> of <b>$no_of_paginations</b></span>"; $msg = $msg . "</ul>" . $goto . $total_string . "</div>"; // content pagination echo $msg; } ?>
Comments
Post a Comment