Education enrollment and public expenditure statistics:

Country:

prepare($query)) { $stmt->bind_param('s', $country); $stmt->execute(); $stmt->bind_result($min, $max); $stmt->fetch(); echo "Range of years with data: $min to $max\n"; $stmt->free_result(); } ?>

prepare($query)) { $stmt->bind_param('s', $country); $stmt->execute(); $stmt->bind_result($year, $fp, $ap, $fs, $ms, $as, $ft, $at, $gni, $exp); $thead = ""; $r_fp = ""; $r_ap = ""; $r_fs = ""; $r_ms = ""; $r_as = ""; $r_ft = ""; $r_at = ""; $r_gni = ""; $r_exp = ""; while ($stmt->fetch()) { $fs = percentString($fs); $ms = percentString($ms); $as = percentString($as); $gni = percentString($gni); $exp = percentString($exp); $thead .= ""; $r_fp .= ""; $r_ap .= ""; $r_fs .= ""; $r_ms .= ""; $r_as .= ""; $r_ft .= ""; $r_at .= ""; $r_gni .= ""; $r_exp .= ""; } $thead .= "\n"; $r_fp .= "\n"; $r_ap .= "\n"; $r_fs .= "\n"; $r_ms .= "\n"; $r_as .= "\n"; $r_ft .= "\n"; $r_at .= "\n"; $r_gni .= "\n"; $r_exp .= "\n"; echo $thead . $r_fp . $r_ap . $r_fs . $r_ms . $r_as . $r_ft . $r_at . $r_gni . $r_exp; $stmt->free_result(); } $mysqli->close(); ?>
 
Number of female primary students
Number of all primary students
Enrollment rate of female secondary students
Enrollment rate of male secondary students
Enrollment rate of all secondary students
Number of female tertiary students
Number of all tertiary students
Public education expenditure as a % of GNI
Public education expenditure as a % of government expenditure $year $fp $ap $fs $ms $as $ft $at $gni $exp