Minggu, 10 Januari 2010

PHP : PROSES CARI

include_once("konek_db.php");
$sql="SELECT NIK,Nama,Alamat,Phone,date_format(Tglmasuk,'%d-%m-%Y') as tanggal,Bagian,Jabatan,Keterangan from karyawan where $pilihan LIKE '%$cari%'";
$qry=mysql_db_query("karyawan",$sql,$connect);

print "";
print "
NIK";
print "
Nama";
print "
Alamat";
print "
Phone";
print "
Tanggal Masuk";
print "
Bagian";
print "
Jabatan";
print "
Keterangan";
while ($row=mysql_fetch_row($qry))
{
print "
$row[0]";
print "
$row[1]";
print "
$row[2]";
print "
$row[3]";
print "
$row[4]";
print "
$row[5]";
print "
$row[6]";
print "
$row[7]";
}
?>

Tidak ada komentar: