SHOW:
|
|
- or go back to the newest paste.
| 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"> </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); |
| 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 `rumahsakit`.`rawatinap` ('kd_rawat', 'kd_pasien, 'nama_pasien', 'kd_kamar') VALUES ('$kd_rawat', '$kd_pasien' , '$nama_pasien' , '$kd_kamar')";
|
| 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); |
| 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); |
| 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']; ?> </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'];?> </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'];?> </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'];?> </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> |
