php mysql网页棋盘源码

CREATE TABLE chessboard (
    id INT AUTO_INCREMENT PRIMARY KEY,
    row INT NOT NULL,
    col INT NOT NULL,
    status ENUM('empty', 'black', 'white') NOT NULL DEFAULT 'empty'
);

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "chessdb";

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

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 初始化棋盘
$boardSize = 8;
$board = array_fill(0, $boardSize, array_fill(0, $boardSize, 'empty'));

// 从数据库加载棋盘状态
$sql = "SELECT row, col, status FROM chessboard";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $board[$row['row']][$row['col']] = $row['status'];
    }
}

$conn->close();

// 显示棋盘
echo "<table border='1'>";
for ($i = 0; $i < $boardSize; $i++) {
    echo "<tr>";
    for ($j = 0; j < $boardSize; $j++) {
        $class = $board[$i][$j];
        echo "<td class='$class'></td>";
    }
    echo "</tr>";
}
echo "</table>";

// CSS 样式
echo "<style>
.empty { width: 50px; height: 50px; background-color: #fff; }
.black { width: 50px; height: 50px; background-color: #000; }
.white { width: 50px; height: 50px; background-color: #fff; border: 1px solid #000; }
</style>";
?>