Posted inUncategorized

php for Ajax- jquery pagination ,php AJAX sayfalama



Hi, this week, using jquery, php, ajax and we will do the paging and data capture, Ajax paging and paging with Ajax examples here will tell us.
While this writer Erin muharrem “kgpager” and we used Ezsql class,
Online test: here
Click here to download …

Turkish Text :
Merhabalar , bu hafta jquery ve php kullanarak ,ajax ile sayfalandırma ve bilgi çekmeyi yapacağız, Ajax sayfalama ve ajax ile sayfalama örneğimizi burada anlatacağım.
bunu yazarken muharrem Erin  “kgpager” ve Ezsql sınıfını kullandık ,
Online test:için Buraya tıklayınız
İndirmek için buraya tıklayınız
[dm]103[/dm]

index.php

STNC AJAX PAGING--selman tunç
<!--
#content ul {
background-color:#000;
height:30px;
list-style:none outside none;
margin:10px 0;
padding:0 0 0 50px;
}#content ul li {

color:#FFFFFF;
float:left;
font:bold 14px Georgia,"Times New Roman",Times,serif;
padding:5px 10px 0;
}
-->



get_var("SELECT count(Id) FROM news");

                $kgPagerOBJ = & new kgPager();
                $kgPagerOBJ->pager_set($pager_url, $total_records, $scroll_page, $per_page, $current_page, $inactive_page_tag, $previous_page_text, $next_page_text, $first_page_text, $last_page_text, $pager_url_last);

                $sql = "SELECT  from news  ORDER BY  Id asc limit ".$kgPagerOBJ->start.", ".$kgPagerOBJ->per_page;
                $contents = $db->get_results($sql, ARRAYA);
                if ($contents != '') {
                    foreach ($contents as $content) {
  echo ''.$content['news'].'';
 echo'
';
  echo $content['news'];
     echo'
';  

      }
     }
 else
 {
  echo 'notting value sorry';
 }
echo '
<div id="content" class="paging">
    ';
    echo $kgPagerOBJ->first_page;
    echo $kgPagerOBJ->previous_page;
    echo $kgPagerOBJ->page_links;
    echo $kgPagerOBJ->next_page;
    echo $kgPagerOBJ->last_page;
    echo '




';
?>

ajax_comment.php
get_var("SELECT count(Id) FROM news");

                $kgPagerOBJ = & new kgPager();
                $kgPagerOBJ->pager_set($pager_url, $total_records, $scroll_page, $per_page, $current_page, $inactive_page_tag, $previous_page_text, $next_page_text, $first_page_text, $last_page_text, $pager_url_last);

                $sql = "SELECT  from news  ORDER BY  Id asc limit ".$kgPagerOBJ->start.", ".$kgPagerOBJ->per_page;
                $contents = $db->get_results($sql, ARRAYA);
                if ($contents != '') {
                    foreach ($contents as $content) {
  echo ''.$content['news'].'';
 echo'
';
  echo $content['news'];
  echo'
';  

      }
     }
 else
 {
  echo 'notting value sorry';
 }

echo '
<div id="content" class="paging">
    ';
    echo $kgPagerOBJ->first_page;
    echo $kgPagerOBJ->previous_page;
    echo $kgPagerOBJ->page_links;
    echo $kgPagerOBJ->next_page;
    echo $kgPagerOBJ->last_page;
    echo '