php - CodeIgniter Pagination only shows fixed numbers (1,2,3) -

-

i did pagination pass data through ajax view. in case skip $config['uri_segemnt'] . here set total number of rows , per page manually. function creates html tags , pagination tags , append them view. working pagination shows 3 numbers every time. seems pagination not calculate total row count,how can solve this? here function , view.

php controller function

public function getvoucherajax() {         if (!empty($_post)) {             $offset = $_post['limit'];             $selecttedlist = $_post['listid'];         } else {             $offset = 0;         }          $count = $this->gettotalocount($selecttedlist);         $vouchercount = $count[0]['vcount'];         //$limit = perpage          $allvouchers = $this->voucher_model->getallvouchers($this->perpage(), $offset, $selecttedlist);          $config = array();         $config['total_rows'] = 56;         $config['per_page'] = 10;   ////bootstrap config pagination         $config['full_tag_open'] = '<ul class="pagination">';         $config['full_tag_close'] = '</ul>';         $config['first_link'] = false;         $config['last_link'] = false;         $config['first_tag_open'] = '<li>';         $config['first_tag_close'] = '</li>';         $config['prev_link'] = '&laquo';         $config['prev_tag_open'] = '<li class="prev">';         $config['prev_tag_close'] = '</li>';         $config['next_link'] = '&raquo';         $config['next_tag_open'] = '<li>';         $config['next_tag_close'] = '</li>';         $config['last_tag_open'] = '<li>';         $config['last_tag_close'] = '</li>';         $config['cur_tag_open'] = '<li class="active"><a href="#">';         $config['cur_tag_close'] = '</a></li>';         $config['num_tag_open'] = '<li>';         $config['num_tag_close'] = '</li>';         $this->pagination->initialize($config);         echo 'row count -'.' '.$config['total_rows'];         $links = $this->pagination->create_links();  //        print_r($allvouchers);         ?>         <div class="col-sm-12">             <table class="table table-hover">                 <thead>                     <tr>                         <th width="50">id</th>                         <th width="150">created</th>                         <th width="150">valid from</th>                         <th width="150">valid to</th>                         <th width="100">type</th>                         <th width="100">state</th>                     </tr>                   </thead>                 <tbody>                     <?php                     foreach ($allvouchers['allvouchers'] $rows) {                         ?>                         <tr>                             <td><?php echo $rows['id'] ?></td>                             <td><?php echo $rows['created'] ?></td>                             <td><?php echo $rows['validfrom'] ?></td>                             <td><?php echo $rows['validto'] ?></td>                             <td><?php echo $rows['type'] ?></td>                             <td><?php echo $rows['state'] ?></td>                         </tr>                         <?php                     }                     ?>                 </tbody>             </table>              <?php echo $links; ?>         </div>           <?php     }

view

<script>     $(function () {          loadlist()         loadvoucher()         pagination()          function loadlist() {             $.ajax({                 method: "post",                 url: "<?php echo base_url(); ?>login/loadlistsajax",             }).done(function ($data) {                 $("#list").html($data);             });         }          function loadvoucher() {             $("#list").change(function () {                 var listid = $(this).val();                 $.ajax({                     method: "post",                     url: "<?php echo base_url(); ?>login/getvoucherajax",                     data: {limit: 0,listid: listid}                 }).done(function($data){                     $("#contents").html($data);                 });             });          }           function pagination(){         $(document).on("click",".pagination li a",function(event) {             event.preventdefault(); //            alert('sddsd');             var segment = $(this).attr("data-ci-pagination-page");             if(!segment){                 segment = 0;             }              var list = $("#list").val(); //            alert(list); //             $.ajax({                     method: "post",                     url: "<?php echo base_url(); ?>login/getvoucherajax",                     data: {limit: segment,listid: list}                 }).done(function($data){                     $("#contents").html($data);                 });          });         }       }); </script>    <div class="col-sm-9">     <div class="row">         <div class="col-sm-3">             <select id="list" class="form-control">              </select>         </div>     </div>       <div id="contents" class="row" style="padding-top: 100px;">        </div>

enter image description here

at top of image, shows query , total row count.


Comments

Post a Comment

Popular posts from this blog

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops', ...
Read more

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null ...
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens ...
Read more