welcome

Samuel's Blog

Jumat, 13 Maret 2009

Data siswa Scripnya

Inilah scrip untuk membuat entry data 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>



Inilah scrip untuk input data siswa :

<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(nama, pesan)
values('$nama','$pesan')";
mysql_query($sqlText);


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

</span>

Inilah scrip untuk melihat data siswa :

<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";
$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 Induk7lt;/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>


Inilah scrip untuk halaman total :

bisa langsung menghubungi P. Welly K. .........................!!!!!!!!!!!!!!!!!!!
 

Template Design By:
SkinCorner
Gaara