Ass.wr.wb
Dalam membuat website di butuhkan suatu perogram yang mungkin dibutuh sekali seperti Aplikasi CRUD (create,read,update,delete) Disini saya akan membagikan sebuah artikel yang mungkin berguna untuk anda yang belum bisa atau belum tahu sama sekali tengtang membuat aplikasi CRUD tersebut silahkan simak di bawah,,dan COPAS (copy paste) code tersebut mau ditulis silahkan tapi menurut saya lebih baik di copy saja karena di tulis akan lama dan pusing karena banyak koding-koding nya.
silahkan...................................
Harus anda ketahui sebelum menulis kode dibawah anda harus membuat data base dulu dengan command prompt atau bisa langsung di adminphp.
Setelah selesai membuat database silahkan anda tulis kode-kode di bawah dengan taliti.
1. koneksi.php
Koneksi.php ialah script untuk menhubungkan ke database latihan.
<?php
$host = "localhost";
$user = "root";
$password = "";
$datbase = "latihan";
mysql_connect($host,$user,$password);
mysql_select_db($datbase);
?>
2. index.php
index.php ini ialah tampilan awalnya.
<?php
include_once 'koneksi.php';
// Hapus data
if(isset($_GET['delete_id']))
{
$sql_query="DELETE FROM users WHERE user_id=".$_GET['delete_id'];
mysql_query($sql_query);
header("Location: $_SERVER[PHP_SELF]");
}
// selesai hapus data
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Membuat CRUD dengan PHP and MySql</title>
<link rel="stylesheet" href="style.css" type="text/css" />
<script type="text/javascript">
function edt_id(id)
{
if(confirm('Apakah anda akan edit ?'))
{
window.location.href='edit.php?edit_id='+id;
}
}
function delete_id(id)
{
if(confirm('Apakah anda akan hapus ?'))
{
window.location.href='index.php?delete_id='+id;
}
}
</script>
</head>
<body>
<center>
<div id="header">
<div id="content">
<label>Membuat CRUD dengan PHP and MySql </label>
</div>
</div>
<div id="body">
<div id="content">
<table align="center">
<tr>
<th colspan="5"><a href="add.php">Tambah</a></th>
</tr>
<th>Nama Depan</th>
<th>Nama Belakang</th>
<th>Alamat Kota</th>
<th colspan="2">Aksi</th>
</tr>
<?php
$sql_query="SELECT * FROM users";
$result_set=mysql_query($sql_query);
while($row=mysql_fetch_row($result_set))
{
?>
<tr>
<td><?php echo $row[1]; ?></td>
<td><?php echo $row[2]; ?></td>
<td><?php echo $row[3]; ?></td>
<td align="center"><a href="javascript:edt_id('<?php echo $row[0]; ?>')">Edit</a></td>
<td align="center"><a href="javascript:delete_id('<?php echo $row[0]; ?>')"> Hapus</a></td>
</tr>
<?php
}
?>
</table>
</div>
</div>
</center>
</body>
</html>
3. create.php
Script yang satu ini ialah script untuk tambah data.
<?php
include_once 'koneksi.php';
if(isset($_POST['btn-save']))
{
// variables for input data
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$city_name = $_POST['city_name'];
// variables for input data
// sql query for inserting data into database
$sql_query = "INSERT INTO users(first_name,last_name,user_city) VALUES('$first_name','$last_name','$city_name')";
// sql query for inserting data into database
// sql query execution function
if(mysql_query($sql_query))
{
?>
<script type="text/javascript">
alert('Data Tersimpan Sukses');
window.location.href='index.php';
</script>
<?php
}
else
{
?>
<script type="text/javascript">
alert('Error while inserting your data');
</script>
<?php
}
// sql query execution function
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Membuat CRUD dengan PHP and MySql </title>
<link rel="stylesheet" href="style.css" type="text/css" />
</head>
<body>
<center>
<div id="header">
<div id="content">
<label>Membuat CRUD dengan PHP and MySql </label>
</div>
</div>
<div id="body">
<div id="content">
<form method="post">
<table align="center">
<tr>
<td align="center"><a href="index.php">Kembali Ke Halaman Awal</a></td>
</tr>
<tr>
<td><input type="text" name="first_name" placeholder="Nama Depan" required /></td>
</tr>
<tr>
<td><input type="text" name="last_name" placeholder="Nama Belakang" required /></td>
</tr>
<tr>
<td><input type="text" name="city_name" placeholder="Kota" required /></td>
</tr>
<tr>
<td><button type="submit" name="btn-save"><strong>Simpan</strong></button></td>
</tr>
</table>
</form>
</div>
</div>
</center>
</body>
</html>
4. edit.php
Halaman ini untuk menampilkan form edit
<?php
include_once 'koneksi.php';
if(isset($_GET['edit_id']))
{
$sql_query="SELECT * FROM users WHERE user_id=".$_GET['edit_id'];
$result_set=mysql_query($sql_query);
$fetched_row=mysql_fetch_array($result_set);
}
if(isset($_POST['btn-update']))
{
// variables for input data
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$city_name = $_POST['city_name'];
// variables for input data
// sql query for update data into database
$sql_query = "UPDATE users SET first_name='$first_name',last_name='$last_name',user_city='$city_name' WHERE user_id=".$_GET['edit_id'];
// sql query for update data into database
// sql query execution function
if(mysql_query($sql_query))
{
?>
<script type="text/javascript">
alert('Data Are Updated Successfully');
window.location.href='index.php';
</script>
<?php
}
else
{
?>
<script type="text/javascript">
alert('error occured while updating data');
</script>
<?php
}
// sql query execution function
}
if(isset($_POST['btn-cancel']))
{
header("Location: index.php");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Membuat CRUD dengan PHP and MySql </title>
<link rel="stylesheet" href="style.css" type="text/css" />
</head>
<body>
<center>
<div id="header">
<div id="content">
<label>Membuat CRUD dengan PHP and MySql </label>
</div>
</div>
<div id="body">
<div id="content">
<form method="post">
<table align="center">
<tr>
<td><input type="text" name="first_name" placeholder="First Name" value="<?php echo $fetched_row['first_name']; ?>" required /></td>
</tr>
<tr>
<td><input type="text" name="last_name" placeholder="Last Name" value="<?php echo $fetched_row['last_name']; ?>" required /></td>
</tr>
<tr>
<td><input type="text" name="city_name" placeholder="City" value="<?php echo $fetched_row['user_city']; ?>" required /></td>
</tr>
<tr>
<td>
<button type="submit" name="btn-update"><strong>UPDATE</strong></button>
<button type="submit" name="btn-cancel"><strong>Cancel</strong></button>
</td>
</tr>
</table>
</form>
</div>
</div>
</center>
</body>
</html>
5. style.php
@charset "utf-8";
/* CSS Document */
*
{
margin:0;
padding:0;
}
body
{
background:#f9f9f9;
font-family:"Open Sans", Courier, monospace;
}
#header
{
width:100%;
height:50px;
background:#EC143C;
color:#f9f9f9;
font-family:"Lucida Sans", "Lucida Grande", sans-serif;
font-size:35px;
text-align:center;
}
#header a
{
color:#fff;
text-decoration:blink;
}
#body
{
margin-top:50px;
}
table
{
width:80%;
font-family:Tahoma, Geneva, sans-serif;
font-weight:bolder;
color:#999;
margin-bottom:80px;
}
table a
{
text-decoration:none;
color:#00a2d1;
}
table,td,th
{
border-collapse:collapse;
border:solid #d0d0d0 1px;
padding:20px;
}
table td input
{
width:97%;
height:35px;
border:dashed #00a2d1 1px;
padding-left:15px;
font-family:Verdana, Geneva, sans-serif;
box-shadow:0px 0px 0px rgba(1,0,0,0.2);
outline:none;
}
table td input:focus
{
box-shadow:inset 1px 1px 1px rgba(1,0,0,0.2);
outline:none;
}
table td button
{
border:solid #f9f9f9 0px;
box-shadow:1px 1px 1px rgba(1,0,0,0.2);
outline:none;
background:#00a2d1;
padding:9px 15px 9px 15px;
color:#f9f9f9;
font-family:Arial, Helvetica, sans-serif;
font-weight:bolder;
border-radius:3px;
width:49.5%;
}
table td button:active
{
position:relative;
top:1px;
}
Setelah selesai menulis kode di atas silahkan anda panggil aplikasi CRUD tersebut di browser anda.
Selesai.sekian terimakasih
Penulis:by.Rusdy
No comments:
Post a Comment