Cara membuat Crud Sederhana Menggunakan PHP & Mysqli With Boostrapp
Langkah Pertama Membuat database dengan nama
- crud_php di http://localhost:8080/phpmyadmin/
Langkah kedua Membuat table diDatabase
CREATE TABLE `tbl_data` (
`id_data` int(11) NOT NULL,
`nama` char(90) NOT NULL,
`jenis_kelamin` enum('L','P') NOT NULL,
`tanggal_lahir` char(40) NOT NULL,
`alamat` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Langkah Ketiga Buat file index.php
Didalam file ini ada beberapa proses input edit dan delete kedalam database seperti :
- if(isset($_POST['input'])){ // fungsi ini digunakan untuk menginput data kedalama database
- if(isset($_POST['edit'])){ // fungsi ini digunakan untuk mengedit data berdasarakan id_data kedalam database
<!DOCTYPE html>
<html lang="en">
<head>
<title>Crud Php & Bootstrap 4</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js"></script>
<!-- Font -->
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Raleway">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<!-- data tab -->
<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css">
<!-- date -->
<script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
<script src="https://unpkg.com/gijgo@1.9.13/js/gijgo.min.js" type="text/javascript"></script>
<link href="https://unpkg.com/gijgo@1.9.13/css/gijgo.min.css" rel="stylesheet" type="text/css" />
</head>
<body>
<nav class="navbar navbar-expand-md bg-dark navbar-dark">
<!-- Brand -->
<a class="navbar-brand" href="#">Crud PHP Mysqli & Bootstrap</a>
<!-- Toggler/collapsibe Button -->
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#collapsibleNavbar">
<span class="navbar-toggler-icon"></span>
</button>
<!-- Navbar links -->
<div class="collapse navbar-collapse" id="collapsibleNavbar">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="index.php">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="index.php?data_mahasiswa">Data Mahasiswa</a>
</li>
<li class="nav-item">
<a class="nav-link text-danger" href="#">Logout</a>
</li>
</ul>
</div>
</nav>
<br>
<div class="container">
<?php
$conn = mysqli_connect('localhost','root','','crud_php') or die(mysqli_error());
//$_POST
if(isset($_POST['input'])){
$nama = $_POST['nama'];
$jenis_kelamin = $_POST['jenis_kelamin'];
$tanggal_lahir = $_POST['tanggal_lahir'];
$alamat = $_POST['alamat'];
//insert database
$insert = mysqli_query($conn,"INSERT INTO `tbl_data` (`nama`,`jenis_kelamin`,`tanggal_lahir`,`alamat`)
values('$nama','$jenis_kelamin','$tanggal_lahir','$alamat')") or die(mysqli_error());
if($insert=="True"){
setcookie("message", "Berhasil Input Kedatabase", time()+600);
}else{
setcookie("message","Gagal Input Kedatabase", time()+600);
}
header('location: index.php?data_mahasiswa');
}else
if(isset($_POST['edit'])){
$id_data = $_POST['id_data'];
$nama = $_POST['nama'];
$jenis_kelamin = $_POST['jenis_kelamin'];
$tanggal_lahir = $_POST['tanggal_lahir'];
$alamat = $_POST['alamat'];
//update kedata base
$update = mysqli_query($conn,"UPDATE `tbl_data` SET nama='$nama', jenis_kelamin='$jenis_kelamin', tanggal_lahir='$tanggal_lahir', alamat='$alamat'
WHERE id_data='$id_data' ");
if($update=="True"){
setcookie("message", "Berhasil Edit Kedatabase", time()+600);
}else{
setcookie("message", "Gagal Edit Kedatabase", time()+600);
}
header('location: index.php?data_mahasiswa');
}else
if(isset($_GET['edit'])){
$id_data = $_GET['edit'];
include_once"edit.php";
}else
if(isset($_GET['hapus'])){
$id_data = $_GET['hapus'];
//hapus database berdasarkan id_data
$delete = mysqli_query($conn,"DELETE FROM `tbl_data` WHERE id_data='$id_data' ");
if($delete){
setcookie("message", "Berhasil Hapus Kedatabase", time()+600);
}else{
setcookie("message", "Gagal Hapus Kedatabase", time()+600);
}
header('location: index.php?data_mahasiswa');
}else
if(isset($_GET['data_mahasiswa'])){
// Cek apakah terdapat cookie dengan nama message
if(!empty($_COOKIE["message"])){ // Jika ada
echo"<div class='alert alert-success alert-dismissible'>
<button type='button' class='close' data-dismiss='alert'>×</button>
<strong>Success!</strong> $_COOKIE[message]
</div>";
}
include_once"data_mahasiswa.php";
}else{
echo'<div class="alert alert-secondary">
<strong>Home</strong> Crud Sederhana Menggunakan Php Mysqli & Boostrapp By Fadillah Nugroho
</div>';
}
?>
<script src="//cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
<script>
//datatab
$(document).ready(function() {
$('#datatab').DataTable();
} );
//datepicker
$('#datepicker').datepicker({
uiLibrary: 'bootstrap4'
});
//konfirmasi Hapus
function konfirmasi(){
tanya = confirm("Anda Yakin Akan Menghapus Data ?");
if(tanya == true) return true;
else return false;
}
</script>
</div>
</body>
</html>
0 Komentar