/home/desid573/public_html/family
Edit: /home/desid573/public_html/family/postcodeArray.php (1014B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
date_default_timezone_set("Australia/Perth");
$sql = "SELECT * FROM `postcode_array` where `year` = '2023'";
$request = $conn->query($sql);
$array = array();
while($row = $request->fetch_assoc()) {
if($array[$row["postcode"]] !== false) {
$number = $array[$row["postcode"]];
$array[$row["postcode"]] = $number + 1;
} else {
$array[$row["postcode"]] = 1;
}
}
ksort($array);
foreach($array as $x => $x_value) {
echo $x . "," . $x_value;
echo "
";
}
?>