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
Studi Kasus : Data mahasiswa sederhana
Keterangan : Susunan file
1. Database
2. Koneksi
Anda sekarang membaca artikel Master CRUD 1 dengan alamat link https://dev-create.blogspot.com/2020/02/master-crud-1.html
Judul : Master CRUD 1
link : Master CRUD 1
Master CRUD 1
Jenis Materi : Cara membuat materi CRUD (Create, Read, Update, Delete ) sederhanaStudi 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();
}
?>
$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>
<!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>
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