p - 13 bab 10 : php mysql lanjut (studi kasus) fileprogram studi diii rekam medis politeknik...

Program Studi DIII Rekam MedisPOLITEKNIK KESEHATAN PERMATA INDONESIAJl. Ringroad Utara No. 22, Gandok, Condong Catur, Depok, Sleman. Telp. (0274) 6411536, 7475694. Fax. (0274) 641153

P - 13Bab 10 : PHP MySQL Lanjut (Studi Kasus)

10.1 Tujuan

Mahasiswa mampu : • Mengetahui dan Memahami Integrasi PHP dengan MySQL• Mengetahui dan Memahami Relasi Dengan phpMyAdmin Designer• Mengetahui dan Memahami Operasi Input, Edit, Delete MySQL Dengan Melibatkan

Relasi Antar Table Dengan PHP

10.2 Materi

1. SQL2. phpMyAdmin Designer3. Studi Kasus Identitas dan Provinsi

10.3 SQL

Terlebih dahulu buat database Prak dan table Provinsi dan table Identitas denganstruktur sebagai berikut :

Relasi Antar Table :

Table T_Provinsi :

PSIK V (Pemrograman II/ PHP MySQL) - 1


Create Table `T_Provinsi`(Ìd_Provinsi` int(5) Not Null Primary Key Auto_Increment, `Provinsi` varchar(50) Not Null, `Kota` varchar(50) Not Null);

Table T_Provinsi :

Create Table `T_Identitas`(Ìd_Identitas` char(12) Not Null Primary Key, `Name` varchar(40) Not Null, `Gender` enum('M','F') Not Null,`Place` varchar(40) Not Null,`Brithday` date Not Null,Àddress` varchar(50) Not Null, Ìd_Provinsi` int(5) References`T_Provinsi`(Ìd_Provinsi`),Àbout` text);

Selanjutnya isi table Provinsi dengan data berikut :



Selanjutnya isi table Identitas dengan data berikut :

Relasi Database dengan phpMyAdmin Designer



10.4 Studi Kasus

Koneksi

<?php/* ------------------------- * Koneksi.php --------------------------- */

$host ="localhost";$user = "root";$password = "";$db_name = "Prak";$connect = mysql_connect($host,$user,$password);if (!$connect){ echo " Tidak Connect ...!!!";}mysql_select_db($db_name) or die ("Database Tidak Ada ...!!!");

?>

T_Provinsi

• Menampilkan data T_Provinsi

<?php/* ------------------------- * Tampil_Provinsi.php --------------------------- */



INCLUDE "../Koneksi/Koneksi.php";?>

<HTML><HEAD><TITLE>PROVINSI</TITLE></HEAD><BODY>

<?php

echo "<DIV ALIGN='CENTER'><B>Provinsi</B><BR /><BR /></DIV> <TABLE BORDER='1' ALIGN='CENTER'> <TR> <TH>No</TH> <TH>Id_Provinsi</TH> <TH>Provinsi</TH> <TH>Kota</TH> <TH>Operation</TH> </TR>"; $view=mysql_query("SELECT * FROM `T_Provinsi` ORDER BY

`Id_Provinsi`"); $no=1; while ($sq=mysql_fetch_array($view)) { echo "<TR> <TD>$no</TD> <TD>$sq[Id_Provinsi]</TD> <TD>$sq[Provinsi]</TD> <TD>$sq[Kota]</TD> <TD> <A HREF=Edit_Provinsi.php?Id=$sq[Id_Provinsi]>Edit</a> |

<A HREF=Hapus_Provinsi.php?Id=$sq[Id_Provinsi]>Delete</a> </TD> </TR>";

$no++; }

echo "</TABLE><BR />"; echo "<FORM METHOD='POST' ACTION='Form_Provinsi.php'> <DIV ALIGN='CENTER'> <INPUT TYPE='SUBMIT' VALUE='Add Provinsi'> </DIV> </FORM>"; $jml = mysql_num_rows($view); echo "<P>Jumlah Data : <B>$jml</B> Data </P>"; ?>



</BODY></HTML>

Output :

• Input data T_Provinsi

File 1 :

<?php/* ------------------------- * Form_Provinsi.php --------------------------- */



<?phpecho "<DIV ALIGN='CENTER'><B>ADD PROVINSI</B><BR /></DIV> <FORM METHOD='POST' ACTION='Input_Provinsi.php'> <TABLE STYLE='WIDTH: 350px;' ALIGN='CENTER'> <TR> <TD>Provinsi</TD>



<TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Provinsi'></TD> </TR> <TR> <TD>Ibu Kota</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Kota'></TD> </TR> <TR> <TD COLSPAN='3'></TD> </TR> <TR> <TD COLSPAN='3' ALIGN='CENTER'> <INPUT TYPE='SUBMIT' VALUE='Save'> | <INPUT TYPE='BUTTON' VALUE='Cancel'

onclick=self.history.back()></TD> </TR> </TABLE> </FORM>";?>

</BODY></HTML>

File 2 :

<?php/* ------------------------- * Input_Provinsi.php --------------------------- */



<?php

mysql_query("INSERT INTO `T_Provinsi` (`Provinsi`,`Kota`) VALUES ('$_POST[Provinsi]','$_POST[Kota]')");

header ('LOCATION:Tampil_Provinsi.php');



?>

</BODY></HTML>

Output :

• Edit data T_Provinsi

File 1 :

<?php/* ------------------------- * Edit_Provinsi.php --------------------------- */



<?php

$edit = mysql_query("SELECT * FROM `T_Provinsi` WHERE `Id_Provinsi`='$_GET[Id]'");$sq = mysql_fetch_array($edit);echo "<DIV ALIGN='CENTER'><B>EDIT PROVINSI</B></DIVv> <FORM METHOD='POST' ACTION='Update_Provinsi.php'> <INPUT TYPE='HIDDEN' NAME='Id' VALUE='$sq[Id_Provinsi]'> <TABLE WIDTH='80%' ALIGN='CENTER'> <TR>



<TD>Provinsi</TD> <TD> : <INPUT TYPE='TEXT' NAME='Provinsi'

VALUE='$sq[Provinsi]'></TD> </TR> <TR> <TD>Kota</TD> <TD> : <INPUT TYPE='TEXT' NAME='Kota'

VALUE='$sq[Kota]'></TD> </TR> <TR> <TD COLSPAN='2'>

<INPUT TYPE='SUBMIT' VALUE='Update'> <INPUT TYPE='BUTTON' VALUE='Cancel'

onclick=self.history.back()></TD>

</TR> </TABLE> </FORM>";?>

</BODY></HTML>

File 2 :

<?php/* ------------------------- * Update_Provinsi.php --------------------------- */

INCLUDE "../Koneksi/Koneksi.php";

mysql_query("UPDATE `T_Provinsi` SET `Provinsi` = '$_POST[Provinsi]', `Kota` = '$_POST[Kota]' WHERE `Id_Provinsi` = '$_POST[Id]'");

header('LOCATION:Tampil_Provinsi.php');

?>

Output :



• Hapus data T_Provinsi

<?php/* ------------------------- * Hapus_Provinsi.php --------------------------- */

INCLUDE "../Koneksi/Koneksi.php";mysql_query("DELETE FROM `T_Provinsi` WHERE `Id_Provinsi`='$_GET[Id]'");header('LOCATION:Tampil_Provinsi.php');

?>

T_Identitas

• Menampilkan data T_Identitas

<?php/* ------------------------- * Tampil_Identitas.php --------------------------- */


<HTML><HEAD><TITLE>IDENTITAS</TITLE></HEAD><BODY>

<?php

echo "<DIV ALIGN='CENTER'><B>Identitas</B><BR /><BR /></DIV>



<TABLE BORDER='1' ALIGN='CENTER'> <TR> <TH>No</TH> <TH>Id_Identitas</TH> <TH>Name</TH> <TH>Gender</TH> <TH>Place</TH> <TH>Brithday</TH> <TH>Address</TH> <TH>Provinsi</TH> <TH>About</TH> <TH>Operation</TH> </TR>";

$view=mysql_query("SELECT Ìd_Identitas`,`Name`,`Gender`,`Place`,`Brithday`,Àddress`,`T_Provinsi`.`Provinsi`,Àbout`

FROM `T_Identitas`,`T_Provinsi`

WHERE `T_Identitas`.Ìd_provinsi`=`T_Provinsi`.Ìd_Provinsi`

ORDER BY Ìd_Identitas`");

$no=1; while($sq=mysql_fetch_array($view)) { echo "<TR> <TD>$no</TD> <TD>$sq[Id_Identitas]</TD> <TD>$sq[Name]</TD> <TD>$sq[Gender]</TD> <TD>$sq[Place]</TD> <TD>$sq[Brithday]</TD> <TD>$sq[Address]</TD> <TD>$sq[Provinsi]</TD> <TD>$sq[About]</TD> <TD> <A HREF=Edit_Identitas.php?

Id=$sq[Id_Identitas]>Edit</a> | <A HREF=Hapus_Identitas.php?

Id=$sq[Id_Identitas]>Delete</a> </TD> </TR>"; $no++; }

echo "</TABLE><BR />";



echo "<FORM METHOD='POST' ACTION='Form_Identitas.php'> <DIV ALIGN='CENTER'> <INPUT TYPE='SUBMIT' VALUE='Add Identitas'> </DIV> </FORM>"; $jml = mysql_num_rows($view); echo "<P>Jumlah Data : <B>$jml</B> Data </P>"; ?>

</BODY></HTML>

Output :

• Input data T_Identitas

File 1 :

<?php/* ------------------------- * Form_Identitas.php --------------------------- */




<HTML><HEAD><TITLE>IDENTITAS</TITLE></HEAD><BODY><?phpecho "<DIV ALIGN='CENTER'><B>Add Identitas</B><BR /></DIV> <FORM METHOD='POST' ACTION='Input_Identitas.php'> <TABLE STYLE='WIDTH: 350px;' ALIGN='CENTER'> <TR> <TD>Id_Identitas</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Id_Identitas'></TD> </TR> <TR> <TD>Name</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Name'></TD> </TR> <TR> <TD>Gender</TD> <TD> : </TD> <TD> <INPUT NAME='Gender' TYPE='RADIO' VALUE='M' CHECKED> MALE <INPUT NAME='Gender' TYPE='RADIO' VALUE='F'> FEMALE </TD> </TR> <TR> <TD>Place</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Place'></TD> </TR> <TR> <TD>Brithday</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Brithday'></TD> </TR> <TR> <TD>Address</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Address'></TD> </TR> <TR> <TD>Provinsi</TD> <TD> : </TD> <TD WIDTH='66%'> <SELECT NAME='Id_Provinsi'> <OPTION VALUE='0' SELECTED> *** Provinsi *** </OPTION> "; $prov = mysql_query("SELECT * FROM `T_Provinsi`



ORDER BY `Id_Provinsi`"); while($data=mysql_fetch_array($prov)) { echo "<OPTION VALUE='$data[Id_Provinsi]'>

'$data[Provinsi]'</OPTION>"; } echo "</SELECT> </TR> <TR> <TD>About</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='About'></TD> </TR> <TR> <TD COLSPAN='3'></TD> </TR> <TR> <TD COLSPAN='3' ALIGN='CENTER'> <INPUT TYPE='SUBMIT' VALUE='Save'> | <INPUT TYPE='BUTTON' VALUE='Cancel'


</BODY></HTML>

File 2 :

<?php/* ------------------------- * Input_Identitas.php --------------------------- */



<?php

mysql_query("INSERT INTO `T_Identitas`



(Ìd_Identitas`,`Name`,`Gender`,`Place`,`Brithday`,Àddress`,Ìd_Provinsi`,Àbout`)

VALUES ('$_POST[Id_Identitas]','$_POST[Name]','$_POST[Gender]',

'$_POST[Place]','$_POST[Brithday]','$_POST[Address]','$_POST[Id_Provinsi]','$_POST[About]')");

header ('LOCATION:Tampil_Identitas.php'); ?>

</BODY></HTML>

Output :

• Edit data T_Identitas

File 1 :

<?php/* ------------------------- * Edit_Identitas.php --------------------------- */

include "../Koneksi/Koneksi.php";?>




<?php

$edit = mysql_query("SELECT Ìd_Identitas`,`Name`,`Gender`,`Place`,`Brithday`,Àddress`,Ìd_Provinsi`,Àbout`

FROM `T_Identitas` WHERE Ìd_Identitas`='$_GET[Id]'");$sq = mysql_fetch_array($edit);

echo "<DIV ALIGN='CENTER'><B>Edit Identitas</B><BR /></DIV> <FORM METHOD='POST' ACTION='Update_Identitas.php'> <INPUT TYPE='HIDDEN' NAME='Id' VALUE='$sq[Id_Identitas]'> <TABLE WIDTH='80%' ALIGN='CENTER'> <TR> <TD>Id_Identitas</TD> <TD> : </TD> <TD>

<INPUT TYPE='TEXT' NAME='Id_Identitas' VALUE='$sq[Id_Identitas]'>

</TD> </TR> <TR> <TD>Name</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Name' VALUE='$sq[Name]'></TD> </TR> <TR> <TD>Gender</TD> <TD> : </TD> <TD> <INPUT NAME='Gender' TYPE='RADIO' VALUE='M' CHECKED> MALE <INPUT NAME='Gender' TYPE='RADIO' VALUE='F'> FEMALE </TD> </TR> <TR> <TD>Place</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='Place' VALUE='$sq[Place]'></TD> </TR> <TR> <TD>Brithday</TD>



<TD> : </TD> <TD>

<INPUT TYPE='TEXT' NAME='Brithday' VALUE='$sq[Brithday]'></TD>

</TR> <TR> <TD>Address</TD> <TD> : </TD> <TD>

<INPUT TYPE='TEXT' NAME='Address' VALUE='$sq[Address]'>

</TD> </TR> <TR> <TD>Provinsi</TD> <TD> : </TD> <TD WIDTH='66%'> <SELECT NAME='Id_Provinsi'> <OPTION VALUE='0' SELECTED> *** Provinsi *** </OPTION> "; $prov = mysql_query("SELECT * FROM `T_Provinsi`

ORDER BY `Id_Provinsi`");

while($data=mysql_fetch_array($prov)) { if ($sq[Id_Provinsi]==$data[Id_Provinsi]) { echo "

<OPTION VALUE='$data[Id_Provinsi]' SELECTED>'$data[Provinsi]'</OPTION>";

} else { echo "

<OPTION VALUE='$data[Id_Provinsi]'>'$data[Provinsi]'</OPTION>";

} } echo "</SELECT> </TR> <TR> <TD>About</TD> <TD> : </TD> <TD><INPUT TYPE='TEXT' NAME='About' VALUE='$sq[About]'>

</TD> </TR> <TR>



<TD COLSPAN='3'></TD> </TR> <TR> <TD COLSPAN='3' ALIGN='CENTER'> <INPUT TYPE='SUBMIT' VALUE='Update'> | <INPUT TYPE='BUTTON' VALUE='Cancel'


</BODY></HTML>

File 2 :

<?php/* ------------------------- * Update_Identitas.php --------------------------- */


if (empty($_POST[Id_Provinsi])) { mysql_query("UPDATE `T_Identitas` SET Ìd_Identitas`='$_POST[Id_Identitas]', `Name`='$_POST[Name]', `Gender`='$_POST[Gender]', `Place`='$_POST[Place]', `Brithday`='$_POST[Brithday]', Àddress`='$_POST[Address]', Àbout`='$_POST[About]' WHERE Ìd_Identitas`='$_POST[Id]'"); }else { mysql_query("UPDATE `T_Identitas` SET Ìd_Identitas`='$_POST[Id_Identitas]', `Name`='$_POST[Name]', `Gender`='$_POST[Gender]', `Place`='$_POST[Place]', `Brithday`='$_POST[Brithday]',



Àddress`='$_POST[Address]', Ìd_Provinsi`='$_POST[Id_Provinsi]', Àbout`='$_POST[About]' WHERE Ìd_Identitas`='$_POST[Id]'"); }

header('LOCATION:Tampil_Identitas.php'); ?>

Output :

• Hapus data T_Identitas

<?php/* ------------------------- * Hapus_Identitas.php --------------------------- */


mysql_query("DELETE FROM `T_Identitas` WHERE Ìd_Identitas`='$_GET[Id]'");

header('LOCATION:Tampil_Identitas.php');?>


p - 13 bab 10 : php mysql lanjut (studi kasus) fileprogram studi diii rekam medis politeknik...

Documents