All pastes #2084493 Raw Edit

Untitled

public text v1 · immutable
#2084493 ·published 2011-09-29 03:40 UTC
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&amp;&amp;bhs=eng" method="post" name="cari" id="cari">
                  Search :&nbsp;
                  <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>&nbsp;</p></td></tr>
            </table>