ColdFusion转PHP：从MySQL查询结果获取最大最小值

方法一：通过SQL直接查询最值（推荐，效率更高） #

直接在MySQL语句中用MIN()和MAX()函数计算，避免全量获取数据后再处理：

SELECT MIN(number_of_times) AS min_times, MAX(number_of_times) AS max_times FROM your_table;

PDO实现示例 #

// 假设已初始化PDO连接$pdo
$sql = "SELECT MIN(number_of_times) AS min_times, MAX(number_of_times) AS max_times FROM your_table";
$stmt = $pdo->query($sql);
$result = $stmt->fetch(PDO::FETCH_ASSOC);

$minValue = $result['min_times']; // 对应示例中的2
$maxValue = $result['max_times']; // 对应示例中的43

echo "最小值: {$minValue}, 最大值: {$maxValue}";

MySQLi实现示例 #

// 假设已初始化MySQLi连接$conn
$sql = "SELECT MIN(number_of_times) AS min_times, MAX(number_of_times) AS max_times FROM your_table";
$result = $conn->query($sql);
$row = $result->fetch_assoc();

$minValue = $row['min_times'];
$maxValue = $row['max_times'];

echo "最小值: {$minValue}, 最大值: {$maxValue}";

方法二：遍历已获取的结果集计算 #

如果已经从数据库获取了包含number_of_times字段的全量结果，可通过PHP内置函数或循环计算最值：

简洁版（用array_column+内置函数） #

// 假设$records是从数据库返回的结果数组，格式示例：
// $records = [
//     ['number_of_times' => 5],
//     ['number_of_times' => 2],
//     ['number_of_times' => 43],
//     ...
// ];

// 提取所有number_of_times值到数组
$timesArray = array_column($records, 'number_of_times');
$minValue = min($timesArray);
$maxValue = max($timesArray);

echo "最小值: {$minValue}, 最大值: {$maxValue}";

循环遍历版（对应ColdFusion原逻辑） #

// 初始化最值为极端值
$minValue = PHP_INT_MAX;
$maxValue = PHP_INT_MIN;

foreach ($records as $record) {
    $current = $record['number_of_times'];
    if ($current < $minValue) {
        $minValue = $current;
    }
    if ($current > $maxValue) {
        $maxValue = $current;
    }
}

echo "最小值: {$minValue}, 最大值: {$maxValue}";

对应ColdFusion原逻辑示例：

<cfquery name="getTimes" datasource="yourDSN">
    SELECT number_of_times FROM your_table
</cfquery>

<cfset minValue = getTimes.number_of_times[1]>
<cfset maxValue = getTimes.number_of_times[1]>
<cfloop query="getTimes">
    <cfif number_of_times < minValue>
        <cfset minValue = number_of_times>
    </cfif>
    <cfif number_of_times > maxValue>
        <cfset maxValue = number_of_times>
    </cfif>
</cfloop>

内容的提问来源于stack exchange，提问作者mesharp