exec("ALTER TABLE `forum_posts` ADD COLUMN `category` VARCHAR(50) NOT NULL DEFAULT 'general' AFTER `content`"); } catch (PDOException $e) { /* column already exists, ignore */ } try { $pdo->exec("ALTER TABLE `forum_posts` ADD COLUMN `views` INT NOT NULL DEFAULT 0 AFTER `category`"); } catch (PDOException $e) { /* ignore */ } try { $pdo->exec("ALTER TABLE `forum_posts` ADD COLUMN `reply_count` INT NOT NULL DEFAULT 0 AFTER `views`"); } catch (PDOException $e) { /* ignore */ } try { $pdo->exec("ALTER TABLE `forum_posts` ADD COLUMN `is_pinned` TINYINT(1) NOT NULL DEFAULT 0 AFTER `reply_count`"); } catch (PDOException $e) { /* ignore */ } try { $pdo->exec("ALTER TABLE `forum_posts` ADD COLUMN `is_locked` TINYINT(1) NOT NULL DEFAULT 0 AFTER `is_pinned`"); } catch (PDOException $e) { /* ignore */ } try { $pdo->exec("ALTER TABLE `forum_posts` ADD COLUMN `updated_at` DATETIME DEFAULT NULL AFTER `created_at`"); } catch (PDOException $e) { /* ignore */ } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $title = trim($_POST['title'] ?? ''); $content = trim($_POST['content'] ?? ''); $category= trim($_POST['category'] ?? ''); if (strlen($title) < 2) { $error = '标题至少需要2个字符'; } elseif (strlen($title) > 200) { $error = '标题不能超过200个字符'; } elseif (empty($content) || $content === '

') { $error = '帖子内容不能为空'; } else { $stmt = $pdo->prepare("INSERT INTO forum_posts (user_id, title, content, category, created_at) VALUES (?,?,?,?,NOW())"); $stmt->execute([$_SESSION['user_id'], $title, $content, $category]); $post_id = $pdo->lastInsertId(); header('Location: /forum-post.php?id=' . $post_id . '&new=1'); exit; } } require_once __DIR__ . '/includes/header.php'; ?>

返回讨论区

发布新帖子

帖子标题 *

0/200

分类

'💬 综合讨论','esim'=>'📱 eSIM 使用','phone'=>'📞 电话号码','device'=>'🔧 设备问题','help'=>'🆘 求助','share'=>'🎉 经验分享']; $sel = $_POST['category'] ?? 'general'; foreach ($cats as $k => $v): ?>

帖子内容 *

支持图片上传（点击工具栏图片按钮） | 支持代码块 | 支持插入链接

取消

发帖小贴士

描述问题时请尽量详细，包括您的设备型号、遇到的具体情况
可以插入截图来更清楚地说明问题
请遵守社区规范，友善交流
相同问题请先搜索是否已有解答