Advertisement
GWibisono

perbaikan v 2

Jan 15th, 2014
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  5. <title>Daftar</title>
  6. </head>
  7. <body>
  8. <form method="post" action="daftar.php">
  9.  
  10. <p align="right">&nbsp;</p>
  11. <p align="center" class="style17">Data Anda Sudah Tersimpan </p>
  12. <div align="center">
  13.   <table width="500" border="0" style='border:1px dashed #000000; border-radius:10px'>
  14.     <?php
  15.     //Baca form dari dokter.php
  16.     include "../koneksi.php";
  17.     $today = date("Ymd");
  18.     $kd_rawat = $_POST['kd_rawat'];
  19.     $kd_pasien = $_POST['kd_pasien'];
  20.     $nama_pasien = $_POST['nama_pasien'];
  21.     $kd_kamar = $_POST['kd_kamar'];
  22.    
  23.     // Cari data kodecust di tabel pelanggan berdasarkan no urut terakhir
  24.     $cari = "select max(kd_rawat) as last from rawatinap where kd_rawat like '$today%'";
  25.     $hasil = mysql_query($cari)or die(mysql_error());
  26.     $data = mysql_fetch_array($hasil);
  27.     $lastkd_rawat = $data['last'];
  28.    
  29.     // Baca nomor urut dari kodecust
  30.     $lastNoUrut = substr($lastkd_rawat, 0, 9);
  31.    
  32.     // Nomor urut ditambah 1
  33.     $nextNoUrut = $lastNoUrut + 1;
  34.    
  35.     // membuat format nomor transaksi beerikutnya
  36.     $nextNokd_rawat = $today.sprintf('%04s', $nextNoUrut);
  37.    
  38.     //proses simpan data kodecust dengan nomor kodecust yang baru
  39.     $cari = "INSERT INTO  `rawatinap` (kd_rawat, kd_pasien, nama_pasien, kd_kamar) VALUES ('$kd_rawat', '$kd_pasien' , '$nama_pasien' , '$kd_kamar')";
  40.         $hasil = mysql_query($cari)or die(mysql_error());
  41.         if ($hasil)
  42.         {
  43.     //jika proses simpan daftar pelanggan baru sukses,
  44.         $cari2 = "SELECT * FROM rawatinap WHERE kd_rawat = '$kd_rawat'";
  45.         $hasil2 = mysql_query($cari2)  or die(mysql_error());
  46.         $data2 = mysql_fetch_array($hasil2);
  47.     ?> 
  48.      <tr>
  49.       <td width="127"><span class="style18">Kode Rawat </span></td>
  50.       <td width="23"><strong>:</strong></td>
  51.       <td width="334" bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['kd_rawat']; ?>&nbsp;</td>
  52.     </tr>
  53.     <tr>
  54.       <td><span class="style18">Kode Pasien</span></td>
  55.       <td><strong>:</strong></td>
  56.       <td bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['kd_pasien'];?>&nbsp;</td>
  57.     </tr>
  58.     <tr>
  59.       <td>Nama Pasien </td>
  60.       <td><strong>:</strong></td>
  61.       <td bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['nama_pasien'];?>&nbsp;</td>
  62.     </tr>
  63.     <tr>
  64.       <td>Kode Kamar </td>
  65.       <td><strong>:</strong></td>
  66.       <td bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['kd_kamar'];?>&nbsp;</td>
  67.     </tr>
  68.   </table>
  69. </div>
  70. <p align="center">
  71.   <?php
  72. }else{
  73.     echo mysql_erro();
  74. }
  75. ?>
  76.   <input type="submit" name="button" id="button" value="tambah" />
  77. </p>
  78. <p align="center">
  79. <tr>
  80.           <td><div align="center"></div></td>
  81.           <td colspan="2"><div align="center"></div></td>
  82. </tr>
  83. </p>
  84. </body>
  85. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement