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.