PHP

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

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 - By TobiWeb.id</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 - <a href="http://tobiweb.id" target="_blank">By TobiWeb</a></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>

ADD.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 - By TobiWeb.id</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 - <a href="http://tobiweb.id" target="_blank">By TobiWeb</a></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>

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 - By TobiWeb.id</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 - <a href="http://tobiweb.id" target="_blank">By TobiWeb</a></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>

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;
}