SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include "librari/inc.koneksidb.php"; | |
| 3 | $NOIP = $_SERVER['REMOTE_ADDR']; | |
| 4 | //Periksa apabila sudah ditemukan | |
| 5 | $sql_cekh = "SELECT * FROM tmp_penyakit | |
| 6 | WHERE noip='$NOIP' | |
| 7 | GROUP BY kd_penyakit"; | |
| 8 | $qry_cekh = mysql_query($sql_cekh, $koneksi); | |
| 9 | $hsl_cekh = mysql_num_rows($qry_cekh); | |
| 10 | if ($hsl_cekh == 1) {
| |
| 11 | $hsl_data = mysql_fetch_array($qry_cekh); | |
| 12 | $sql_user = "SELECT * FROM tmp_user WHERE noip='$NOIP'"; | |
| 13 | $qry_user = mysql_query($sql_user, $koneksi); | |
| 14 | $hsl_user = mysql_fetch_array($qry_user); | |
| 15 | $sql_in = "INSERT INTO analisa_hasil SET | |
| 16 | kd_penyakit='$hsl_data[kd_penyakit]', | |
| 17 | noip='$hsl_user[noip]', | |
| 18 | tanggal='$hsl_user[tanggal]'"; | |
| 19 | mysql_query($sql_in, $koneksi); | |
| 20 | echo "<meta http-equiv='refresh' content='0; url=index.php?page=hasil'>"; | |
| 21 | exit; | |
| 22 | } | |
| 23 | $sqlcek = "SELECT * FROM tmp_analisa WHERE noip='$NOIP'"; | |
| 24 | $qrycek = mysql_query($sqlcek, $koneksi); | |
| 25 | $datacek= mysql_num_rows($qrycek); | |
| 26 | if ($datacek >= 1) {
| |
| 27 | //jika tmp kosong | |
| 28 | $sqlg = "SELECT gejala.* FROM gejala,tmp_analisa | |
| 29 | WHERE gejala.kd_gejala=tmp_analisa.kd_gejala | |
| 30 | AND tmp_analisa.noip='$NOIP' | |
| 31 | AND NOT tmp_analisa.kd_gejala | |
| 32 | IN(SELECT kd_gejala | |
| 33 | FROM tmp_gejala WHERE noip='$NOIP') | |
| 34 | ORDER BY gejala.kd_gejala LIMIT 10"; | |
| 35 | $qryg = mysql_query($sqlg, $koneksi); | |
| 36 | $datag = mysql_fetch_array($qryg); | |
| 37 | ||
| 38 | $kdgejala = $datag['kd_gejala']; | |
| 39 | $gejala = $datag['nm_gejala']; | |
| 40 | ||
| 41 | } | |
| 42 | else {
| |
| 43 | //jika tmp kosong | |
| 44 | $kdp= $kd_penyakit; | |
| 45 | $sqlg = "SELECT * FROM gejala ORDER BY RAND()"; | |
| 46 | $qryg = mysql_query($sqlg, $koneksi); | |
| 47 | $datag = mysql_fetch_array($qryg); | |
| 48 | ||
| 49 | $kdgejala = $datag['kd_gejala']; | |
| 50 | $gejala = $datag['nm_gejala']; | |
| 51 | } | |
| 52 | ?> | |
| 53 | <html> | |
| 54 | <head> | |
| 55 | <title>Form Utama Penelusuran</title> | |
| 56 | </head> | |
| 57 | <body> | |
| 58 | <form action="?page=konsulcek" method="post" name="form1" | |
| 59 | target="_self"><center> | |
| 60 | <table width="200" border="0"align="center" > | |
| 61 | <tr> | |
| 62 | <td><img src="img/doktor.jpg" width="139" height="136"> | |
| 63 | </td> | |
| 64 | <td><table width="490" border="0" cellpadding="0" cellspacing="0" > | |
| 65 | <tr> | |
| 66 | <td><b>Jawablah Pertanyaan Berikut Sesuai | |
| 67 | Gejala Yang Anda Alami :<br><br></b></td> | |
| 68 | - | </tr> |
| 68 | + | </tr> |
| 69 | <?php | |
| 70 | $kdp= $kd_penyakit; | |
| 71 | $sqlg = "SELECT * FROM gejala ORDER BY RAND()"; | |
| 72 | - | <?= $gejala; ?> |
| 72 | + | |
| 73 | - | ? |
| 73 | + | while($datag = mysql_fetch_array($qryg)) |
| 74 | - | <br><input name="TxtKdGejala" type="hidden" value="<?= |
| 74 | + | {
|
| 75 | - | $kdgejala; ?>"></td> |
| 75 | + | |
| 76 | $kdgejala = $datag['kd_gejala']; | |
| 77 | $gejala = $datag['nm_gejala']; | |
| 78 | - | <td ><input type="submit" name="RbPilih" |
| 78 | + | ?> |
| 79 | - | value="YA" checked> |
| 79 | + | |
| 80 | - | |
| 80 | + | |
| 81 | - | <input type="submit" name="RbPilih" value="TIDAK"></td> |
| 81 | + | |
| 82 | <?= $gejala; ?> | |
| 83 | <br><input type=radio name="TxtKdGejala[<?=$kdgejala;?>]" value='Y' />YA | |
| 84 | <br><input type=radio name="TxtKdGejala[<?=$kdgejala;?>]" value='T' />TIDAK | |
| 85 | </td> | |
| 86 | </tr> | |
| 87 | <?php | |
| 88 | } | |
| 89 | ||
| 90 | ?> | |
| 91 | ||
| 92 | <tr> | |
| 93 | <td bgcolor="#FFFFFF"></td> | |
| 94 | </tr> | |
| 95 | </table></td> | |
| 96 | </tr> | |
| 97 | </table> | |
| 98 | <input type=submit value='lanjut' /> | |
| 99 | </form> | |
| 100 | </body> | |
| 101 | </html> |