Assalamualaikum Wr.Wb
A. Materi.
1. Pertama kita buat script koneksi utuk menyambungkan ke databasenya, dan simpan dengan nama "koneksi.php"
<?php
$servername = "localhost";
$user = "root";
$pasword = "";
$db = "perpus";
$koneksi = mysql_connect ($servername,$user, $pasword)
or die ('gagal terkoneksi'.mysql_error());
$database = mysql_select_db ($db)
or die ('gagal terhubung ke database'.mysql_error());
?>
2.Setelah itu kita buat file "index.php"
<html>
<head>
</head>
<body>
<table width="auto" border="1">
<tr>
<td colspan="2" align="center"><h1>Sistem Informasi Perpustakaan SMK Hasan Kafrawi</h1> <br><script type='text/javascript' src='//eclkmpsa.com/adServe/banners?tid=94091_154020_0&tagid=2'></script> <br> <script type='text/javascript' src='//eclkmpbn.com/adServe/banners?tid=94091_154020_2'></script></td>
</tr>
<tr>
<td width = "200" bgcolor="#1aff1a">
<ul>
<li><a href="anggota.php">Anggota</a></li>
<li><a href="buku.php">Buku</a></li>
<li><a href="Pinjam.php">Pinjam</a></li>
<ul>
</td>
<td width="auto">Selamat Datang Di Sistem Perpustakaan SMK Hasan Kafrawi</td>
</tr>
<tr>
<td colspan="2" align="center">Yakun-La_Pulga</td>
</tr>
</table>
</body>
</html>
kita coba jalankan di browser maka hasilnya akan seperti ini.
3.selanjutnya kita buat file "anggota.php"
<html>
<head>
</head>
<body>
<table width="auto" border="5">
<tr>
<td colspan="2" align="center" bgcolor="#eee"><h1>Sistem Informasi Perpustakaan SMK Hasan Kafrawi</h1></td>
</tr>
<tr>
<td width = "auto" bgcolor="#1aff1a">
<ul>
<li><a href="anggota.php">Siswa</a></li>
<li><a href="buku.php">Buku</a></li>
<li><a href="pinjam.php">Pinjam</a></li>
<ul>
</td>
<td width="auto" >
<a href="input_anggota.php">Input anggota</a>
<table border="1">
<style>
table {
border-collapse: collapse;
width: 100%;
}
th, td {
padding: 8px;
}
tr:nth-child(even){background-color: #f2f2f2}
th {
background-color: #4CAF50;
color: white;
}
</style>
<thead>
<tr>
<th >No</th>
<th >id_anggota </th>
<th >nama anggota </th>
<th >alamat </th>
<th >TTl </th>
<th >Status</th>
<th >Aksi</th>
</tr>
</thead>
<tbody>
<?php
include "koneksi.php";
$query = "select * from anggota order by id_anggota";
$sql = mysql_query ($query);
$no = 1;
while ($data=mysql_fetch_array($sql)) {
?>
<tr class="odd gradeX">
<td><?php echo $no?></td>
<td><?php echo $data['id_anggota'];?></td>
<td><?php echo $data['nm_anggota'];?></td>
<td><?php echo $data['alamat'];?></td>
<td><?php echo $data['ttl_anggota'];?></td>
<td class="center"><?php echo $data['status_anggota'];?></td>
<td class="center"><a href="edit_anggota.php?id=<?php echo $data['id_anggota']; ?>" > Edit </a>|<a href="hapus_anggota.php?id=<?php echo $data['id_anggota']; ?>"
onClick = "return confirm('Apakah Anda ingin mengapus <?php echo $data['nm_anggota']; ?>?')"> hapus</a></td>
</tr>
<?php $no++; }?>
</tbody>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#eee">Yakun-La_Pulga<br><script type='text/javascript' src='//eclkmpsa.com/adServe/banners?tid=94091_154020_0&tagid=2'></script> <br> <script type='text/javascript' src='//eclkmpbn.com/adServe/banners?tid=94091_154020_2'></script></td>
</tr>
</table>
</body>
</html>
kita coba jalankan di browser maka hasilnya kan seperti ini.
4.Supaya kita bisa menambahkan anggota di perpustakaan , kita harus buat file "input_anggota.php"
<html>
<head>
</head>
<body>
<table width="auto" border="5" bgcolor="#eee">
<tr>
<td colspan="2" align="center"><h1>Selamat Datang Di Sistem Perpustakaan SMK Hasan Kafrawi</h1></td>
</tr>
<tr>
<td width = "200" bgcolor="#1aff1a">
<ul>
<li><a href="anggota.php">Siswa</a></li>
<li><a href="buku.php">Buku</a></li>
<li><a href="pinjam.php">Pinjam</a></li>
<ul>
</td>
<td width="auto">
<form method="post" action="proses.php" >
<table border="0">
<tr>
<td>Nama Siswa</td>
<td>:</td>
<td><input type="text" name="nama" placeholder="Nama"></td>
</tr>
<tr>
<td>Alamat</td>
<td>:</td>
<td><textarea name="alamat" placeholder="Alamat" ></textarea></td>
</tr>
<tr>
<td>TTL</td>
<td>:</td>
<td><textarea name="ttl" placeholder="Tempat tanggal lahir" ></textarea></td>
</tr>
<tr>
<td>Status</td>
<td>:</td>
<td><select name="status">
<option value="1">aktif</option>
<option value="2">tidak aktif</option>
</select></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type="submit" name="simpan" value="simpan"></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#eee">Yakun-La_Pulga<br><script type='text/javascript' src='//eclkmpsa.com/adServe/banners?tid=94091_154020_0&tagid=2'></script> <br> <script type='text/javascript' src='//eclkmpbn.com/adServe/banners?tid=94091_154020_2'></script></td>
</tr>
</table>
</body>
</html>
Kemudian kita coba buka di browser maka hasilnya akan seperti ini
5. Setelah itu kita buat file "proses.php"
<?php
include "koneksi.php";
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$ttl = $_POST['ttl'];
$status = $_POST['status'];
$query = mysql_query('insert into anggota(nm_anggota,alamat,ttl_anggota,status_anggota) values ("'.$nama.'","'.$alamat.'","'.$ttl.'","'.$status.'")');
if ($query) {
echo "<script>alert('data berhasil disimpan');
document.location.href='anggota.php'</script>\n";
} else {
echo "<script>alert('data gagal disimpan');
document.location.href='input_anggota.php'</script>\n";
}
?>
Referensi :
- nurulafidah123456.blogspot.co.id
- www.wikipedia.com
"Sekian postingan saya kali ini semoga bermanfaat, selamat mencoba.
Wassalamualaikum Wr.Wb
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon