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>


Selasa, 03 Maret 2009

Entry Data Siswa


















Script :



<html>
<head>
<title>Input Data dari Form ke MySQL</title>
</head>

<body>
<?php
$nama = $_POST['nama'];
$pesan = $_POST['pesan'];
$conn = mysql_connect("localhost","root","");

if (!$conn) {
echo "Could not connect to db";
exit(1);
}
$db = mysql_select_db("latihan",$conn);

$sqlText = "insert into bukutamu(na
ma, pesan)
values('$nama','$pesan')";
mysql_query($sqlText);


?>Data telah dimasukkan dalam database<br />
</body>
</html>

















Scriptnya:



<html>

<body background=bg2.jpg>
<br>
<font face="Courier New">
<h1>Profile Sekolah</h1>
<P>

SMA NEGERI KEPANJEN
Menuju Sekolah Bertaraf Internasional

</P>
</font>
</body>
</html>


















Scriptnya:

<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="tex
t" 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>


















Scriptnya:

<HTML>
<HEAD>
<TITLE>Program Sistem Informasi Sekolah</TITLE>
</HEAD>

<FRAMESET ROWS="180,*" border=1>
<FRAME SRC="judul.html" SCROLLING=NO NORESIZE>
<FRAMESET COLS="200,*">
<FRAME SRC="menu.html" NORESIZE>
<FRAME SRC="prakata.html" NAME="FRAME-3">

</FRAMESET>
</FRAMESET>

</HTML>
















Scriptnya:


<html>
<head>
<title>Data Siswa</title>
</head>


<body background="bg2.jpg">

<font size=16>Buku Tamu</font>
<br />

<hr>
Ketik Nama dan Pesan Anda pada text box berikut :<br />
<br />
<br />
<form id="form1? name="form1? method="post" action="isi.php">
Nama
<input type="text" name="nama" id="nama" />
<br />
&
lt;br />
Pesan
<textarea name="pesan" id="pesan" col
s="45? rows="5?></textarea>
<br />
<br />
<hr>
<input type="submit" name="Submit" id="Submit" value="Kirim" />
</form>
</body>

&
lt;/html>
















Scriptnya:

<html>
<head>
<title>Daftar D
ata yang ada di MySQL</title>
</head>

<body bgcolor="#000000">

<font color="#FFFFFF" size="5">Buku Tamu<br />
</font>
<hr>
<font color="#FFFFFF">
<br />
<?php
$conn = mysql_connect("localhost","root","");
if (!$conn) {
echo "Could not connect to db";
exit(1);
}
$db = mysql_select_db("latiha
n",$conn);

$sqlText = "select * from bukutamu";
$result = mysql_query($sqlText);
while($row=mysql_fetch_object($result))
{
?>

<b>Nama</b>: php echo $row->nama;?><br>
<b>Pesan</b>: php echo $row->pesan;?><br>
<hr>
<br />
<?php } ?>
<marquee>
---
</marquee>
</font> <font color="#FFFFFF">
<marquee>
</marquee>
</font>
<marquee>
<font color="blue" size="3">--- AYO KAMU BISA BIKIN PROGRAM PAKE PHP ---
running text</font>----
</marquee>
</body>

</html>

















Scriptnya:

<html>

<body background=bg2.jpg>
<br>
<font face="Courier New">
<h1>Profile Sekolah</h1>
<P>
SMA NEGERI KEPANJEN
Menuju Sekolah Bertaraf Internasional

</P>
</font>
</body>
</html>