用mysql检索员工工资，用nymber_format检索php

SELECT salary FROM employees;

<?php
// 连接到MySQL数据库
$conn = mysqli_connect("数据库主机", "用户名", "密码", "数据库名");

// 检查连接是否成功
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 执行查询语句
$sql = "SELECT salary FROM employees";
$result = mysqli_query($conn, $sql);

// 检查查询结果
if (mysqli_num_rows($result) > 0) {
    // 输出每个员工的工资
    while ($row = mysqli_fetch_assoc($result)) {
        $formattedSalary = number_format($row["salary"], 2); // 格式化工资数据
        echo "工资: " . $formattedSalary . "<br>";
    }
} else {
    echo "没有找到员工工资数据";
}

// 关闭数据库连接
mysqli_close($conn);
?>