apicp.LotteryList.php 812 Bytes
<?php
/**
 * 跨域处理
 */
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Methods:GET,POST");
    /**
     *  获取中奖记录
     */

    include "Common/JsonResponse.php";
    include "Common/mysqlHelper.php";
    include "Common/WechatHelper.php";
    include "Common/Encrypter.php";

    if(!isset($_GET['prize_id'])){
        JsonResponse::error('prize_id参数不能为空');
    }

    $mysql = new mysqlHelper();
    $prize_id = $_GET['prize_id'];

    $prizeList = $mysql->fetchAll(
        "SELECT l.id,l.user_id,u.realname,u.headimg,u.prize_no FROM lottery as l 
                LEFT JOIN user as u on u.id = l.user_id
                WHERE prize_id = {$prize_id} AND is_cancel = 0");

    $prizeList = $prizeList ?? [];
    JsonResponse::result(['data' => $prizeList]);