Using ThinkPHP6 Collection Methods to Process Database Query Results

In ThinkPHP6, after executing a database query, the returned value is a think\Collection object, which can be manipulated similarly to an array but requires specific collection methods for processing.

The most commonly used methods are toArray, which converts the collection to a plain PHP array, and isEmpty, which checks whether the collection contains any records.

Below is a code example that queries the shop_goods table, checks if the result is empty, and prints both the original collection and its array representation:

$select = Db::table('shop_goods')->whrer('id', 1)->select();
if ($select->isEmpty()) {
    echo '数据为空';
    exit;
}
print_r($select);
print_r($select->toArray());
}

When the query returns data, the output shows the collection object structure followed by the corresponding array, illustrating how the toArray method simplifies further data handling.