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']]);
}