aku ada try satu konsep link tapi post
contohnya mcm ni
CODE
<?
#####################
include "sesi.php"; #
##############################################
include "db_buka.php";// buka pangkalan data #
##############################################
?>
<html>
<head><title>View All [<?=$_GET[jadual];?>]</title>
<meta name="robots" content="noindex,nofollow">
</head>
<body>
<?php
##########################
include "menu_link.php"; #
##########################
$myTable=$_REQUEST[jadual]; $sql = "SELECT id, nama, catatan, cari FROM ".$myTable." ";
$sql .= ($_REQUEST['cari']==null)? "" : "WHERE cari=".$_REQUEST['cari']." ";
switch ($myTable):
case 'buku_rak':
$buku=1; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
case 'buku_rak_para':
$buku=2; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
case 'buku_tajuk':
$buku=3; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
case 'buku_topik':
$buku=4; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
default : //echo "Jadual:$myTable|Cari=$cari";
endswitch;
echo "\r";
echo "<fieldset>";
$kotak1="border:1px solid #000000";
$kotak3="width:100px";
$kotak4="padding:8px 8px 8px 8px";
$kotak0="\n<div style='$kotak1;$kotak3;$kotak4'>";
/*
$papar[] = $_REQUEST['cari2'];
foreach($namaJadual as $myTable)
{// ulang mula
$cetak .= $papar[];
}// ulang tamat
*/
// ------------------------------------------------------------------------------------------------------------------------ //
##################################################
// ambil halaman semasa, jika tiada, cipta satu! #
if ( !isset($_REQUEST['page']) ){$page = 1;}
else {$page = $_REQUEST['page'];}
##################################################
#############--------Mula- query MySQL (LIMIT ".$dari_baris.", ".$baris_max.")--------------#####################
$baris_max = $_REQUEST['item']; // berapa item dalam satu halaman
$dari_baris = (($page * $baris_max) - $baris_max); // Tentukan had query berasaskan nombor halaman semasa.
$query = " ".$sql." LIMIT ".$dari_baris.", ".$baris_max." ";
$result = @mysql_query($query) or die (mysql_error()."<hr>$query<hr>");
$fields = mysql_num_fields($result) or die("Num Fields Failed/ Nama Medan Takde");
$rows = mysql_num_rows($result);
// nak cari $rows
if ($rows=='0'): echo "<legend><font color=blue face=Wingdings size=5>L</font>|".$cetak."</legend>\n";
echo $kotak0."\n<form method='post' action='buku_tambah.php'>".
"\n<a href='java script:document.forms[0].submit()'>Tambah Baru</a>".
"\n<input type='hidden' name='jadual' value='".$jadual[$buku]."'>".
"\n<input type='hidden' name='cari' value='".$_REQUEST['cari']."'>".
"\n<input type='hidden' name='cari2' value='".$_REQUEST['cari2']."'>".
"\n</form></div>\n";
else: // mula kalau jumpa
$kira=0;$buku=$buku+1;
echo "<legend>:) - Bahagian ".$myTable." | ".$cetak."</legend>\n";
while($row = mysql_fetch_array($result))
{// mula papar $row
if ($myTable=='buku_topik')
{echo "".
"\r<div>".$row[nama]."</div>".
"\r<div><pre>".$row[catatan]."</pre></div>".
"";
}
else
{
$kotak2=($kira % '2'=='0')? "background-color: #dda0dd" : "background-color: #ffffff";
$kotak0="\n<div style='$kotak1;$kotak2;$kotak4'>";
echo $kotak0."\n<form method='post' action=''>".
"\n<a href='java script:document.forms[".$kira++."].submit()'>".$row[1]."</a>".
"\n<input type='hidden' name='jadual' value='".$jadual[$buku]."'>".
"\n<input type='hidden' name='item' value='10'>".
"\n<input type='hidden' name='masuk' value='1'>".
"\n<input type='hidden' name='cari' value='".$row[0]."'>".
"\n<input type='hidden' name='cari2' value='".$row[1]."'>".
"\n</form></div>\n";
}
}// tutup papar $row
endif; //tamat jika jumpa
// tamat - cari $rows
#############--------Tamat- query MySQL (LIMIT ".$dari_baris.", ".$baris_max.")--------------#####################
########################----- Mula - Bina hyperlink untuk nombor halaman---------###########################
$result = @mysql_query($sql) or die (mysql_error());
$bil_semua = mysql_num_rows ($result); // Tentukan bilangan baris di dalam DB:
$muka_surat = ceil($bil_semua / $baris_max);// Tentukan bilangan halaman.
$senarai_medan="jadual=$myTable&item=$baris_max";
$muka="\r<div align=center style='float:left;border:1px solid #000000;width:15px;padding:2px 2px 2px 2px;'>";
$mukaT="\r<div align=center style='float:left;border:1px dotted #000000;width:15px;padding:2px 2px 2px 2px;'>";
$mukaP="\r<div style='float:left; border:1px solid #ffffff;'>";
$muka2='</div>';
$div2="$muka2$mukaP$muka2";
////////////////////////////////////////////////////////////////////////////////////////
if ($myTable=='buku_topik') {echo "";}
else {
echo "\r\r<div align=left>Halaman<br>"; // Papar halaman
if($page > 1) // Bina halaman sebelum
{echo "".$muka."<a href='?page=".($page - 1)."&$senarai_medan'><</a>".$div2."\r";}
for($i = 1; $i <= $muka_surat; $i++) // Bina halaman terkini
{
if(($page) == $i){echo "\r$mukaT".$i."$div2\r";}
else {echo "\r".$muka."\r<a href='?page=$i&$senarai_medan'>$i</a>".$div2."\r";}
}
if($page < $muka_surat) // Bina halaman akhir
{echo "".$muka."\r<a href='?page=".($page + 1)."&$senarai_medan'>></a>".$div2."\r";}
echo "\r</div>";
}
////////////////////////////////////////////////////////////////////////////////////////
########################----- Tamat - Bina hyperlink untuk nombor halaman---------###########################
// ------------------------------------------------------------------------------------------------------------------------ //
echo "\r</fieldset>\r";
?>
</body>
</html>
#####################
include "sesi.php"; #
##############################################
include "db_buka.php";// buka pangkalan data #
##############################################
?>
<html>
<head><title>View All [<?=$_GET[jadual];?>]</title>
<meta name="robots" content="noindex,nofollow">
</head>
<body>
<?php
##########################
include "menu_link.php"; #
##########################
$myTable=$_REQUEST[jadual]; $sql = "SELECT id, nama, catatan, cari FROM ".$myTable." ";
$sql .= ($_REQUEST['cari']==null)? "" : "WHERE cari=".$_REQUEST['cari']." ";
switch ($myTable):
case 'buku_rak':
$buku=1; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
case 'buku_rak_para':
$buku=2; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
case 'buku_tajuk':
$buku=3; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
case 'buku_topik':
$buku=4; //echo "Jadual:".$myTable."|$buku|Cari=".$_REQUEST['cari']."|".$_REQUEST['cari2']."";
break;
default : //echo "Jadual:$myTable|Cari=$cari";
endswitch;
echo "\r";
echo "<fieldset>";
$kotak1="border:1px solid #000000";
$kotak3="width:100px";
$kotak4="padding:8px 8px 8px 8px";
$kotak0="\n<div style='$kotak1;$kotak3;$kotak4'>";
/*
$papar[] = $_REQUEST['cari2'];
foreach($namaJadual as $myTable)
{// ulang mula
$cetak .= $papar[];
}// ulang tamat
*/
// ------------------------------------------------------------------------------------------------------------------------ //
##################################################
// ambil halaman semasa, jika tiada, cipta satu! #
if ( !isset($_REQUEST['page']) ){$page = 1;}
else {$page = $_REQUEST['page'];}
##################################################
#############--------Mula- query MySQL (LIMIT ".$dari_baris.", ".$baris_max.")--------------#####################
$baris_max = $_REQUEST['item']; // berapa item dalam satu halaman
$dari_baris = (($page * $baris_max) - $baris_max); // Tentukan had query berasaskan nombor halaman semasa.
$query = " ".$sql." LIMIT ".$dari_baris.", ".$baris_max." ";
$result = @mysql_query($query) or die (mysql_error()."<hr>$query<hr>");
$fields = mysql_num_fields($result) or die("Num Fields Failed/ Nama Medan Takde");
$rows = mysql_num_rows($result);
// nak cari $rows
if ($rows=='0'): echo "<legend><font color=blue face=Wingdings size=5>L</font>|".$cetak."</legend>\n";
echo $kotak0."\n<form method='post' action='buku_tambah.php'>".
"\n<a href='java script:document.forms[0].submit()'>Tambah Baru</a>".
"\n<input type='hidden' name='jadual' value='".$jadual[$buku]."'>".
"\n<input type='hidden' name='cari' value='".$_REQUEST['cari']."'>".
"\n<input type='hidden' name='cari2' value='".$_REQUEST['cari2']."'>".
"\n</form></div>\n";
else: // mula kalau jumpa
$kira=0;$buku=$buku+1;
echo "<legend>:) - Bahagian ".$myTable." | ".$cetak."</legend>\n";
while($row = mysql_fetch_array($result))
{// mula papar $row
if ($myTable=='buku_topik')
{echo "".
"\r<div>".$row[nama]."</div>".
"\r<div><pre>".$row[catatan]."</pre></div>".
"";
}
else
{
$kotak2=($kira % '2'=='0')? "background-color: #dda0dd" : "background-color: #ffffff";
$kotak0="\n<div style='$kotak1;$kotak2;$kotak4'>";
echo $kotak0."\n<form method='post' action=''>".
"\n<a href='java script:document.forms[".$kira++."].submit()'>".$row[1]."</a>".
"\n<input type='hidden' name='jadual' value='".$jadual[$buku]."'>".
"\n<input type='hidden' name='item' value='10'>".
"\n<input type='hidden' name='masuk' value='1'>".
"\n<input type='hidden' name='cari' value='".$row[0]."'>".
"\n<input type='hidden' name='cari2' value='".$row[1]."'>".
"\n</form></div>\n";
}
}// tutup papar $row
endif; //tamat jika jumpa
// tamat - cari $rows
#############--------Tamat- query MySQL (LIMIT ".$dari_baris.", ".$baris_max.")--------------#####################
########################----- Mula - Bina hyperlink untuk nombor halaman---------###########################
$result = @mysql_query($sql) or die (mysql_error());
$bil_semua = mysql_num_rows ($result); // Tentukan bilangan baris di dalam DB:
$muka_surat = ceil($bil_semua / $baris_max);// Tentukan bilangan halaman.
$senarai_medan="jadual=$myTable&item=$baris_max";
$muka="\r<div align=center style='float:left;border:1px solid #000000;width:15px;padding:2px 2px 2px 2px;'>";
$mukaT="\r<div align=center style='float:left;border:1px dotted #000000;width:15px;padding:2px 2px 2px 2px;'>";
$mukaP="\r<div style='float:left; border:1px solid #ffffff;'>";
$muka2='</div>';
$div2="$muka2$mukaP$muka2";
////////////////////////////////////////////////////////////////////////////////////////
if ($myTable=='buku_topik') {echo "";}
else {
echo "\r\r<div align=left>Halaman<br>"; // Papar halaman
if($page > 1) // Bina halaman sebelum
{echo "".$muka."<a href='?page=".($page - 1)."&$senarai_medan'><</a>".$div2."\r";}
for($i = 1; $i <= $muka_surat; $i++) // Bina halaman terkini
{
if(($page) == $i){echo "\r$mukaT".$i."$div2\r";}
else {echo "\r".$muka."\r<a href='?page=$i&$senarai_medan'>$i</a>".$div2."\r";}
}
if($page < $muka_surat) // Bina halaman akhir
{echo "".$muka."\r<a href='?page=".($page + 1)."&$senarai_medan'>></a>".$div2."\r";}
echo "\r</div>";
}
////////////////////////////////////////////////////////////////////////////////////////
########################----- Tamat - Bina hyperlink untuk nombor halaman---------###########################
// ------------------------------------------------------------------------------------------------------------------------ //
echo "\r</fieldset>\r";
?>
</body>
</html>
contoh output mcm kat bawah ni
http://www.amin007.o...projek/masalah/
dari apa yg aku study
kalau <a href='java script:document.forms[".$kira++."].submit()'>
yg mana nilai awal $kira=0
nilai yg dibawa seperti yg aku nak
tapi kalau aku letak nilai awal $kira=1
lain pulak dibawanya
kenapa yer? harap dapat bagi penjelasan

Sign In
Register
Help


MultiQuote