connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// 获取所有标签页的绘画数据
$tabs = [];
for ($i = 1; $i <= 5; $i++) {
$stmt = $conn->prepare("SELECT * FROM drawings WHERE tab_id = ?");
$stmt->bind_param("i", $i);
$stmt->execute();
$result = $stmt->get_result();
$drawings = [];
while ($row = $result->fetch_assoc()) {
$drawings[] = $row;
}
$tabs[] = [
'id' => $i,
'drawings' => $drawings
];
}
// 检查用户是否已经画过
$hasDrawn = false;
if (isset($_SESSION['user_id'])) {
$stmt = $conn->prepare("SELECT * FROM drawings WHERE user_id = ?");
$stmt->bind_param("s", $_SESSION['user_id']);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$hasDrawn = true;
}
}
// 随机选择一个标签页
$selectedTab = rand(1, 5);
if (isset($_GET['tab'])) {
$selectedTab = intval($_GET['tab']);
}
?>
Drawing App
Welcome to the Drawing App