在PHP中使用SQL原生函数的保留类型存储结果

try {
    $pdo = new PDO($dsn, $user, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $pdo->query('SELECT * FROM your_table');
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

    foreach ($result as $row) {
        // 根据需要进行类型检查和转换
        if (!is_numeric($row['your_numeric_column'])) {
            throw new Exception('Data type mismatch for column your_numeric_column');
        }
        // 进行后续操作
    }
} catch (Exception $e) {
    echo 'Error: ' . $e->getMessage();
}

$dsn = 'mysql:host=localhost;dbname=your_database';
$user = 'your_username';
$password = 'your_password';

try {
    $pdo = new PDO($dsn, $user, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $pdo->query('SELECT id, name, age FROM users');
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

    foreach ($result as $row) {
        echo 'ID: ' . $row['id'] . ', Name: ' . $row['name'] . ', Age: ' . $row['age'] . "\n";
    }
} catch (Exception $e) {
    echo 'Error: ' . $e->getMessage();
}