What are the best practices for filtering out occupied places from an array of numbers generated in PHP based on database values?

When generating an array of numbers in PHP based on database values, it is important to filter out any occupied places to ensure accurate data representation. One way to achieve this is by querying the database for the occupied places and then using PHP to filter out those values from the generated array. This can be done by comparing the database values with the generated array and removing any matches.

// Query the database to get occupied places
$occupiedPlaces = [1, 3, 5]; // Example occupied places

// Generate array of numbers
$generatedArray = range(1, 10);

// Filter out occupied places from the generated array
$filteredArray = array_diff($generatedArray, $occupiedPlaces);

// Output the filtered array
print_r($filteredArray);