使用PHP和MySQL更新股票

CREATE TABLE stocks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    code VARCHAR(10) NOT NULL,
    name VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    change_percentage DECIMAL(5, 2) NOT NULL
);

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database_name";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("数据库连接失败： " . $conn->connect_error);
}
?>

<?php
// 获取股票数据源的数据
$stockData = getStockData();

// 更新股票数据到数据库
foreach ($stockData as $stock) {
    $code = $stock['code'];
    $name = $stock['name'];
    $price = $stock['price'];
    $changePercentage = $stock['change_percentage'];

    // 执行MySQL插入或更新操作
    $sql = "INSERT INTO stocks (code, name, price, change_percentage)
            VALUES ('$code', '$name', '$price', '$changePercentage')
            ON DUPLICATE KEY UPDATE
                name = '$name',
                price = '$price',
                change_percentage = '$changePercentage'";
    $result = $conn->query($sql);
    
    if ($result === TRUE) {
        echo "股票 $code 更新成功\n";
    } else {
        echo "股票 $code 更新失败： " . $conn->error;
    }
}

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