KonsultasiFm

<?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">&nbsp;
 &nbsp;</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>
        <tr>
        <br>
          <td width="312" >Apakah Anda mengalami
            <?= $gejala; ?>
            ?
            <br><input name="TxtKdGejala" type="hidden" value="<?=
 $kdgejala; ?>"></td>
        </tr>
        <tr>
          <td ><input type="submit" name="RbPilih"
 value="YA" checked>
          &nbsp;  &nbsp;  &nbsp;  &nbsp;  &nbsp;  &nbsp;  &nbsp;
            <input type="submit" name="RbPilih" value="TIDAK"></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"></td>
        </tr>
      </table></td>
    </tr>
  </table>
  </form>
</body>
</html>