<html>
<head>
<title>Untitled Document</title>
</head>
<body>
<script language="javascript">
function validasi()
{if (document.f_mhs.npm.value=="")
{ alert("Isi dulu npm anda!");
document.f_mhs.npm.focus();
return false;
}
if (document.f_mhs.nama.value=="")
{ alert("Isi dulu nama anda!");
document.f_mhs.nama.focus();
return false;
}
if (document.f_mhs.tempat_lahir.value=="")
{ alert("Isi dulu tempat lahir anda!");
document.f_mhs.tempat_lahir.focus();
return false;
}
if (document.f_mhs.tgl_lahir.value=="")
{ alert("Isi dulu tanggal lahir anda!");
document.f_mhs.tgl_lahir.focus();
return false;
}
if (document.f_mhs.alamat.value=="")
{ alert("Isi dulu alamat!");
document.f_mhs.alamat.focus();
return false;
}
return true;
}
</script>
<form action="simpan.php" name="f_mhs" method="post" onSubmit="return validasi()">
<h2 align="left">Entri Data Mahasiswa</h2>
<table border="0">
<tr><td align="right" >Npm</td><td>:</td><td><input type="text" name="npm" size="20"></input></td></tr>
<tr><td align="right" >Nama</td><td>:</td><td><input type="text" name="nama" size="20"></input></td></tr>
<tr><td align="right" >Tempat lahir</td><td>:</td><td><input type="text" name="tempat_lahir" size="20"></input></td></tr>
<tr><td align="right">Tgl Lahir</td><td>:</td><td><input type="text" name="tgl_lahir" size="20"></input></td></tr>
<tr><td align="right">Alamat</td><td>:</td><td rowspan="5"><textarea name="alamat" rows="5" cols="16"></textarea></td></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr><td><input type="submit" name="simpan" value="Simpan"></td>
<td></td><td><input type="reset" name="hapus" value="Hapus"></td></tr>
</table>
</form>
</body>
</html>
tampil.php
<html>
<head>
<title>Tampil Data Member</title>
<style type = "text/CSS">
table { border: 1px solid #C0C0C0;}
td { border: 1px solid #C0C0C0;}
</style>
</head>
<body>
<table width="600">
<tr bgcolor="#AA0CCC">
<td colspan="8"><b><p align="center">DAFTAR MEMBER</p></b></td>
</tr>
<tr bgcolor="#33F99F">
<td align="center" width="200"><b>NPM</b></td>
<td align="center" width="200"><b>Nama</b></td>
<td align="center" width="200"><b>Tempat Lahir</b></td>
<td align="center" width="150"><b>tgl lahir</b></td>
<td align="center" width="200"><b>Alamat</b></td>
</tr>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal konek server".mysql_error());
mysql_select_db("dbsiswa",$koneksi)
or die ("Database gagal dibuka".mysql_error());
$sql = "SELECT * FROM mahasiswa ";
$qry = mysql_query($sql, $koneksi)
or die ("Query Gagal ".mysql_error());
while($data=mysql_fetch_array($qry)){
?>
<tr>
<td><?php echo $data['npm']; ?></td>
<td><?php echo $data['nama']; ?></td>
<td align="center"><?php echo $data['tempat_lahir']; ?></td>
<td align="center"><?php echo $data['tgl_lahir']; ?></td>
<td><?php echo $data['alamat']; ?></td>
</tr>
<?php } ?>
</table>
<a href="index.php">Masukkan Data Baru</a>
</body>
</html>
<head>
<title>Tampil Data Member</title>
<style type = "text/CSS">
table { border: 1px solid #C0C0C0;}
td { border: 1px solid #C0C0C0;}
</style>
</head>
<body>
<table width="600">
<tr bgcolor="#AA0CCC">
<td colspan="8"><b><p align="center">DAFTAR MEMBER</p></b></td>
</tr>
<tr bgcolor="#33F99F">
<td align="center" width="200"><b>NPM</b></td>
<td align="center" width="200"><b>Nama</b></td>
<td align="center" width="200"><b>Tempat Lahir</b></td>
<td align="center" width="150"><b>tgl lahir</b></td>
<td align="center" width="200"><b>Alamat</b></td>
</tr>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal konek server".mysql_error());
mysql_select_db("dbsiswa",$koneksi)
or die ("Database gagal dibuka".mysql_error());
$sql = "SELECT * FROM mahasiswa ";
$qry = mysql_query($sql, $koneksi)
or die ("Query Gagal ".mysql_error());
while($data=mysql_fetch_array($qry)){
?>
<tr>
<td><?php echo $data['npm']; ?></td>
<td><?php echo $data['nama']; ?></td>
<td align="center"><?php echo $data['tempat_lahir']; ?></td>
<td align="center"><?php echo $data['tgl_lahir']; ?></td>
<td><?php echo $data['alamat']; ?></td>
</tr>
<?php } ?>
</table>
<a href="index.php">Masukkan Data Baru</a>
</body>
</html>
simpan.php
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dbsiswa", $con);
$sql="INSERT INTO mahasiswa (npm, nama, tempat_lahir, tgl_lahir, alamat)
VALUES
('$_POST[npm]','$_POST[nama]','$_POST[tempat_lahir]','$_POST[tgl_lahir]','$_POST[alamat]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record berhasil di masukkan...";
echo "<br><a href='index.php'>Kembali</a>";
echo "<br><a href='tampil.php'>Tampil</a>";
mysql_close($con)
?>
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dbsiswa", $con);
$sql="INSERT INTO mahasiswa (npm, nama, tempat_lahir, tgl_lahir, alamat)
VALUES
('$_POST[npm]','$_POST[nama]','$_POST[tempat_lahir]','$_POST[tgl_lahir]','$_POST[alamat]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record berhasil di masukkan...";
echo "<br><a href='index.php'>Kembali</a>";
echo "<br><a href='tampil.php'>Tampil</a>";
mysql_close($con)
?>
Langganan:
Postingan (Atom)
Postingan
