<?php
include("koneksi.php");
mysql_select_db("jancuk");
$query = mysql_query("select * from pasien") or die(mysql_error());
echo "<tr>";
echo "<td width=950 valign=top><h3 align=center>DATA PASIEN</h3>";
$jmlpasien = mysql_num_rows($query);
echo "<table border=1 align=center>";
echo "<tr bgcolor=#c0c0c0 align=center>";
echo "<th><b>Nomor</font></b>";
echo "<th><b>Kode Pasien</font></b>";
echo "<th><b>Nama Pasien</font></b>";
echo "<th><b>Alamat</font></b>";
echo "<th><b>Golongan darah</font></b>";
echo "<th><b>Jenis Kelamin</font></b>";
echo "<th><b>Tempat Lahir</font></b>";
echo "<th><b>Tanggal Lahir</font></b>";
echo "<th><b>Nomor Telp.</font></b>";
echo "</tr>";
for ($i = 1; $i <= $jmlpasien; $i++)
{
$baris_data = mysql_fetch_array($query);
echo "<tr>";
echo "<td><font color=#c0c0c0 size=2>".$i. ".</td>";
echo "<td> $baris_data[kode_pasien]</td>";
echo "<td> $baris_data[nama_pasien]</td>";
echo "<td> $baris_data[alamat]</td>";
echo "<td> $baris_data[gol_darah]</td>";
echo "<td> $baris_data[jen_kel]</td>";
echo "<td> $baris_data[tem_lahir]</td>";
echo "<td> $baris_data[tgl_lahir]</td>";
echo "<td> $baris_data[no_tlp]</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
echo "<table>";
echo "<tr align=center>";
echo "<td bgcolor=white colspan=3> Jumlah Total Pasien = </font>" ;
$total = $jmlpasien;
echo "<td bgcolor=white width=20 align=left> $total </td>";
echo '<a href ="entripasien.php"><font size=2>Kembali Ke Form Entri Data</font> </a>';
echo "</table>";
echo "<br >";
echo"<form>";
echo "<input type ='button' value='Cetak Pasien' onClick='window.print()'>";
echo "</form>";
?>
Tampilkan postingan dengan label web. Tampilkan semua postingan
Tampilkan postingan dengan label web. Tampilkan semua postingan
Rabu, 16 Juni 2010
simpan.php
<?php
include ("koneksi.php");
mysql_select_db("jancuk", $koneksi);
$cari="select*from pasien where kode_pasien='$_POST[textpasien]'";
$query=mysql_query($cari);
$periksa_data = mysql_num_rows($query);
if ($periksa_data != 0)
{
echo "Data sudah ada, silakan periksa lagi";
echo '<a href ="entripasien.php"> kembali ke Form Entri Data </a>';
return;
}
$sql="INSERT INTO pasien (kode_pasien,nama_pasien,alamat,gol_darah,jen_kel,tem_lahir,tgl_lahir,no_tlp)
VALUES ('$_POST[textpasien]','$_POST[textnama]','$_POST[textalamat]','$_POST[combodarah]','$_POST[combojk]',
'$_POST[texttempat]','$_POST[texttgl_lahir]','$_POST[texttelp]')";
if (!mysql_query($sql,$koneksi))
{
die('Error:'.mysql_error());
}
echo "satu record/data BERHASIL ditambahkan ke dalam tabel";
mysql_close($koneksi);
echo '<a href = "entripasien.php"> Kembali ke Entri Data </a>';
echo '</form>';
?>
?>
include ("koneksi.php");
mysql_select_db("jancuk", $koneksi);
$cari="select*from pasien where kode_pasien='$_POST[textpasien]'";
$query=mysql_query($cari);
$periksa_data = mysql_num_rows($query);
if ($periksa_data != 0)
{
echo "Data sudah ada, silakan periksa lagi";
echo '<a href ="entripasien.php"> kembali ke Form Entri Data </a>';
return;
}
$sql="INSERT INTO pasien (kode_pasien,nama_pasien,alamat,gol_darah,jen_kel,tem_lahir,tgl_lahir,no_tlp)
VALUES ('$_POST[textpasien]','$_POST[textnama]','$_POST[textalamat]','$_POST[combodarah]','$_POST[combojk]',
'$_POST[texttempat]','$_POST[texttgl_lahir]','$_POST[texttelp]')";
if (!mysql_query($sql,$koneksi))
{
die('Error:'.mysql_error());
}
echo "satu record/data BERHASIL ditambahkan ke dalam tabel";
mysql_close($koneksi);
echo '<a href = "entripasien.php"> Kembali ke Entri Data </a>';
echo '</form>';
?>
?>
koneksi.php
<?php
$nameserver="localhost";
$username="root";
$password="";
$koneksi=mysql_connect($nameserver,$username,$password);
if (!$koneksi)
{
die('Koneksi Gagal !!:'.mysql_error());
}
?>
$nameserver="localhost";
$username="root";
$password="";
$koneksi=mysql_connect($nameserver,$username,$password);
if (!$koneksi)
{
die('Koneksi Gagal !!:'.mysql_error());
}
?>
Input data Pasien
<html>
<head>
<title>Entri Data Pasien</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
function trim(str)
{
return str.replace(/^\s+|\s+$/g,'');
}
function validasipasien()
{
var cpasien,cnama,calamat,cgol_darah,ckelamin,ctempat,ctanggal,ctelp;
with(window.document.formpasien)
{
cpasien = textpasien;
cnama = textnama;
calamat = textalamat;
cgol_darah = combodarah;
ckelamin = combojk;
ctempat = texttempat;
ctanggal = texttgl_lahir;
ctelp = texttelp;
}
if(trim(cpasien.value) == '')
{
alert('Silahkan isi dulu nama dengan lengkap');
cpasien.focus();
return false;
}
else
if(trim(cnama.value) == '')
{
alert('Silahkan isi dulu nama dengan lengkap');
cnama.focus();
return false;
}
else
if(trim(calamat.value)== '')
{
alert('Alamat jangan kosong!!');
calamat.focus();
return false;
}
else
if(trim(cgol_darah.value) == '')
{
alert('Isi dulu golongan darah pasien');
cgol_darah.focus();
return false;
}
else
if(trim(ckelamin.value) == '')
{
alert('Silahkan isi dulu jenis kelamin');
ckelamin.focus();
return false;
}
else
if(trim(ctempat.value) == '')
{
alert('Silahkan isi dulu tempat lahir pasien');
ctempat.focus();
return false;
}
else
if(trim(ctanggal.value) == '')
{
alert('Silahkan isi tanggal lahir pasien');
ctanggal.focus();
return false;
}
else
if(trim(ctelp.value) == '')
{
alert('Silahkan isi dulu nomor telephon !!');
ctelp.focus();
return false;
}
else
{
cpasien.value = trim(cpasien.value);
cnama.value = trim(cnama.value);
calamat.value = trim(calamat.value);
cgol_darah.value = trim(cgol_darah.value);
ckelamin.value = trim(ckelamin.value);
ctempat.value = trim(ctempat.value);
ctanggal.value = trim(ctanggal.value);
ctelp.value = trim(ctelp.value);
return true;
}
}
</script>
</head>
<body>
<FORM action = "simpanpasien.php" onsubmit = "return validasipasien();"
METHOD = "POST" name="formpasien" ENCTYPE="MULTIPART/FORM-DATA">
<font color="blue"><h3>ENTRI DATA PASIEN </h3>
<HR>
<table>
<tr><td align="right"> Kode Pasien : </td>
<td><input id="textpasien" name="textpasien"
type ="text" maxlength="8" size="8">
</td>
</tr>
<tr><td align="right"> Nama Pasien : </td>
<td><input id="textnama" name="textnama"
type ="text" maxlength="25" size="15">
</td>
</tr>
<tr><td align="right"> Alamat : </td>
<td><input id="textalamat" name="textalamat"
type ="text" maxlength="40" size="20">
</td>
</tr>
<tr><td align="right">Golongan Darah : </td>
<td>
<select id="combodarah" name="combodarah">
<option value="A" selected>A</option>
<option value="B">B</option>
<option value="AB">AB</option>
<option value="O">O</option>
</select>
</td>
</tr>
<tr><td align="right">Jenis Kelamin : </td>
<td>
<select id="combojk" name="combojk">
<option value="L" selected>L</option>
<option value="P">P</option>
</select>
</td>
</tr>
<tr><td align="right">
<font size="2"color="blue">Tempat lahir :</font>
</td>
<td>
<input id="texttempat" name="texttempat" type="text" maxlength="15" size="15">
</td>
</tr>
<tr><td align="right">
<font size="2"color="blue">Tanggal lahir :</font>
</td>
<td>
<input id="texttgl_lahir" name="texttgl_lahir" type="text" maxlength="15" size="15">
</td>
</tr>
<tr><td align="right">
<font size="2"color="blue">Nomor Telepon :</font>
</td>
<td>
<input id="texttelp" name="texttelp" type="text" maxlength="15" size="15">
</td>
</tr>
</table>
<hr>
<input name="tombolsimpan" type="submit" value="Simpan">
<hr>
</form>
</body>
</html>
<head>
<title>Entri Data Pasien</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
function trim(str)
{
return str.replace(/^\s+|\s+$/g,'');
}
function validasipasien()
{
var cpasien,cnama,calamat,cgol_darah,ckelamin,ctempat,ctanggal,ctelp;
with(window.document.formpasien)
{
cpasien = textpasien;
cnama = textnama;
calamat = textalamat;
cgol_darah = combodarah;
ckelamin = combojk;
ctempat = texttempat;
ctanggal = texttgl_lahir;
ctelp = texttelp;
}
if(trim(cpasien.value) == '')
{
alert('Silahkan isi dulu nama dengan lengkap');
cpasien.focus();
return false;
}
else
if(trim(cnama.value) == '')
{
alert('Silahkan isi dulu nama dengan lengkap');
cnama.focus();
return false;
}
else
if(trim(calamat.value)== '')
{
alert('Alamat jangan kosong!!');
calamat.focus();
return false;
}
else
if(trim(cgol_darah.value) == '')
{
alert('Isi dulu golongan darah pasien');
cgol_darah.focus();
return false;
}
else
if(trim(ckelamin.value) == '')
{
alert('Silahkan isi dulu jenis kelamin');
ckelamin.focus();
return false;
}
else
if(trim(ctempat.value) == '')
{
alert('Silahkan isi dulu tempat lahir pasien');
ctempat.focus();
return false;
}
else
if(trim(ctanggal.value) == '')
{
alert('Silahkan isi tanggal lahir pasien');
ctanggal.focus();
return false;
}
else
if(trim(ctelp.value) == '')
{
alert('Silahkan isi dulu nomor telephon !!');
ctelp.focus();
return false;
}
else
{
cpasien.value = trim(cpasien.value);
cnama.value = trim(cnama.value);
calamat.value = trim(calamat.value);
cgol_darah.value = trim(cgol_darah.value);
ckelamin.value = trim(ckelamin.value);
ctempat.value = trim(ctempat.value);
ctanggal.value = trim(ctanggal.value);
ctelp.value = trim(ctelp.value);
return true;
}
}
</script>
</head>
<body>
<FORM action = "simpanpasien.php" onsubmit = "return validasipasien();"
METHOD = "POST" name="formpasien" ENCTYPE="MULTIPART/FORM-DATA">
<font color="blue"><h3>ENTRI DATA PASIEN </h3>
<HR>
<table>
<tr><td align="right"> Kode Pasien : </td>
<td><input id="textpasien" name="textpasien"
type ="text" maxlength="8" size="8">
</td>
</tr>
<tr><td align="right"> Nama Pasien : </td>
<td><input id="textnama" name="textnama"
type ="text" maxlength="25" size="15">
</td>
</tr>
<tr><td align="right"> Alamat : </td>
<td><input id="textalamat" name="textalamat"
type ="text" maxlength="40" size="20">
</td>
</tr>
<tr><td align="right">Golongan Darah : </td>
<td>
<select id="combodarah" name="combodarah">
<option value="A" selected>A</option>
<option value="B">B</option>
<option value="AB">AB</option>
<option value="O">O</option>
</select>
</td>
</tr>
<tr><td align="right">Jenis Kelamin : </td>
<td>
<select id="combojk" name="combojk">
<option value="L" selected>L</option>
<option value="P">P</option>
</select>
</td>
</tr>
<tr><td align="right">
<font size="2"color="blue">Tempat lahir :</font>
</td>
<td>
<input id="texttempat" name="texttempat" type="text" maxlength="15" size="15">
</td>
</tr>
<tr><td align="right">
<font size="2"color="blue">Tanggal lahir :</font>
</td>
<td>
<input id="texttgl_lahir" name="texttgl_lahir" type="text" maxlength="15" size="15">
</td>
</tr>
<tr><td align="right">
<font size="2"color="blue">Nomor Telepon :</font>
</td>
<td>
<input id="texttelp" name="texttelp" type="text" maxlength="15" size="15">
</td>
</tr>
</table>
<hr>
<input name="tombolsimpan" type="submit" value="Simpan">
<hr>
</form>
</body>
</html>
Kamis, 24 Desember 2009
Keluar.php
KIRIM.php
<?php
session_start();
$namauser = $_POST['user'];
$password = $_POST['sandi'];
$koneksi=mysql_connect('localhost','root','');
mysql_select_db("kharisma");
$query=mysql_query("SELECT * from login where user='$namauser' AND password='$password'");
$periksa=mysql_num_rows($query);
if ($periksa=!0)
{
$_SESSION['namauser']=$namauser;
echo "<p>Selamat Datang ".$_SESSION['namauser']."</P>";
echo "<p>Berikut ini menu navigasi anda</p>";
echo "<p><a href='pertama.php'>Navigasi A</a>";
echo "<a href='kedua.php'>Navigasi A</a>";
}
else
{
echo "Silahkan Login Dulu!";
}
?>
Index.php
<html>
<head><title>Form Login</title>
</head>
<body>
<form method="post" action="kirim.php">
Pengguna : <input type="text" name="user"><br>
Kata Sandi : <input type="password" name="sandi"><br>
<input type="submit" name="submit" value="Kirim">
</body>
</html>
Formmahasiswa.php
<html>
<head><title>Belajar Tabel</title>
</head>
<body>
<form name = "FMhs" method = post>
<table border = 0>
<tr><td colspan = "3"><h1><center>Form Mahasiswa</center></h1></td></tr>
<tr><td>NPM</td><td>:</td><td><input type = "text" name = "txtnpm" maxlength = 14></td></tr>
<tr><td>NAMA</td><td>:</td><td><input type = "text" name = "txtnama"></td></tr>
<tr><td>PRODI</td><td>:</td><td><SELECT name = "comboprodi">
<option value = "TI">Teknik Informatika</option>
<option value = "SI">Sistem Informasi</option>
</SELECT></td></tr>
<tr><td>JENIS KELAMIN</td><td>:</td><td><input type = "radio" name = "rdLaki-laki" value = "Laki-laki">Laki-laki
<input type = "radio" name = "rdPerempuan" value = "Perempuan">Perempuan</td></tr>
<tr><td>HOBY</td><td>:</td><td><input type = "checkbox" value = "Catur" name = "cbhoby" checked>Catur
<input type = "checkbox" value = "Musik" name = "cbhoby">Musik</td></tr>
<tr><td><input type = "submit" value = "SIMPAN"></td><td><input type = "reset" value = "BERSIHKAN"></td></tr>
</table>
</form>
</body>
</html>
<?php
session_start();
$namauser = $_POST['user'];
$password = $_POST['sandi'];
$koneksi=mysql_connect('localhost','root','');
mysql_select_db("kharisma");
$query=mysql_query("SELECT * from login where user='$namauser' AND password='$password'");
$periksa=mysql_num_rows($query);
if ($periksa=!0)
{
$_SESSION['namauser']=$namauser;
echo "<p>Selamat Datang ".$_SESSION['namauser']."</P>";
echo "<p>Berikut ini menu navigasi anda</p>";
echo "<p><a href='pertama.php'>Navigasi A</a>";
echo "<a href='kedua.php'>Navigasi A</a>";
}
else
{
echo "Silahkan Login Dulu!";
}
?>
Index.php
<html>
<head><title>Form Login</title>
</head>
<body>
<form method="post" action="kirim.php">
Pengguna : <input type="text" name="user"><br>
Kata Sandi : <input type="password" name="sandi"><br>
<input type="submit" name="submit" value="Kirim">
</body>
</html>
Formmahasiswa.php
<html>
<head><title>Belajar Tabel</title>
</head>
<body>
<form name = "FMhs" method = post>
<table border = 0>
<tr><td colspan = "3"><h1><center>Form Mahasiswa</center></h1></td></tr>
<tr><td>NPM</td><td>:</td><td><input type = "text" name = "txtnpm" maxlength = 14></td></tr>
<tr><td>NAMA</td><td>:</td><td><input type = "text" name = "txtnama"></td></tr>
<tr><td>PRODI</td><td>:</td><td><SELECT name = "comboprodi">
<option value = "TI">Teknik Informatika</option>
<option value = "SI">Sistem Informasi</option>
</SELECT></td></tr>
<tr><td>JENIS KELAMIN</td><td>:</td><td><input type = "radio" name = "rdLaki-laki" value = "Laki-laki">Laki-laki
<input type = "radio" name = "rdPerempuan" value = "Perempuan">Perempuan</td></tr>
<tr><td>HOBY</td><td>:</td><td><input type = "checkbox" value = "Catur" name = "cbhoby" checked>Catur
<input type = "checkbox" value = "Musik" name = "cbhoby">Musik</td></tr>
<tr><td><input type = "submit" value = "SIMPAN"></td><td><input type = "reset" value = "BERSIHKAN"></td></tr>
</table>
</form>
</body>
</html>
Login.php
LOGIN.php
<html>
<head><title>Form Login</title>
</head>
<body>
<form method="post" action="kirim.php">
Pengguna : <input type="text" name="user"><br>
Kata Sandi : <input type="password" name="sandi"><br>
<input type="submit" name="submit" value="Kirim">
</body>
</html>
<html>
<head><title>Form Login</title>
</head>
<body>
<form method="post" action="kirim.php">
Pengguna : <input type="text" name="user"><br>
Kata Sandi : <input type="password" name="sandi"><br>
<input type="submit" name="submit" value="Kirim">
</body>
</html>
Rabu, 23 Desember 2009
TAMPIL.php
TAMPILBUU.PHP
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Tugas Pemrograman Web Dasar</title>
</head>
<body>
<table width="750" border="1">
<tr bgcolor="#33CCCC">
<td colspan="8"><b><p align="center">DAFTAR BUKU</p></b></td>
</tr>
<tr bgcolor="#33FFFF">
<td align="center" width="100"><b>Kode Buku</b></td>
<td align="center" width="500"><b>Judul Buku</b></td>
<td align="center" width="150"><b>Kode Pengarang</b></td>
<td align="center" width="150"><b>Kode Penerbit</b></td>
<td align="center" width="200"><b>ISBN Buku</b></td>
<td align="center" width="150"><b>Tahun Terbit</b></td>
<td align="center" colspan="2" width="100"><b>Tombol</b></td>
</tr>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal konek server".mysql_error());
mysql_select_db("bukudb",$koneksi)
or die ("Database gagal dibuka".mysql_error());
$sql = "SELECT * FROM buku ";
$qry = mysql_query($sql, $koneksi)
or die ("Query Gagal ".mysql_error());
while($data=mysql_fetch_array($qry)){
?>
<tr>
<td><?php echo $data['kode_buku']; ?></td>
<td><?php echo $data['judul_buku']; ?></td>
<td><?php echo $data['kode_pengarang']; ?></td>
<td><?php echo $data['kode_penerbit']; ?></td>
<td><?php echo $data['isbn_buku']; ?></td>
<td><?php echo $data['tahun_terbit']; ?></td>
<td align="center"><a href="hapusbuku.php?ID=<?php echo $data['kode_buku']; ?>">Hapus</a></td>
<td align="center"><a href="tampilubahbuku.php?ID=<?php echo $data['kode_buku']; ?>">Ubah</a></td>
</tr>
<?php } ?>
</table>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Tugas Pemrograman Web Dasar</title>
</head>
<body>
<table width="750" border="1">
<tr bgcolor="#33CCCC">
<td colspan="8"><b><p align="center">DAFTAR BUKU</p></b></td>
</tr>
<tr bgcolor="#33FFFF">
<td align="center" width="100"><b>Kode Buku</b></td>
<td align="center" width="500"><b>Judul Buku</b></td>
<td align="center" width="150"><b>Kode Pengarang</b></td>
<td align="center" width="150"><b>Kode Penerbit</b></td>
<td align="center" width="200"><b>ISBN Buku</b></td>
<td align="center" width="150"><b>Tahun Terbit</b></td>
<td align="center" colspan="2" width="100"><b>Tombol</b></td>
</tr>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal konek server".mysql_error());
mysql_select_db("bukudb",$koneksi)
or die ("Database gagal dibuka".mysql_error());
$sql = "SELECT * FROM buku ";
$qry = mysql_query($sql, $koneksi)
or die ("Query Gagal ".mysql_error());
while($data=mysql_fetch_array($qry)){
?>
<tr>
<td><?php echo $data['kode_buku']; ?></td>
<td><?php echo $data['judul_buku']; ?></td>
<td><?php echo $data['kode_pengarang']; ?></td>
<td><?php echo $data['kode_penerbit']; ?></td>
<td><?php echo $data['isbn_buku']; ?></td>
<td><?php echo $data['tahun_terbit']; ?></td>
<td align="center"><a href="hapusbuku.php?ID=<?php echo $data['kode_buku']; ?>">Hapus</a></td>
<td align="center"><a href="tampilubahbuku.php?ID=<?php echo $data['kode_buku']; ?>">Ubah</a></td>
</tr>
<?php } ?>
</table>
</body>
</html>
simpan.php
SIMPANbuku.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal Konek Server".mysql_error());
if($koneksi)
//echo ("BERHASIL Konek Server");
{
mysql_select_db("bukudb", $koneksi)
or die ("Database Gagal Dibuka".mysql_error());
//echo ("BERHASIL Buka Database");
$txtkodebuku=$_POST['txtkodebuku'];
$txtjudulbuku=$_POST['txtjudulbuku'];
$txtkodepengarang=$_POST['cmbpengarang'];
$txtkodepenerbit=$_POST['cmbpenerbit'];
$txtisbnbuku=$_POST['txtisbnbuku'];
$txttahunterbit=$_POST['txttahunterbit'];
$sql="INSERT INTO buku
VALUES ('$txtkodebuku', '$txtjudulbuku', '$txtkodepengarang',
'$txtkodepenerbit', '$txtisbnbuku', '$txttahunterbit')";
mysql_query($sql, $koneksi)
or die ("Gagal Simpan Query : ".mysql_error());
echo ("Data BERHASIL disimpan");
include "tampilbuku.php";
}
?>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal Konek Server".mysql_error());
if($koneksi)
//echo ("BERHASIL Konek Server");
{
mysql_select_db("bukudb", $koneksi)
or die ("Database Gagal Dibuka".mysql_error());
//echo ("BERHASIL Buka Database");
$txtkodebuku=$_POST['txtkodebuku'];
$txtjudulbuku=$_POST['txtjudulbuku'];
$txtkodepengarang=$_POST['cmbpengarang'];
$txtkodepenerbit=$_POST['cmbpenerbit'];
$txtisbnbuku=$_POST['txtisbnbuku'];
$txttahunterbit=$_POST['txttahunterbit'];
$sql="INSERT INTO buku
VALUES ('$txtkodebuku', '$txtjudulbuku', '$txtkodepengarang',
'$txtkodepenerbit', '$txtisbnbuku', '$txttahunterbit')";
mysql_query($sql, $koneksi)
or die ("Gagal Simpan Query : ".mysql_error());
echo ("Data BERHASIL disimpan");
include "tampilbuku.php";
}
?>
</body>
</html>
forminputbuku
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal Konek Server !!!!".mysql_error());
mysql_select_db("bukudb",$koneksi)
or die ("Gagal Buka Database !!!!".mysql_error());
$sql = "SELECT * FROM penerbit ";
$qry = mysql_query($sql, $koneksi)
or die ("Gagal Tampilkan Data !!!!".mysql_error());
$data = mysql_fetch_array($qry);
$kode_penerbit = $data['kode_penerbit'];
$nama_penerbit = $data['nama_penerbit'];
$alamat_penerbit = $data['alamat_penerbit'];
?>
</head>
<body>
<form action="simpanbuku.php" method="post" name="formbuku" target="_self">
<table width="350" border="1">
<tr bgcolor="#66ffff">
<td colspan="2">
<b><p align="center">Masukan Data Buku</p></b>
</td>
</tr>
<tr>
<td width="200">Kode Buku</td>
<td width="250"> : <input name="txtkodebuku" type="text" size="10" maxlenght="10"></td>
</tr>
<tr>
<td>Judul Buku</td>
<td> : <input name="txtjudulbuku" type="text" size="30" maxlength="30">
</td>
</tr>
<tr>
<td>Kode Pengarang</td>
<td> :
<select name="cmbpengarang">
<option value="notpenerbit" selected>[ Pengarang Buku ]</option>
<?php
$sql = "SELECT * FROM pengarang ORDER BY kode_pengarang";
$qry = mysql_query($sql, $koneksi) or die ("Gagal query");
while ($data =mysql_fetch_array($qry))
{
echo "<option value='$data[kode_pengarang]' $cek>$data[kode_pengarang]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>Kode Penerbit</td>
<td> :
<select name="cmbpenerbit">
<option value="notpenerbit" selected>[ Penerbit Buku ]</option>
<?php
$sql = "SELECT * FROM penerbit ORDER BY kode_penerbit";
$qry = mysql_query($sql, $koneksi) or die ("Gagal query");
while ($data =mysql_fetch_array($qry)) {
echo "<option value='$data[kode_penerbit]' $cek>$data[kode_penerbit]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>ISBN Buku</td>
<td> : <input name="txtisbnbuku" type="text" size="30" maxlength="30"></td>
</tr>
<tr>
<td>Tahun Terbit</td>
<td> : <input name="txttahunterbit" type="text" size="30" maxlength="30"></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" name="submit" value="Simpan">
</td>
</tr>
</table>
</form>
</body>
</html>
<html>
<head>
<title></title>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal Konek Server !!!!".mysql_error());
mysql_select_db("bukudb",$koneksi)
or die ("Gagal Buka Database !!!!".mysql_error());
$sql = "SELECT * FROM penerbit ";
$qry = mysql_query($sql, $koneksi)
or die ("Gagal Tampilkan Data !!!!".mysql_error());
$data = mysql_fetch_array($qry);
$kode_penerbit = $data['kode_penerbit'];
$nama_penerbit = $data['nama_penerbit'];
$alamat_penerbit = $data['alamat_penerbit'];
?>
</head>
<body>
<form action="simpanbuku.php" method="post" name="formbuku" target="_self">
<table width="350" border="1">
<tr bgcolor="#66ffff">
<td colspan="2">
<b><p align="center">Masukan Data Buku</p></b>
</td>
</tr>
<tr>
<td width="200">Kode Buku</td>
<td width="250"> : <input name="txtkodebuku" type="text" size="10" maxlenght="10"></td>
</tr>
<tr>
<td>Judul Buku</td>
<td> : <input name="txtjudulbuku" type="text" size="30" maxlength="30">
</td>
</tr>
<tr>
<td>Kode Pengarang</td>
<td> :
<select name="cmbpengarang">
<option value="notpenerbit" selected>[ Pengarang Buku ]</option>
<?php
$sql = "SELECT * FROM pengarang ORDER BY kode_pengarang";
$qry = mysql_query($sql, $koneksi) or die ("Gagal query");
while ($data =mysql_fetch_array($qry))
{
echo "<option value='$data[kode_pengarang]' $cek>$data[kode_pengarang]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>Kode Penerbit</td>
<td> :
<select name="cmbpenerbit">
<option value="notpenerbit" selected>[ Penerbit Buku ]</option>
<?php
$sql = "SELECT * FROM penerbit ORDER BY kode_penerbit";
$qry = mysql_query($sql, $koneksi) or die ("Gagal query");
while ($data =mysql_fetch_array($qry)) {
echo "<option value='$data[kode_penerbit]' $cek>$data[kode_penerbit]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>ISBN Buku</td>
<td> : <input name="txtisbnbuku" type="text" size="30" maxlength="30"></td>
</tr>
<tr>
<td>Tahun Terbit</td>
<td> : <input name="txttahunterbit" type="text" size="30" maxlength="30"></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" name="submit" value="Simpan">
</td>
</tr>
</table>
</form>
</body>
</html>
isi
<html>
<head><title>text/css</title>
</head>
<body bgcolor="ccccff">
<h1>database mahasiswa</h1>
</body>
</html>
<head><title>text/css</title>
</head>
<body bgcolor="ccccff">
<h1>database mahasiswa</h1>
</body>
</html>
menu
<html>
<head><title>text/css</title>
</head>
<body bgcolor="ccccff">
<h2>MENU</h2>
<p><a href="data.html" target="frmisi">Form Mahasiswa</a><br>
<a href="buku.html" target="frmisi">Kumpulan Buku</a></p>
</body>
</html>
<head><title>text/css</title>
</head>
<body bgcolor="ccccff">
<h2>MENU</h2>
<p><a href="data.html" target="frmisi">Form Mahasiswa</a><br>
<a href="buku.html" target="frmisi">Kumpulan Buku</a></p>
</body>
</html>
Frame
<html>
<head><title>text/css</title>
<frameset rows="20%,60%,">
<frame src="judul.html">
<frameset cols="20%,60%">
<frame src="menu.html" border="0">
<frameset rows="60%,20%">
<frame src="inti.html" border="0" >
<frame src="tampil.html" border="0">
</frameset>
</frame>
</head>
<body>
</body>
</html>
<head><title>text/css</title>
<frameset rows="20%,60%,">
<frame src="judul.html">
<frameset cols="20%,60%">
<frame src="menu.html" border="0">
<frameset rows="60%,20%">
<frame src="inti.html" border="0" >
<frame src="tampil.html" border="0">
</frameset>
</frame>
</head>
<body>
</body>
</html>
Selasa, 04 Agustus 2009
Pemrograman web
<html>
<head>
<title> Judul </title>
</head>
<body bgcolor =#d0fff1>
<center>
<p><b> praktikum1</b>
<font color=red>
<MARQUEE direction=left><h2> SELAMAT DATANG </h2></MARQUEE direction=up down>
<BR>
<center>
<font color=red>
<h1> STIMIK KHARISMA </h1></b>
<font>
</font>
<p> x <sup>2</sup> </p>
<p> x <sup>y</sup><sup>2</sup>
<HR>
</body>
</html>
Langganan:
Postingan (Atom)