获取由PDO fetchAll (PDO::FETCH_OBJ)从DB检索的对象的属性

try {
    // 创建PDO连接
    $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'username', 'password');
    
    // 准备SQL查询
    $stmt = $pdo->prepare('SELECT * FROM users');
    
    // 执行查询
    $stmt->execute();
    
    // 获取所有记录作为对象数组
    $users = $stmt->fetchAll(PDO::FETCH_OBJ);
    
    // 遍历对象数组并输出属性
    foreach ($users as $user) {
        echo "ID: " . $user->id . ", Name: " . $user->name . ", Email: " . $user->email . "<br>";
    }
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}

$stmt = $pdo->prepare('SELECT id, name AS userName, email AS userEmail FROM users');

$stmt = $pdo->prepare('SELECT * FROM users LIMIT :offset, :limit');
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);

$date = new DateTime($user->dateField);
$formattedDate = $date->format('Y-m-d');