rendered paste body<table width="583" height="63" border="0" align="center">
<tr>
<td width="141" height="25"><br /><br />
<div align="left" class="style4"> <img align="bottom" height="20" src="image/picture/header/src_logo.ico" /> Search Product Name </div>
<br /></td>
</tr>
<tr>
<td height="32"><form action="product.php?id=4&&bhs=eng" method="post" name="cari" id="cari">
Search :
<input type="text" name="v" id="v" />
<input style="vertical-align:bottom;" src="image/picture/header/button_search.png" type="image" name="enter" value="SEARCH">
</form>
<?php
$conn = mysql_connect("localhost", "root", "welcome");
mysql_select_db("berno");
//membentuk klausa where pencarian
$query = '';
if(isset($_POST['v']) && $_POST['v']){
$query .= " where enama like '%{$_POST['v']}%'";
}
//mencari banyak data yang ada dalam tabel
$sqlCount = "select count(id_equick) from t_equick".$query;
$rsCount = mysql_fetch_array(mysql_query($sqlCount));
$banyakData = $rsCount[0];
$page = isset($_GET['page'])? $_GET['page'] : 1;
$limit = 10;
$start = ($limit * $page) - $limit;
$sql_limit = "select * from t_equick {$query} order by enama limit {$start}, {$limit}";
$result = mysql_query($sql_limit);
//form pencarian
//if(mysql_num_rows($sql_limit) > 0){
?>
<?php
//menampilkan data
echo '<table border="0">
<tr><br><br><br>
<td><strong>-- Produk --</strong><br><br></td>
</tr>';
?>
<?php
while ($t_equick = mysql_fetch_array($result)) {
echo '<tr>';
echo '<td>' . $t_equick['enama'] . '</td>';
echo '<td></td>';
echo '<td></td>';
echo '<td></td>';
echo '<td></td>';
echo '<td></td>';
echo '<td>' . $t_equick['eketerangan'] . '</td>';
echo '</tr>';
?>
<?php } ?>
<?php
echo '</table>';
?>
<?php
//membuat pagination
$banyakHalaman = ceil($banyakData / $limit);
echo '<br><br><br>';
echo 'Page: ';
for ($j = 1; $j <= $banyakHalaman; $j++) {
if ($page != $j) {
echo ' <a href="product.php?id=4&&bhs=eng&&page=' . $j .($query ? '&v='.$_GET['v'] : ''). '">' . $j . '</a> ';
}
else {
echo "[$j] ";
}
}
?>
<p> </p></td></tr>
</table>