phpcms 新增站点

<?php
// 假设这是后台管理界面的处理脚本

// 获取表单提交的数据
$site_name = $_POST['site_name'];
$site_domain = $_POST['site_domain'];
$db_host = $_POST['db_host'];
$db_name = $_POST['db_name'];
$db_user = $_POST['db_user'];
$db_pass = $_POST['db_pass'];
$site_dir = $_POST['site_dir'];

// 检查数据是否完整
if (empty($site_name) || empty($site_domain) || empty($db_host) || empty($db_name) || empty($db_user) || empty($db_pass) || empty($site_dir)) {
    echo "所有字段都必须填写";
    exit;
}

// 连接数据库
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if ($mysqli->connect_error) {
    die("连接数据库失败: " . $mysqli->connect_error);
}

// 创建站点目录
if (!file_exists($site_dir)) {
    mkdir($site_dir, 0755, true);
}

// 初始化站点数据
$sql = "CREATE TABLE IF NOT EXISTS `sites` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `domain` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
)";
$mysqli->query($sql);

// 插入站点数据
$sql = "INSERT INTO `sites` (`name`, `domain`) VALUES ('$site_name', '$site_domain')";
$mysqli->query($sql);

echo "站点新增成功";
?>