php 投票(调查)_PHP教程-php教程-PHP中文网

首页

后端开发

php教程

php 投票(调查)_PHP教程

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 pm 05:49 PM

includephp投票调查

/**
* 投票调查
*
*
* */
include "isLogin.php";
include "../conn/config.inc.php";
/*action操作初始化*/
if(emptyempty($_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 "<script>location.href='poll.php?action=polllist'</script>";
    }else{
        echo "<script>alert('失败！');history.go(-1)</script>";
    }
}
//投票列表
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 "<script>location.href='poll.php?action=polllist'</script>";
    }else{
        echo "<script>alert('失败！');history.go(-1)</script>";
    }
}
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');
}
//更新投票信息 www.2cto.com
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 "<script>location.href='poll.php?action=polllist'</script>";
    }else{
        echo "<script>alert('更新失败！');history.go(-1)</script>";
    }
}

//==============投票相关函数=================
//获取投票信息
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;
}

?>

摘自 chaojie2009的专栏

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn