Advertisement
GWibisono

form pertanyaan

Feb 18th, 2014
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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">&nbsp;
  63.  &nbsp;</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>
  69. <?php
  70. $kdp= $kd_penyakit;
  71.     $sqlg = "SELECT * FROM gejala ORDER BY RAND()";
  72.     $qryg = mysql_query($sqlg, $koneksi);
  73.     while($datag = mysql_fetch_array($qryg))
  74.     {
  75.    
  76.     $kdgejala = $datag['kd_gejala'];
  77.     $gejala   = $datag['nm_gejala'];
  78. ?>     
  79.         <tr>
  80.         <br>
  81.           <td width="312" >Apakah Anda mengalami
  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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement