if(isset($_GET['topic'])){
//untuk detail satu topic
}else{
//untuk paging
}
INI SCRIPT LENGKAP DENGAN READMORE
<?php
if(isset($_GET['topic'])){
$sql = mysql_query("SELECT *
FROM help_topic WHERE help_topic_id='$_GET[topic]'");
$data
= mysql_fetch_array($sql);
echo
$data[0].". ".$data[1]."<br>";
echo
"<p
style=margin:0;margin-left:20px;>".$data['description']."</p>";
} else {
$sql
= mysql_query("SELECT * FROM help_topic");
$jml
= mysql_num_rows($sql);
$jml_tampil
= 10;
if(isset($_GET['hal'])
&& $_GET['hal']<> 1)
$awal
= ($_GET['hal']-1)*$jml_tampil;
else
$awal = 0;
$halaman
= round($jml/10);
if($_GET['hal']<=1)
$prev=1;
else
$prev=$_GET['hal']-1;
echo
"<a href=?page=mysqlhelp&hal=$prev>Prev</a>";
for($i=1;
$i<=$halaman;$i++)
echo "<a
href=?page=mysqlhelp&hal=$i>$i</a> ";
if($_GET['hal']>=$jml)
$next=$jml;
else
$next=$_GET['hal']+1;
echo
"<a href=?page=mysqlhelp&hal=$next>Next</a>";
echo"<br>";
$sql
= mysql_query("SELECT * FROM help_topic LIMIT $awal,$jml_tampil");
while($data
= mysql_fetch_array($sql)){
echo $data[0].".
".$data[1]."<br>";
echo "<p
style=margin:0;margin-left:20px;>".substr($data['description'],0,100)."...<br>";
echo "<a
href=?page=mysqlhelp&topic=$data[0]>Read
More</a></p><br>";
}
}
?>
Source: Materi di Sekolah

No comments:
Post a Comment