Rabu, 11 Maret 2009

NIE LHO gMBRnYA

NIE scriPtE

<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>