lihatpasien.php

??php

include ("gaya_tabelku.css");

include("koneksi.php");

mysql_select_db("db_klinikduta");

$query = mysql_query("select * from pasien order by kd_pasien") or die (mysql_error());





echo "?tr>";

echo "?td width=950 valign=top>?h3 align=center> Data Pasien ?/h3>";



$jmlpasien = mysql_num_rows($query);

echo "?table border=1 align=center>";

echo "?tr bgcolor=green align=center>";

echo "?th>?b> Nomor?/font>";

echo "?th>?b> Kode Pasien?/font>";

echo "?th>?b> Nama Pasien?/font>";

echo "?th>?b> Alamat?/font>";

echo "?th>?b> golongan Darah?/font>";

echo "?th>?b> Jenis Kelamin?/font>";

echo "?th>?b> Tempat Lahir?/font>";

echo "?th>?b> Tanggal Lahir?/font>?/b>";

echo "?th>?b> Nomor Telepon?/font>?/b>";

echo "?/tr>";



for ($i=1; $i ?= $jmlpasien; $i++)

{

$baris_data = mysql_fetch_array ($query);



echo "?tr>";

echo "?td>?font color = blue size=1 >" .$i. ".?/td>";

echo "?td>$baris_data[kd_pasien]?/td>";

echo "?td>$baris_data[nama]?/td>";

echo "?td>$baris_data[alamat]?/td>";

echo "?td>$baris_data[gol_darah]?/td>";

echo "?td>$baris_data[jk]?/td>";

echo "?td>$baris_data[tp_lahir]?/td>";

echo "?td>$baris_data[tgl_lahir]?/td>";

echo "?td>$baris_data[telp]?/td>";

echo "?/tr>";

}



echo "?/table>";

echo "?br>";



echo "?table>";

echo "?tr align = center>";

echo "?td bgcolor = white colspan = 3> Jumlah Total Pasien = ?/front>";



$total = $jmlpasien ;

echo "?td bgcolor = white width = 20 align = left> $total ?/td>";



echo '?a href = "entripasien.php"> Kembali ke Form Entri Data ?/a>';

echo "?/table>";

echo "?br >";

echo"?form>";

echo "?input type ='button' value='Cetak Pasien' onClick='window.print()'>";

echo '?a href = "caripasien.php"> Mau Perbaiki Data???/a> atau ?a href ="caripasien2.php"> Mau hapus data?? ?/a>';



echo "?/form>";

?>