How can PHP be used to manipulate and organize data retrieved from a MySQL database for age group analysis?

To manipulate and organize data retrieved from a MySQL database for age group analysis in PHP, you can use SQL queries to group the data by age ranges and then process the results in PHP to generate the desired analysis. 

// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query to retrieve data from MySQL database
$sql = "SELECT age FROM users";
$result = $conn->query($sql);

// Initialize age group counters
$ageGroups = array(
    "0-18" => 0,
    "19-30" => 0,
    "31-45" => 0,
    "46-60" => 0,
    "61+" => 0
);

// Process retrieved data and categorize into age groups
while ($row = $result->fetch_assoc()) {
    $age = $row['age'];
    if ($age <= 18) {
        $ageGroups["0-18"]++;
    } elseif ($age <= 30) {
        $ageGroups["19-30"]++;
    } elseif ($age <= 45) {
        $ageGroups["31-45"]++;
    } elseif ($age <= 60) {
        $ageGroups["46-60"]++;
    } else {
        $ageGroups["61+"]++;
    }
}

// Output age group analysis
foreach ($ageGroups as $group => $count) {
    echo "Age group $group: $count users\n";
}

// Close MySQL connection
$conn->close();

Keywords

PHP MySQL data manipulation age group analysis data organization

Related Questions