php 怎么投票,php 投票(调查)

/**

* 投票调查

*

*

* */

include "isLogin.php";

include "../conn/config.inc.php";

/*action操作初始化*/

if(empty($_REQUEST['action'])){

$_REQUEST['action']='list';

}else {

$_REQUEST['action']=trim($_REQUEST['action']);

}

if($_REQUEST['action']=='add'){

$tpl->assign('submitButton','添加');

$tpl->assign('tmess','添加投票选项');

$tpl->assign('act','insert');

$tpl->display('admin/addpoll.tpl');

}elseif ($_REQUEST['action']=='insert'){

$title=$_POST['title'];

$desc=$_POST['desc'];

$addtime=time();

$poll=$_POST['poll'];

$sql="insert into poll (title,des,addtime) values ('$title','$desc','$addtime')";

$rs=$db->query($sql);

$lastid=$db->insert_id();

foreach ($poll as $v){

$sql2="insert into poll_option (pollid,opdata) values ('$lastid','$v')";

$rs2=$db->query($sql2);

}

if($rs&&$rs2){

echo "";

}else{

echo "";

}

}

//投票列表

elseif ($_REQUEST['action']=='polllist'){

//$sql="select * from poll order by id desc";

//$rs=$db->query($sql);

//$poll=$db->fetch_array($rs);

$poll=getpoll();

$tpl->assign('poll',$poll);

$tpl->assign('tmess','投票列表');

$tpl->display('admin/polllist.tpl');

}

//删除

elseif ($_REQUEST['action']=='del'){

$id=$_GET['id'];

$sql="delete from poll where id={$id}";

$sql2="delete from poll_option where pollid={$id}";

//echo $sql="delete from poll INNER JOIN poll_option ON poll_option.pollid=poll.id where id={$id}";

$rs=$db->query($sql);

$rs2=$db->query($sql2);

if($rs&&$rs2){

echo "";

}else{

echo "";

}

}

elseif ($_REQUEST['action']=='edit'){

$id=intval($_GET['id']);

//$sql="SELECT p.id, p.title, p.des, p.addtime, po.id, po.pollid, po.opdata

// FROM poll AS p

// LEFT JOIN poll_option AS po ON p.id = po.pollid

// WHERE p.id ={$id}";

$sql="select * from poll where id={$id}";

$rs=$db->query($sql);

$row=$db->fetch_array($rs);

$sql2="select* from poll_option where pollid={$id} order by id ASC";

$rs2=$db->query($sql2);

$i=0;

$potion='';

while ($row2=$db->fetch_array($rs2)){

$i++;

$potion.="

";

if($i>2){

$potion.="";

}

$potion.="

";

}

$tpl->assign('pp',$potion);

$tpl->assign('post',$row);

$tpl->assign('tmess','更新投票');

$tpl->assign('submitButton','更新');

$tpl->assign('act','update');

$tpl->display('admin/editpoll.tpl');

}

//更新投票信息

elseif ($_REQUEST['action']=='update'){

$id=$_POST['id'];

$title=$_POST['title'];

$desc=$_POST['desc'];

$addtime=time();

$poll=$_POST['poll'];

$sql="update poll SET title='{$title}',des='{$desc}',addtime='{$addtime}' where id='{$id}'";

$rs=$db->query($sql);

foreach ($poll as $k=> $v){

// echo "ID:是".$k."值是：".$v;

// echo "
";

$sql2="update poll_option SET opdata='{$v}' where id='{$k}' and pollid={$id} ";

$rs2=$db->query($sql2);

}

if($rs&&$rs2){

echo "";

}else{

echo "";

}

}

//==============投票相关函数=================

//获取投票信息

function getpoll(){

global $db;

$sql="select * from poll order by id desc";

$rs=$db->query($sql);

$data=array();

while ($row=$db->fetch_array($rs)){

$data[]=$row;

}

return $data;

}

?> 只写了部分后续会贴出来，希望大家给与指教。。。。。。