Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include "librari/inc.koneksidb.php";
- $NOIP = $_SERVER['REMOTE_ADDR'];
- //Periksa apabila sudah ditemukan
- $sql_cekh = "SELECT * FROM tmp_penyakit
- WHERE noip='$NOIP'
- GROUP BY kd_penyakit";
- $qry_cekh = mysql_query($sql_cekh, $koneksi);
- $hsl_cekh = mysql_num_rows($qry_cekh);
- if ($hsl_cekh == 1) {
- $hsl_data = mysql_fetch_array($qry_cekh);
- $sql_user = "SELECT * FROM tmp_user WHERE noip='$NOIP'";
- $qry_user = mysql_query($sql_user, $koneksi);
- $hsl_user = mysql_fetch_array($qry_user);
- $sql_in = "INSERT INTO analisa_hasil SET
- kd_penyakit='$hsl_data[kd_penyakit]',
- noip='$hsl_user[noip]',
- tanggal='$hsl_user[tanggal]'";
- mysql_query($sql_in, $koneksi);
- echo "<meta http-equiv='refresh' content='0; url=index.php?page=hasil'>";
- exit;
- }
- $sqlcek = "SELECT * FROM tmp_analisa WHERE noip='$NOIP'";
- $qrycek = mysql_query($sqlcek, $koneksi);
- $datacek= mysql_num_rows($qrycek);
- if ($datacek >= 1) {
- //jika tmp kosong
- $sqlg = "SELECT gejala.* FROM gejala,tmp_analisa
- WHERE gejala.kd_gejala=tmp_analisa.kd_gejala
- AND tmp_analisa.noip='$NOIP'
- AND NOT tmp_analisa.kd_gejala
- IN(SELECT kd_gejala
- FROM tmp_gejala WHERE noip='$NOIP')
- ORDER BY gejala.kd_gejala LIMIT 10";
- $qryg = mysql_query($sqlg, $koneksi);
- $datag = mysql_fetch_array($qryg);
- $kdgejala = $datag['kd_gejala'];
- $gejala = $datag['nm_gejala'];
- }
- else {
- //jika tmp kosong
- $kdp= $kd_penyakit;
- $sqlg = "SELECT * FROM gejala ORDER BY RAND()";
- $qryg = mysql_query($sqlg, $koneksi);
- $datag = mysql_fetch_array($qryg);
- $kdgejala = $datag['kd_gejala'];
- $gejala = $datag['nm_gejala'];
- }
- ?>
- <html>
- <head>
- <title>Form Utama Penelusuran</title>
- </head>
- <body>
- <form action="?page=konsulcek" method="post" name="form1"
- target="_self"><center>
- <table width="200" border="0"align="center" >
- <tr>
- <td><img src="img/doktor.jpg" width="139" height="136">
- </td>
- <td><table width="490" border="0" cellpadding="0" cellspacing="0" >
- <tr>
- <td><b>Jawablah Pertanyaan Berikut Sesuai
- Gejala Yang Anda Alami :<br><br></b></td>
- </tr>
- <?php
- $kdp= $kd_penyakit;
- $sqlg = "SELECT * FROM gejala ORDER BY RAND()";
- $qryg = mysql_query($sqlg, $koneksi);
- while($datag = mysql_fetch_array($qryg))
- {
- $kdgejala = $datag['kd_gejala'];
- $gejala = $datag['nm_gejala'];
- ?>
- <tr>
- <br>
- <td width="312" >Apakah Anda mengalami
- <?= $gejala; ?>
- <br><input type=radio name="TxtKdGejala[<?=$kdgejala;?>]" value='Y' />YA
- <br><input type=radio name="TxtKdGejala[<?=$kdgejala;?>]" value='T' />TIDAK
- </td>
- </tr>
- <?php
- }
- ?>
- <tr>
- <td bgcolor="#FFFFFF"></td>
- </tr>
- </table></td>
- </tr>
- </table>
- <input type=submit value='lanjut' />
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement