Script Koneksi.php
<?php
$host="localhost";
$user="root";
$pass="";
$database="RawatJalan";
$site_url='http://localhost/RawatJalanArief';
$site_path= $_SERVER['DOCUMENT_ROOT']."/RawatJalanArief/";
mysql_connect($host,$user,$pass) or die ("Error Tidak Bisa Konek ke Database");
mysql_select_db($database) or die ("Error Tidak Bisa Memilih Database");
?>
Script login
<?php
include "koneksi.php";
if(isset($_POST['submit'] )&& $_POST['submit'] !=""){
$password=md5($_POST['pass']);
$user=$_POST['user'];
$query="SELECT * FROM user where username='$user'"; //Query select User semua
$query=mysql_query($query);
$Jumlah=mysql_num_rows($query);
if($Jumlah >0){
$query=mysql_query("SELECT * FROM user where username='$user' AND password='$password'");
if(mysql_num_rows($query) >0)
{
session_start();
$_SESSION['user']=$user;
$_SESSION['log']=true;
header("Location:user/index.php");
}else{
echo "Password Salah";
}
}else{
echo "Password Salah";
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Login | Rawat Jalan Aplication</title>
<link href="css/960.css" rel="stylesheet" type="text/css" media="all" />
<link href="css/reset.css" rel="stylesheet" type="text/css" media="all" />
<link href="css/text.css" rel="stylesheet" type="text/css" media="all" />
<link href="css/login.css" rel="stylesheet" type="text/css" media="all" />
<style type="text/css">
body {
background-image: url(images/bg.gif);
}
</style>
</head>
<body>
<div class="container_16">
<div class="grid_6 prefix_5 suffix_5">
<h1>Rawat Jalan Aplication</h1>
<div id="login">
<form id="form1" name="form1" method="post" action="">
<p>
<label><strong>Username</strong>
<input type="text" class="inputText" id="textfield" name="user"/>
</label>
</p>
<p>
<label><strong>Password</strong>
<input type="password" class="inputText" id="textfield2" name="pass" />
</label>
</p>
<input type="submit" name="submit" value="Login" /></td>
</form>
<br clear="all" />
</div>
</div>
<br clear="all" />
</body>
</html>
Script index.php (halaman admin)
<?php
session_start();
if (!isset($_SESSION['log']) || $_SESSION['log']==false) {
header("location:../index.php");
}
include "../koneksi.php";
include $site_path."header.php";
include $site_path."sidebar.php";
?>
<section id="main" class="column">
<h4 class="alert_info">Welcome to Rawat Jalan Aplication.</h4>
<article class="module width_full">
<header><h3>Rawat Jalan Aplication</h3></header>
<div class="module_content">
<article class="stats_graph">
<?
print("Selamat datang ".$_SESSION[user]) ;
?>
</article>
<div class="clear"></div>
</div>
</article><!-- end of stats article -->
Script list.php
<?php
session_start();
if (!isset($_SESSION['log']) || $_SESSION['log']==false) {
header("location:../index.php");
}
include "../koneksi.php";
include $site_path."header.php";
include $site_path."sidebar.php";
$sqlresep= "SELECT nomorResep,tanggalResep,dokter.kodeDkt,pasien.kodePsn,poliklinik.KodePlk,totalharga,bayar,kembali FROM dokter,poliklinik,pasien,resep WHERE poliklinik.KodePlk = dokter.KodePlk AND dokter.kodeDkt = resep.kodeDkt AND pasien.kodePsn = resep.kodePsn
";
$sqlresep= mysql_query($sqlresep);
?>
<section id="main" class="column">
<h4 class="alert_info">Welcome to Rawat Jalan Aplication.</h4>
<article class="module width_full">
<header><h3>Rawat Jalan Aplication</h3></header>
<div class="module_content">
<article class="stats_graph">
<h2>Daftar Resep</h2>
<br/>
<table class="bordered">
<thead>
<tr>
<th><p align="center">Nomor Resep</th>
<th><p align="center">Tanggal Resep</th>
<th><p align="center">Kode Dokter</th>
<th><p align="center">Kode Pasien</th>
<th><p align="center">Kode Poliklinik</th>
<th><p align="center">Total Harga</th>
<th><p align="center">Bayar</th>
<th><p align="center">Kembali</th>
<th><p align="center">Action</th>
</tr>
<tr>
<?
while($dataresep=mysql_fetch_array($sqlresep)) {
echo "<tr>";
echo "<td>$dataresep[nomorResep]</td>";
echo "<td>$dataresep[tanggalResep]</td>";
echo "<td>$dataresep[kodeDkt]</td>";
echo "<td>$dataresep[kodePsn]</td>";
echo "<td>$dataresep[KodePlk]</td>";
echo "<td>$dataresep[totalharga]</td>";
echo "<td>$dataresep[bayar]</td>";
echo "<td>$dataresep[kembali]</td>";
echo "<td align=\"center\"><a href=\"edit_resep.php?nomorResep=$dataresep[nomorResep]\"><img src=\"$site_url/images/edit.png\" title=\"Edit \"></a> | <a href=\"delete_resep.php?nomorResep=$dataresep[nomorResep]\"><img src=\"$site_url/images/delete.png\" title=\"Delete\" onClick=\"return confirm('Yakin ingin menghapusnya ?');\"></a></td>";
print("</tr>");
}
print ("</table>");
?>
<br />
<input type ="button" value = "Create" onClick="location.href='tambah_resep.php'">
</article>
<div class="clear"></div>
</div>
</article><!-- end of stats article -->
Script Tambah Data
<?php
session_start();
if (!isset($_SESSION['log']) || $_SESSION['log']==false) {
header("location:../index.php");
}
include "../koneksi.php";
include $site_path."header.php";
include $site_path."sidebar.php";
if(isset($_POST['submit'])){
$nomorResep=$_POST['nomorResep'];
$tanggalResep=$_POST['tanggalResep'];
$kodeDkt=$_POST['kodeDkt'];
$kodePsn=$_POST['kodePsn'];
$KodePlk=$_POST['KodePlk'];
$totalHarga=$_POST['totalHarga'];
$bayar=$_POST['bayar'];
$kembali=$_POST['kembali'];
$query="
INSERT INTO resep values('$nomorResep','$tanggalResep','$kodeDkt','$kodePsn','$KodePlk','$totalHarga','$bayar','$kembali')";
if($query=mysql_query($query)){
echo "<script type=\"text/javascript\">document.location=\"daftar_resep.php\"</script>";
}}
?>
<section id="main" class="column">
<h4 class="alert_info">Welcome to Rawat Jalan Aplication.</h4>
<article class="module width_full">
<header><h3>Rawat Jalan Aplication</h3></header>
<h1 class="samples" align="center">
Tambah Data Resep
</h1>
<form action="" method="post" id="identitasForm">
<tr>
<td>Nomor Resep : </td>
<td><?
include "../koneksi.php";
$sql = "SELECT nomorResep from resep order by nomorResep desc limit 0,1";
$sql = mysql_query($sql);
$oto = mysql_fetch_row($sql);
//echo $oto[0];
$matis = explode("-", $oto[0]);
//echo $matis[1];
$baru = $matis[1]+1;
echo "<b>RS - ".$baru."</b>";
?>
<input type="hidden" name="nomorResep" value="<?php echo "RS-".$baru; ?>"></td>
<td></td>
</tr>
<br>
<br>
<tr>
<td>Tanggal Resep: </td>
<td><input type="text" id="tanggal1" border="1px" name="tanggalResep" ></td>
<td></td>
</tr>
<br>
<br>
<tr>
<td>Nama Dokter : </td>
<td><select name=kodeDkt>
<option value="<?=$kodeDkt?>">Pilih Salah Satu</option>
<?
$getkodeDkt="SELECT * FROM dokter";
$getkodeDkt=mysql_query($getkodeDkt);
while($datakodeDkt=mysql_fetch_array($getkodeDkt)){
print("<option value=\"$datakodeDkt[kodeDkt]\">$datakodeDkt[namaDkt]</option>");
}
?>
</select></td>
<td></td>
</tr>
<br>
<br>
<tr>
<td>Nama Pasien : </td>
<td><select name=kodePsn>
<option value="<?=$kodePsn?>">Pilih Salah Satu</option>
<?
$getkodePsn="SELECT * FROM pasien";
$getkodePsn=mysql_query($getkodePsn);
while($datakodePsn=mysql_fetch_array($getkodePsn)){
print("<option value=\"$datakodePsn[kodePsn]\">$datakodePsn[namaPsn]</option>");
}
?>
</select></td>
<td></td>
</tr>
<br>
<br>
<tr>
<td>Nama Poliklinik: </td>
<td><select name=KodePlk>
<option value="<?=$KodePlk?>">Pilih Salah Satu</option>
<?
$getKodePlk="SELECT * FROM poliklinik";
$getKodePlk=mysql_query($getKodePlk);
while($dataKodePlk=mysql_fetch_array($getKodePlk)){
print("<option value=\"$dataKodePlk[KodePlk]\">$dataKodePlk[NamaPlk]</option>");
}
?>
</select>
</td>
<td></td>
</tr>
<br>
<br>
<tr>
<td>Total Harga : </td>
<td><input type="text" id="totalHarga" border="1px" name="totalHarga" >
</td>
<td></td>
</tr>
<br>
<br>
<tr>
<td>Bayar : </td>
<td><input type="text" id="bayar" border="1px" name="bayar" ></td>
<td></td>
</tr>
<br>
<br>
<tr>
<td>Kembali : </td>
<td><input type="text" id="kembali" border="1px" name="kembali" ></td>
<td></td>
</tr>
<br>
<br>
<tr>
<td> </td>
<td>
<input type="submit" name="submit" value="Simpan" />
<input type="reset" name="reset" value="Reset" />
</td>
</tr></table></form>
Script edit data
<?php
session_start();
include "../koneksi.php";
include $site_path."header.php";
include $site_path."sidebar.php";
$nomorResep=$_GET['nomorResep'];
if(!isset($_SESSION['log']) || $_SESSION['log']==false){
header("Location:login.php");
}
if(isset($_POST['submit'])){
$nomorResep=$_POST['nomorResep'];
$tanggalResep=$_POST['tanggalResep'];
$kodeDkt=$_POST['kodeDkt'];
$kodePsn=$_POST['kodePsn'];
$KodePlk=$_POST['KodePlk'];
$totalHarga=$_POST['totalHarga'];
$bayar=$_POST['bayar'];
$kembali=$_POST['kembali'];
$set="UPDATE resep SET nomorResep='$nomorResep',tanggalResep='$tanggalResep',kodeDkt='$kodeDkt',kodePsn='$kodePsn',KodePlk='$KodePlk',totalHarga='$totalHarga',bayar='$bayar',kembali='$kembali' WHERE nomorResep='$nomorResep'";
if($sukses=mysql_query($set)){
?>
<script type="text/javascript">document.location="daftar_resep.php"</script>
<?
}else{
$err=mysql_error();
echo "$err";
}
}else{
$sql="SELECT * FROM resep where nomorResep = '$nomorResep'
";
$sql = mysql_query($sql);
$data = mysql_fetch_array($sql);
}
?>
<section id="main" class="column">
<h4 class="alert_info">Welcome to Rawat Jalan Aplication.</h4>
<article class="module width_full">
<header><h3>Rawat Jalan Aplication</h3></header>
<h1 class="samples" align="center">
Edit Data Resep
</h1>
<form action="" method="post">
<tr>
<td>Nomor Resep:</td>
<td>
<input type="text" name="nomorResep" value="<?=$data['nomorResep']?>"></td>
</tr>
<br>
<br>
<tr>
<td>Tanggal Resep:</td>
<td>
<input type="text" name="tanggalResep" id="tanggal1" value="<?=$data['tanggalResep']?>"></td>
</tr>
<br>
<br>
<tr>
<td>Nama Dokter : </td>
<td>
<select name=kodeDkt>
<option value="<?=$data['$kodeDkt']?>">Pilih Salah Satu</option>
<?
$getkodeDkt="SELECT * FROM dokter";
$getkodeDkt=mysql_query($getkodeDkt);
while($datakodeDkt=mysql_fetch_array($getkodeDkt)){
print("<option value=\"$datakodeDkt[kodeDkt]\">$datakodeDkt[namaDkt]</option>");
}
?>
</select></td>
</tr>
<br>
<br>
<tr>
<td>Nama Pasien : </td>
<td>
<td><select name=kodePsn>
<option value="<?=$kodePsn?>">Pilih Salah Satu</option>
<?
$getkodePsn="SELECT * FROM pasien";
$getkodePsn=mysql_query($getkodePsn);
while($datakodePsn=mysql_fetch_array($getkodePsn)){
print("<option value=\"$datakodePsn[kodePsn]\">$datakodePsn[namaPsn]</option>");
}
?>
</select>
</td>
</tr>
<br>
<br>
<tr>
<td>Nama Poliklinik: </td>
<td>
<select name=KodePlk>
<option value="<?=$KodePlk?>">Pilih Salah Satu</option>
<?
$getKodePlk="SELECT * FROM poliklinik";
$getKodePlk=mysql_query($getKodePlk);
while($dataKodePlk=mysql_fetch_array($getKodePlk)){
print("<option value=\"$dataKodePlk[KodePlk]\">$dataKodePlk[NamaPlk]</option>");
}
?>
</select>
</td>
</tr>
<br>
<br>
<tr>
<td>Total Harga : </td>
<td>
<input type="text" name="totalHarga" value="<?=$data['totalHarga']?>">
</td>
</tr>
<br>
<br>
<tr>
<td>Bayar : </td>
<td>
<input type="text" name="bayar" value="<?=$data['bayar']?>"></td>
</tr>
<br>
<br>
<tr>
<td>Kembali : </td>
<td>
<input type="text" name="kembali" value="<?=$data['kembali']?>"></td>
</tr>
<br>
<br>
<tr>
<td> </td>
<td>
<input type="reset" value="Reset">
<input type="submit" name="submit" value="Save">
</td>
</tr>
</table>
</form>
Script delete
<?php
include "../koneksi.php";
$nomorResep = $_GET['nomorResep'];
$query = "DELETE FROM resep where nomorResep = '$nomorResep'";
if($query = mysql_query ($query)){
header("Location:daftar_resep.php");
echo"berhasil";
}else{
echo "Gagal menghapus data";
}
?>
Script logout
<?php
session_start();
session_unset($_SESSION[log]);
header("Location:../index.php");
?>
Jumat, 15 Februari 2013
