Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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=iso-8859-1" />
- <title>Daftar</title>
- </head>
- <body>
- <form method="post" action="daftar.php">
- <p align="right"> </p>
- <p align="center" class="style17">Data Anda Sudah Tersimpan </p>
- <div align="center">
- <table width="500" border="0" style='border:1px dashed #000000; border-radius:10px'>
- <?php
- //Baca form dari dokter.php
- include "../koneksi.php";
- $today = date("Ymd");
- $kd_rawat = $_POST['kd_rawat'];
- $kd_pasien = $_POST['kd_pasien'];
- $nama_pasien = $_POST['nama_pasien'];
- $kd_kamar = $_POST['kd_kamar'];
- // Cari data kodecust di tabel pelanggan berdasarkan no urut terakhir
- $cari = "select max(kd_rawat) as last from rawatinap where kd_rawat like '$today%'";
- $hasil = mysql_query($cari)or die(mysql_error());
- $data = mysql_fetch_array($hasil);
- $lastkd_rawat = $data['last'];
- // Baca nomor urut dari kodecust
- $lastNoUrut = substr($lastkd_rawat, 0, 9);
- // Nomor urut ditambah 1
- $nextNoUrut = $lastNoUrut + 1;
- // membuat format nomor transaksi beerikutnya
- $nextNokd_rawat = $today.sprintf('%04s', $nextNoUrut);
- //proses simpan data kodecust dengan nomor kodecust yang baru
- $cari = "INSERT INTO `rawatinap` (kd_rawat, kd_pasien, nama_pasien, kd_kamar) VALUES ('$kd_rawat', '$kd_pasien' , '$nama_pasien' , '$kd_kamar')";
- $hasil = mysql_query($cari)or die(mysql_error());
- if ($hasil)
- {
- //jika proses simpan daftar pelanggan baru sukses,
- $cari2 = "SELECT * FROM rawatinap WHERE kd_rawat = '$kd_rawat'";
- $hasil2 = mysql_query($cari2) or die(mysql_error());
- $data2 = mysql_fetch_array($hasil2);
- ?>
- <tr>
- <td width="127"><span class="style18">Kode Rawat </span></td>
- <td width="23"><strong>:</strong></td>
- <td width="334" bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['kd_rawat']; ?> </td>
- </tr>
- <tr>
- <td><span class="style18">Kode Pasien</span></td>
- <td><strong>:</strong></td>
- <td bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['kd_pasien'];?> </td>
- </tr>
- <tr>
- <td>Nama Pasien </td>
- <td><strong>:</strong></td>
- <td bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['nama_pasien'];?> </td>
- </tr>
- <tr>
- <td>Kode Kamar </td>
- <td><strong>:</strong></td>
- <td bgcolor="#FFFFFF" style='border:1px solid #000000; border-radius:5px'><?php echo $data2['kd_kamar'];?> </td>
- </tr>
- </table>
- </div>
- <p align="center">
- <?php
- }else{
- echo mysql_erro();
- }
- ?>
- <input type="submit" name="button" id="button" value="tambah" />
- </p>
- <p align="center">
- <tr>
- <td><div align="center"></div></td>
- <td colspan="2"><div align="center"></div></td>
- </tr>
- </p>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement