Master CRUD 1 - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul Master CRUD 1, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan Artikel Master CRUD, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.

Judul : Master CRUD 1
link : Master CRUD 1

Baca juga


Master CRUD 1

Jenis Materi : Cara membuat materi CRUD (Create, Read, Update, Delete ) sederhana
Studi Kasus : Data mahasiswa sederhana
Keterangan : Susunan file



1. Database


Nama Database : dbstimik.php



2. Koneksi

Nama file : koneksi.php
scrip php:

<?php
$databaseHost = 'localhost';
$databaseName = 'dbstmik';
$databaseUsername = 'root';
$databasePassword = '';

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

if (mysqli_connect_errno()){
 echo "Koneksi database gagal : " . mysqli_connect_error();
}
?>

===============================================================
Alternatif script :

<?php
$koneksi = mysqli_connect('localhost', 'root', '', 'dbstmik');
if (mysqli_connect_errno()) {
  echo "Koneksi gagal : ".mysqli_connect_error();
}
?>


3. Halaman Index

Nama file : index.php
Script php :

<!DOCTYPE html>
<html>
<head>
  <title></title>
</head>
<body>
<center>
  <table style="width: 70%;" border="1" cellspacing="0" cellpadding="5">
  <tr><th><img src="image/1c.png" height="120px" width="240px;"></th></tr>
  <tr><th><a href="?open=beranda">BERANDA</a> | <a href="?open=input">INPUT DATA</a> | <a href="?open=cari">CARI DATA </a> | <a href="?open=laporan"> LAPORAN</a></th></tr>
  <tr><th>

   <?php 
   if(isset($_GET['open'])){
   switch ($_GET['open']){
                         
              case'':
                                if (!file_exists ("buka.php")) die ("File Tidak Ada!");
                                include "buka.php"; break;
                             
                                default :
                                if (!file_exists ("buka.php")) die ("File Tidak Ada!");
                                include "buka.php"; break;                       
                           
                case 'input' :
                                 if (!file_exists ("tambah.php")) die ("File Tidak Ada!");
                                 include "tambah.php"; break;     
                         
                 case 'cari' :
                                 if (!file_exists ("cari.php")) die ("File Tidak Ada!");
                                 include "cari.php"; break; 
             
                 case 'laporan' :
                                 if (!file_exists ("laporan.php")) die ("File Tidak Ada!");
                                 include "laporan.php"; break; 

                 case 'update' :
                                 if (!file_exists ("update.php")) die ("File Tidak Ada!");
                                 include "update.php"; break; 

                    }

                    }elseif(isset($_GET['beranda'])){
                        include("buka.php");
                    }else{
                        include("buka.php");
                    }
   ?>

  </th></tr>
  <tr><th>Diberdayakan oleh : <a href='index.php'>wsacces.online</a></th></tr>
 </table>

</center>
</body>
</html>

4. Halaman Input Data

Nama file : tambah.php
Script php :

<html>
<head>
    <title>Input Data</title>
</head>
<body>
<center>

 <p>Input Data Mahasiswa</p>

 <form action="tambah.php" method="post" name="form1">
 <table width="25%" border="0">
  <tr>
  <td>NAMA</td>
  <td><input type="text" name="nama"></td>
  </tr>
  <tr>
  <td>NIM</td>
  <td><input type="text" name="nim"></td>
  </tr>
  <tr>
  <td>Jurusan</td>
  <td>
     <select name="jurusan" required>
       <option value="">Pilih </option>
       <option value="SISTIM INFORMASI">SISTIM INFORMASI</option>
       <option value="TEKNIK INFORMATIKA">TEKNIK INFORMATIKA</option>         
     </select>
   </td>
   </tr>
   <tr>
   <td>Alamat</td>
    <td><textarea name="alamat"></textarea></td>
    </tr>
    <tr>
     <td>No TLP</td>
     <td><input type="text" name="tlp"></td>
    </tr>
    <tr>
    <td></td>
    <td><input type="submit" name="Submit" value="Tambah"></td>
    </tr>
    </table>
    <br><br>
</form>
</center>
</body>
</html>

<?php

    $_SERVER['REQUEST_URI']= 'http://localhost/latihan1/?open=input';
    $bar=$_SERVER['REQUEST_URI'];

     include('koneksi.php');

    if(isset($_POST['Submit'])) {
        $nama = $_POST['nama'];
        $nim = $_POST['nim'];
        $jurusan = $_POST['jurusan'];
        $alamat = $_POST['alamat'];
        $tlp = $_POST['tlp'];
     
        $result = mysqli_query($koneksi, "INSERT INTO t_mahasiswa(nama,nim,jurusan,alamat,tlp) VALUES('$nama','$nim','$jurusan','$alamat','$tlp')");

   
 if($result){

     echo'<script language="javascript">alert("Data Berhasil Ditambahkan!");document.location="'.$bar.'";</script>';

 }else{
   
    echo'<script language="javascript">alert("Data Berhasil Dikirim!");document.location="'.$bar.'";</script>';

 }
 }
 
    ?>


5. Halaman Cari Data

Nama file : cari.php
Script php :

<!DOCTYPE html>
<html>
<head>
<title>Cari</title>
</head>
<body>
<center>

<h2>CARI DATA MAHASISWA</h2>

<?php
include 'koneksi.php';
?>

<form method="post">
<input type="text" name="nt" placeholder="Masukan Nim Mahasiswa">
<input type="submit" name="submit" value="cari">
</form>

<?php

 if (ISSET($_POST['submit'])){
 $cari = $_POST['nt'];
 $result = mysqli_query($koneksi, "SELECT * FROM t_mahasiswa WHERE nim='$cari'");
 // perhatikan fungsi = berbedadengan like

 while ($row = mysqli_fetch_array($result)){
  ?>

<?php echo "<h3>Hasil Pencarian</h3>"; ?>

<table border=1>
<tr>
  <th bgcolor="#AAAAAA">NAMA</th>   <th bgcolor="#AAAAAA">NIM</th> <th bgcolor="#AAAAAA">JURUSAN</th> <th bgcolor="#AAAAAA">ALAMAT</th> <th bgcolor="#AAAAAA">TLP</th> <th bgcolor="#AAAAAA">OPSI</th>
</tr>
 <tr>

 <td><?php echo $row['nama']; ?></td>
 <td><?php echo $row['nim']; ?></td>
 <td><?php echo $row['jurusan']; ?></td>
 <td><?php echo $row['alamat']; ?></td>
 <td><?php echo $row['tlp']; ?></td>

 <td><?php echo "<a href='index.php?open=update&nim=$row[nim]'>Edit</a> | <a href='hapus.php?nim=$row[nim]'>Delete</a>"."<br><br>";?>  </td>

</tr>
</table>

<?php echo "<br>" ?>

 <?php }} ?>

</center>
</body>
</html>

6. Halama Delete Data

Nama file : hapus.php
Script php :

<?php
// include database connection file
include ("koneksi.php");

// Get id from URL to delete that user
$nim = $_GET['nim'];

// Delete user row from table based on given id
$result = mysqli_query($koneksi, "DELETE FROM t_mahasiswa WHERE nim=$nim");

if($result){
 
     echo '<script language="javascript">alert("Data Berhasil Dihapus!"); document.location="index.php?open=cari";</script>';
 
  }else{
 
     echo '<script language="javascript">alert("Data Gagal Dihapus!"); document.location="index.php?open=cari";</script>';
  }
 ?>


7. Halaman Laporan

Nama file : laporan.php
Script php :

<?php

include ("koneksi.php");


$result = mysqli_query($koneksi, "SELECT * FROM t_mahasiswa ORDER BY nim DESC");
?>

<html>
<head> 
    <title>Laporan</title>
</head>

<body>
<center>

<h3>DAFTAR DATA MAHASISWA</h3>

    <table width='80%' border=1>

    <tr>
       <th bgcolor="#AAAAAA">NO</th>  <th bgcolor="#AAAAAA">NAMA</th>   <th bgcolor="#AAAAAA">NIM</th> <th bgcolor="#AAAAAA">JURUSAN</th> <th bgcolor="#AAAAAA">ALAMAT</th> <th bgcolor="#AAAAAA">TLP</th>
    </tr>
    <?php

    $nomor=1;
    while($row = mysqli_fetch_array($result)) {       
        echo "<tr>";
        echo "<td>".$nomor++."</td>";
        echo "<td>".$row['nama']."</td>";
        echo "<td>".$row['nim']."</td>";
        echo "<td>".$row['jurusan']."</td>"; 
        echo "<td>".$row['alamat']."</td>";
        echo "<td>".$row['tlp']."</td>";
           
    }

    ?>
    </table>
 
<br>
<br>

</center>
</body>
</html>

8. Halaman Buka

Nama file : buka.php
Script php :

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<center>
<br>
<img src="image/g.png" height="300px" width="500px;">
<br><br>


</center>
</body>
</html>






Demikianlah Artikel Master CRUD 1

Sekianlah artikel Master CRUD 1 kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.

Anda sekarang membaca artikel Master CRUD 1 dengan alamat link https://dev-create.blogspot.com/2020/02/master-crud-1.html