How can PHP developers efficiently handle and manipulate arrays retrieved from database queries in PHP?

When retrieving arrays from database queries in PHP, developers can efficiently handle and manipulate them by using built-in array functions such as foreach, array_map, array_filter, and array_reduce. These functions allow developers to iterate over the arrays, apply transformations, filter out unwanted data, and perform calculations as needed. 

// Example code snippet demonstrating how to handle and manipulate arrays retrieved from database queries in PHP

// Assume $results is an array retrieved from a database query
$results = [
    ['id' => 1, 'name' => 'John', 'age' => 25],
    ['id' => 2, 'name' => 'Jane', 'age' => 30],
    ['id' => 3, 'name' => 'Alice', 'age' => 22]
];

// Using foreach to iterate over the array and print out each record
foreach ($results as $result) {
    echo "ID: " . $result['id'] . ", Name: " . $result['name'] . ", Age: " . $result['age'] . "<br>";
}

// Using array_map to transform the array by adding a new key 'status' to each record
$results = array_map(function($result) {
    $result['status'] = ($result['age'] >= 25) ? 'Adult' : 'Minor';
    return $result;
}, $results);

// Using array_filter to filter out records where age is less than 25
$filteredResults = array_filter($results, function($result) {
    return $result['age'] >= 25;
});

// Using array_reduce to calculate the total age of all records
$totalAge = array_reduce($results, function($carry, $result) {
    return $carry + $result['age'];
}, 0);

echo "Total Age: " . $totalAge;

Keywords

PHP arrays database queries manipulation efficiency

Related Questions