# Pagination in jquery with php

**URL:** <https://forum.kirupa.com/t/pagination-in-jquery-with-php/280777>\
**Category:** Uncategorized\
**Created:** [January 31, 2009, 6:30pm UTC](https://forum.kirupa.com/t/pagination-in-jquery-with-php/280777 "2009-01-31T18:30:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sumantapaul123](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@sumantapaul123](https://forum.kirupa.com/u/sumantapaul123)\
**Post date:** [January 31, 2009, 6:30pm UTC](https://forum.kirupa.com/t/pagination-in-jquery-with-php/280777/1 "2009-01-31T18:30:37Z")

</div>

If there is any one can solve my problem

i have two file  
one is  
index.html  
code is  
\<?php  
error\_reporting( E\_ALL );  
$conn = mysql\_connect( ‘localhost’, ‘root’, ‘’);  
if ( is\_resource( $conn ) ) {  
if ( !mysql\_select\_db(‘db155735726’, $conn) ) {  
echo ‘\<p\>Can not select db.\</p\>’;  
}

```
    $sql = 'SELECT COUNT(*) from news;';
    $res = mysql_query($sql);
    if ( is_resource( $res ) ) {
            $total = mysql_result( $res, 0 );
    
    }

}

```

?\>  
\<html\>  
\<head\>  
\<script type=“text/javascript” src=“jquery.min.js”\>\</script\>  
\<script type=“text/javascript” src=“jquery.pagination.js”\>\</script\>  
\<script type=“text/javascript”\>  
function pageselectCallback(page\_id, jq){  
var first = (page\_id_10)+1, second = (page\_id_10)+5;  
$(’#Searchresult’).text(“Showing search results " + first + ‘-’ + second);  
$.ajax({  
type:‘GET’,  
url:‘ajax.php’,  
data:‘offset=’ + first + ‘&limit=5’,  
success:function(msg) {  
$(’#ajaxContent’).html(msg);  
}  
});  
}  
$(document).ready(function(){  
$(”#Pagination").pagination( \<?php echo $total;?\>, {  
num\_edge\_entries: 2,  
num\_display\_entries: 8,  
callback: pageselectCallback  
});

```
    pageselectCallback(0);
});
&lt;/script&gt;

```

\</head\>  
\<body\>  
\<div id=“Pagination”\>

```
 &lt;/div&gt;&lt;br clear="all"/&gt;
&lt;div id="Searchresult"&gt;
&lt;/div&gt;
&lt;div id="ajaxContent"&gt; &lt;table border="2"&gt;
 &lt;tr&gt;
 &lt;th &gt; date&lt;/th&gt;
 &lt;th &gt; germanText&lt;/th&gt;
 &lt;th &gt; englishText&lt;/th&gt;
 &lt;th &gt; germanTitle&lt;/th&gt;
 &lt;th &gt; englishTitle&lt;/th&gt;
 &lt;/tr&gt;
 &lt;tbody&gt;
 &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
  &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
  &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
  &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
  &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
  &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
  &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
  &lt;tr&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;td&gt;static elements&lt;/td&gt;
 &lt;/tr&gt;
 &lt;/tbody&gt;
 &lt;/table&gt; &lt;/div&gt;

```

\</body\>  
\</html\>

other one is  
ajax.php  
code like  
\<?php  
$offset = $\_GET[‘offset’];  
$limit = $\_GET[‘limit’];  
$conn = mysql\_connect( ‘localhost’, ‘root’, ‘’);  
if ( is\_resource( $conn ) ) {  
if ( !mysql\_select\_db(‘db155735726’, $conn) ) {  
echo ‘\<p\>Can not select db.\</p\>’;  
}  
$result = mysql\_query('SELECT \* from NEWS LIMIT ’ . $offset . ‘,’ . $limit);  
if ( is\_resource( $result ) ) {

```
    while ( $row = mysql_fetch_assoc( $result ) ) {
    
     echo $row['date']; 
    echo $row['germanText'] ; 
    echo $row['englishText']; 
    echo $row['germanTitle'] ; 
    echo $row['englishTitle'] ; 
    }
    
            
}
}

```

?\>

it works fine  
but i want to display result in tabuler format  
if any one can solve my problem please help me