Tutorial Crud Dengan PHP, Mysqli, Dan Bootstraps

Hallo Sobat...

Disini gua mau share tutorial dan source code crud dengan menggunakan PHP mysqli dan bootstrap

langsung ke codenya saja ya guys....

Database 

CREATE DATABASE wjd_praktek;

CREATE TABLE `pendaftaran_siswa`.`calon_siswa` (
`id` INT NOT NULL AUTO_INCREMENT ,
`nama` VARCHAR(64) NOT NULL ,
`alamat` VARCHAR(255) NOT NULL ,
`jenis_kelamin` VARCHAR(16) NOT NULL ,
`agama` VARCHAR(16) NOT NULL ,
`sekolah_asal` VARCHAR(64) NOT NULL ,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;

koneksi.php

<?php
   
   
    //error_reporting(0);//agar tidak menampilkan pesan error
   
    // konek ke database wdj_praktek
   
    $host = "localhost";
    $user = "root";
    $pass = "";
    $db    = "wdj_praktek";
   
    $koneksi = mysqli_connect($host,$user,$pass,$db);
   
   
?>

index.php

 

<!-- konek ke database -->
<?php
include 'koneksi.php';
 ?>
<!DOCTYPE html>
<html>
<head>
    <title>WDJ PRAKTEK</title>
<link rel="stylesheet" type="text/css" href="assets/css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="assets/css/style.css">
<link rel="stylesheet" type="text/css" href="assets/css/bootstrap.min.css">
</head>
<body>

<div id="header">
  <a href="index.php">ENTRY INFORMASI</a>
</div>

<div class="container">
<h1>FORM ENTRY INFORMASI</h1>

<!-- Form isi input informasi -->

<form action="" method="POST">
  <div class="form-group">
    <label for="judul">JUDUL</label>
    <input type="text" class="form-control" id="judul" name="judul" required="required" placeholder="Judul Informasi">
  </div>
  <div class="form-group">
    <label for="isi">ISI</label>
    <input type="text" class="form-control" id="isi" name="isi" required="required" placeholder="Isi Informasi">
  </div>
  <!-- menuju proses input informasi -->
  <button type="submit" class="btn btn-primary" name="submit">SIMPAN</button>
</form>


<br><br>
<h1>DATA INFORMASI</h1>

<!-- mendeklarasi table -->

<table class="table table-bordered table-striped">
<!-- kepala table -->
    <thead>
      <tr>
        <th>ID</th>
        <th>JUDUL</th>
        <th>ISI</th>
        <th>JAMPOST</th>
        <th>AKSI</th>
      </tr>
    </thead>
    <tbody>
 <!-- script php menampilkan data informasi -->
     <?php

        $query = mysqli_query($koneksi,"select * FROM informasi");
       
        while($data = mysqli_fetch_array($query)){
            ?>
      <tr>
        <td><?php echo $data['id']; ?></td>
        <td><?php echo $data['judul']; ?></td>
        <td><?php echo $data['isi']; ?></td>
        <td><?php echo $data['jampost']; ?></td>
        <td>
            <!-- tombol edit -->
          <a href="<?php echo 'edit.php?id='.$data['id'].'';?>" class="btn btn-default btn-md" title="Edit" NAME>Edit</a> 
          <!-- tombol delete -->
               <a href="<?php echo 'index.php?id='.$data['id'].'';?>" class="btn btn-primary btn-md" name="delete" title="Delete">Hapus
          </td>
      
      </tr>

     <?php } ?>
     
    </tbody>
  </table>
</div>
<div id="footer">
    <p>Copyright bayujunisp &copy;2019</p>
</div>
</body>

<script type="text/javascript" src="assets/js/jquery.min.js"></script>
<script type="text/javascript" src="assets/js/bootstrap.min.js"></script>
</html>

<!-- script untuk input -->
<?php

if(isset($_POST['submit']))
{
 
$urut = mysqli_fetch_array(mysqli_query($koneksi,"SELECT MAX(id) AS no FROM informasi"));
   
$id = $urut['no']+1;

   
$judul = $_POST['judul'];
$isi = $_POST['isi'];

date_default_timezone_set('Asia/jakarta');
$time = date('h:i:s');

//simpan data ke database table informasi
$query = mysqli_query($koneksi,"insert into informasi values('$id','$judul','$isi','$time')") or die(mysqli_error());

echo "<script>alert('data berhasil disimpan');
document.location.href='index.php'; </script>";
}
 ?>

 <!-- script php untuk delete -->
 <?php
if(isset($_GET['id'])){
  $id =$_GET['id'];

$query=mysqli_query($koneksi,"delete from informasi where id='$id'") or die(mysqli_error());

  echo "<script>alert('data berhasil dihapus');
document.location.href='index.php'; </script>";
}
  ?>

edit.php 

<?php
include 'koneksi.php';
 ?>
<!DOCTYPE html>
<html>
<head>
    <title>WDJ PRAKTEK</title>
<link rel="stylesheet" type="text/css" href="assets/css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="assets/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="assets/css/style.css">
</head>
<body>
<div id="header">
 
<a href="index.php">ENTRY INFORMASI</a>
  </div>
<div class="container">
<br><br><br>
<h1>FORM UPDATE INFORMASI</h1>

<?php
$id= $_GET['id'];
$query = mysqli_query($koneksi,"select*from informasi where id = '$id'");
while ($data = mysqli_fetch_array($query)) {

 ?>
<form action="" method="POST">
<input type="hidden" name="id" value="<?php echo $data['id']; ?>">
  <div class="form-group">
    <label for="judul">JUDUL</label>
    <input type="text" class="form-control" id="judul" name="judul" value="<?php echo $data['judul']; ?>" required="required">
  </div>
  <div class="form-group">
    <label for="isi">ISI</label>
    <input type="text" class="form-control" id="isi" name="isi" value="<?php echo $data['isi']; ?>" required="required">
  </div>
      <button type="submit" class="btn btn-primary" name="update">UPDATE</button>
  

</form>
<?php } ?>
</div>

<br><br><br><br><br><br><br><br>
<div id="footer">
  <p>Copyright bayujunisp &copy;2019</p>
</div>
</body>
<script type="text/javascript" src="assets/js/jquery.min.js"></script>
<script type="text/javascript" src="assets/js/bootstrap.min.js"></script>
</html>

<?php
if(isset($_POST['update'])){

$id = $_POST['id'];
$judul = $_POST['judul'];
$isi = $_POST['isi'];
$query = mysqli_query($koneksi,"update informasi set judul = '$judul',isi = '$isi' where id = '$id'") or die(mysqli_error());

if ($query){
  echo "<script>alert('data berhasil diupdate');
document.location.href='index.php'; </script>";
  }
   else {
    echo "<script>alert('data gagal diupdate');
document.location.href='index.php'; </script>";
  }

}
 ?>


Untuk Link Source Code bisa di klik disini..

LINK SOURCE CODE

 

Sekian Dari Postingan saya ini semoga bermanfaat.....