Template for Using a SQLite3 Database - Diseases

database file existsarray(4) { [0]=> int(1) ["DiseaseID"]=> int(1) [1]=> string(7) "Measles" ["DiseaseName"]=> string(7) "Measles" }
array(4) { [0]=> int(2) ["DiseaseID"]=> int(2) [1]=> string(5) "Mumps" ["DiseaseName"]=> string(5) "Mumps" }
array(4) { [0]=> int(3) ["DiseaseID"]=> int(3) [1]=> string(7) "Rubella" ["DiseaseName"]=> string(7) "Rubella" }


IDSymptom
1Cough
2Rash
3Sneezing
4Runny Nose
5Fever
6Lethargy
7Apetite loss
8Swollen eyes
9Light sensitivity
10Aching body
11Red eyes
12Swollen cheeks
13Headache
14Fatigue
15Joint pain
16Swollen lymph nodes

Array ( [0] => 1 [DiseaseID] => 1 [1] => Measles [DiseaseName] => Measles [2] => 1 [SymptomID] => 1 [3] => 1 [IndicatorID] => 1 [4] => Cough [IndicatorName] => Cough )

Array ( [0] => 1 [DiseaseID] => 1 [1] => Measles [DiseaseName] => Measles [2] => 2 [SymptomID] => 2 [3] => 3 [IndicatorID] => 3 [4] => Sneezing [IndicatorName] => Sneezing )

Array ( [0] => 1 [DiseaseID] => 1 [1] => Measles [DiseaseName] => Measles [2] => 3 [SymptomID] => 3 [3] => 5 [IndicatorID] => 5 [4] => Fever [IndicatorName] => Fever )

Array ( [0] => 2 [DiseaseID] => 2 [1] => Mumps [DiseaseName] => Mumps [2] => 4 [SymptomID] => 4 [3] => 5 [IndicatorID] => 5 [4] => Fever [IndicatorName] => Fever )

Array ( [0] => 2 [DiseaseID] => 2 [1] => Mumps [DiseaseName] => Mumps [2] => 5 [SymptomID] => 5 [3] => 13 [IndicatorID] => 13 [4] => Headache [IndicatorName] => Headache )

Array ( [0] => 2 [DiseaseID] => 2 [1] => Mumps [DiseaseName] => Mumps [2] => 6 [SymptomID] => 6 [3] => 7 [IndicatorID] => 7 [4] => Apetite loss [IndicatorName] => Apetite loss )

Array ( [0] => 3 [DiseaseID] => 3 [1] => Rubella [DiseaseName] => Rubella [2] => 7 [SymptomID] => 7 [3] => 13 [IndicatorID] => 13 [4] => Headache [IndicatorName] => Headache )

Array ( [0] => 3 [DiseaseID] => 3 [1] => Rubella [DiseaseName] => Rubella [2] => 8 [SymptomID] => 8 [3] => 2 [IndicatorID] => 2 [4] => Rash [IndicatorName] => Rash )

Array ( [0] => 3 [DiseaseID] => 3 [1] => Rubella [DiseaseName] => Rubella [2] => 9 [SymptomID] => 9 [3] => 11 [IndicatorID] => 11 [4] => Red eyes [IndicatorName] => Red eyes )