السلام عليكم قمت بعمل هذا الكود ولكنه لايخرج نتائج ارجو المساعده فيه وشكرا
<?php
session_start();
/*
CREATE TABLE `multipages` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 150 ) NOT NULL ,
`comment` TEXT NOT NULL
) ENGINE = MYISAM ;
*
*/
$con=mysql_pconnect('localhost','root','123') or die("Error in connection with database!!");
$selectDB=mysql_select_db("test") or die("Error in selecting DB");
if(!$_SESSION['records']){
$query="SELECT * FROM multipages";
$result=mysql_query($query);
if(!$result){
echo die("Error in fetching results");
}
else{
$_SESSION['records']=mysql_num_rows($result);
$records_num=$_SESSION['records'];
mysql_free_result($result);
}
}
$recordes_eachpage=2;
$pages_count=ceil($records_num/$recordes_eachpage);
if(!isset($_GET['page'])) {
$page=1;
}
if(isset($_GET['page'])){
if($_GET['page'] > $pages_count || intval($_GET['page'])<=0){
die("Not Found !!");}
else {
$page=(int)$_GET['page'];
$start=($page-1)*$recordes_eachpage;
$end=$recordes_eachpage;
if($records_num <1){
die("No Data Found !!");
}
else{
$query="SELECT * FROM multipages LIMIT $start,$recordes_eachpage";
$result=mysql_query($query);
while ($post = mysql_fetch_object($result)) {
echo $post->comment."<br />";
}
echo "<hr />";
for($i=1;$i<$pages_count;$i++){
if($page == $i){
echo $page;
}else{
echo "<a href='multipages.php?page=".$i."'>".$i."</a>";
if($i != $pages_count){
echo " - ";
}
}
}
}
}
}
?>