Rabu, 04 Maret 2009
tugas anyar
scripnya :
<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>
edit entry siswa
>html<
>body background="bg2.jpg"<
>font size=16<Entry Data Siswa>/font<
>br /<
>hr<
Ketik data-data siswa dibawah ini :>br /<
>br /<
>br /<
>form id="form1? name="form1? method="post" action="isisiswa.php"<
>table<
>tr<>td<Nama Siswa>/td<>td<>input type="text" name="nama" id="nama" /<>/td<>/tr<
>tr<>td<Nomor Induk>/td<>td<>input type="text" name="induk" id="induk" /<>/td<>/tr<
>tr<>td<Kelas>/td<>td<>input type="text" name="kelas" id="kelas" /<>/td<>/tr<
>/table<
>br /<
>br /<
>hr<
>input type="submit" name="Submit" id="Submit" value="Kirim" /<
>/form<
>/body<
>/html<
>body background="bg2.jpg"<
>font size=16<Entry Data Siswa>/font<
>br /<
>hr<
Ketik data-data siswa dibawah ini :>br /<
>br /<
>br /<
>form id="form1? name="form1? method="post" action="isisiswa.php"<
>table<
>tr<>td<Nama Siswa>/td<>td<>input type="text" name="nama" id="nama" /<>/td<>/tr<
>tr<>td<Nomor Induk>/td<>td<>input type="text" name="induk" id="induk" /<>/td<>/tr<
>tr<>td<Kelas>/td<>td<>input type="text" name="kelas" id="kelas" /<>/td<>/tr<
>/table<
>br /<
>br /<
>hr<
>input type="submit" name="Submit" id="Submit" value="Kirim" /<
>/form<
>/body<
>/html<
Langganan:
Postingan (Atom)