soroush.r70
جمعه 21 مهر 1391, 09:13 صبح
یه نمونه ساده
function news()
{
if(isset($_GET['id']) && $_GET['id'] != '' && is_numeric($_GET['id'])) {
$id = (int) $_GET['id'];
$res = mysql_query("SELECT * FROM `tbl_news` WHERE (`id`='{$id}') ORDER BY `id` LIMIT 1");
}
else {
$page = (isset($_GET['page']) && is_numeric($_GET['page'])) ? (((int) $_GET['page']) - 1) : 0;
if($page < 0) {
$page = 0;
}
$perpage = 3;
$start = ($page * $perpage);
$res = mysql_query("SELECT * FROM `tbl_news` ORDER BY `id` desc LIMIT {$start}, {$perpage}");
if($res && mysql_num_rows($res) > 0) {
while($row=mysql_fetch_assoc($res))
{
echo'
مطالب شما
';
}
}
$count = mysql_result(mysql_query('SELECT COUNT(*) AS `count` FROM `tbl_news`'), 0, 0);
$count = ceil($count / $perpage);
for($i = 1; $i <= $count; $i++) {
if($i != ($page + 1)) {
echo '<a href="index.php?page='.$i.'" id="textpage">'.$i.'</a> ';
}
else {
echo '<span id="textpagea">'.$i.'</span> ';
}
}
}
}