get_results("SELECT * FROM tb_gejala WHERE kode_gejala IN (SELECT kode_gejala FROM tb_konsultasi WHERE jawaban='Ya')"); if( !$rows ) : print_msg('Belum ada gejala terpilih!', 'warning'); echo '

Konsultasi Lagi

'; else: ?>

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?>
Diagnosa nama_diagnosa?>
Solusi keterangan?>
Dosis Vitamin dosis_vitamin?>

Konsultasi Lagi Cetak