-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathKonsultasiFm.php
94 lines (86 loc) · 2.94 KB
/
KonsultasiFm.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
<?php
include "librari/inc.koneksidb.php";
$NOIP = $_SERVER['REMOTE_ADDR'];
# Periksa apabila sudah ditemukan
//periksa data penyakit di dalam tmp
$sql_cekh = "SELECT * FROM tmp_hama
WHERE noip='$NOIP'
GROUP BY kd_hama";
$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);
//memindahkan data tmp ke tabel hasil_analisa
$sql_pasien = "SELECT * FROM tmp_pengguna WHERE noip='$NOIP'";
$qry_pasien = mysql_query($sql_pasien, $koneksi);
$hsl_pasien = mysql_fetch_array($qry_pasien);
//perintah untuk memindah data
$sql_in = "INSERT INTO analisa_hasil SET
nama='$hsl_pasien[nama]',
kelamin='$hsl_pasien[kelamin]',
alamat='$hsl_pasien[alamat]',
pekerjaan='$hsl_pasien[pekerjaan]',
kd_hama='$hsl_data[kd_hama]',
noip='$hsl_pasien[noip]',
tanggal='$hsl_pasien[tanggal]'";
mysql_query($sql_in, $koneksi);
echo "<meta http-equiv='refresh' content='0; url=index.php?page=hasil'>";
exit;
}
#Apabla Belum Menemukan Penyakit
$sqlcek = "SELECT * FROM tmp_analisa WHERE noip='$NOIP'";
$qrycek = mysql_query($sqlcek, $koneksi);
$datacek= mysql_num_rows($qrycek);
if ($datacek >= 1) {
// Seandainya tmp_analisa tidak kosong
// SQL ambil data gejala yang tidak ada di dalam tabel tmp_gejala(NOT IN...)
$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 1";
$qryg = mysql_query($sqlg, $koneksi);
$datag = mysql_fetch_array($qryg);
$kdgejala = $datag['kd_gejala'];
$gejala = $datag['nm_gejala'];
//echo " ADA BOS ($sqlg)";
}
else {
// Seandainya tmp kosong
$sqlg = "SELECT * FROM gejala ORDER BY kd_gejala LIMIT 1";
$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">
<table width="450" border="0" cellpadding="2" cellspacing="1" bgcolor="#000000">
<tr>
<td bgcolor="#D7F346"><b>JAWABLAH PERTANYAAN BERIKUT :</b></td>
</tr>
<tr>
<td width="312" bgcolor="#FFFFFF">Apakah Jagung Anda mengalami
<?= $gejala; ?> ?
<input name="TxtKdGejala" type="hidden" value="<?= $kdgejala; ?>"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> <input type="radio" name="RbPilih" value="YA" checked>
Benar (YA)
<input type="radio" name="RbPilih" value="TIDAK">
Salah (TIDAK)</td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> <input type="submit" name="Submit" value="Jawab"></td>
</tr>
</table>
</form>
</body>
</html>