当前位置：首页 > PHP

核销 php 实现

2026-01-29 17:07:14PHP

核销功能的基本实现思路

核销功能通常用于验证优惠券、门票、礼品卡等的一次性使用。以下是PHP实现核销功能的关键步骤：

数据库设计

创建存储核销码的表结构，例如：

CREATE TABLE `verification_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0 COMMENT '0-未使用 1-已使用',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

生成核销码

使用PHP生成唯一核销码：

function generateVerificationCode($length = 8) {
    $characters = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $code = '';
    for ($i = 0; $i < $length; $i++) {
        $code .= $characters[rand(0, strlen($characters) - 1)];
    }
    return $code;
}

核销验证接口

实现核销验证的PHP代码：

function verifyCode($code) {
    $db = new PDO('mysql:host=localhost;dbname=your_db', 'username', 'password');

    $stmt = $db->prepare("SELECT * FROM verification_codes WHERE code = :code LIMIT 1");
    $stmt->execute([':code' => $code]);
    $record = $stmt->fetch(PDO::FETCH_ASSOC);

    if (!$record) {
        return ['success' => false, 'message' => '核销码不存在'];
    }

    if ($record['status'] == 1) {
        return ['success' => false, 'message' => '该核销码已被使用'];
    }

    $update = $db->prepare("UPDATE verification_codes SET status = 1, user_id = :user_id WHERE code = :code");
    $update->execute([
        ':user_id' => $_SESSION['user_id'],
        ':code' => $code
    ]);

    return ['success' => true, 'message' => '核销成功'];
}

安全增强措施

增加防刷机制：

session_start();
if (!isset($_SESSION['verify_attempts'])) {
    $_SESSION['verify_attempts'] = 0;
}

if ($_SESSION['verify_attempts'] > 5) {
    die('尝试次数过多，请稍后再试');
}

// 在验证失败时增加计数
$_SESSION['verify_attempts']++;

日志记录功能

记录核销操作：

function logVerification($code, $user_id, $status) {
    $db = new PDO('mysql:host=localhost;dbname=your_db', 'username', 'password');
    $stmt = $db->prepare("INSERT INTO verification_logs (code, user_id, status, ip_address) VALUES (?, ?, ?, ?)");
    $stmt->execute([$code, $user_id, $status, $_SERVER['REMOTE_ADDR']]);
}

前端交互示例

简单的HTML表单：

<form action="verify.php" method="post">
    <input type="text" name="verification_code" placeholder="请输入核销码" required>
    <button type="submit">核销</button>
</form>