Sorguyu yeniden biçimlendirilmesi

0 Cevap php

I sym_dis adında bir tablo var.

select * from sym_dis verir

 +--------------+-----------------------------------+
 | disease      | symptom                           |
 +--------------+-----------------------------------+
 | typhoid      | headache                          |
 | typhoid      | high fever                        |
 | typhoid      | pain in the abdomen               |
 | typhoid      | sore throat                       |
 | typhoid      | feeling of fatigue                |
 | typhoid      | weekness                          |
 | typhoid      | constipation                      |
 | polio        | headache                          |
 | polio        | nausea                            |
 | polio        | vomiting                          |
 | polio        | general discomfort                |
 | polio        | slight fever for upto three days  |
 | polio        | stiffness                         |
 | polio        | fever                             |
 | polio        | difficulty swallowing             |
 | polio        | muscle pain and spasms            |
 | yellow fever | high fever                        |
 | yellow fever | chills                            | 
 | yellow fever | headache                          |
 | yellow fever | muscle ache                       |
 | yellow fever | vomiting                          |
 | yellow fever | backache                          |
 | hepatitis B  | jaundice                          |
 | hepatitis B  | fatigue                           |
 | hepatitis B  | abdominal pain                    |
 | hepatitis B  | loss of appetite                  |
 | hepatitis B  | nausea                            |
 | hepatitis B  | vomiting                          |
 | hepatitis B  | joint pain                        |
 | hepatitis B  | dark coloured wine                |
 | hepatitis B  | yellowish tinged skin and eyes    |
 +--------------+-----------------------------------+

Ben nasıl çıktı şu olsun o kadar php ve html kullanarak yukarıdaki tabloyu yeniden biçimlendirmek?

+--------------+-----------------------------------+
| disease      | symptom                           |
+--------------+-----------------------------------+
| typhoid      | headache                          |
|              | high fever                        |
|              | pain in the abdomen               |
|              | sore throat                       |
|              | feeling of fatigue                |
|              | weekness                          |
|              | constipation                      |
| polio        | headache                          |
|              | nausea                            |
|              | vomiting                          |
|              | general discomfort                |
|              | slight fever for upto three days  |
|              | stiffness                         |
|              | fever                             |
|              | difficulty swallowing             |
|              | muscle pain and spasms            |
| yellow fever | high fever                        |
|              | chills                            | 
|              | headache                          |
|              | muscle ache                       |
|              | vomiting                          |
|              | backache                          |   
| hepatitis B  | jaundice                          |
|              | fatigue                           |
|              | abdominal pain                    |
|              | loss of appetite                  |
|              | nausea                            |
|              | vomiting                          |
|              | joint pain                        |
|              | dark coloured wine                |
|              | yellowish tinged skin and eyes    |
+--------------+-----------------------------------+

0 Cevap