How can PHP be used to automatically sort and display data in a table based on specific criteria, such as points or status?

To automatically sort and display data in a table based on specific criteria in PHP, you can use the `usort` function to sort the data array based on the desired criteria. Then, you can loop through the sorted data array to display it in a table format on the web page. 

<?php
// Sample data array with points and status
$data = array(
    array('name' => 'John', 'points' => 50, 'status' => 'Active'),
    array('name' => 'Alice', 'points' => 30, 'status' => 'Inactive'),
    array('name' => 'Bob', 'points' => 40, 'status' => 'Active')
);

// Function to compare data based on points
function comparePoints($a, $b) {
    return $a['points'] - $b['points'];
}

// Sort data array based on points
usort($data, 'comparePoints');

// Display sorted data in a table
echo '<table>';
echo '<tr><th>Name</th><th>Points</th><th>Status</th></tr>';
foreach ($data as $row) {
    echo '<tr>';
    echo '<td>' . $row['name'] . '</td>';
    echo '<td>' . $row['points'] . '</td>';
    echo '<td>' . $row['status'] . '</td>';
    echo '</tr>';
}
echo '</table>';
?>

Keywords

PHP sorting data table display criteria status

Related Questions