Tulisan ini berawal dari salah satu mata kuliah di kampus, gue disuruh ngerjain CRUD pake script PHP sederhana dengan waktu 15 menit. Sesuai perintah soal, editor yang dipake adalah PHP Coder, webserver pake Apache2Triad. Hmm.. Jadul banget sih, cuman ya.. Ikutin apa kata perintah aja deh.. hehe
Tapi, gue agak bandel, gue nantangin waktu 15 menit itu dengan nulis kode PHP ngga di PHP Coder, tapi murni pake editor bawaan windows: Notepad. Siapa yang ngga kenal editor Notepad? Cung!!! 😀
Dalam kurun waktu 15 menit, gue mulai ngetik… <?php tik tik tik….. 5 menit…. 10 menit…. dan… selesaii.. 😀
Selama lagi ngerjain soal, gue kepikiran buat nulis scriptnya di blog.. Niatnya buat berbagi aja 🙂
# File: index.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 |
<?php // @Author : Ahmad Fauzi // NIM : 12101779 // Kelas : 12.5B.B // File : index.php require ("lib/config.php"); if (isset($_POST['simpan_btn'])) { $date = date('Y-m-d H:i:s'); $qry = @mysql_query("INSERT INTO `karyawan` VALUES('', '$_POST[nik]', '$_POST[nama]', '$_POST[alamat]', '$_POST[jk]', '$_POST[telp]', '$date')"); if ($qry) { echo "<div style='text-align:center;font-weight:bolder;background-color:green;border:1px dashed red;padding:10px;'>Data berhasil disimpan</div>"; } else { echo "<div style='text-align:center;font-weight:bolder;background-color:yellow;border:1px dashed red;padding:10px;'>Data gagal disimpan</div>"; } } if (isset($_POST['edit_btn'])) { //$date = date('Y-m-d H:i:s'); $qry = @mysql_query("UPDATE `karyawan` SET nik = '$_POST[nik]', nama = '$_POST[nama]', alamat = '$_POST[alamat]', jk = '$_POST[jk]', telp = '$_POST[telp]' WHERE id = '$_POST[id]'"); if ($qry) { echo "<div style='text-align:center;font-weight:bolder;background-color:green;border:1px dashed red;padding:10px;'>Data berhasil diubah</div>"; } else { echo "<div style='text-align:center;font-weight:bolder;background-color:yellow;border:1px dashed red;padding:10px;'>Data gagal diubah</div>"; } } $qry = @mysql_query("SELECT * FROM karyawan"); $total = @mysql_num_rows($qry); ?> <html> <head> <title>Tabel Data Karyawan</title> </head> <body> <?php if ($_GET['mod'] == "tambah") { ?> <pre> <b>TAMBAH KARYAWAN BARU</b> -------------------------------------- <form action="" method="post"> NIK : <input type="text" name="nik"/> Nama Karyawan : <input type="text" name="nama"/> Alamat Karyawan : <textarea name="alamat" cols="50" rows="3"></textarea> Jenis Kelamin : <select name="jk"> <option value="Laki-Laki">Laki-Laki</option> <option value="Perempuan">Perempuan</option> </select> No. Telepon : <input type="text" name="telp"/> <input type="submit" name="simpan_btn" value="Simpan Karyawan"/> | <input type="reset" value="Hapus Ulang"/> | <input type="button" onClick="window.location.href='./index.php'" value="Lihat Semua Karyawan"/> </form> </pre> <?php } elseif ($_GET['mod'] == "edit") { $qry = @mysql_query("SELECT * FROM karyawan WHERE id = '$_GET[id]'"); $row = @mysql_fetch_array($qry); if ($row['jk'] == "Laki-Laki") { $lkselected = "selected"; } if ($row['jk'] == "Perempuan") { $prselected = "selected"; } ?> <pre> <b>EDIT KARYAWAN</b> -------------------------------------- <form action="" method="post"> <input type="hidden" name="id" value="<?= $row['id'] ?>"> NIK : <input type="text" value="<?= $row['nik'] ?>" name="nik"/> Nama Karyawan : <input type="text" value="<?= $row['nama'] ?>" name="nama"/> Alamat Karyawan : <textarea name="alamat" cols="50" rows="3"><?= $row['alamat'] ?></textarea> Jenis Kelamin : <select name="jk"> <option <?= $lkselected ?> value="Laki-Laki">Laki-Laki</option> <option <?= $prselected ?> value="Perempuan">Perempuan</option> </select> No. Telepon : <input type="text" value="<?= $row['telp'] ?>" name="telp"/> <input type="submit" name="edit_btn" value="Ubah Karyawan"> | <input type="button" onClick="window.location.href='./index.php'" value="Batalkan Edit & Lihat Semua Karyawan"/> </form> </pre> <?php } elseif ($_GET['mod'] == "delete") { $qry = @mysql_query("DELETE FROM karyawan WHERE id = '$_GET[id]'"); if ($qry) { echo "<div style='text-align:center;font-weight:bolder;background-color:green;border:1px dashed red;padding:10px;'>Data berhasil dihapus (Mengarahkan dalam 2 detik)</div><meta http-equiv='refresh' content='2;URL=./index.php'>"; } else { echo "<div style='text-align:center;font-weight:bolder;background-color:yellow;border:1px dashed red;padding:10px;'>Data gagal dihapus</div>"; } ?> <?php } else { ?> <center>Total Karyawan: <?= $total ?></center> <table width="100%" border="1"> <tr style="background-color:black;color:#fff;text-align:center;font-weight:bolder;"> <td width="5%">No</td> <td width="10%">NIK</td> <td width="20%">Nama</td> <td width="30%">Alamat</td> <td width="15%">J/K</td> <td width="10%">Phone</td> <td width="10%">Options</td> </tr> <?php $no = 1; while ($row = @mysql_fetch_array($qry)) { ?> <tr> <td align="center"><?= $no++; ?></td> <td><?= $row['nik'] ?></td> <td><?= $row['nama'] ?></td> <td><?= $row['alamat'] ?></td> <td><?= $row['jk'] ?></td> <td><?= $row['telp'] ?></td> <td align="center"><a href="index.php?mod=edit&id=<?= $row['id'] ?>">Edit</a> | <a href="index.php?mod=delete&id=<?= $row['id'] ?>" onclick="return window.confirm('Yakin akan menghapus?')">Delete</a></td> </tr> <?php } ?> </table> <a href="index.php?mod=tambah">Tambah Karyawan Baru</a> <?php } ?> </body> </html> |
# File: lib/config.php
1 2 3 4 5 6 7 8 9 |
<?php // @Author : Ahmad Fauzi // NIM : 12101779 // Kelas : 12.5B.B // File : config.php $conn = mysql_connect("localhost", "root", "") or die("Tidak dapat terhubung ke server"); mysql_select_db("sistem_karyawan", $conn) or die("Tidak dapat menemukan database"); ?> |
 # Database: sistem_karyawan (pake MySQL)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 23, 2013 at 04:33 AM -- Server version: 5.1.44 -- PHP Version: 5.3.1 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `sistem_karyawan` -- -- -------------------------------------------------------- -- -- Table structure for table `karyawan` -- CREATE TABLE IF NOT EXISTS `karyawan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nik` varchar(100) NOT NULL, `nama` varchar(100) NOT NULL, `alamat` text NOT NULL, `jk` varchar(50) NOT NULL, `telp` varchar(100) NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `karyawan` -- INSERT INTO `karyawan` (`id`, `nik`, `nama`, `alamat`, `jk`, `telp`, `date`) VALUES (3, '12100', 'Budiman', 'Jakarta', 'Laki-Laki', '0812345', '2013-02-23 04:32:46'), (4, '12101', 'Sulaiman', 'Bogor', 'Laki-Laki', '0854321', '2013-02-23 04:33:14'), (5, '12102', 'Fatimah', 'Bandung', 'Perempuan', '0898765', '2013-02-23 04:33:28'); |
Databasenya jangan lupa di import yaa 🙂
Semoga ngebantu yaa 😀