![\"struktur\"](\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/struktur.jpg\")
<\/a><\/figure><\/div>\n\n\n\nstruktur tabel profil yang kita buat, bisa kalian lihat diatas. Nah kita sudah punya database dengan nama karyawan dengan tabel profil . Kita lanjutkan dengan membuat file untuk koneksi ke database.<\/p>\n\n\n
\n<?php\n \n $server = 'localhost'; \/\/nama lokalhost\n $username = 'root'; \/\/ nama user\n $password = ''; \/\/password\n $dbase = 'karyawan2'; \/\/ nama databse\n \n \/\/ query untuk koneksi ke database\n mysql_connect($server, $username, $password) or die (mysql_error());\n \n \/\/query untuk koneksi ke database\n mysql_select_db($dbase) or die (mysql_error());\n \n \n \n\/**\n * Created by PhpStorm.\n * User: faroq\n * Date: 3\/2\/2015\n * Time: 10:11 PM\n *\/\n<\/pre><\/div>\n\n\nSimpan file diatas dengan nama koneksi.php<\/p>\n\n\n\n
Kita lanjutkan dengan membuat aksi untuk input data,<\/p>\n\n\n
\n<!DOCTYPE html>\n<html>\n<head lang="en">\n <meta charset="UTF-8">\n <title>Input Profil<\/title>\n <link rel="stylesheet" href="http:\/\/yui.yahooapis.com\/pure\/0.6.0\/pure-min.css">\n <script type="text\/javascript" src="ckeditor\/ckeditor.js"><\/script>\n<\/head>\n<body>\n <form action="insert.php" method="post">\n <table align="center">\n <tr>\n <td colspan="3"><h3>Form Input Profil<\/h3><\/td>\n <\/tr>\n <tr>\n <td>Nama<\/td>\n <td>:<\/td>\n <td><input type="text" name="nama" placeholder="Masukan Nama" required="required"><\/td>\n <\/tr>\n <tr>\n <td>Jenis Kelamin<\/td>\n <td>:<\/td>\n <td><input type="radio" name="jenis_kelamin" value="Laki-laki">Laki-laki<\/td>\n <td><input type="radio" name="jenis_kelamin" value="Perempuan">Perempuan<\/td>\n <\/tr>\n <tr>\n <td>Alamat<\/td>\n <td>:<\/td>\n <td><textarea cols="30" rows="5" name="alamat" class="ckeditor"><\/textarea><\/td>\n <\/tr>\n <tr>\n <td>Nomor Telepon<\/td>\n <td>:<\/td>\n <td><input type="text" name="tlp"><\/td>\n <\/tr>\n <tr>\n <td colspan="3"><input type="submit" name="submit" value="Send">\n <input type="reset" name="reset" value="Clear"><\/td>\n <\/tr>\n <\/table>\n <\/form>\n \n \n <h4><a href="data_profil.php">Lihat Data<\/a><\/h4>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\nsimpan file diatas dengan nama input_profil.php<\/p>\n\n\n\n
Kita lanjutkan dengan membuat proses, untuk insert ke databasenya.<\/p>\n\n\n
\n<?php\n \ninclude ("koneksi.php");\n \n$nama = $_POST['nama'];\n$jk = $_POST['jenis_kelamin'];\n$almt = $_POST['alamat'];\n$telepon = $_POST['tlp'];\n \n\/\/Perintah Query untuk proses insert ke database\n \n$sql_profil = "INSERT INTO profil (nama,jenis_kelamin,alamat,no_tlp)\n VALUES ('$nama','$jk','$almt','$telepon')";\n \n$sql = mysql_query($sql_profil) or die (mysql_error());\n \nif($sql){\n echo "Berhasil Simpan!\n <meta http-equiv='refresh' content='3;url=input_profil.php'>";\n} else {\n echo "Gagal simpan!\n <meta http-equiv='refresh' content='3;url=input_profil.php'>";\n}\n \n\/**\n * Created by PhpStorm.\n * User: faroq\n * Date: 3\/4\/2015\n * Time: 7:25 PM\n *\/\n<\/pre><\/div>\n\n\nsimpan file diatas dengan nama insert.php<\/p>\n\n\n\n
Sekarang kita lanjutkan untuk membuat tampilannya, sekarang buatlah file seperti berikut ini:<\/p>\n\n\n
\n<!DOCTYPE html>\n<html>\n<head lang="en">\n <meta charset="UTF-8">\n <title>Data Profil<\/title>\n <link rel="stylesheet" href="http:\/\/yui.yahooapis.com\/pure\/0.6.0\/pure-min.css">\n<\/head>\n<body>\n \n <h1 align="center">Data Profil<\/h1>\n <table border="1" align="center">\n <tr>\n <td>No<\/td>\n <td>Id Profil<\/td>\n <td>Nama<\/td>\n <td>Jenis Kelamin<\/td>\n <td>Alamat<\/td>\n <td>No Telpon<\/td>\n <td colspan="2">Aksi<\/td>\n <\/tr>\n <?php\n include("koneksi.php");\n $sql_profil = "SELECT * FROM profil";\n $sql = mysql_query($sql_profil) or die (mysql_error());\n \n \/\/proses menampilkan diambil dari database\n \n $no = 1;\n ?>\n <?php while($data_profil = mysql_fetch_array($sql)){ ?>\n \n <tr>\n <td><?php echo $no ?><\/td>\n <td><?php echo $data_profil['id_profil']?><\/td>\n <td><?php echo $data_profil['nama']?><\/td>\n <td><?php echo $data_profil['jenis_kelamin']?><\/td>\n <td><?php echo $data_profil['alamat']?><\/td>\n <td><?php echo $data_profil['no_tlp']?><\/td>\n <td><a href='edit_profil.php?edit_id=<?php echo $data_profil['id_profil']?>'>Edit<\/td>\n <td><a href=hapus.php?hapus_id=<?php echo $data_profil['id_profil']?>'>Hapus<\/a><\/td>\n \n <\/tr>\n \n <?php $no++; } ?>\n <\/table>\n \n <h4><a href="input_profil.php">+Tambah Data<\/a><\/h4>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\nsimpan file diatas dengan nama data_profil.php<\/p>\n\n\n\n
oke kita lanjutkan supaya data tersebut bisa kita edit, kita buat file seperti berikut ini:<\/p>\n\n\n
\n<!DOCTYPE html>\n<html>\n<head lang="en">\n <meta charset="UTF-8">\n <title>Input Profil<\/title>\n <link rel="stylesheet" href="http:\/\/yui.yahooapis.com\/pure\/0.6.0\/pure-min.css">\n<\/head>\n<body>\n \n <!--Form Edit Profil Karyawan -->\n \n <?php\n include("koneksi.php");\n $id_edit = $_GET['edit_id'];\n $query = "SELECT * FROM profil WHERE id_profil = '$id_edit'";\n $sql = mysql_query($query) or die(mysql_error());\n while($data = mysql_fetch_array($sql)){\n $id_profil = $data["id_profil"];\n $nama = $data["nama"];\n $jk = $data["jenis_kelamin"];\n $almt = $data["alamat"];\n $tlp = $data["no_tlp"];\n }\n ?>\n \n \n<form action="update.php" method="post" enctype="multipart\/form-data">\n <table align="center">\n <input type="hidden" name="id_profil" value="<?php echo $id_profil?>">\n <tr>\n <td colspan="3"><h3>Form Input Profil<\/h3><\/td>\n <\/tr>\n <tr>\n <td>Nama<\/td>\n <td>:<\/td>\n <td><input type="text" name="nama" value="<?php echo $nama?>"><\/td>\n <\/tr>\n <tr>\n <td>Jenis Kelamin<\/td>\n <td>:<\/td>\n <td><input type="radio" name="jenis_kelamin" value="Laki-laki" <?php if($jk == 'Laki-laki') echo "checked"?>>Laki-laki<\/td>\n <td><input type="radio" name="jenis_kelamin" value="Perempuan" <?php if($jk == 'Perempuan') echo "checked"?>>Perempuan<\/td>\n <\/tr>\n <tr>\n <td>Alamat<\/td>\n <td>:<\/td>\n <td><textarea cols="30" rows="5" name="alamat"><?php echo $almt?><\/textarea><\/td>\n <\/tr>\n <tr>\n <td>Nomor Telepon<\/td>\n <td>:<\/td>\n <td><input type="text" name="tlp" value="<?php echo $tlp?>"><\/td>\n <\/tr>\n <tr>\n <td colspan="3"><input type="submit" name="submit" value="Send">\n <input type="reset" name="reset" value="Clear"><\/td>\n <\/tr>\n <\/table>\n<\/form>\n \n <h4><a href="data_profil.php">Lihat Data<\/a><\/h4>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\nsimpan nama file diatas dengan nama edit_profil.php
Kita lanjut dengan membuat file untuk proses updatenya<\/p>\n\n\n
\n<?php\ninclude"koneksi.php";\n \n$id_profil = $_POST['id_profil'];\n$nama = $_POST['nama'];\n$jenis_kelamin = $_POST['jenis_kelamin'];\n$alamat = $_POST['alamat'];\n$telp = $_POST['tlp'];\n \n$query = "UPDATE profil\n SET nama='$nama', jenis_kelamin='$jenis_kelamin', alamat='$alamat', no_tlp='$telp', WHERE id_profil = '$id_profil'";\n$sql = mysql_query($query) or die (mysql_error());\n \n if($sql){\n echo"Berhasil Update\n <meta http-equiv='refresh' content='1;url=data_profil.php'>";\n } else {\n echo "Gagal Update";\n }\nmysql_close();\n \n\/**\n * Created by PhpStorm.\n * User: faroq\n * Date: 2\/14\/2015\n * Time: 11:34 AM\n *\/\n<\/pre><\/div>\n\n\nsimpan file tersebut dengan nama update.php
Untuk berikutnya kita buat file hapus.php<\/p>\n\n\n
\n<?php\n \n include("koneksi.php");\n \n $id_hapus = $_GET['hapus_id'];\n \n $sql_hapus = "DELETE FROM profil WHERE id_profil = '$id_hapus'";\n $sql = mysql_query($sql_hapus) or die (mysql_error());\n \n if($sql){\n echo"<script type='text\/javascript'> alert('Data Berhasil di Hapus!')<\/script>\n <meta http-equiv='refresh' content='4;url=data_profil.php'>";\n } else {\n echo"Hapus Data Gagal!";\n }\n \n \n\/**\n * Created by PhpStorm.\n * User: faroq\n * Date: 3\/4\/2015\n * Time: 8:29 PM\n *\/\n<\/pre><\/div>\n\n\n![\"ed\"](\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed.png\")
<\/a><\/figure>\n\n\n\nedit_id dan hapus_id yang akan kita $_GET<\/p>\n\n\n\n![\"ed2\"](\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed2.png\")
<\/a><\/figure>\n\n\n\n