Tutorial Membuat CRUD dengan PHP

Untuk basic CRUD blog ini mengutip dari sini

Download file dasar berikut Download dan kemudian extract file tersebut ke folder C:\xampp\htdocs\Pendaftaran

Langkah pertama buatlah database terlebih dahulu dengan cara paste SQL berikut

create database crud_db;

use crud_db;

CREATE TABLE `users` (

`id` int(11) NOT NULL auto_increment,

`nama` varchar(100),

`ketunaan` varchar(100),

`alamat` varchar(15),

`telp` varchar(15),

`bakat` varchar(15),

`ortu` varchar(15),

PRIMARY KEY (`id`)

);

Masuk ke phpMyAdmin, click "SQL"

execute SQL diatas

Cek database harusnya sudah terbuat

- config.php
Setelah membuat database, langkah selanjutnya membuat file config.php, buka file config php yang tadi telah di download, kemudian masukkan code berikut :

<?php
/**
* using mysqli_connect for database connection
*/

$databaseHost = 'localhost';
$databaseName = 'crud_db';
$databaseUsername = 'root';
$databasePassword = '';

$mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName);

?>

kemudian save.

Saya percepat saya untuk bagian CRUD karena blog ini juga akan membahas penggunaan Bootstrap juga, jika ingin lebih detail mengenai CRUD silahkan kesini

- Index.php
Copy paste code berikut kedalam file index.php :

<?php
// Create database connection using config file
include_once("config.php");

// Fetch all users data from database
$result = mysqli_query($mysqli, "SELECT * FROM users 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>Ketunaan</th> <th>Alamat</th> <th>Telepon</th> <th>Bakat</th> <th>Orang Tua</th> <th>Action </th>
</tr>
<?php
while($user_data = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$user_data['nama']."</td>";
echo "<td>".$user_data['ketunaan']."</td>";
echo "<td>".$user_data['alamat']."</td>";
echo "<td>".$user_data['telp']."</td>";
echo "<td>".$user_data['bakat']."</td>";
echo "<td>".$user_data['ortu']."</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>

- 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>Nama</td>
<td><input type="text" name="nama"></td>
</tr>
<tr>
<td>Ketunaan</td>
<td><input type="text" name="ketunaan"></td>
</tr>
<tr>
<td>Alamat</td>
<td><input type="text" name="alamat"></td>
</tr>
<tr>
<td>Nomor Telepon</td>
<td><input type="text" name="telp"></td>

</tr>
<tr>
<td>Bakat</td>
<td><input type="text" name="bakat"></td>

</tr>
<tr>
<td>Nama Orang Tua</td>
<td><input type="text" name="ortu"></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'])) {
$nama = $_POST['nama'];
$ketunaan = $_POST['ketunaan'];
$alamat = $_POST['alamat'];
$telp = $_POST['telp'];
$bakat= $_POST['bakat'];
$ortu = $_POST['ortu'];

// include database connection file
include_once("config.php");

// Insert user data into table
$result = mysqli_query($mysqli, "INSERT INTO users(nama,ketunaan,alamat,telp,bakat,ortu) VALUES('$nama','$ketunaan','$alamat','$telp','$bakat','$ortu')");

// Show message when user added
echo "User added successfully. <a href='index.php'>View Users</a>";
}
?>
</body>

</html>

- 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'];
$ketunaan=$_POST['ketunaan'];
$alamat=$_POST['alamat'];
$telp=$_POST['telp'];
$bakat=$_POST['bakat'];
$ortu=$_POST['ortu'];

// update user data
$result = mysqli_query($mysqli, "UPDATE users SET nama='$nama',ketunaan='$ketunaan',alamat='$alamat',telp='$telp',bakat='$bakat',ortu='$ortu' 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 users WHERE id=$id");

while($user_data = mysqli_fetch_array($result))
{
$nama = $user_data['nama'];
$ketunaan = $user_data['ketunaan'];
$alamat = $user_data['alamat'];
$telp = $user_data['telp'];
$bakat = $user_data['bakat'];
$ortu = $user_data['ortu'];
}
?>
<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>Nama</td>
<td><input type="text" name="nama" value=<?php echo $nama;?>></td>
</tr>
<tr>
<td>Ketunaan</td>
<td><input type="text" name="ketunaan" value=<?php echo $ketunaan;?>></td>
</tr>
<tr>
<td>Alamat</td>
<td><input type="text" name="alamat" value=<?php echo $alamat;?>></td>
</tr>

<tr>
<td>Telepon</td>
<td><input type="text" name="telp" value=<?php echo $telp;?>></td>
</tr>

<tr>
<td>Bakat</td>
<td><input type="text" name="bakat" value=<?php echo $bakat;?>></td>
</tr>

<tr>
<td>Orang Tua</td>
<td><input type="text" name="ortu" value=<?php echo $ortu;?>></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>

- 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 users WHERE id=$id");

// After delete redirect to Home, so that latest user list will be displayed.
header("Location:index.php");

?>

setelah semua file sudah dibuat langkah berikutnya akan saya sediakan template dan bisa di Download disini, setelah didownload kemudian extract semua file tsb kedalam folder yg sama dengan file sebelumnya.

Rubah file index.php menjadi seperti berikut :

<!DOCTYPE html>

<!--

<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>

-->

<?php

// Create database connection using config file

include_once("config.php");

// Fetch all users data from database

$result = mysqli_query($mysqli, "SELECT * FROM users ORDER BY id DESC");

?>

<html lang="en">

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<meta name="description" content="">

<meta name="author" content="">

<title>Clean Blog - Start Bootstrap Theme</title>

<!-- Bootstrap core CSS -->

<link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

<!-- Custom fonts for this template -->

<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">

<link href='https://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>

<link href='https://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800' rel='stylesheet' type='text/css'>

<!-- Custom styles for this template -->

<link href="css/clean-blog.min.css" rel="stylesheet">

</head>

<body>

<!-- Navigation -->

<nav class="navbar navbar-expand-lg navbar-light fixed-top" id="mainNav">

<div class="container">

<a class="navbar-brand" href="index.php">Start Bootstrap</a>

<button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">

Menu

<i class="fa fa-bars"></i>

</button>

<div class="collapse navbar-collapse" id="navbarResponsive">

<ul class="navbar-nav ml-auto">

<li class="nav-item">

<a class="nav-link" href="index.php">Home</a>

</li>

<li class="nav-item">

<a class="nav-link" href="about.html">About</a>

</li>

<li class="nav-item">

<a class="nav-link" href="post.html">Sample Post</a>

</li>

<li class="nav-item">

<a class="nav-link" href="contact.html">Contact</a>

</li>

</ul>

</div>

</div>

</nav>

<!-- Page Header -->

<header class="masthead" style="background-image: url('img/home-bg.jpg')">

<div class="overlay"></div>

<div class="container">

<div class="row">

<div class="col-lg-8 col-md-10 mx-auto">

<div class="site-heading">

<h1>Clean Blog</h1>

<span class="subheading">A Blog Theme by Start Bootstrap</span>

</div>

</div>

</div>

</div>

</header>

<!-- Main Content -->

<div class="container">

<a type="button" class="btn btn-info" href="add.php">Add New User</a><br/><br/>

<table class="table table-hover">    

<tr>

<th>Nama</th> <th>Ketunaan</th> <th>Alamat</th> <th>Telepon</th> <th>Bakat</th> <th>Orang Tua</th> <th>Action </th> 

</tr>

<?php

while($user_data = mysqli_fetch_array($result)) {        

echo "<tr>";

echo "<td>".$user_data['nama']."</td>";

echo "<td>".$user_data['ketunaan']."</td>";

echo "<td>".$user_data['alamat']."</td>";

echo "<td>".$user_data['telp']."</td>";

echo "<td>".$user_data['bakat']."</td>";   

echo "<td>".$user_data['ortu']."</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>

</div>

<hr>

<!-- Footer -->

<footer>

<div class="container">

<div class="row">

<div class="col-lg-8 col-md-10 mx-auto">

<ul class="list-inline text-center">

<li class="list-inline-item">

<a href="#">

<span class="fa-stack fa-lg">

<i class="fa fa-circle fa-stack-2x"></i>

<i class="fa fa-twitter fa-stack-1x fa-inverse"></i>

</span>

</a>

</li>

<li class="list-inline-item">

<a href="#">

<span class="fa-stack fa-lg">

<i class="fa fa-circle fa-stack-2x"></i>

<i class="fa fa-facebook fa-stack-1x fa-inverse"></i>

</span>

</a>

</li>

<li class="list-inline-item">

<a href="#">

<span class="fa-stack fa-lg">

<i class="fa fa-circle fa-stack-2x"></i>

<i class="fa fa-github fa-stack-1x fa-inverse"></i>

</span>

</a>

</li>

</ul>

<p class="copyright text-muted">Copyright &copy; Your Website 2018</p>

</div>

</div>

</div>

</footer>

<!-- Bootstrap core JavaScript -->

<script src="vendor/jquery/jquery.min.js"></script>

<script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

<!-- Custom scripts for this template -->

<script src="js/clean-blog.min.js"></script>

</body>

</html>

Rubah edit.php menjadi :

<?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'];

$ketunaan=$_POST['ketunaan'];

$alamat=$_POST['alamat'];

$telp=$_POST['telp'];

$bakat=$_POST['bakat'];

$ortu=$_POST['ortu'];

// update user data

$result = mysqli_query($mysqli, "UPDATE users SET nama='$nama',ketunaan='$ketunaan',alamat='$alamat',telp='$telp',bakat='$bakat',ortu='$ortu' 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 users WHERE id=$id");

while($user_data = mysqli_fetch_array($result))

{

$nama = $user_data['nama'];

$ketunaan = $user_data['ketunaan'];

$alamat = $user_data['alamat'];

$telp = $user_data['telp'];

$bakat = $user_data['bakat'];

$ortu = $user_data['ortu'];

}
?>
<html>

<head>

<!-- Bootstrap core CSS -->

<link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

<!-- Custom fonts for this template -->

<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">

<link href='https://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>

<link href='https://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800' rel='stylesheet' type='text/css'>

<!-- Custom styles for this template -->

<link href="css/clean-blog.min.css" rel="stylesheet">   

    <title>Edit User Data</title>

</head>

<body>

<div class="container">

<a type="button" class="btn btn-info" href="index.php">Home</a>

<br/><br/>

<form name="update_user" method="post" action="edit.php">

<table class="table table-hover">

<tr>

<td>Nama</td>

<td><input type="text" name="nama" value=<?php echo $nama;?>></td>

</tr>

<tr>

<td>Ketunaan</td>

<td><input type="text" name="ketunaan" value=<?php echo $ketunaan;?>></td>

</tr>

<tr>

<td>Alamat</td>

<td><input type="text" name="alamat" value=<?php echo $alamat;?>></td>

</tr>

<tr>

<td>Telepon</td>

<td><input type="text" name="telp" value=<?php echo $telp;?>></td>

</tr>

<tr>

<td>Bakat</td>

<td><input type="text" name="bakat" value=<?php echo $bakat;?>></td>

</tr>

<tr>

<td>Orang Tua</td>

<td><input type="text" name="ortu" value=<?php echo $ortu;?>></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>

</div>    

</body>

</html>

Rubah Add.php

<html>

<head>

<!-- Bootstrap core CSS -->

<link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

<!-- Custom fonts for this template -->

<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">

<link href='https://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>

<link href='https://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800' rel='stylesheet' type='text/css'>

<!-- Custom styles for this template -->

<link href="css/clean-blog.min.css" rel="stylesheet">

    <title>Add Users</title>

</head>

<body>

<div class="container">

<a type="button" class="btn btn-info" href="index.php">Go to Home</a>

<br/><br/>

<form action="add.php" method="post" name="form1">

<table class="table table-hover">

<tr> 

<td>Nama</td>

<td><input type="text" name="nama"></td>

</tr>

<tr> 

<td>Ketunaan</td>

<td><input type="text" name="ketunaan"></td>

</tr>

<tr> 

<td>Alamat</td>

<td><input type="text" name="alamat"></td>

</tr>

<tr> 

<td>Nomor Telepon</td>

<td><input type="text" name="telp"></td>

</tr>

<tr> 

<td>Bakat</td>

<td><input type="text" name="bakat"></td>

</tr>

<tr> 

<td>Nama Orang Tua</td>

<td><input type="text" name="ortu"></td>

</tr>

<tr> 

<td></td>

<td><input type="submit" class="btn btn-success" name="Submit" value="Add"></td>

</tr>

</table>
 </form>
</div>
<?php

// Check If form submitted, insert form data into users table.

if(isset($_POST['Submit'])) {

$nama = $_POST['nama'];

$ketunaan = $_POST['ketunaan'];

$alamat = $_POST['alamat'];

$telp = $_POST['telp'];

$bakat= $_POST['bakat'];

$ortu = $_POST['ortu'];

// include database connection file

include_once("config.php");

// Insert user data into table

$result = mysqli_query($mysqli, "INSERT INTO users(nama,ketunaan,alamat,telp,bakat,ortu) VALUES('$nama','$ketunaan','$alamat','$telp','$bakat','$ortu')");

// Show message when user added

echo "User added successfully. <a href='index.php'>View Users</a>";

}

?>

</body>

</html>

Tekno Anime Game

Breaking News

Tutorial Membuat CRUD dengan PHP

No comments

Popular Posts

Recent Posts

Comments

Categories

Tags

Featured Posts

Recent Posts

Recent in Sports