MEMBUAT PHP CRUD DATA MAHASISWA DAN DATA BUKU
tampilan home
tampilan data mahasiswa
tampilan edit mahasiswa
tampilan buku
tampilan edit buku
langkah-langkah
langkah 1
untuk buku
membuat script buku.php
<div class="container">
<a class="btn btn-outline-info bg-primary my-2 my-sm-0 text-white" href="?page=tambah">Tambah Data Buku</a><table class="table table-striped">
<thead>
<tr>
<th>#</th>
<th>judul buku</th>
<th>penerbit</th>
<th>Jenis buku</th>
<th>Pengarang</th>
<th>Foto</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$no = 0;
$buku=$mysqli->query("SELECT * FROM buku");
while ($m=mysqli_fetch_array($buku)) {
$no++;
?>
<?php
include "paging1.php";
$p = new paging_buku;
$batas = 5;
$posisi = $p->cariPosisi($batas);
$buku = $mysqli->query("SELECT * FROM buku ORDER BY id DESC LIMIT $posisi,$batas");
$no=0;
while ($m=mysqli_fetch_array($buku)) {
$no++;
?>
<tr>
<th scope="row"><?php echo $no; ?></th>
<td><?php echo $m['judul_buku']; ?></td>
<td><?php echo $m['penerbit']; ?></td>
<td><?php echo $m['jenis_buku']; ?></td>
<td><?php echo $m['pengarang']; ?></td>
<td> <img src="images/<?php echo $m['gambar']; ?>" height="50"> </td>
<td>
<button type="button" class="btn btn-dark">
<a href="index.php?page=edit1&id=<?php echo $m['id']; ?>">Edit <i class="fa fa-pencil"></i> </a>
</button> |
<button type="button" class="btn btn-danger">
<a href="index.php?page=delete1&id=<?php echo $m['id']; ?>" onclick="return confirm('Anda yakin mau menghapus data ini ?')">Hapus<i class="fa fa-trash-o"></i></a>
</button>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div class="halaman">
<nav aria-label="...">
<ul class="pagination">
<?php } ?>
<?php
$jmldata = mysqli_num_rows($mysqli->query("SELECT * FROM buku"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET['home'], $jmlhalaman);
echo " <li class= 'page-item'>$linkHalaman</li> ";
?>
</ul>
</nav>
</div>
</div>
<a class="btn btn-outline-info bg-primary my-2 my-sm-0 text-white" href="?page=tambah">Tambah Data Buku</a><table class="table table-striped">
<thead>
<tr>
<th>#</th>
<th>judul buku</th>
<th>penerbit</th>
<th>Jenis buku</th>
<th>Pengarang</th>
<th>Foto</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$no = 0;
$buku=$mysqli->query("SELECT * FROM buku");
while ($m=mysqli_fetch_array($buku)) {
$no++;
?>
<?php
include "paging1.php";
$p = new paging_buku;
$batas = 5;
$posisi = $p->cariPosisi($batas);
$buku = $mysqli->query("SELECT * FROM buku ORDER BY id DESC LIMIT $posisi,$batas");
$no=0;
while ($m=mysqli_fetch_array($buku)) {
$no++;
?>
<tr>
<th scope="row"><?php echo $no; ?></th>
<td><?php echo $m['judul_buku']; ?></td>
<td><?php echo $m['penerbit']; ?></td>
<td><?php echo $m['jenis_buku']; ?></td>
<td><?php echo $m['pengarang']; ?></td>
<td> <img src="images/<?php echo $m['gambar']; ?>" height="50"> </td>
<td>
<button type="button" class="btn btn-dark">
<a href="index.php?page=edit1&id=<?php echo $m['id']; ?>">Edit <i class="fa fa-pencil"></i> </a>
</button> |
<button type="button" class="btn btn-danger">
<a href="index.php?page=delete1&id=<?php echo $m['id']; ?>" onclick="return confirm('Anda yakin mau menghapus data ini ?')">Hapus<i class="fa fa-trash-o"></i></a>
</button>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div class="halaman">
<nav aria-label="...">
<ul class="pagination">
<?php } ?>
<?php
$jmldata = mysqli_num_rows($mysqli->query("SELECT * FROM buku"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET['home'], $jmlhalaman);
echo " <li class= 'page-item'>$linkHalaman</li> ";
?>
</ul>
</nav>
</div>
</div>
langkah 2
membuat script create.php
<?php
$judul_buku = $_POST['judul_buku'];
$penerbit = $_POST['penerbit'];
$jenis_buku = $_POST['jenis_buku'];
$pengarang = $_POST['pengarang'];
$gambar = $_FILES['gambar']['nama'];
$mysqli->query("INSERT INTO buku(judul_buku,penerbit,jenis_buku,pengarang,gambar) VALUES('$judul_buku','$penerbit','$jenis_buku','$pengarang','$gambar')");
move_uploaded_file($_FILES['$gambar']['tmp_name'],'images/'.$gambar);
header('location:?page=buku');
?>
$judul_buku = $_POST['judul_buku'];
$penerbit = $_POST['penerbit'];
$jenis_buku = $_POST['jenis_buku'];
$pengarang = $_POST['pengarang'];
$gambar = $_FILES['gambar']['nama'];
$mysqli->query("INSERT INTO buku(judul_buku,penerbit,jenis_buku,pengarang,gambar) VALUES('$judul_buku','$penerbit','$jenis_buku','$pengarang','$gambar')");
move_uploaded_file($_FILES['$gambar']['tmp_name'],'images/'.$gambar);
header('location:?page=buku');
?>
langkah3
membuat delete,php
<?php
$hapus = $mysqli->query("select*from mahasiswa where id='$_GET[id]'");
$nama_gambar = mysqli_fetch_array($hapus);
$lokasi = $nama_gambar['gambar'];
$hapus_gambar = "images/$lokasi";
unlink($hapus_gambar);
$mysqli->query("DELETE FROM mahasiswa WHERE id='$_GET[id]'");
header('location:index.php');
?>
$hapus = $mysqli->query("select*from mahasiswa where id='$_GET[id]'");
$nama_gambar = mysqli_fetch_array($hapus);
$lokasi = $nama_gambar['gambar'];
$hapus_gambar = "images/$lokasi";
unlink($hapus_gambar);
$mysqli->query("DELETE FROM mahasiswa WHERE id='$_GET[id]'");
header('location:index.php');
?>
langkah4
membuat delete1.php
<?php
$hapus = $mysqli->query("select*from buku where id='$_GET[id]'");
$nama_gambar = mysqli_fetch_array($hapus);
$lokasi = $nama_gambar['gambar'];
$hapus_gambar = "images/$lokasi";
unlink($hapus_gambar);
$mysqli->query("DELETE FROM buku WHERE id='$_GET[id]'");
header('location:?page=buku');
?>
$hapus = $mysqli->query("select*from buku where id='$_GET[id]'");
$nama_gambar = mysqli_fetch_array($hapus);
$lokasi = $nama_gambar['gambar'];
$hapus_gambar = "images/$lokasi";
unlink($hapus_gambar);
$mysqli->query("DELETE FROM buku WHERE id='$_GET[id]'");
header('location:?page=buku');
?>
langkah 5
membuat edit.php
<div class="container">
<?php
$edit=$mysqli->query("select*from buku where id='$_GET[id]'");
$e=mysqli_fetch_array($edit);
?>
<form name="form_buku" action="index.php?page=update1" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="judul_buku">judul buku</label>
<input type="hidden" name="id" value="<?php echo $e['id']; ?>">
<input type="text" class="form-control" id="judul_buku" placeholder="Input judul_buku" name="judul_buku" required value="<?php echo $e['judul_buku']; ?>">
</div>
<div class="form-group">
<label for="penerbit"></label>
<input type="text" class="form-control" id="penerbit" placeholder="Input penerbit" name="penerbit" required value="<?php echo $e['penerbit']; ?>">
</div>
<div class="form-group">
<label for="Jenis_buku">jenis buku</label>
<select name="jenis_buku" class="form-control" id="jenis_buku" required>
<option value="<?php echo $e['jenis_buku']; ?>"><?php echo $e['jenis_buku']; ?></option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="Alamat">pengarang</label>
<textarea class="form-control" id="pengarang" placeholder="pengarang" name="pengarang" required><?php echo $e['pengarang']; ?></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
<span><?php echo $e['gambar']; ?></span>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Update</button>
</div>
</form>
</div>
<?php
$edit=$mysqli->query("select*from buku where id='$_GET[id]'");
$e=mysqli_fetch_array($edit);
?>
<form name="form_buku" action="index.php?page=update1" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="judul_buku">judul buku</label>
<input type="hidden" name="id" value="<?php echo $e['id']; ?>">
<input type="text" class="form-control" id="judul_buku" placeholder="Input judul_buku" name="judul_buku" required value="<?php echo $e['judul_buku']; ?>">
</div>
<div class="form-group">
<label for="penerbit"></label>
<input type="text" class="form-control" id="penerbit" placeholder="Input penerbit" name="penerbit" required value="<?php echo $e['penerbit']; ?>">
</div>
<div class="form-group">
<label for="Jenis_buku">jenis buku</label>
<select name="jenis_buku" class="form-control" id="jenis_buku" required>
<option value="<?php echo $e['jenis_buku']; ?>"><?php echo $e['jenis_buku']; ?></option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="Alamat">pengarang</label>
<textarea class="form-control" id="pengarang" placeholder="pengarang" name="pengarang" required><?php echo $e['pengarang']; ?></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
<span><?php echo $e['gambar']; ?></span>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Update</button>
</div>
</form>
</div>
langkah6
membuat paging.php
<?php
class paging_buku{
function cariPosisi($batas){
if(empty($_GET['home'])){
$posisi=0;
$_GET['home']=1;
}
else{
$posisi = ($_GET['home']-1) * $batas;
}
return $posisi;
}
// Fungsi untuk menghitung total halaman
function jumlahHalaman($jmldata, $batas){
$jmlhalaman = ceil($jmldata/$batas);
return $jmlhalaman;
}
// Fungsi untuk link halaman 1,2,3
function navHalaman($halaman_aktif, $jmlhalaman){
$link_halaman = "<li class='page-item'></li>";
// Link ke halaman pertama (first) dan sebelumnya (prev)
if($halaman_aktif > 1){
$prev = $halaman_aktif-1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=buku&home>First</a></li>
<li class='page-item'><a class='page-link' href=?page=buku&home=$prev> Prev</a></li> ";
}
else{
$link_halaman .= " <li class='page-item disabled'><a class='page-link' href='#' tabindex='-1' aria-label='Previous'> Previous </a></li> ";
}
// Link halaman 1,2,3, ...
$angka = ($halaman_aktif > 3 ? "<li class='page-item'> <span aria-hidden='true'>...</span> " : " </li>");
for ($i=$halaman_aktif-2; $i<$halaman_aktif; $i++){
if ($i < 1)
continue;
$angka .= "<li class='page-item'><a class='page-link' href=?page=buku&home=$i>$i</a></li> ";
}
$angka .= " <li class='page-item active'> <a class='page-link' href='#'>$halaman_aktif</a> <span class='sr-only'>(current)</span></li> ";
for($i=$halaman_aktif+1; $i<($halaman_aktif+3); $i++){
if($i > $jmlhalaman)
break;
$angka .= "<li class='page-item'><a class='page-link' href=buku.php?home=$i>$i</a></li> ";
}
$angka .= ($halaman_aktif+2<$jmlhalaman ? " <li class='page-item'> <span aria-hidden='true'>...</span> <a class='page-link' href=?page=buku.php&home=$jmlhalaman> $jmlhalaman</a> " : " </li>");
$link_halaman .= "<li class='page-item'>$angka</li>";
// Link ke halaman berikutnya (Next) dan terakhir (Last)
if($halaman_aktif < $jmlhalaman){
$next = $halaman_aktif+1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=buku&home=$next>Next</a></li>
<li class='page-item'><a class='page-link' href=?page=buku&home=$jmlhalaman>Last </a><li>";
}
else{
$prev = $halaman_aktif-1;
$link_halaman .= " <li class='page-item'><a class='page-link' href='?page=buku' aria-label='Next'> Next</a></li> ";
}
return $link_halaman;
}
}
?>
class paging_buku{
function cariPosisi($batas){
if(empty($_GET['home'])){
$posisi=0;
$_GET['home']=1;
}
else{
$posisi = ($_GET['home']-1) * $batas;
}
return $posisi;
}
// Fungsi untuk menghitung total halaman
function jumlahHalaman($jmldata, $batas){
$jmlhalaman = ceil($jmldata/$batas);
return $jmlhalaman;
}
// Fungsi untuk link halaman 1,2,3
function navHalaman($halaman_aktif, $jmlhalaman){
$link_halaman = "<li class='page-item'></li>";
// Link ke halaman pertama (first) dan sebelumnya (prev)
if($halaman_aktif > 1){
$prev = $halaman_aktif-1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=buku&home>First</a></li>
<li class='page-item'><a class='page-link' href=?page=buku&home=$prev> Prev</a></li> ";
}
else{
$link_halaman .= " <li class='page-item disabled'><a class='page-link' href='#' tabindex='-1' aria-label='Previous'> Previous </a></li> ";
}
// Link halaman 1,2,3, ...
$angka = ($halaman_aktif > 3 ? "<li class='page-item'> <span aria-hidden='true'>...</span> " : " </li>");
for ($i=$halaman_aktif-2; $i<$halaman_aktif; $i++){
if ($i < 1)
continue;
$angka .= "<li class='page-item'><a class='page-link' href=?page=buku&home=$i>$i</a></li> ";
}
$angka .= " <li class='page-item active'> <a class='page-link' href='#'>$halaman_aktif</a> <span class='sr-only'>(current)</span></li> ";
for($i=$halaman_aktif+1; $i<($halaman_aktif+3); $i++){
if($i > $jmlhalaman)
break;
$angka .= "<li class='page-item'><a class='page-link' href=buku.php?home=$i>$i</a></li> ";
}
$angka .= ($halaman_aktif+2<$jmlhalaman ? " <li class='page-item'> <span aria-hidden='true'>...</span> <a class='page-link' href=?page=buku.php&home=$jmlhalaman> $jmlhalaman</a> " : " </li>");
$link_halaman .= "<li class='page-item'>$angka</li>";
// Link ke halaman berikutnya (Next) dan terakhir (Last)
if($halaman_aktif < $jmlhalaman){
$next = $halaman_aktif+1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=buku&home=$next>Next</a></li>
<li class='page-item'><a class='page-link' href=?page=buku&home=$jmlhalaman>Last </a><li>";
}
else{
$prev = $halaman_aktif-1;
$link_halaman .= " <li class='page-item'><a class='page-link' href='?page=buku' aria-label='Next'> Next</a></li> ";
}
return $link_halaman;
}
}
?>
langkah7
mebuat tambah.php
<div class="container">
<form name="form_buku" action="index.php?page=create1" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="judul_buku">judul buku</label>
<input type="text" class="form-control" id="judul_buku" placeholder="Input judul buku" name="judul_buku" required>
</div>
<div class="form-group">
<label for="penerbit">penerbit</label>
<input type="text" class="form-control" id="penerbit" placeholder="Input penerbit" name="penerbit" required>
</div>
<div class="form-group">
<label for="jenis_buku">Pilih Jenis Buku</label>
<select name="jenis_buku" class="form-control" id="jenis_buku" required>
<option value="">None</option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="pengarang">pengarang</label>
<textarea class="form-control" id="pengarang" placeholder="pengarang" name="pengarang" required></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Simpan</button>
</div>
</form>
</div>
<form name="form_buku" action="index.php?page=create1" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="judul_buku">judul buku</label>
<input type="text" class="form-control" id="judul_buku" placeholder="Input judul buku" name="judul_buku" required>
</div>
<div class="form-group">
<label for="penerbit">penerbit</label>
<input type="text" class="form-control" id="penerbit" placeholder="Input penerbit" name="penerbit" required>
</div>
<div class="form-group">
<label for="jenis_buku">Pilih Jenis Buku</label>
<select name="jenis_buku" class="form-control" id="jenis_buku" required>
<option value="">None</option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="pengarang">pengarang</label>
<textarea class="form-control" id="pengarang" placeholder="pengarang" name="pengarang" required></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Simpan</button>
</div>
</form>
</div>
langkah 8
membuat update.php
<?php
$gambar = $_FILES['gambar']['name'];
if (empty($gambar)) {
$mysqli->query("UPDATE buku SET judul_buku = '$_POST[judul_buku]',
$gambar = $_FILES['gambar']['name'];
if (empty($gambar)) {
$mysqli->query("UPDATE buku SET judul_buku = '$_POST[judul_buku]',
baca nya cape ya? sama.lanjutt!kebawah
langkah9
untuk mahasiswa
membuat script add.php
<div class="container">
<form name="form_mahasiswa" action="index.php?page=create" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="NIM">NIM</label>
<input type="text" class="form-control" id="nim" placeholder="Input Nomor Induk Mahasiswa" name="nim" required>
</div>
<div class="form-group">
<label for="Nama">Nama</label>
<input type="text" class="form-control" id="nama" placeholder="Input Nama" name="nama" required>
</div>
<div class="form-group">
<label for="Jurusan">Pilih Jurusan</label>
<select name="jurusan" class="form-control" id="jurusan" required>
<option value="">None</option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="Alamat">Alamat</label>
<textarea class="form-control" id="alamat" placeholder="Alamat" name="alamat" required></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Simpan</button>
</div>
</form>
</div>
<form name="form_mahasiswa" action="index.php?page=create" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="NIM">NIM</label>
<input type="text" class="form-control" id="nim" placeholder="Input Nomor Induk Mahasiswa" name="nim" required>
</div>
<div class="form-group">
<label for="Nama">Nama</label>
<input type="text" class="form-control" id="nama" placeholder="Input Nama" name="nama" required>
</div>
<div class="form-group">
<label for="Jurusan">Pilih Jurusan</label>
<select name="jurusan" class="form-control" id="jurusan" required>
<option value="">None</option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="Alamat">Alamat</label>
<textarea class="form-control" id="alamat" placeholder="Alamat" name="alamat" required></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Simpan</button>
</div>
</form>
</div>
langkah 10
membuat create.php
<?php
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$jurusan = $_POST['jurusan'];
$alamat = $_POST['alamat'];
$gambar = $_FILES['gambar']['nama'];
$mysqli->query("INSERT INTO mahasiswa(nim,nama,jurusan,alamat,gambar) VALUES('$nim','$nama','$jurusan','$alamat','$gambar')");
move_uploaded_file($_FILES['$gambar']['tmp_name'],'images/'.$gambar);
header('location:index.php');
?>
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$jurusan = $_POST['jurusan'];
$alamat = $_POST['alamat'];
$gambar = $_FILES['gambar']['nama'];
$mysqli->query("INSERT INTO mahasiswa(nim,nama,jurusan,alamat,gambar) VALUES('$nim','$nama','$jurusan','$alamat','$gambar')");
move_uploaded_file($_FILES['$gambar']['tmp_name'],'images/'.$gambar);
header('location:index.php');
?>
langkah11
membuat delet.php
<?php
$hapus = $mysqli->query("select*from mahasiswa where id='$_GET[id]'");
$nama_gambar = mysqli_fetch_array($hapus);
$lokasi = $nama_gambar['gambar'];
$hapus_gambar = "images/$lokasi";
unlink($hapus_gambar);
$mysqli->query("DELETE FROM mahasiswa WHERE id='$_GET[id]'");
header('location:?page=read');
?>
$hapus = $mysqli->query("select*from mahasiswa where id='$_GET[id]'");
$nama_gambar = mysqli_fetch_array($hapus);
$lokasi = $nama_gambar['gambar'];
$hapus_gambar = "images/$lokasi";
unlink($hapus_gambar);
$mysqli->query("DELETE FROM mahasiswa WHERE id='$_GET[id]'");
header('location:?page=read');
?>
langkah12
membuat edit.php
<div class="container">
<?php
$edit=$mysqli->query("select*from mahasiswa where id='$_GET[id]'");
$e=mysqli_fetch_array($edit);
?>
<form name="form_mahasiswa" action="index.php?page=update" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="NIM">NIM</label>
<input type="hidden" name="id" value="<?php echo $e['id']; ?>">
<input type="text" class="form-control" id="nim" placeholder="Input Nomor Induk Mahasiswa" name="nim" required value="<?php echo $e['nim']; ?>">
</div>
<div class="form-group">
<label for="Nama">Nama</label>
<input type="text" class="form-control" id="nama" placeholder="Input Nama" name="nama" required value="<?php echo $e['nama']; ?>">
</div>
<div class="form-group">
<label for="Jurusan">Pilih Jurusan</label>
<select name="jurusan" class="form-control" id="jurusan" required>
<option value="<?php echo $e['jurusan']; ?>"><?php echo $e['jurusan']; ?></option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="Alamat">Alamat</label>
<textarea class="form-control" id="alamat" placeholder="Alamat" name="alamat" required><?php echo $e['alamat']; ?></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
<span><?php echo $e['gambar']; ?></span>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Update</button>
</div>
</form>
</div>
<?php
$edit=$mysqli->query("select*from mahasiswa where id='$_GET[id]'");
$e=mysqli_fetch_array($edit);
?>
<form name="form_mahasiswa" action="index.php?page=update" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="NIM">NIM</label>
<input type="hidden" name="id" value="<?php echo $e['id']; ?>">
<input type="text" class="form-control" id="nim" placeholder="Input Nomor Induk Mahasiswa" name="nim" required value="<?php echo $e['nim']; ?>">
</div>
<div class="form-group">
<label for="Nama">Nama</label>
<input type="text" class="form-control" id="nama" placeholder="Input Nama" name="nama" required value="<?php echo $e['nama']; ?>">
</div>
<div class="form-group">
<label for="Jurusan">Pilih Jurusan</label>
<select name="jurusan" class="form-control" id="jurusan" required>
<option value="<?php echo $e['jurusan']; ?>"><?php echo $e['jurusan']; ?></option>
<option value="Sistem Informasi">Sistem Informasi</option>
<option value="Teknik Informatika">Teknik Informatika</option>
<option value="Teknik Komputer">Teknik Komputer</option>
<option value="Sistem Informasi Akuntansi">Sistem Informasi Akuntansi</option>
</select>
</div>
<div class="form-group">
<label for="Alamat">Alamat</label>
<textarea class="form-control" id="alamat" placeholder="Alamat" name="alamat" required><?php echo $e['alamat']; ?></textarea>
</div>
<div class="form-group">
<label for="Gambar">Input Foto</label>
<input type="file" class="form-control" id="gambar" name="gambar" required>
<span><?php echo $e['gambar']; ?></span>
</div>
<div class="form-group">
<button type="reset" class="btn btn-danger">Reset</button>
<button type="submit" class="btn btn-primary">Update</button>
</div>
</form>
</div>
langkah 13
membuat paging.php
<?php
class paging_mahasiswa{
function cariPosisi($batas){
if(empty($_GET['home'])){
$posisi=0;
$_GET['home']=1;
}
else{
$posisi = ($_GET['home']-1) * $batas;
}
return $posisi;
}
// Fungsi untuk menghitung total halaman
function jumlahHalaman($jmldata, $batas){
$jmlhalaman = ceil($jmldata/$batas);
return $jmlhalaman;
}
// Fungsi untuk link halaman 1,2,3
function navHalaman($halaman_aktif, $jmlhalaman){
$link_halaman = "<li class='page-item'></li>";
// Link ke halaman pertama (first) dan sebelumnya (prev)
if($halaman_aktif > 1){
$prev = $halaman_aktif-1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=read&home>First</a></li>
<li class='page-item'><a class='page-link' href=?page=read&home=$prev> Prev</a></li> ";
}
else{
$link_halaman .= " <li class='page-item disabled'><a class='page-link' href='#' tabindex='-1' aria-label='Previous'> Previous </a></li> ";
}
// Link halaman 1,2,3, ...
$angka = ($halaman_aktif > 3 ? "<li class='page-item'> <span aria-hidden='true'>...</span> " : " </li>");
for ($i=$halaman_aktif-2; $i<$halaman_aktif; $i++){
if ($i < 1)
continue;
$angka .= "<li class='page-item'><a class='page-link' href=?page=read&home=$i>$i</a></li> ";
}
$angka .= " <li class='page-item active'> <a class='page-link' href='#'>$halaman_aktif</a> <span class='sr-only'>(current)</span></li> ";
for($i=$halaman_aktif+1; $i<($halaman_aktif+3); $i++){
if($i > $jmlhalaman)
break;
$angka .= "<li class='page-item'><a class='page-link' href=?page=read&home=$i>$i</a></li> ";
}
$angka .= ($halaman_aktif+2<$jmlhalaman ? " <li class='page-item'> <span aria-hidden='true'>...</span> <a class='page-link' href=?page=read&home=$jmlhalaman> $jmlhalaman</a> " : " </li>");
$link_halaman .= "<li class='page-item'>$angka</li>";
// Link ke halaman berikutnya (Next) dan terakhir (Last)
if($halaman_aktif < $jmlhalaman){
$next = $halaman_aktif+1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=read&home=$next>Next</a></li>
<li class='page-item'><a class='page-link' href=?page=read&home=$jmlhalaman>Last </a><li>";
}
else{
$prev = $halaman_aktif-1;
$link_halaman .= " <li class='page-item'><a class='page-link' href='?page=read&home$next' aria-label='Next'> Next</a></li> ";
}
return $link_halaman;
}
}
?>
class paging_mahasiswa{
function cariPosisi($batas){
if(empty($_GET['home'])){
$posisi=0;
$_GET['home']=1;
}
else{
$posisi = ($_GET['home']-1) * $batas;
}
return $posisi;
}
// Fungsi untuk menghitung total halaman
function jumlahHalaman($jmldata, $batas){
$jmlhalaman = ceil($jmldata/$batas);
return $jmlhalaman;
}
// Fungsi untuk link halaman 1,2,3
function navHalaman($halaman_aktif, $jmlhalaman){
$link_halaman = "<li class='page-item'></li>";
// Link ke halaman pertama (first) dan sebelumnya (prev)
if($halaman_aktif > 1){
$prev = $halaman_aktif-1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=read&home>First</a></li>
<li class='page-item'><a class='page-link' href=?page=read&home=$prev> Prev</a></li> ";
}
else{
$link_halaman .= " <li class='page-item disabled'><a class='page-link' href='#' tabindex='-1' aria-label='Previous'> Previous </a></li> ";
}
// Link halaman 1,2,3, ...
$angka = ($halaman_aktif > 3 ? "<li class='page-item'> <span aria-hidden='true'>...</span> " : " </li>");
for ($i=$halaman_aktif-2; $i<$halaman_aktif; $i++){
if ($i < 1)
continue;
$angka .= "<li class='page-item'><a class='page-link' href=?page=read&home=$i>$i</a></li> ";
}
$angka .= " <li class='page-item active'> <a class='page-link' href='#'>$halaman_aktif</a> <span class='sr-only'>(current)</span></li> ";
for($i=$halaman_aktif+1; $i<($halaman_aktif+3); $i++){
if($i > $jmlhalaman)
break;
$angka .= "<li class='page-item'><a class='page-link' href=?page=read&home=$i>$i</a></li> ";
}
$angka .= ($halaman_aktif+2<$jmlhalaman ? " <li class='page-item'> <span aria-hidden='true'>...</span> <a class='page-link' href=?page=read&home=$jmlhalaman> $jmlhalaman</a> " : " </li>");
$link_halaman .= "<li class='page-item'>$angka</li>";
// Link ke halaman berikutnya (Next) dan terakhir (Last)
if($halaman_aktif < $jmlhalaman){
$next = $halaman_aktif+1;
$link_halaman .= "
<li class='page-item'><a class='page-link' href=?page=read&home=$next>Next</a></li>
<li class='page-item'><a class='page-link' href=?page=read&home=$jmlhalaman>Last </a><li>";
}
else{
$prev = $halaman_aktif-1;
$link_halaman .= " <li class='page-item'><a class='page-link' href='?page=read&home$next' aria-label='Next'> Next</a></li> ";
}
return $link_halaman;
}
}
?>
langkah14
membuat read.php
<div class="container">
<a class="btn btn-outline-info bg-primary my-2 my-sm-0 text-white" href="?page=add">Tambah Data Mahasiswa</a>
<table class="table table-striped">
<thead>
<tr>
<th>#</th>
<th>NIM</th>
<th>Nama Mahasiswa</th>
<th>Jurusan</th>
<th>Alamat</th>
<th>Foto</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$no = 0;
$mahasiswa=$mysqli->query("SELECT * FROM mahasiswa");
while ($m=mysqli_fetch_array($mahasiswa)) {
$no++;
?>
<?php
include "paging.php";
$p = new paging_mahasiswa;
$batas = 5;
$posisi = $p->cariPosisi($batas);
$mahasiswa = $mysqli->query("SELECT * FROM mahasiswa ORDER BY id DESC LIMIT $posisi,$batas");
$no=0;
while ($m=mysqli_fetch_array($mahasiswa)) {
$no++;
?>
<tr>
<th scope="row"><?php echo $no; ?></th>
<td><?php echo $m['nim']; ?></td>
<td><?php echo $m['nama']; ?></td>
<td><?php echo $m['jurusan']; ?></td>
<td><?php echo $m['alamat']; ?></td>
<td> <img src="images/<?php echo $m['gambar']; ?>" height="50"> </td>
<td>
<button type="button" class="btn btn-dark">
<a href="index.php?page=edit&id=<?php echo $m['id']; ?>">Edit <i class="fa fa-pencil"></i> </a>
</button> |
<button type="button" class="btn btn-danger">
<a href="index.php?page=delete&id=<?php echo $m['id']; ?>" onclick="return confirm('Anda yakin mau menghapus data ini ?')">Hapus<i class="fa fa-trash-o"></i></a>
</button>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div class="halaman">
<nav aria-label="...">
<ul class="pagination">
<?php } ?>
<?php
$jmldata = mysqli_num_rows($mysqli->query("SELECT * FROM mahasiswa"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET['home'], $jmlhalaman);
echo " <li class= 'page-item'>$linkHalaman</li> ";
?>
</ul>
</nav>
</div>
</div>
<a class="btn btn-outline-info bg-primary my-2 my-sm-0 text-white" href="?page=add">Tambah Data Mahasiswa</a>
<table class="table table-striped">
<thead>
<tr>
<th>#</th>
<th>NIM</th>
<th>Nama Mahasiswa</th>
<th>Jurusan</th>
<th>Alamat</th>
<th>Foto</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$no = 0;
$mahasiswa=$mysqli->query("SELECT * FROM mahasiswa");
while ($m=mysqli_fetch_array($mahasiswa)) {
$no++;
?>
<?php
include "paging.php";
$p = new paging_mahasiswa;
$batas = 5;
$posisi = $p->cariPosisi($batas);
$mahasiswa = $mysqli->query("SELECT * FROM mahasiswa ORDER BY id DESC LIMIT $posisi,$batas");
$no=0;
while ($m=mysqli_fetch_array($mahasiswa)) {
$no++;
?>
<tr>
<th scope="row"><?php echo $no; ?></th>
<td><?php echo $m['nim']; ?></td>
<td><?php echo $m['nama']; ?></td>
<td><?php echo $m['jurusan']; ?></td>
<td><?php echo $m['alamat']; ?></td>
<td> <img src="images/<?php echo $m['gambar']; ?>" height="50"> </td>
<td>
<button type="button" class="btn btn-dark">
<a href="index.php?page=edit&id=<?php echo $m['id']; ?>">Edit <i class="fa fa-pencil"></i> </a>
</button> |
<button type="button" class="btn btn-danger">
<a href="index.php?page=delete&id=<?php echo $m['id']; ?>" onclick="return confirm('Anda yakin mau menghapus data ini ?')">Hapus<i class="fa fa-trash-o"></i></a>
</button>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div class="halaman">
<nav aria-label="...">
<ul class="pagination">
<?php } ?>
<?php
$jmldata = mysqli_num_rows($mysqli->query("SELECT * FROM mahasiswa"));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET['home'], $jmlhalaman);
echo " <li class= 'page-item'>$linkHalaman</li> ";
?>
</ul>
</nav>
</div>
</div>
langkah 15
membuat update.php
<?php
$gambar = $_FILES['gambar']['name'];
if (empty($gambar)) {
$mysqli->query("UPDATE mahasiswa SET nim = '$_POST[nim]',
$gambar = $_FILES['gambar']['name'];
if (empty($gambar)) {
$mysqli->query("UPDATE mahasiswa SET nim = '$_POST[nim]',
langkah 16
untuk tampilan awal
membuat home.php
<div class="container">
<center> <h1>sourcode </h1>
<p>This is some text.</p><br/>
<footer>Copy right © ibrahim</footer>
</div>
<center> <h1>sourcode </h1>
<p>This is some text.</p><br/>
<footer>Copy right © ibrahim</footer>
</div>
langkah17
membuat index.php
<!DOCTYPE html>
<html lang="en">
<head>
<title>Belajar CRUD</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="css/style.css">
<link rel="stylesheet" type="text/css" href="font-awesome/css/font-awesome.min.css">
</head>
<body>
<div id="wrapper">
<nav class="navbar navbar-light" style="background: #00008B">
<a class="navbar-brand" style="color: pink" href="">sourcecode ibrahim</a>
<ul class="nav navbar-nav">
<li class="nav-item active">
<a class="nav-link" href="index.php" style="color: blue">Home<span class="sr-only">(current)</span></a>
</li>
<li class="nav-item">
<a class="nav-link" style="color: green" href="index.php?page=read">Data Mahasiswa</a>
</li>
<li class="nav-item">
<a class="nav-link" style="color: orange" href="?page=buku"> Data Buku </a>
</li>
</ul>
</nav>
<div class="container box">
<?php include "pages.php"; ?>
</div>
</div>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js"></script>
<script src="ckeditor/ckeditor.js"></script>
<script type="text/javascript">
CKEDITOR.replace('alamat',{height:300});
</script>
</body>
</html>
<html lang="en">
<head>
<title>Belajar CRUD</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="css/style.css">
<link rel="stylesheet" type="text/css" href="font-awesome/css/font-awesome.min.css">
</head>
<body>
<div id="wrapper">
<nav class="navbar navbar-light" style="background: #00008B">
<a class="navbar-brand" style="color: pink" href="">sourcecode ibrahim</a>
<ul class="nav navbar-nav">
<li class="nav-item active">
<a class="nav-link" href="index.php" style="color: blue">Home<span class="sr-only">(current)</span></a>
</li>
<li class="nav-item">
<a class="nav-link" style="color: green" href="index.php?page=read">Data Mahasiswa</a>
</li>
<li class="nav-item">
<a class="nav-link" style="color: orange" href="?page=buku"> Data Buku </a>
</li>
</ul>
</nav>
<div class="container box">
<?php include "pages.php"; ?>
</div>
</div>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js"></script>
<script src="ckeditor/ckeditor.js"></script>
<script type="text/javascript">
CKEDITOR.replace('alamat',{height:300});
</script>
</body>
</html>
langkah18
membuat koneksi.php
<?php
$host="localhost";
$user="root";
$pass="";
$database="perpus2";
$mysqli=new mysqli($host,$user,$pass,$database);
if (mysqli_connect_errno()) {
trigger_error('Koneksi ke database gagal : ' . mysqli_connect_error(), E_USER_ERROR);
}
?>
$host="localhost";
$user="root";
$pass="";
$database="perpus2";
$mysqli=new mysqli($host,$user,$pass,$database);
if (mysqli_connect_errno()) {
trigger_error('Koneksi ke database gagal : ' . mysqli_connect_error(), E_USER_ERROR);
}
?>
langkah19
membuat pages.php
<?php
error_reporting(error_reporting() & ~E_NOTICE );
include "koneksi.php";
if ($_GET['page']=="add") {
include "mahasiswa/add.php";
}
else if ($_GET['page']=="create") {
include "mahasiswa/create.php";
}
else if ($_GET['page']=="edit") {
include "mahasiswa/edit.php";
}
else if ($_GET['page']=="update") {
include "mahasiswa/update.php";
}
else if ($_GET['page']=="delete") {
include "mahasiswa/delete.php";
}
else if ($_GET['page']=="read") {
include "mahasiswa/read.php";
}
else if ($_GET['page']=="buku") {
include "buku/buku.php";
}
else if ($_GET['page']=="tambah") {
include "buku/tambah.php";
}
else if ($_GET['page']=="create1") {
include "buku/create1.php";
}
else if ($_GET['page']=="edit1") {
include "buku/edit1.php";
}
else if ($_GET['page']=="delete1") {
include "buku/delete1.php";
}
else if ($_GET['page']=="update1") {
include "buku/update1.php";
}
else{
include "Home.php";
}
?>
error_reporting(error_reporting() & ~E_NOTICE );
include "koneksi.php";
if ($_GET['page']=="add") {
include "mahasiswa/add.php";
}
else if ($_GET['page']=="create") {
include "mahasiswa/create.php";
}
else if ($_GET['page']=="edit") {
include "mahasiswa/edit.php";
}
else if ($_GET['page']=="update") {
include "mahasiswa/update.php";
}
else if ($_GET['page']=="delete") {
include "mahasiswa/delete.php";
}
else if ($_GET['page']=="read") {
include "mahasiswa/read.php";
}
else if ($_GET['page']=="buku") {
include "buku/buku.php";
}
else if ($_GET['page']=="tambah") {
include "buku/tambah.php";
}
else if ($_GET['page']=="create1") {
include "buku/create1.php";
}
else if ($_GET['page']=="edit1") {
include "buku/edit1.php";
}
else if ($_GET['page']=="delete1") {
include "buku/delete1.php";
}
else if ($_GET['page']=="update1") {
include "buku/update1.php";
}
else{
include "Home.php";
}
?>
Komentar
Posting Komentar