<?php

// 示例代码：排行榜功能实现

$pdo = new PDO('mysql:host=localhost;dbname=online_service', 'root', 'password');

// 创建排行榜表

$sql = "CREATE TABLE IF NOT EXISTS ranking (

id INT AUTO_INCREMENT PRIMARY KEY,

user_id INT NOT NULL,

score INT NOT NULL

)";

$stmt = $pdo->prepare($sql);

$stmt->execute();

// 插入用户分数数据

$insert_sql = "INSERT INTO ranking (user_id, score) VALUES (:user_id, :score)";

$stmt = $pdo->prepare($insert_sql);

$stmt->bindParam(':user_id', $userId);

$stmt->bindParam(':score', $score);

// 模拟插入几个用户的分数

$users = [

['user_id' => 1, 'score' => 95],

['user_id' => 2, 'score' => 88],

['user_id' => 3, 'score' => 92]

];

foreach ($users as $user) {

$userId = $user['user_id'];

$score = $user['score'];

$stmt->execute();

}

// 查询排行榜前10名

$rank_sql = "SELECT * FROM ranking ORDER BY score DESC LIMIT 10";

$stmt = $pdo->query($rank_sql);

$ranking = $stmt->fetchAll(PDO::FETCH_ASSOC);

print_r($ranking);

?>

// 一站式网上办事大厅功能实现

// 假设我们有一个办事大厅页面，展示各种服务的链接

echo "<a href='service1.php'>服务1</a>";

echo "<a href='service2.php'>服务2</a>";

echo "<a href='service3.php'>服务3</a>";