PEMROGRAMAN BASIS DATA
PDO MYSQL MENGGUNAKAN BOOTSTRAP
DisusunOleh:
Nama : Mettania Vica Wijayanti
NPM : 16753033
Program Studi : Manajemen Informatika IV A
JURUSAN EKONOMI DAN BISNIS
POLITEKNIK NEGERI LAMPUNG
BANDAR LAMPUNG
2016/2017
BAB I
PENDAHULUAN
Salah satu bentuk penerapan teknologi informasi dalam dunia bisnis adalah sebuah aplikasi penjualan terintegrasi, dalam artian sistem yang mampu membantu meningkatkan efisiensi dan efektifitas kinerja bisnis, membantu pembuatan keputusan manajerial sehingga menguatkan posisi kompetitif dalam kondisi pasar yang berubah cepat.
Cara peran teknologi informasi terhadap kemajuan organisasi sudah tidak diragukan lagi. Dengan dukungan teknologi informasi yang baik, maka sebuah perusahaan akan memiliki berbagai keunggulan kompetitif sehingga mampu bersaing dengan perusahaan lain. Pemanfaatan komputer sebagai alat kerja bantu, khususnya sebagai media pengolah data, baik yang berskala besar maupun skala kecil selalu memudahkan dalam proses pengerjaannya.
BAB II
LANDASAN TEORI
PDO (PHP Data Objects) adalah php extension untuk mengakses database, sama seperti mysql_query atau mysql_fetch_array. Saat ini fungsi seperti mysql_query dan mysql_fetch_array sudah di-deprecated dan akan segera dihapus. Oleh karena itu kita perlu segera beralih menggunakan PDO atau MySQLi untuk menyimpan, edit atau hapus data. PDO bisa dipakai untuk mengakses beberapa database berbeda, sedangkan MySQLi hanya untuk database mysql. Jika saat ini kita menggunakan database MySQL dan di kemudian hari berganti menggunakan database PostgreSQL maka kita tidak perlu lagi mengubah kode yang sudah dibuat. Jadi bisa dibilang kalau PDO adalah bahasa pemrograman untuk masa depan. Karena untuk saat ini masih belum banyak atau jarang yang sudah menggunakan PDO atau MySQLi.
BAB III
PEMBAHASAN
Selanjutnya, tulis script berikut dan simpan dengan nama file master_prodi1.php untuk pengolahan data READ PDO
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert();
break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> DATA PRODI </H3>
<a href="master_prodi2.php?a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Prodi</td>
<td>Nama Prodi</td>
<td>Akreditasi</td>
<td>Tahun Berdiri</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['nmprodi']; ?></td>
<td><?php echo $baris['akreditasi']; ?></td>
<td><?php echo $baris['thn_berdiri']; ?></td>
<td>
<a href="#" class="btn btn-default btn-xs">UPDATE</a>
<a href="#" class="btn btn-default btn-xs">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Prodi</td>
<td><input type="text" name="nmprodi" id="nmprodi" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">Akreditasi</td>
<td><input type="text" name="akreditasi" id="akreditasi" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">Tahun Berdiri</td>
<td><input type="text" name="thn_berdiri" id="thn_brdiri" maxlength="25" size="25"></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Prodi</h3><br>
<a href="master_prodi2.php?a=reset">Batal</a>
<br>
<form action="master_prodi2.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmprodi" => "",
"akreditasi" => "",
"thn_berdiri" => "",
"publish" => "T");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
// jalankan query
$hasil = $kdb->query('SELECT * FROM prodi');
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
//echo $_POST["nmprodi"];
$sql = $kdb->query (" insert into `prodi` (`nmprodi`, `akreditasi`,`thn_berdiri`) values ( '".$_POST["nmprodi"]."', '".$_POST["akreditasi"]."', '".$_POST["thn_berdiri"]."' )");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idprodi = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idprodi); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA PRODI </H3>
<a href="master_prodi3.php?a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Prodi</td>
<td>Nama Prodi</td>
<td>Akreditasi</td>
<td>Tahun Masuk</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['nmprodi']; ?></td>
<td><?php echo $baris['akreditasi']; ?></td>
<td><?php echo $baris['thn_berdiri']; ?></td>
<td>
<a href="master_prodi3.php?a=edit&id=<?php echo $baris['idprodi']; ?>">UPDATE</a>
<a href="#" >DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Prodi</td>
<td><input type="text" name="nmprodi" id="nmprodi" maxlength="25" size="25" value="<?php echo trim($row["nmprodi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Akreditasi</td>
<td><input type="text" name="akreditasi" id="akreditasi" maxlength="25" size="25" value="<?php echo trim($row["akreditasi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tahun Berdiri</td>
<td><input type="text" name="thn_berdiri" id="thn_berdiri" maxlength="25" size="25" value="<?php echo trim($row["thn_berdiri"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Prodi</h3><br>
<a href="master_prodi3.php?a=reset">Batal</a>
<br>
<form action="master_prodi3.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmprodi" => "",
"akreditasi" => "",
"thn_berdiri" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idprodi)
{
global $kdb;
$hasil2 = sql_select_byid($idprodi);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Prodi</h3><br>
<a href="master_prodi3.php?a=reset">Batal</a>
<br>
<form action="master_prodi3.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idprodi" value="<?php echo $idprodi; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
// jalankan query
$hasil = $kdb->query('SELECT * FROM prodi');
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `prodi` (`nmprodi`, `akreditasi`,`thn_berdiri`) values ( '".$_POST["nmprodi"]."', '".$_POST["akreditasi"]."','".$_POST["thn_berdiri"]."' )");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idprodi)
{
global $kdb;
// jalankan query
$hasil2 = $kdb->query('SELECT * FROM prodi where idprodi='.$idprodi);
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `prodi` set `nmprodi` = '".$_POST["nmprodi"]."', `akreditasi` = '".$_POST["akreditasi"]."', `thn_berdiri` = '".$_POST["thn_berdiri"]."' where idprodi = ".$_POST["idprodi"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idprodi = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
case "delete": sql_delete(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idprodi); break;
case "hapus" : curd_delete($idprodi); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA PRODI </H3>
<a href="index.php?menu=2&a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<a href="index.php?menu=2" >HOME</a>
<tr>
<td>No</td>
<td>ID Prodi</td>
<td>Nama Prodi</td>
<td>Akreditasi</td>
<td>Tahun Berdiri</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['nmprodi']; ?></td>
<td><?php echo $baris['akreditasi']; ?></td>
<td><?php echo $baris['thn_berdiri']; ?></td>
<td>
<a href="index.php?menu=2&a=edit&id=<?php echo $baris['idprodi']; ?>">UPDATE</a>
<a href="index.php?menu=2&a=hapus&id=<?php echo $baris['idprodi']; ?>">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">nama prodi</td>
<td><input type="text" name="nmprodi" id="nmprodi" maxlength="25" size="25" value="<?php echo trim($row["nmprodi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">akreditasi</td>
<td><input type="text" name="akreditasi" id="akreditasi" maxlength="25" size="25" value="<?php echo trim($row["akreditasi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">tahun berdiri</td>
<td><input type="text" name="thn_berdiri" id="thn_berdiri" maxlength="25" size="25" value="<?php echo trim($row["thn_berdiri"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Prodi</h3><br>
<a href="index.php?menu=2&a=reset">Batal</a>
<br>
<form action="index.php?menu=2&a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmprodi" => "",
"akreditasi" => "",
"thn_berdiri" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idprodi)
{
global $kdb;
$hasil2 = sql_select_byid($idprodi);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Prodi</h3><br>
<a href="index.php?menu=2&a=reset">Batal</a>
<br>
<form action="index.php?menu=2&a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idprodix" value="<?php echo $idprodi; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function curd_delete($idprodi)
{
global $kdb;
$hasil2 = sql_select_byid($idprodi);
$row = $hasil2->fetch();
?>
<h3>Penghapusan Data Prodi</h3><br>
<a href="index.php?menu=2&a=reset">Batal</a>
<br>
<form action="index.php?menu=2a=reset" method="post">
<input type="hidden" name="sql" value="delete" >
<input type="hidden" name="idprodix" value="<?php echo $idprodi; ?>" >
<h3> Anda yakin akan menghapus data prodi <?php echo $row['nmprodi'];?> </h3>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query('select * from prodi');
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `prodi` (`nmprodi`,`akreditasi`,`thn_berdiri`) values ( '".$_POST["nmprodi"]."', '".$_POST["akreditasi"]."', '".$_POST["thn_berdiri"]."' )");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idprodi)
{
global $kdb;
$hasil2 = $kdb->query(" select * from prodi where idprodi = ".$idprodi);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `prodi` set `nmprodi` = '".$_POST["nmprodi"]."', akreditasi = '".$_POST["akreditasi"]."', thn_berdiri = '".$_POST["thn_berdiri"]."' where idprodi = ".$_POST["idprodix"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_delete()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" delete from `prodi` where idprodi = ".$_POST["idprodix"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$kdb = koneksidatabase();
curd_read();
function curd_read()
{
$hasil = sql_select();
$i = 1;
?>
<H3> MASTER DATA DOSEN </H3>
<a href="#" class="btn btn-default btn-xs">CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td> ID Dosen </td>
<td> Nama Dosen </td>
<td> Gelar </td>
<td> Jenis Kelamin </td>
<td> Tanggal Lahir </td>
<td> Tempat Lahir </td>
<td> ID Prodi </td>
<td> ID Pendidikan </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<table>
<tr>
<td> <?php echo $i; ?> </td>
<td> <?php echo $baris['iddosen']; ?> </td>
<td> <?php echo $baris['nmdosen']; ?> </td>
<td> <?php echo $baris['gelar']; ?> </td>
<td> <?php echo $baris['sex']; ?> </td>
<td> <?php echo $baris['tanggal_lhr']; ?> </td>
<td> <?php echo $baris['tempat_lhr']; ?> </td>
<td> <?php echo $baris['idprodi']; ?> </td>
<td> <?php echo $baris['idpendidikan']; ?> </td>
<td>
<a href="#" class="btn btn-default btn-xs"> UPDATE </a>
<a href="#" class="btn btn-default btn-xs"> DELETE </a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query("select * from dosen");
//$hasil = mysqli_query($kdb, $sql) or die (mysql_error());
return $hasil;
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert();
break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> DATA DOSEN </H3>
<a href="master_dosen2.php?a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td> No </td>
<td> ID Dosen </td>
<td> Nama Dosen </td>
<td> Gelar </td>
<td> Jenis Kelamin </td>
<td> Tanggal Lahir </td>
<td> Tempat Lahir </td>
<td> ID Prodi </td>
<td> ID Pendidikan </td>
<td> Menu </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td> <?php echo $baris['iddosen']; ?> </td>
<td> <?php echo $baris['nmdosen']; ?> </td>
<td> <?php echo $baris['gelar']; ?> </td>
<td> <?php echo $baris['sex']; ?> </td>
<td> <?php echo $baris['tanggal_lhr']; ?> </td>
<td> <?php echo $baris['tempat_lhr']; ?> </td>
<td> <?php echo $baris['idprodi']; ?> </td>
<td> <?php echo $baris['idpendidikan']; ?> </td>
<td>
<a href="#" class="btn btn-default btn-xs">UPDATE</a>
<a href="#" class="btn btn-default btn-xs">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Dosen</td>
<td><input type="text" name="nmdosen" id="nmdosen" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">Gelar</td>
<td><input type="text" name="gelar" id="gelar" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">Jenis Kelamin</td>
<td><input type="text" name="sex" id="sex" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">Tanggal Lahir</td>
<td><input type="text" name="tanggal_lhr" id="tanggal_lhr" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">Tempat Lahir</td>
<td><input type="text" name="tempat_lhr" id="tempat_lhr" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">ID Prodi</td>
<td><input type="text" name="idprodi" id="idprodi" maxlength="25" size="25"></td>
</tr>
<tr>
<td width="200px">ID Pendidikan</td>
<td><input type="text" name="idpendidikan" id="idpendidikan" maxlength="25" size="25"></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Dosen</h3><br>
<a href="master_dosen2.php?a=reset">Batal</a>
<br>
<form action="master_dosen2.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmdosen" => "",
"gelar" => "",
"sex" => "",
"tanggal_lhr" => "",
"tempat_lhr" => "",
"idprodi" => "",
"idpendidikan" => "",
"publish" => "T");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
// jalankan query
$hasil = $kdb->query('SELECT * FROM dosen');
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
//echo $_POST["nmprodi"];
$sql = $kdb->query (" insert into `dosen` (`nmdosen`, `gelar`, `sex`, `tanggal_lhr`, `tempat_lhr`, `idprodi`, `idpendidikan`) values ( '".$_POST["nmdosen"]."', '".$_POST["gelar"]."', '".$_POST["sex"]."', '".$_POST["tanggal_lhr"]."', '".$_POST["tempat_lhr"]."', '".$_POST["idprodi"]."', '".$_POST["idpendidikan"]."')");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$iddosen = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($iddosen); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA Dosen </H3>
<a href="master_dosen3.php?a=tambah" >CREATE</a>
<table border="1">
<tr>
<td>No</td>
<td>Nama Dosen</td>
<td>Gelar</td>
<td>Tempat Lahir</td>
<td>Tanggal Lahir</td>
<td>Sex</td>
<td>Id Prodi</td>
<td>Id Pendidikan</td>
<td> Menu </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['nmdosen']; ?></td>
<td><?php echo $baris['gelar']; ?></td>
<td><?php echo $baris['tempat_lhr']; ?></td>
<td><?php echo $baris['tanggal_lhr']; ?></td>
<td><?php echo $baris['sex']; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['idpendidikan']; ?></td>
<td>
<a href="master_dosen3.php?a=edit&id=<?php echo $baris['iddosen']; ?>">UPDATE</a>
<a href="#" >DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Dosen</td>
<td><input type="text" name="nmdosen" id="nmdosen" maxlength="25" size="25" value="<?php echo trim($row["nmdosen"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Gelar</td>
<td><input type="text" name="gelar" id="gelar" maxlength="25" size="25" value="<?php echo trim($row["gelar"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tempat Lahir</td>
<td><input type="text" name="tempat_lhr" id="tempat_lhr" maxlength="25" size="25" value="<?php echo trim($row["tempat_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tanggal Lahir</td>
<td><input type="text" name="tanggal_lhr" id="tanggal_lhr" maxlength="25" size="25" value="<?php echo trim($row["tanggal_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Jenis Kelamin</td>
<td><input type="text" name="sex" id="sex" maxlength="25" size="25" value="<?php echo trim($row["sex"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Prodi</td>
<td><input type="text" name="idprodi" id="idprodi" maxlength="25" size="25" value="<?php echo trim($row["idprodi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Pendidikan</td>
<td><input type="text" name="idpendidikan" id="idpendidikan" maxlength="25" size="25" value="<?php echo trim($row["idpendidikan"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data dosen</h3><br>
<a href="master_dosen3.php?a=reset">Batal</a>
<br>
<form action="master_dosen3.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmdosen" => "",
"gelar" => "",
"tempat_lhr" => "",
"tanggal_lhr" => "",
"sex" => "",
"idprodi" => "",
"idpendidikan" => "",);
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($iddosen)
{
global $kdb;
$hasil2 = sql_select_byid($iddosen);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Dosen</h3><br>
<a href="master_dosen3.php?a=reset">Batal</a>
<br>
<form action="master_dosen3.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="iddosenx" value="<?php echo $iddosen; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from dosen ");
//$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `dosen` (`nmdosen`, `gelar`,`tempat_lhr`,`tanggal_lhr`,`sex`,`idprodi`,`idpendidikan`) values ( '".$_POST["nmdosen"]."', '".$_POST["gelar"]."', '".$_POST["tempat_lhr"]."', '".$_POST["tanggal_lhr"]."', '".$_POST["sex"]."', '".$_POST["idprodi"]."', '".$_POST["idpendidikan"]."' )");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($iddosen)
{
global $kdb;
$hasil2 = $kdb->query(" select * from dosen where iddosen = ".$iddosen);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `dosen` set `nmdosen` = '".$_POST["nmdosen"]."', gelar = '".$_POST["gelar"]."', tempat_lhr = '".$_POST["tempat_lhr"]."', tanggal_lhr = '".$_POST["tanggal_lhr"]."', sex = '".$_POST["sex"]."', idprodi = '".$_POST["idprodi"]."', idpendidikan = '".$_POST["idpendidikan"]."' where iddosen = ".$_POST["iddosenx"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$iddosen = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
case "delete": sql_delete(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($iddosen); break;
case "hapus" : curd_delete($iddosen); break;
default : curd_read(); break;
}
mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA DOSEN </H3>
<a href="master_dosen4.php?a=tambah" >CREATE</a>
<table border="1" >
<tr>
<td>Id Dosen<S></S></td>
<td>Nama Dosen</td>
<td>Gelar</td>
<td>Tempat Lahir</td>
<td>Tanggal Lahir</td>
<td>Jenis Kelamin</td>
<td>Id Prodi</td>
<td>Id Pendidikan</td>
<td>Menu</td>
</tr>
<?php
while($baris = mysqli_fetch_array($hasil))
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['nmdosen']; ?></td>
<td><?php echo $baris['gelar']; ?></td>
<td><?php echo $baris['tempat_lhr']; ?></td>
<td><?php echo $baris['tanggal_lhr']; ?></td>
<td><?php echo $baris['sex']; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['idpendidikan']; ?></td>
<td>
<a href="master_dosen4.php?a=edit&id=<?php echo $baris['iddosen']; ?>">UPDATE</a>
<a href="master_dosen4.php?a=hapus&id=<?php echo $baris['iddosen']; ?>">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Dosen</td>
<td><input type="text" name="nmdosen" id="nmdosen" maxlength="25" size="25" value="<?php echo trim($row["nmdosen"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Gelar</td>
<td><input type="text" name="gelar" id="gelar" maxlength="25" size="25" value="<?php echo trim($row["gelar"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tempat Lahir</td>
<td><input type="text" name="tempat_lhr" id="tempat_lhr" maxlength="25" size="25" value="<?php echo trim($row["tempat_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tanggal Lahir</td>
<td><input type="date" name="tanggal_lhr" id="tanggal_lhr" maxlength="25" size="25" value="<?php echo trim($row["tanggal_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Jenis Kelamin</td>
<td><input type="text" name="sex" id="sex" maxlength="25" size="25" value="<?php echo trim($row["sex"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Prodi</td>
<td><input type="text" name="idprodi" id="idprodi" maxlength="25" size="25" value="<?php echo trim($row["idprodi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Pendidikan</td>
<td><input type="text" name="idpendidikan" id="idpendidikan maxlength="25" size="25" value="<?php echo trim($row["idpendidikan"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Dosen</h3><br>
<a href="master_dosen4.php?a=reset">Batal</a>
<br>
<form action="master_dosen4.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmdosen" => "",
"gelar" => "",
"tempat_lhr" => "",
"tanggal_lhr" => "",
"sex" => "",
"idprodi" => "",
"idpendidikan" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($iddosen)
{
global $kdb;
$hasil2 = sql_select_byid($iddosen);
$row = mysqli_fetch_array($hasil2);
?>
<h3>Pengubahan Data dosen</h3><br>
<a href="master_dosen4.php?a=reset">Batal</a>
<br>
<form action="master_dosen4.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="iddosen" value="<?php echo $iddosen; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function curd_delete($iddosen)
{
global $kdb;
$hasil2 = sql_select_byid($iddosen);
$row = mysqli_fetch_array($hasil2);
?>
<h3>Penghapusan Data Dosen</h3><br>
<a href="master_dosen4.php?a=reset">Batal</a>
<br>
<form action="master_dosen4.php?a=reset" method="post">
<input type="hidden" name="sql" value="delete" >
<input type="hidden" name="iddosen" value="<?php echo $iddosen; ?>" >
<h3> Do you want to Delete this???<?php echo $row['nmdosen'];?> </h3>
<p><input type="submit" name="action" value="Delete" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$sql = " select * from dosen ";
$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = " insert into `dosen` (`nmdosen`,`gelar`,`tempat_lhr`,`tanggal_lhr`,`sex`,`idprodi`,`idpendidikan`) values ( '".$_POST["nmdosen"]."','".$_POST["gelar"]."','".$_POST["tempat_lhr"]."','".$_POST["tanggal_lhr"]."','".$_POST["sex"]."','".$_POST["idprodi"]."','".$_POST["idpendidikan"]."')";
mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($iddosen)
{
global $kdb;
$sql = " select * from dosen where iddosen = ".$iddosen;
$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = " update `dosen` set `nmdosen` = '".$_POST["nmdosen"]."',`gelar` = '".$_POST["gelar"]."',`tempat_lhr` = '".$_POST["tempat_lhr"]."',`tanggal_lhr` = '".$_POST["tanggal_lhr"]."',`sex` = '".$_POST["sex"]."',`idprodi` = '".$_POST["idprodi"]."',`idpendidikan` = '".$_POST["idpendidikan"]."'where iddosen = ".$_POST["iddosen"];
mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_delete()
{
global $kdb;
global $_POST;
$sql = " delete from `dosen` where iddosen = ".$_POST["iddosen"];
mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$kdb = koneksidatabase();
curd_read();
function curd_read()
{
$hasil = sql_select();
$i = 1;
?>
<H3> MASTER DATA MAHASISWA </H3>
<a href="#" class="btn btn-default btn-xs"> CREATE </a>
<table border='1px' width='70%'>
<tr>
<td>No</td>
<td>ID MHS</td>
<td>NPM</td>
<td>Nama</td>
<td>Tempat Lahir</td>
<td>Tanggal Lahir</td>
<td>Sex</td>
<td>Tahun Masuk</td>
<td>ID Prodi</td>
<td>ID Status Akademik</td>
<td> Menu </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idmhs']; ?></td>
<td><?php echo $baris['npm']; ?></td>
<td><?php echo $baris['nama']; ?></td>
<td><?php echo $baris['tempat_lhr']; ?></td>
<td><?php echo $baris['tanggal_lhr']; ?></td>
<td><?php echo $baris['sex']; ?></td>
<td><?php echo $baris['thn_masuk']; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['idstatusaka']; ?></td>
<td>
<a href="#" class="btn btn-default btn-xs"> UPDATE </a>
<a href="#" class="btn btn-default btn-xs"> DELETE </a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query("select * from mahasiswa");
//$hasil = mysqli_query($kdb, $sql) or die (mysql_error());
return $hasil;
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idmhs = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idmhs); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA Mahasiswa </H3>
<a href="master_mahasiswa2.php?a=tambah" >CREATE</a>
<table border="1" >
<tr>
<td>No</td>
<td>ID MHS</td>
<td>NPM</td>
<td>Nama</td>
<td>Tempat Lahir</td>
<td>Tanggal Lahir</td>
<td>Sex</td>
<td>Tahun Masuk</td>
<td>ID Prodi</td>
<td>ID Status Akademik</td>
<td> Menu </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idmhs']; ?></td>
<td><?php echo $baris['npm']; ?></td>
<td><?php echo $baris['nama']; ?></td>
<td><?php echo $baris['tempat_lhr']; ?></td>
<td><?php echo $baris['tanggal_lhr']; ?></td>
<td><?php echo $baris['sex']; ?></td>
<td><?php echo $baris['thn_masuk']; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['idstatusaka']; ?></td>
<td>
<a href="master_mahasiswa2.php?a=edit&id=<?php echo $baris['idmhs']; ?>">UPDATE</a>
<a href="#" >DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">NPM</td>
<td><input type="text" name="npm" id="npm" maxlength="25" size="25" value="<?php echo trim($row["npm"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Nama Mahasiswa</td>
<td><input type="text" name="nama" id="nama" maxlength="25" size="25" value="<?php echo trim($row["nama"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tempat Lahir</td>
<td><input type="text" name="tempat_lhr" id="tempat_lhr" maxlength="25" size="25" value="<?php echo trim($row["tempat_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tanggal Lahir</td>
<td><input type="text" name="tanggal_lhr" id="tanggal_lhr" maxlength="25" size="25" value="<?php echo trim($row["tanggal_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Jenis Kelamin</td>
<td><input type="text" name="sex" id="sex" maxlength="25" size="25" value="<?php echo trim($row["sex"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tahun Masuk</td>
<td><input type="text" name="thn_masuk" id="thn_masuk" maxlength="25" size="25" value="<?php echo trim($row["thn_masuk"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Prodi</td>
<td><input type="text" name="idprodi" id="idprodi" maxlength="25" size="25" value="<?php echo trim($row["idprodi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Status Akademik</td>
<td><input type="text" name="idstatusaka" id="idstatusaka" maxlength="25" size="25" value="<?php echo trim($row["idstatusaka"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Mahasiswa</h3><br>
<a href="master_mahasiswa2.php?a=reset">Batal</a>
<br>
<form action="master_mahasiswa2.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"npm" => "",
"nama" => "",
"tempat_lhr" => "",
"tanggal_lhr" => "",
"sex" => "",
"thn_masuk" => "",
"idprodi" => "",
"idstatusaka" => "",);
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idmhs)
{
global $kdb;
$hasil2 = sql_select_byid($idmhs);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data mahasiswa</h3><br>
<a href="master_mahasiswa2.php?a=reset">Batal</a>
<br>
<form action="master_mahasiswa2.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idmhsx" value="<?php echo $idmhs; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from mahasiswa ");
//$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `mahasiswa` (`npm`, `nama`, `tempat_lhr`, `tanggal_lhr`, `sex`, `thn_masuk`, `idprodi`, `idstatusaka`) values ( '".$_POST["npm"]."', '".$_POST["nama"]."', '".$_POST["tempat_lhr"]."', '".$_POST["tanggal_lhr"]."', '".$_POST["sex"]."', '".$_POST["thn_masuk"]."', '".$_POST["idprodi"]."', '".$_POST["idstatusaka"]."' )");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idmhs)
{
global $kdb;
$hasil2 = $kdb->query(" select * from mahasiswa where idmhs = ".$idmhs);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idmhs = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idmhs); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA MAHASISWA </H3>
<a href="master_mahasiswa3.php?a=tambah" >CREATE</a>
<table border="1" >
<tr>
<td>No</td>
<td>ID MHS</td>
<td>NPM</td>
<td>Nama</td>
<td>Tempat Lahir</td>
<td>Tanggal Lahir</td>
<td>Sex</td>
<td>Tahun Masuk</td>
<td>ID Prodi</td>
<td>ID Status Akademik</td>
<td> Menu </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idmhs']; ?></td>
<td><?php echo $baris['npm']; ?></td>
<td><?php echo $baris['nama']; ?></td>
<td><?php echo $baris['tempat_lhr']; ?></td>
<td><?php echo $baris['tanggal_lhr']; ?></td>
<td><?php echo $baris['sex']; ?></td>
<td><?php echo $baris['thn_masuk']; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['idstatusaka']; ?></td>
<td>
<a href="master_mahasiswa3.php?a=edit&id=<?php echo $baris['idmhs']; ?>">UPDATE</a>
<a href="#" >DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">NPM</td>
<td><input type="text" name="npm" id="npm" maxlength="25" size="25" value="<?php echo trim($row["npm"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Nama Mahasiswa</td>
<td><input type="text" name="nama" id="nama" maxlength="25" size="25" value="<?php echo trim($row["nama"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tempat Lahir</td>
<td><input type="text" name="tempat_lhr" id="tempat_lhr" maxlength="25" size="25" value="<?php echo trim($row["tempat_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tanggal Lahir</td>
<td><input type="text" name="tanggal_lhr" id="tanggal_lhr" maxlength="25" size="25" value="<?php echo trim($row["tanggal_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Jenis Kelamin</td>
<td><input type="text" name="sex" id="sex" maxlength="25" size="25" value="<?php echo trim($row["sex"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tahun Masuk</td>
<td><input type="text" name="thn_masuk" id="thn_masuk" maxlength="25" size="25" value="<?php echo trim($row["thn_masuk"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Prodi</td>
<td><input type="text" name="idprodi" id="idprodi" maxlength="25" size="25" value="<?php echo trim($row["idprodi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Status Akademik</td>
<td><input type="text" name="idstatusaka" id="idstatusaka" maxlength="25" size="25" value="<?php echo trim($row["idstatusaka"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data mahasiswa</h3><br>
<a href="master_mahasiswa3.php?a=reset">Batal</a>
<br>
<form action="master_mahasiswa3.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"npm" => "",
"nama" => "",
"tempat_lhr" => "",
"tanggal_lhr" => "",
"sex" => "",
"thn_masuk" => "",
"idprodi" => "",
"idstatusaka" => "",);
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idmhs)
{
global $kdb;
$hasil2 = sql_select_byid($idmhs);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data mahasiswa</h3><br>
<a href="master_mahasiswa3.php?a=reset">Batal</a>
<br>
<form action="master_mahasiswa3.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idmhsx" value="<?php echo $idmhs; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from mahasiswa ");
//$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `mahasiswa` (`npm`, `nama`, `tempat_lhr`, `tanggal_lhr`, `sex`, `thn_masuk`, `idprodi`, `idstatusaka`) values ( '".$_POST["npm"]."', '".$_POST["nama"]."', '".$_POST["tempat_lhr"]."', '".$_POST["tanggal_lhr"]."', '".$_POST["sex"]."', '".$_POST["thn_masuk"]."', '".$_POST["idprodi"]."', '".$_POST["idstatusaka"]."' )");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idmhs)
{
global $kdb;
$hasil2 = $kdb->query(" select * from mahasiswa where idmhs = ".$idmhs);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `mahasiswa` set `npm` = '".$_POST["npm"]."',nama = '".$_POST["nama"]."',tempat_lhr = '".$_POST["tempat_lhr"]."',tanggal_lhr = '".$_POST["tanggal_lhr"]."',sex = '".$_POST["sex"]."' ,thn_masuk = '".$_POST["thn_masuk"]."',idprodi = '".$_POST["idprodi"]."',idstatusaka = '".$_POST["idstatusaka"]."'where npm = ".$_POST["npm"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idmhs = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
case "delete": sql_delete(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idmhs); break;
case "hapus" : curd_delete($idmhs); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA MAHASISWA </H3>
<a href="index.php?menu=3&a=tambah" >CREATE</a>
<a href="index.php?menu=3" >HOME</a>
<table border="1" >
<tr>
<td>No</td>
<td> ID MHS</td>
<td>NPM</td>
<td>Nama</td>
<td>Tempat Lahir</td>
<td>Tanggal Lahir</td>
<td>Sex</td>
<td>Tahun Masuk</td>
<td>ID Prodi</td>
<td>ID Status Akademik</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idmhs']; ?></td>
<td><?php echo $baris['npm']; ?></td>
<td><?php echo $baris['nama']; ?></td>
<td><?php echo $baris['tempat_lhr']; ?></td>
<td><?php echo $baris['tanggal_lhr']; ?></td>
<td><?php echo $baris['sex']; ?></td>
<td><?php echo $baris['thn_masuk']; ?></td>
<td><?php echo $baris['idprodi']; ?></td>
<td><?php echo $baris['idstatusaka']; ?></td>
<td>
<a href="index.php?menu=3&a=edit&id=<?php echo $baris['idmhs']; ?>">UPDATE</a>
<a href="index.php?menu=3&a=hapus&id=<?php echo $baris['idmhs']; ?>">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">NPM</td>
<td><input type="text" name="npm" id="npm" maxlength="25" size="25" value="<?php echo trim($row["npm"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Nama Mahasiswa</td>
<td><input type="text" name="nama" id="nama" maxlength="25" size="25" value="<?php echo trim($row["nama"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tempat Lahir</td>
<td><input type="text" name="tempat_lhr" id="tempat_lhr" maxlength="25" size="25" value="<?php echo trim($row["tempat_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tanggal Lahir</td>
<td><input type="text" name="tanggal_lhr" id="tanggal_lhr" maxlength="25" size="25" value="<?php echo trim($row["tanggal_lhr"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Jenis Kelamin</td>
<td><input type="text" name="sex" id="sex" maxlength="25" size="25" value="<?php echo trim($row["sex"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Tahun Masuk</td>
<td><input type="text" name="thn_masuk" id="thn_masuk" maxlength="25" size="25" value="<?php echo trim($row["thn_masuk"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Prodi</td>
<td><input type="text" name="idprodi" id="idprodi" maxlength="25" size="25" value="<?php echo trim($row["idprodi"]) ?>" ></td>
</tr>
<tr>
<td width="200px">Id Status Akademik</td>
<td><input type="text" name="idstatusaka" id="idstatusaka" maxlength="25" size="25" value="<?php echo trim($row["idstatusaka"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Mahasiswa</h3><br>
<a href="index.php?menu=3&a=reset">Batal</a>
<br>
<form action="index.php?menu=3&a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"npm" => "",
"nama" => "",
"tempat_lhr" => "",
"tanggal_lhr" => "",
"sex" => "",
"thn_masuk" => "",
"idprodi" => "",
"idstatusaka" => "",);
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idmhs)
{
global $kdb;
$hasil2 = sql_select_byid($idmhs);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Mahasiswa</h3><br>
<a href="index.php?menu=3&a=reset">Batal</a>
<br>
<form action="index.php?menu=3&a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idmhs" value="<?php echo $idmhs; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function curd_delete($idmhs)
{
global $kdb;
$hasil2 = sql_select_byid($idmhs);
$row = $hasil2->fetch();
?>
<h3>Penghapusan Data Mahasiswa</h3><br>
<a href="index.php?menu=3&a=reset">Batal</a>
<br>
<form action="index.php?menu=3&a=reset" method="post">
<input type="hidden" name="sql" value="delete" >
<input type="hidden" name="idmhs" value="<?php echo $idmhs; ?>" >
<h3> Anda yakin akan menghapus data mahasiswa <?php echo $row['nama'];?> </h3>
<p><input type="submit" name="action" value="delete" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from mahasiswa ");
//$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `mahasiswa` (`npm`,`nama`,`tempat_lhr`, `tanggal_lhr`, `sex`, `thn_masuk`, `idprodi`, `idstatusaka`) values ( '".$_POST["npm"]."', '".$_POST["nama"]."', '".$_POST["tempat_lhr"]."', '".$_POST["tanggal_lhr"]."', '".$_POST["sex"]."', '".$_POST["thn_masuk"]."', '".$_POST["idprodi"]."', '".$_POST["idstatusaka"]."' )");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idmhs)
{
global $kdb;
$hasil2 = $kdb->query(" select * from mahasiswa where idmhs = ".$idmhs);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `mahasiswa` set `npm` = '".$_POST["npm"]."',nama = '".$_POST["nama"]."',tempat_lhr = '".$_POST["tempat_lhr"]."',tanggal_lhr = '".$_POST["tanggal_lhr"]."',sex = '".$_POST["sex"]."' ,thn_masuk = '".$_POST["thn_masuk"]."',idprodi = '".$_POST["idprodi"]."',idstatusaka = '".$_POST["idstatusaka"]."'where idmhs = ".$_POST["idmhs"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_delete()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" delete from `mahasiswa` where idmhs = ".$_POST["idmhs"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$kdb = koneksidatabase();
curd_read();
function curd_read()
{
$hasil = sql_select();
$i = 1;
?>
<H3> MASTER DATA PENDIDIKAN </H3>
<a href="#" class="btn btn-default btn-xs"> CREATE </a>
<table border='1px' width='30%'>
<tr>
<td> No </td>
<td> ID Pendidikan </td>
<td> Nama Pendidikan </td>
<td> Menu </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td> <?php echo $i; ?> </td>
<td> <?php echo $baris['idpendidikan']; ?> </td>
<td> <?php echo $baris['nmpendidikan']; ?> </td>
<td>
<a href="#" class="btn btn-default btn-xs"> UPDATE </a>
<a href="#" class="btn btn-default btn-xs"> DELETE </a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
// jalankan query
$hasil = $kdb->query('SELECT * FROM pendidikan');
return $hasil;
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert();
break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> DATA PENDIDIKAN </H3>
<a href="master_pendidikan2.php?a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Pendidikan</td>
<td>Nama Pendidikan</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idpendidikan']; ?></td>
<td><?php echo $baris['nmpendidikan']; ?></td>
<td>
<a href="#" class="btn btn-default btn-xs">UPDATE</a>
<a href="#" class="btn btn-default btn-xs">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Pendidikan</td>
<td><input type="text" name="nmpendidikan" id="nmpendidikan" maxlength="25" size="25"></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Pendidikan</h3><br>
<a href="master_pendidikan2.php?a=reset">Batal</a>
<br>
<form action="master_pendidikan2.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmpendidikan" => "",
"publish" => "T");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
// jalankan query
$hasil = $kdb->query('SELECT * FROM pendidikan');
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
//echo $_POST["nmprodi"];
$sql = $kdb->query (" insert into `pendidikan` (`nmpendidikan`) values ( '".$_POST["nmpendidikan"]."')");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idpendidikan = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idpendidikan); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA PENDIDIKAN </H3>
<a href="master_pendidikan3.php?a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Pendidikan</td>
<td>Nama Pendidikan</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idpendidikan']; ?></td>
<td><?php echo $baris['nmpendidikan']; ?></td>
<td>
<a href="master_pendidikan3.php?a=edit&id=<?php echo $baris['idpendidikan']; ?>">UPDATE</a>
<a href="#" >DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Pendidikan</td>
<td><input type="text" name="nmpendidikan" id="nmpendidikan" maxlength="25" size="25" value="<?php echo trim($row["nmpendidikan"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Pendidikan</h3><br>
<a href="master_pendidikan3.php?a=reset">Batal</a>
<br>
<form action="master_pendidikan3.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmpendidikan" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idpendidikan)
{
global $kdb;
$hasil2 = sql_select_byid($idpendidikan);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Pendidikan</h3><br>
<a href="master_pendidikan3.php?a=reset">Batal</a>
<br>
<form action="master_pendidikan3.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idpendidikan" value="<?php echo $idpendidikan; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from pendidikan ");
//hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `pendidikan` (`nmpendidikan`) values ( '".$_POST["nmpendidikan"]."')");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idpendidikan)
{
global $kdb;
$hasil2 = $kdb->query(" select * from pendidikan where idpendidikan = ".$idpendidikan);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `pendidikan` set `nmpendidikan` = '".$_POST["nmpendidikan"]."' where idpendidikan = ".$_POST["idpendidikan"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idpendidikan = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
case "delete": sql_delete(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idpendidikan); break;
case "hapus" : curd_delete($idpendidikan); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA PENDIDIKAN </H3>
<a href="index.php?menu=5&a=tambah" >CREATE</a>
<a href="index.php?menu=5" >HOME</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Pendidikan</td>
<td>Nama Pendidikan</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idpendidikan']; ?></td>
<td><?php echo $baris['nmpendidikan']; ?></td>
<td>
<a href="index.php?menu=5&a=edit&id=<?php echo $baris['idpendidikan']; ?>">UPDATE</a>
<a href="index.php?menu=5&a=hapus&id=<?php echo $baris['idpendidikan']; ?>">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">nama pendidikan</td>
<td><input type="text" name="nmpendidikan" id="nmpendidikan" maxlength="25" size="25" value="<?php echo trim($row["nmpendidikan"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Pendidikan</h3><br>
<a href="index.php?menu=5&a=reset">Batal</a>
<br>
<form action="index.php?menu=5&a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmpendidikan" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idpendidikan)
{
global $kdb;
$hasil2 = sql_select_byid($idpendidikan);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Pendidikan</h3><br>
<a href="index.php?menu=5&a=reset">Batal</a>
<br>
<form action="index.php?menu=5&a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idpendidikan" value="<?php echo $idpendidikan; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function curd_delete($idpendidikan)
{
global $kdb;
$hasil2 = sql_select_byid($idpendidikan);
$row = $hasil2->fetch();
?>
<h3>Penghapusan Data Pendidikan</h3><br>
<a href="index.php?menu=5&a=reset">Batal</a>
<br>
<form action="index.php?menu=5&a=reset" method="post">
<input type="hidden" name="sql" value="delete" >
<input type="hidden" name="idpendidikan" value="<?php echo $idpendidikan; ?>" >
<h3> Anda yakin akan menghapus data Pendidikan <?php echo $row['nmpendidikan'];?> </h3>
<p><input type="submit" name="action" value="DELETE" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from pendidikan ");
//$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `pendidikan` (`nmpendidikan`) values ( '".$_POST["nmpendidikan"]."')");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idpendidikan)
{
global $kdb;
$hasil2 = $kdb->query(" select * from pendidikan where idpendidikan = ".$idpendidikan);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `pendidikan` set `nmpendidikan` = '".$_POST["nmpendidikan"]."' where idpendidikan = ".$_POST["idpendidikan"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_delete()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" delete from `pendidikan` where idpendidikan = ".$_POST["idpendidikan"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$kdb = koneksidatabase();
curd_read();
function curd_read()
{
$hasil = sql_select();
$i = 1;
?>
<H3> MASTER DATA STATUS AKADEMIK </H3>
<a href="#" class="btn btn-default btn-xs"> CREATE </a>
<table border='1px' width='40%'>
<tr>
<td> No </td>
<td> ID Atatus Akademik </td>
<td> Nama Status Akademik </td>
<td> Menu </td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td> <?php echo $i; ?> </td>
<td> <?php echo $baris['idstatusaka']; ?> </td>
<td> <?php echo $baris['nmstatusaka']; ?> </td>
<td>
<a href="#" class="btn btn-default btn-xs"> UPDATE </a>
<a href="#" class="btn btn-default btn-xs"> DELETE </a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query("select * from status_akademik");
//$hasil = mysqli_query($kdb, $sql) or die (mysql_error());
return $hasil;
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert();
break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> DATA STATUS AKADEMIK </H3>
<a href="master_statusaka2.php?a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Status Akademik</td>
<td>Nama Status Akademik</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idstatusaka']; ?></td>
<td><?php echo $baris['nmstatusaka']; ?></td>
<td>
<a href="#" class="btn btn-default btn-xs">UPDATE</a>
<a href="#" class="btn btn-default btn-xs">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Status Akademik</td>
<td><input type="text" name="nmstatusaka" id="nmstatusaka" maxlength="25" size="25"></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Status Akademik</h3><br>
<a href="master_statusaka2.php?a=reset">Batal</a>
<br>
<form action="master_statusaka2.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmstatusaka" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from status_akademik ");
//$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
//echo $_POST["nmstatusaka"];
$sql = $kdb->query(" insert into `status_akademik` (`nmstatusaka`) values ( '".$_POST["nmstatusaka"]."')");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idstatusaka = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idstatusaka); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA STATUS AKADEMIK </H3>
<a href="master_statusaka3.php?a=tambah" >CREATE</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Status Akademik</td>
<td>Nama Status Akademik</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idstatusaka']; ?></td>
<td><?php echo $baris['nmstatusaka']; ?></td>
<td>
<a href="master_statusaka3.php?a=edit&id=<?php echo $baris['idstatusaka']; ?>">UPDATE</a>
<a href="#" >DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">Nama Status Akademik</td>
<td><input type="text" name="nmstatusaka" id="nmstatusaka" maxlength="25" size="25" value="<?php echo trim($row["nmstatusaka"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Status Akademik</h3><br>
<a href="master_statusaka3.php?a=reset">Batal</a>
<br>
<form action="master_statusaka3.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmstatusaka" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idstatusaka)
{
global $kdb;
$hasil2 = sql_select_byid($idstatusaka);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Status Akademik</h3><br>
<a href="master_statusaka3.php?a=reset">Batal</a>
<br>
<form action="master_statusaka3.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idstatusaka" value="<?php echo $idstatusaka; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from status_akademik ");
//hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `status_akademik` (`nmstatusaka`) values ( '".$_POST["nmstatusaka"]."')");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idstatusaka)
{
global $kdb;
$hasil2 = $kdb->query(" select * from status_akademik where idstatusaka = ".$idstatusaka);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `status_akademik` set `nmstatusaka` = '".$_POST["nmstatusaka"]."' where idstatusaka = ".$_POST["idstatusaka"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idstatusaka = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
case "insert": sql_insert(); break;
case "update": sql_update(); break;
case "delete": sql_delete(); break;
}
switch ($a) {
case "reset" : curd_read(); break;
case "tambah": curd_create(); break;
case "edit" : curd_update($idstatusaka); break;
case "hapus" : curd_delete($idstatusaka); break;
default : curd_read(); break;
}
//mysqli_close($kdb);
function curd_read()
{
$hasil = sql_select();
$i=1;
?>
<H3> MASTER DATA STATUS AKADEMIK </H3>
<a href="index.php?menu=6&a=tambah" >CREATE</a>
<a href="index.php?menu=6" >HOME</a>
<table class="table table-bordered" border='1'>
<tr>
<td>No</td>
<td>ID Status Akademik</td>
<td>Nama Status Akademik</td>
<td>Menu</td>
</tr>
<?php
while($baris = $hasil->fetch())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $baris['idstatusaka']; ?></td>
<td><?php echo $baris['nmstatusaka']; ?></td>
<td>
<a href="index.php?menu=6&a=edit&id=<?php echo $baris['idstatusaka']; ?>">UPDATE</a>
<a href="index.php?menu=6&a=hapus&id=<?php echo $baris['idstatusaka']; ?>">DELETE</a>
</td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
//mysqli_free_result($hasil);
}
?>
<?php
function formeditor($row)
{
?>
<table>
<tr>
<td width="200px">nama status akademik</td>
<td><input type="text" name="nmstatusaka" id="nmstatusaka" maxlength="25" size="25" value="<?php echo trim($row["nmstatusaka"]) ?>" ></td>
</tr>
</table>
<?php }?>
<?php
function curd_create()
{
?>
<h3>Penambahan Data Status Aka</h3><br>
<a href="index.php?menu=6&a=reset">Batal</a>
<br>
<form action="index.php?menu=6&a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
"nmstatusaka" => "");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>
<?php
function curd_update($idstatusaka)
{
global $kdb;
$hasil2 = sql_select_byid($idstatusaka);
$row = $hasil2->fetch();
?>
<h3>Pengubahan Data Status Akademik</h3><br>
<a href="index.php?menu=6&a=reset">Batal</a>
<br>
<form action="index.php?menu=6&a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idstatusakax" value="<?php echo $idstatusaka; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>
<?php
function curd_delete($idstatusaka)
{
global $kdb;
$hasil2 = sql_select_byid($idstatusaka);
$row = $hasil2->fetch();
?>
<h3>Penghapusan Data Status Akademik</h3><br>
<a href="index.php?menu=6&a=reset">Batal</a>
<br>
<form action="index.php?menu=6&a=reset" method="post">
<input type="hidden" name="sql" value="delete" >
<input type="hidden" name="idstatusakax" value="<?php echo $idstatusaka; ?>" >
<h3> Anda yakin akan menghapus data status akademik <?php echo $row['nmstatusaka'];?> </h3>
<p><input type="submit" name="action" value="Delete" ></p>
</form>
<?php } ?>
<?php
function koneksidatabase()
{
include('../koneksi/koneksi_pdo.php');
return $kdb;
}
function sql_select()
{
global $kdb;
$hasil = $kdb->query(" select * from status_akademik ");
//$hasil = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil;
}
function sql_insert()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" insert into `status_akademik` (`nmstatusaka`) values ( '".$_POST["nmstatusaka"]."')");
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_select_byid($idstatusaka)
{
global $kdb;
$hasil2 = $kdb->query(" select * from status_akademik where idstatusaka = ".$idstatusaka);
//$hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
return $hasil2;
}
function sql_update()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" update `status_akademik` set `nmstatusaka` = '".$_POST["nmstatusaka"]."' where idstatusaka = ".$_POST["idstatusakax"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
function sql_delete()
{
global $kdb;
global $_POST;
$sql = $kdb->query(" delete from `status_akademik` where idstatusaka = ".$_POST["idstatusakax"]);
//mysqli_query($kdb, $sql) or die( mysql_error());
}
?>
<?php
$menu = !empty($_GET['menu']) ? $_GET['menu'] : "1";
?>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title> Sistem Menu</title>
<link href="bootstrap/bootstrap.css" rel="stylesheet">
<link href="bootstrap/docs.css" rel="stylesheet">
</head>
<body >
<header class="navbar navbar-inverse navbar-fixed-top bs-docs-nav" role="banner">
<div class="container">
<div class="navbar-header">
<a href="index.php?menu=1" class="navbar-brand">PENGOLAHAN DATA MAHASISWA</a>
</div>
</div>
</header>
<div class="container bs-docs-container">
<div class="row">
<div class="col-md-3">
<div class="bs-sidebar" role="complementary">
<ul class="nav bs-sidenav">
<li <?php if($menu==1) { echo 'class="active"'; } else { echo 'class=""'; } ?>>
<a href="index.php?menu=1">Home</a>
</li>
<li <?php if($menu==2) { echo 'class="active"'; } else { echo 'class=""'; } ?>>
<a href="index.php?menu=2">Master Prodi</a>
</li>
<li <?php if($menu==3) { echo 'class="active"'; } else { echo 'class=""'; } ?>>
<a href="index.php?menu=3">Master Mahasiswa</a>
</li>
<li <?php if($menu==4) { echo 'class="active"'; } else { echo 'class=""'; } ?>>
<a href="index.php?menu=4">Master Dosen</a>
</li>
<li <?php if($menu==5) { echo 'class="active"'; } else { echo 'class=""'; } ?>>
<a href="index.php?menu=5">Master Pendidikan</a>
</li>
<li <?php if($menu==6) { echo 'class="active"'; } else { echo 'class=""'; } ?>>
<a href="index.php?menu=6">Master Status Akademik</a>
</li>
</ul>
</div>
</div>
<div class="col-md-9" role="main">
<?php
switch($menu)
{
case('1'): include_once('../menu/index.php'); break;
case('2'): include_once('../menu/master_prodi4.php'); break;
case('3'): include_once('../menu/master_mahasiswa4.php'); break;
case('4'): include_once('../menu/master_dosen4.php'); break;
case('5'): include_once('../menu/master_pendidikan4.php'); break;
case('6'): include_once('../menu/master_statusaka4.php'); break;
//default: include_once('../menu/master_home.php'); break;
}
?>
</div>
</div>
</div>
<footer class="bs-footer" role="contentinfo">
<div class="container">
<p>Praktik 11 / Sistem Menu / SIWEB / Program Studi Manajemen Informatika Politeknik Negeri Lampung .</p>
</div>
</footer>
<script src="bootstrap/jquery-1.js"></script>
<script src="bootstrap/bootstrap.js"></script>
</body>
</html>
?>
<hr>
<link href="framework/bootstrap/css/bootstrap.css" rel="stylesheet">
<link href="framework/bootstrap/css/bootstrap.min.css" rel="stylesheet">
<?php
session_start();
try{
$kdb = new PDO('mysql:host=localhost;dbname=akademik2', 'root', '');
$kdb->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}catch(PDOException $e){
echo $e->getMessage();
}
$nmuser = $_POST['nmuser'];
$psw = $_POST['psw'];
$op = $_GET['op'];
if($op=="in"){
$cek = $kdb->query("SELECT * FROM user WHERE nmuser='$nmuser' AND password='$psw' AND publish='T' ");
if($cek->rowCount($cek)==1){
$c = $cek->fetch(PDO::FETCH_ASSOC);
$_SESSION['nmuser'] = $c['nmuser'];
header("location:index.php");
}else{
die('<div class="alert alert-danger" class="col-sm-8" role="alert">
<span class="glyphicon glyphicon-exclamation-sign" aria-hidden="true"></span>
<span class="sr-only">Error:</span>
Username atau Password Salah
<a href="login.php">kembali</a> </div>');
}
}else if($op=="out"){
unset($_SESSION['nmuser']);
header("location:index.php");
}
?>
BAB IV
PENUTUP
4.1. Kesimpulan
Jika MySQLi dikhususkan untuk koneksi maupun query database MySQL, berbeda dengan PDO, yang menyediakan syntax yang seragam, namun mendukung koneksi maupun query ke berbagai database, tidak hanya MySQL, tapi postgree, Oracle, Microsoft SQL Server, SQLite dan banyak lagi.
Jika Anda menggunakan PDO sebagai jembatan untuk koneksi ke database, jelas banyak sekali keuntungannya. Sebagai contohnya jika saat ini Anda mendevelop suatu aplikasi yang diyakini nantinya akan berskala besar, baik luas dari segi fitur, maupun padat dari segi visitor. Menghandle ribuan bahkan ribuan hingga jutaan user setiap harinya. Awalnya bolehlah Anda gunakan dulu MySQL sebagai databasenya, dan ketika ingin pindah ke sistem database lain, misal pindah ke oracle tidak perlu melakukan koding ulang querynya, cukup koneksinya saja.