Selasa, 10 Maret 2009

Entry Siswa Berdasarkan Induk
















<html>

<body background="bg1.jpg">

<br>


<font size="5" ><center>DAFTAR SISWA</center><br />

</font>

<?php

$conn = mysql_connect("localhost","root","");

if (!$conn) {

echo "Could not connect to db";

exit(1);

}

$db = mysql_select_db("latihan",$conn);


$sqlText = "select * from siswa order by induk";

$result = mysql_query($sqlText);

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

echo "<tr><td width=150><b><center>Nama Siswa</center></b></td>

<td width=150><b><center>Nomor Induk</center></b></td></b>

<td width=150><b><center>Kelas</center></b></td></b></tr>";


while($row=mysql_fetch_object($result))

{

echo "<tr><td>$row->nama</td><td align=center>$row->induk</td><td align=center>$row->kelas</td></tr>";

}


echo "</table>";

?>

</body>

</html>


Tidak ada komentar: