phpcms调用外部数据源

<?php
// 连接外部数据库
$host = 'external_host';
$dbname = 'external_db';
$user = 'external_user';
$pass = 'external_pass';

$conn = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);

// 查询数据
$stmt = $conn->query("SELECT * FROM external_table");
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($results as $row) {
    echo $row['column_name'] . "<br>";
}
?>

<?php
$url = 'https://api.example.com/data';

$options = array(
    'http' => array(
        'header'  => "Content-type: application/x-www-form-urlencoded\r\n",
        'method'  => 'GET'
    )
);
$context  = stream_context_create($options);
$result = file_get_contents($url, false, $context);

if ($result === FALSE) { /* Handle error */ }

$data = json_decode($result, true);

foreach ($data as $item) {
    echo $item['key'] . "<br>";
}
?>