<table>
<thead>
<tr class=head>
<th>No.</th>
<th>Nama</th>
<th>Coy.No</th>
<th>Perusahaan</th>
<th>Foto</th>
<th>Edit</th>
<th>Delete</th>
<thead></tr>
<?php
$result = mysql_query("select * from gambar");
while ($fetch_tampil = mysql_fetch_array($result)) {
?>
<tr align="center">
<td><?php echo $fetch_tampil['id'] ?></td>
<td><?php echo $fetch_tampil['nama'] ?></td>
<td><?php echo $fetch_tampil['coy_no'] ?></td>
<td><img src="/<?php echo $fetch_tampil['gambar'];?>' alt="" width=50 height=20></td>
<td> <a href="edit_gambar.php?aksi=edit&id=<?php echo $fetch_tampil['id'] ?>"><img src=images/edit.gif /></a></td>
<td> <a href="?aksi=hapus&id=<?php echo $fetch_tampil['id'] ?>"><img src=images/delete.gif /></a></td>
</tr>
<?php
}
?>
Imagenya belom muncul master..tolong dibantu <form name="form1" method="post" action="">
<p>
<label for="username">username</label>
:
<input type="text" name="username" id="username">
</p>
<p>
<label for="password">password</label>
:
<input type="text" name="password" id="password">
</p>
<p>
<label for="isi_posting">Isi Berita</label>
:
<input type="text" name="isi_posting" id="isi_posting">
</p>
<p> </p>
<p>
<input type="submit" name="kirim" id="kirim" value="Submit">
</p>
</form>
<tr><td> </td>
<td> </td>
<td width='45'> </td>
<td><input type='hidden' name='tanda' id='tanda' value='' /></td>
<td><a href='?menu=tambah_data'> <input type='submit' value='Add Tagihan' id='add' onclick='set_tanda(1)' /></a>
<input type='submit' value='Save' id='save' onclick='set_tanda(0)'/></td>
</tr>
mohon bantuannya mastah
<?php
mysql_connect("dbhost", "dbuser", "dbpassword");
mysql_select_db("dbname");
$bagianWhere = "";
if (isset($_POST['nimCat']))
{
$nim = $_POST['nim'];
if (empty($bagianWhere))
{
$bagianWhere .= "nim = '$nim'";
}
}
if (isset($_POST['namaCat']))
{
$namamhs = $_POST['nama'];
if (empty($bagianWhere))
{
$bagianWhere .= "namamhs LIKE '%$namamhs%'";
}
else
{
$bagianWhere .= " AND namamhs LIKE '%$namamhs%'";
}
}
if (isset($_POST['alamatCat']))
{
$alamat = $_POST['alamat'];
if (empty($bagianWhere))
{
$bagianWhere .= "alamat LIKE '%$alamat%'";
}
else
{
$bagianWhere .= " AND alamat LIKE '%$alamat%'";
}
}
if (isset($_POST['sexCat']))
{
$sex = $_POST['sex'];
if (empty($bagianWhere))
{
$bagianWhere .= "sex = '$sex'";
}
else
{
$bagianWhere .= " AND sex = '$sex'";
}
}
$query = "SELECT * FROM mhs WHERE ".$bagianWhere;
$hasil = mysql_query($query);
echo "<table border='1'>";
echo "<tr><td>NIM</td><td>Nama Mahasiswa</td><td>Alamat</td><td>Jenis Kelamin</td></tr>";
while ($data = mysql_fetch_array($hasil))
{
echo "<tr><td>".$data['nim']."</td><td>".$data['namamhs']."</td><td>".$data['alamat']."</td><td>".$data['sex']."</td></tr>";
}
echo "</table>";
?>
<h1>Cari Data Mahasiswa</h1>
<p>Pilih kategori pencarian</p>
<form method="post" action="proses.php">
<table>
<tr><td><input type="checkbox" name="nimCat"> NIM</td><td><input type="text" name="nim"></td></tr>
<tr><td><input type="checkbox" name="namaCat"> Nama Mahasiswa</td><td><input type="text" name="nama"></td></tr>
<tr><td><input type="checkbox" name="alamatCat"> Alamat</td><td><input type="text" name="alamat"></td></tr>
<tr><td><input type="checkbox" name="sexCat"> Jenis Kelamin</td><td><input type="radio" name="sex" value="L"> Laki-Laki <input type="radio" name="sex" value="P"> Perempuan</td></tr>
<tr><td></td><td><input type="submit" name="submit" value="Submit"></td></tr>
</table>
</form>