Hasil Diagnosa

get_results("SELECT * FROM tb_gejala WHERE kode_gejala IN (SELECT kode_gejala FROM tb_konsultasi WHERE jawaban='Ya')"); ?>

Biodata Konsultasi

get_results("SELECT * FROM tb_hasil order by id desc limit 1"); $no=0; foreach($rowss as $rowd):?>
Nama No. Hp Jenis Kelamin Alamat Tanggal
nama ?> no_hp?> jk?> alamat?> tgl?>

Gejala Terpilih

No Nama Gejala
nama_gejala?>
get_results("SELECT * FROM tb_relasi r INNER JOIN tb_diagnosa d ON d.kode_diagnosa = r.kode_diagnosa WHERE r.kode_gejala IN (SELECT kode_gejala FROM tb_konsultasi WHERE jawaban='Ya') ORDER BY r.kode_diagnosa, r.kode_gejala"); foreach($rows as $row){ @$diagnosa[$row->kode_diagnosa]['mb'] = $diagnosa[$row->kode_diagnosa]['mb'] + $row->mb * (1 - $diagnosa[$row->kode_diagnosa]['mb']); @$diagnosa[$row->kode_diagnosa]['md'] = $diagnosa[$row->kode_diagnosa]['md'] + $row->md * (1 - $diagnosa[$row->kode_diagnosa]['md']); @$diagnosa[$row->kode_diagnosa]['cf'] = $diagnosa[$row->kode_diagnosa]['mb'] - $diagnosa[$row->kode_diagnosa]['md']; } ?>

Hasil Analisa

$value) { $new_arr[$key] = $value['cf']; } arsort($new_arr); $result = array(); foreach($new_arr as $key => $value){ @$result[$key] = ++$no; } return $result; } $rank = ranking($diagnosa); foreach($rank as $key => $value):?>
No Vitamin Kepercayaan
nama_diagnosa; ?> %
Vitamin nama_diagnosa; ?>
Solusi solusi; ?>