Belajar PHP: CRUD dengan PHP paling sederhana

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

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>

--------------------------------------

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="Perempuan">Perempuan</option>

</select>

No. Telepon : <input type="text" name="telp"/>

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

--------------------------------------

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

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

<td width="30%">Alamat</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"><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

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

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