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> |