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

  1. Latar belakang

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.

  1. Tujuan
  1. Mahasiswa dapat memahami apa iti PDO(PHP Data Object)
  2. Mahasiswa mampu membuat web menggunakan PDO
  3. Mahasiswa mampu mengimplementasikan PDO dalam Pemrograman Sistem Basis Data

  1. Rumusan masalah
  1. Apa itu PDO ?
  2. Bagaimana cara mengaktifkan PDO ?
  3. Bagaimana cara mengimplementasikan PDO dalam Pemrograman Basis Data

BAB II

LANDASAN TEORI

  1. Pengertian PDO(PHP Data Object)

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

  1. Langkah pertama, buatlah file koneksi untuk pdo dengan nama koneksi_pdo.php.

  1. Kemudian download bootstrap yang akan kita gunakan, lalu simpan di dalam folder bootstrap yang berada di dalam folder menu.

  1. Buatlah database dengan nama akademik, dan buat table dosen, mahasiswa, pendidikan, prodi dan status akademik di dalam database akademik.

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());

}

?>

  1. Tulislah script berikut dan simpan dengan nama file master_prodi3.php pada pengolahan data UPDATE PDO.

<?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());

}

?>

  1. Tuliskan script berikut dan simpan dengan nama file master_prodi4.php pada pengolahan data DELETE PDO.

<?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());

}

?>

  1. Buat script seperti berikut dan simpan dengan nama master_prodi.php pada pengolahan data READ PDO.

<?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;

        }

?>

                

  1. Buat script seperti berikut dan simpan dengan nama master_dosen2.php pada pengolahan data CREATE 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 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());

}

?>

  1. Buatkan script seperti berikut dan simpan dnegan nama master_dosne3.php pada pengolahan data UPDATE PDO.

<?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());

}

?>

  1. Buat script seperti berikut dan simpan dengan nama master_prodi4.php  pada pengolahan data DELETE PDO.

<?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());

}

?>

  1. Buat script sepeti beikut dan simpan dengan nama master_mahasiswa1.php pada pengolahan data READ PDO.

<?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;

        }

?>

  1. Buat script seperti berikut dan simpan dengan nama master_mahasiswa2.php pada pengolahan data CREATE PDO.

<?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;

}

?>

  1. Buat script seprti berikut dan simpan dnegan nama master_mahasiswa3.php pada pengolahan data UPDATE PDO.

<?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());

}

?>        

  1. Buat script seperti berikut dan simpan dengan nama master_mahasiswa4.php pada pengolahan data DELETE PDO

<?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());

}

?>

  1. Buat script seperti berikut dan simpan dengan nama master_pendidikan1.php pada pengolahan data READ PDO.

<?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;        

}

?>        

  1. Buat script seperti berikun dan simpan dengan nama master_pendidikan2.php untuk pengolahan data CREATE 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 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());

}

?>

  1. Buat script seperti berikut dan simpan dengan nama master_pendidikan3.php pada pengolahan data UPDATE PDO.

<?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());

}

?>

  1. Buat script seperti berikut dan simpan dengan nama master_pendidikan4.php pada pengolahan data DELETE PDO.

<?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());

}

?>

  1. Buat script seperti berikut dan simpan dengan nama master_statusaka1.php pada pengolahan data READ PDO.

<?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;

        }

?>        

  1. Buat script seperti berikut dan simpan dengan nama master_statusaka2.php pada pengolahan data CREATE 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 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());

}

?>

  1. Buatlah script seperti berikut dan simpan dengan nama master_statusaka3.php pada pengolahan data UPDATE PDO.

<?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());

}

?>

  1. Buat script seperti berikut dan simpan dengan nama master_statusaka4.php pada pengolahan data DELETE PDO.

<?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());

}

?>

  1. Simpan file index.php berikut ini dan simpan di dalam folder menu.

<?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>

?>

  1. Kemudian buat file system.php dengan script seperti berikut, lalu masukkan bootstrap nya.

<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");

}

?>

  1. Kemudian cek hasilnya pada browser.

        


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.