by Lansung saja ke bagaimana cara Membuat create, read, update, dan delete atau biasa kita sebut CRUD Dengan PHP dan MySQLi
1. Membuat database
/* Create Database and Table */ create database db_sharecode; use db_sharecode; CREATE TABLE `pelanggan` ( `id` int(11) NOT NULL auto_increment, `nama` varchar(100), `email` varchar(100), `hp` varchar(15), PRIMARY KEY (`id`) );
2. Membuat Koneksi
silahakan buat satu file php nama terserah anda, untuk kasus ini saya buat dengan nama config.php
<?php /** * using mysqli_connect for database connection */ $databaseHost = 'localhost'; $databaseName = 'db_sharecode'; $databaseUsername = 'root'; $databasePassword = ''; $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); ?>
3. Membuat file index.php
<?php
// Create database connection using config file
include_once("config.php");
// Fetch all peanggan data from database
$result = mysqli_query($mysqli, "SELECT * FROM pelanggan ORDER BY id DESC");
?>
<html>
<head>
<title>Homepage</title>
</head>
<body>
<a href="add.php">Add New User</a><br/><br/>
<table width='80%' border=1>
<tr>
<th>Nama</th> <th>Nomor Hp</th> <th>Email</th> <th>Update</th>
</tr>
<?php
while($user_data = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$user_data['name']."</td>";
echo "<td>".$user_data['email']."</td>";
echo "<td>".$user_data['hp']."</td>";
echo "<td><a href='edit.php?id=$user_data[id]'>Edit</a> | <a href='delete.php?id=$user_data[id]'>Delete</a></td></tr>";
}
?>
</table>
</body>
</html>
4. Membuat file add.php
<html>
<head>
<title>Add Users</title>
</head>
<body>
<a href="index.php">Go to Home</a>
<br/><br/>
<form action="add.php" method="post" name="form1">
<table width="25%" border="0">
<tr>
<td>Name</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email"></td>
</tr>
<tr>
<td>Hp</td>
<td><input type="text" name="hp"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Add"></td>
</tr>
</table>
</form>
<?php
// Check If form submitted, insert form data into users table.
if(isset($_POST['Submit'])) {
$name = $_POST['name'];
$email = $_POST['email'];
$hp = $_POST['hp'];
// include database connection file
include_once("config.php");
// Insert user data into table
$result = mysqli_query($mysqli, "INSERT INTO users(name,email,hp) VALUES('$name','$email','$hp')");
// Show message when user added
echo "User added successfully. <a href='index.php'>View Users</a>";
}
?>
</body>
</html>
5. Membuat file edit.php
<?php
// include database connection file
include_once("config.php");
// Check if form is submitted for user update, then redirect to homepage after update
if(isset($_POST['update']))
{
$id = $_POST['id'];
$nama=$_POST['nama'];
$hp=$_POST['hp'];
$email=$_POST['email'];
// update user data
$result = mysqli_query($mysqli, "UPDATE pelanggan SET nama='$nama',email='$email',hp='$hp' WHERE id=$id");
// Redirect to homepage to display updated user in list
header("Location: index.php");
}
?>
<?php
// Display selected user data based on id
// Getting id from url
$id = $_GET['id'];
// Fetech user data based on id
$result = mysqli_query($mysqli, "SELECT * FROM pelanggan WHERE id=$id");
while($user_data = mysqli_fetch_array($result))
{
$nama = $user_data['nama'];
$email = $user_data['email'];
$hp = $user_data['hp'];
}
?>
<html>
<head>
<title>Edit User Data</title>
</head>
<body>
<a href="index.php">Home</a>
<br/><br/>
<form name="update_user" method="post" action="edit.php">
<table border="0">
<tr>
<td>Name</td>
<td><input type="text" name="nama" value=<?php echo $nama;?>></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" value=<?php echo $email;?>></td>
</tr>
<tr>
<td>hp</td>
<td><input type="text" name="hp" value=<?php echo $hp;?>></td>
</tr>
<tr>
<td><input type="hidden" name="id" value=<?php echo $_GET['id'];?>></td>
<td><input type="submit" name="update" value="Update"></td>
</tr>
</table>
</form>
</body>
</html>
6. Membuat file delete.php
<?php
// include database connection file
include_once("config.php");
// Get id from URL to delete that user
$id = $_GET['id'];
// Delete user row from table based on given id
$result = mysqli_query($mysqli, "DELETE FROM pelanggan WHERE id=$id");
// After delete redirect to Home, so that latest user list will be displayed.
header("Location:index.php");
?>
