php⼿机投票源码,php投票系统简单实现源码（13）_PHP教
程
require_once ‘OperatorDB.php’;
class OperatorVotingDB
{
private $odb;
public function __construct()
{
$this->odb = new OperatorDB();
}
public function __destruct()
{
$this->odb = null;
}
/**
* 清空Voting数据中的所有表
*
* 调⽤数据库操作类，执⾏clear数据库的操作
*/
public function clearTables()
{
$sqls = array(“TRUNCATE ip_votes;”,”TRUNCATE count_voting;”);
$this->odb->exec($sqls[0]);
$this->odb->exec($sqls[1]);
}
/**
* 重置count_voting表中的CountValues字段为0
*
*/
public function resetCountValues()
{
$sql = “UPDATE count_voting SET CountVotes = 0;”;
}
php手机版下载/
**
* 投票
* 将信息写⼊ip_votes表
* @param type $ip
* @param type $loc
* @param type $time
* @param type $name
*/
public function vote($ip,$loc,$name)
{
$sql = “INSERT INTO ip_votes VALUES (NULL, ‘$ip’, ‘$loc’, NOW(), ‘$name’)”; $subsql = “SELECT MAX(to_days(VoteTime)) FROM ip_votes WHERE IP=’$ip'”; $stm = $this->odb->query($subsql);
if (count($row=$stm->fetchAll())==1)
{
$now = date(“Y-m-d H:i:s”);
$subsql = “SELECT to_days(‘$now’);”;
$stm = $this->odb->query($subsql)->fetch();
$time = $stm[0];//使⽤mysql计算出的today时间
// echo $time.”
“;
// echo $row[0][0];
if ($time-$row[0][0]<1) 表中最⼤的时间和现在的时间$time⽐较
{
echo “投票失败，相同ip需要隔⼀天才能投票”;
return;
}
}
// echo $sql;
echo “投票成功!”;
$this->odb->exec($sql);
}
* 添加SelectName字段的⾏
*
* @param string $name
* @param string $label
* @param int $count
*/
public function addSelectName($name, $label, $count=0)
{
$sql = “INSERT INTO count_voting VALUES (‘$name’, ‘$label’, $count);”; $this->odb->exec($sql);
}
/**
* 获取总投票情况，按票数排序的结果
*
* 按CountVotes字段排序，返回count_voting表
*
* @param int $n
*
*/
public function getVotesSortByCount($n=-1)
{
$sql = “SELECT * FROM count_voting ORDER BY CountVotes DESC LIMIT 0 , $n;”; if (-1 == $n)
{
$sql = “SELECT * FROM count_voting ORDER BY CountVotes DESC;”;
}
// echo $sql;
return $this->odb->query($sql);
}
/**
* 获取投票情况，按票数排序并按标签分组的结果
*
* 按CountVotes字段排序并按LabelName字段分组，返回count_voting表

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。