KIM BUM CUTE

KIM BUM CUTE

CARDCAPTOR SAKURA

CARDCAPTOR SAKURA

CUTEST BRIDGE CARD

CUTEST BRIDGE CARD

Jumat, 06 Maret 2009

Entry Siswa Berdasarkan Nomor Induk




Entry Siswa Dalam Induk Terurut


Script Kode Dari Program Ini Yaitu:





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









Diposting oleh di Tidak ada komentar:

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(nama, 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="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>


















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" cols="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 Data 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("latihan",$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>
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)