phpcms二次开发实例

CREATE TABLE `user_points` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `points` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

// 增加积分
function add_points($user_id, $points) {
    $db = pc_base::load_model('user_points_model');
    $data = array(
        'user_id' => $user_id,
        'points' => $points,
        'created_at' => date('Y-m-d H:i:s')
    );
    $db->insert($data);
}

// 查询用户积分
function get_user_points($user_id) {
    $db = pc_base::load_model('user_points_model');
    $data = $db->get_one(array('user_id' => $user_id));
    return $data ? $data['points'] : 0;
}

<!-- 在用户信息区域显示积分 -->
<div class="user-info">
    <p>用户名: <?php echo $username; ?></p>
    <p>积分: <?php echo get_user_points($user_id); ?></p>
</div>

$db = pc_base::load_model('user_points_model');
$db->set_db_config(array(
    'db_host' => 'localhost',
    'db_name' => 'phpcms',
    'db_user' => 'root',
    'db_pass' => 'password',
));

function add_points($user_id, $points) {
    // 函数体
}

add_points(1, 10); // 确保在调用前定义

<div class="user-info">
    <p>用户名: <?php echo $username; ?></p>
    <p>积分: <?php echo get_user_points($user_id); ?></p>
</div>