$selectSql = "SELECT huaweiId FROM " . $tableName . " WHERE lottery='0'";
$selectRes = $dbModel->selectFromTable($selectSql);
if (!empty($selectRes)) {
while ($row = mysql_fetch_assoc($selectRes)) {
array_push($guestList, $row['huaweiId']);
}
//计算数组长度
$allPeople = count($guestList);
if (shuffle($guestList)) {
$key = rand(0, $allPeople - 1);
//取得健名的随机数
$lotteryNo = $guestList[$key];
//获取中奖用户工号
//更新数据库lottery字段为中奖情况
$updateSql = "UPDATE " . $tableName . " SET lottery='" . $giftLever . "' WHERE huaweiId=" . $lotteryNo;
$updateRes = $dbModel->updateTable($updateSql);
//查询出用户相关信息
$selectPickedSql = "SELECT * FROM " . $tableName . " WHERE huaweiId=" . $lotteryNo;
$selectPickedRes = $dbModel->selectFromTable($selectPickedSql);
if (!empty($selectPickedRes)) {
while ($row = mysql_fetch_assoc($selectPickedRes)) {
//array_push($pickedDate[$i],$row['name']);//姓名
//array_push($pickedDate[$i],$row['huaweiId']);//工号
//array_push($pickedDate[$i],$row['avatar']);//头像,$row['avatar']
$pickedDate[$i] = array($row['name'], $row['huaweiId'], $tableName);
}
} else {
echo "未取到中奖用户信息";
}
} else {
echo "打乱失败";
