api.Vote.php 909 Bytes
<?php
    /**
     *  获取投票通道
     */

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

    // 登录验证,验证cookie是否有openid,没有前端走微信openid获取流程
    if (!isset($_COOKIE['openid'])) {
        JsonResponse::error('进入姿势不对?');
    } 
    // 查询是否可以投票
    $mysql = new mysqlHelper();
    // pdo保存数据
    $sql = "SELECT `value` from `setting` WHERE `key` = 'isStartVote' AND `value` = 1;";
    $data = $mysql->fetch($sql);
    if (empty($data)) {
        JsonResponse::error('等候主持人宣布开启投票通道');
    }
    $sql = "SELECT `value` from `setting` WHERE `key` = 'voteUrl';";
    $data = $mysql->fetch($sql);
    if (empty($data)) {
        JsonResponse::error('等候主持人宣布开启投票通道');
    } else {
        JsonResponse::result(['url' => $data['value']]);
    }