如何利用PHP开发微信公众号的个人中心

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    openid VARCHAR(50) NOT NULL,
    nickname VARCHAR(50) NOT NULL,
    avatar VARCHAR(255) NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

<?php

// 获取用户授权
$userInfo = $wechat->getUserInfo($_GET['code']);
$openid = $userInfo['openid'];
$nickname = $userInfo['nickname'];
$avatar = $userInfo['headimgurl'];

// 保存用户信息到数据库
$db->query("INSERT INTO users (openid, nickname, avatar) VALUES ('$openid', '$nickname', '$avatar')");

<?php

// 获取用户信息
$user = $db->query("SELECT * FROM users WHERE openid = '$openid'")->fetch(PDO::FETCH_ASSOC);

// 展示用户头像和昵称
echo "<img src='{$user['avatar']}' alt='{$user['nickname']}' />";
echo "<h2>{$user['nickname']}</h2>";

// 展示其他个人中心功能
echo "<a href='#'>我的订单</a>";
echo "<a href='#'>我的收藏</a>";
echo "<a href='#'>个人设置</a>";