上海期货金属交易所行情查询 (上海期货金属交易所)

上海夜店 08-07 阅读：2 评论：18

欢迎来到上海期货金属交易所行情查询平台。在这里，您可以查询上海期货金属交易所上市的所有金属合约实时行情。

prepare("SELECT FROM quotes WHERE symbol = ?");$stmt->bind_param("s", $symbol);// 执行查询$stmt->execute();// 绑定结果$stmt->bind_result($id, $symbol, $name, $last, $change, $change_percent, $open, $high, $low, $volume, $turnover);// 获取查询结果$stmt->fetch();// 关闭查询语句$stmt->close();// 关闭数据库连接$conn->close();// 输出查询结果echo "

";echo "

" . $symbol . " - " . $name . "

";echo "

最新价: " . $last . "
涨跌: " . $change . ($change > 0 ? " (+)" : " (-)") . "
涨跌幅: " . $change_percent . "%
开盘价: " . $open . "
最高价: " . $high . "
最低价: " . $low . "
成交量: " . $volume . "
成交额: " . $turnover . "

";echo "

";}?>

prepare("SELECT FROM quotes");// 执行查询$stmt->execute();// 绑定结果$stmt->bind_result($id, $symbol, $name, $last, $change, $change_percent, $open, $high, $low, $volume, $turnover);// 循环输出查询结果while ($stmt->fetch()) {echo "";echo "";echo "";echo "";echo "";echo "";echo "";}// 关闭查询语句$stmt->close();// 关闭数据库连接$conn->close();?>