dedecms 投票功能

<?php
// 创建投票活动
function createVote($title, $options, $starttime, $endtime) {
    global $dsql;
    $sql = "INSERT INTO `dede_vote` (title, starttime, endtime) VALUES ('$title', '$starttime', '$endtime')";
    $dsql->ExecuteNoneQuery($sql);
    $voteid = $dsql->GetLastID();

    foreach ($options as $option) {
        $sql = "INSERT INTO `dede_voteoption` (voteid, option) VALUES ('$voteid', '$option')";
        $dsql->ExecuteNoneQuery($sql);
    }
}

// 投票
function vote($voteid, $optionid) {
    global $dsql;
    $sql = "UPDATE `dede_voteoption` SET votes = votes + 1 WHERE voteid = '$voteid' AND id = '$optionid'";
    $dsql->ExecuteNoneQuery($sql);
}

// 获取投票结果
function getVoteResult($voteid) {
    global $dsql;
    $sql = "SELECT id, option, votes FROM `dede_voteoption` WHERE voteid = '$voteid' ORDER BY votes DESC";
    $dsql->SetQuery($sql);
    $dsql->Execute();
    return $dsql->GetArray();
}
?>