phpcms多站点设置

server {
    listen 80;
    server_name site1.example.com;

    root /var/www/site1;
    index index.php index.html index.htm;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
    }
}

server {
    listen 80;
    server_name site2.example.com;

    root /var/www/site2;
    index index.php index.html index.htm;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
    }
}

// 查询特定站点的数据
$site_id = 1; // 假设当前站点ID为1
$sql = "SELECT * FROM content WHERE site_id = $site_id";
$result = mysqli_query($conn, $sql);

// 设置站点权限
$site_id = 1;
$role_id = 2;
$permissions = ['view', 'edit'];

foreach ($permissions as $permission) {
    $sql = "INSERT INTO site_permissions (site_id, role_id, permission) VALUES ($site_id, $role_id, '$permission')";
    mysqli_query($conn, $sql);
}