PHP で実装されたオンライン投票システムのソーシャル メディア統合

<?php
// 连接数据库
$mysqli = new mysqli("localhost", "用户名", "密码", "数据库名");
if ($mysqli->connect_errno) {
    die("数据库连接失败: " . $mysqli->connect_error);
}

// 获取投票选项
$query = "SELECT id, option_name FROM options";
$result = $mysqli->query($query);
$options = array();
while ($row = $result->fetch_assoc()) {
    $option_id = $row['id'];
    $option_name = $row['option_name'];
    $options[$option_id] = $option_name;
}

// 处理用户投票
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['vote'])) {
    $option_id = $_POST['vote'];
    $query = "UPDATE options SET votes = votes + 1 WHERE id = $option_id";
    $result = $mysqli->query($query);
    if ($mysqli->affected_rows == 1) {
        echo "投票成功！";
    } else {
        echo "投票失败，请稍后再试。";
    }
}

// 显示投票选项
foreach ($options as $option_id => $option_name) {
    echo "<input type="radio" name="vote" value="$option_id">
          $option_name<br>";
}
echo "<input type="submit" value="提交投票">
     </form>";

// 关闭数据库连接
$mysqli->close();
?>

// Facebook分享按钮
echo "<a href="https://www.facebook.com/dialog/share?app_id=YOUR_APP_ID
      &display=popup&href=投票链接&redirect_uri=回调链接"
      target="_blank">分享到Facebook</a>";

// 获取Facebook分享统计
$response = file_get_contents("https://graph.facebook.com/v11.0/?id=投票链接&fields=engagement");
$json = json_decode($response, true);
$share_count = $json['engagement']['share_count'];
echo "分享到Facebook次数: $share_count";