php调查系统1

//程序名 recordvotepoll.php3 //作者:phpstudent //本程序用于记录投票数 //接口参数 $vpollid调查id,$vchioceid选项id,在提交表单中必须有着两个参数,一般$vpollid require(database.php3); //database.php3是屏蔽了mysql及oracle差异性的自定义数据库接口 $db = new database(); $db->opendefaultconnection(); $sql = “select chiocenum from pollchioce where poll and chioceid = “.$vchioceid; $db->openresultset($sql); $db->rstnext(); $vpolldata=$db->getitem(1); $vpolldata++; //增加票数 //更新数据表 $sql = “update pollchioce set chiocenum = “.$vpolldata.” where poll and chioceid = “.$vchioceid; $db->executeupdate($sql); $db->executeupdate(“commit”); $db->closeconnection(); echo(“感谢您参与本次调查以下是调查结果”); include(showresult.php3); //showresult.php3是显示结果的文件 ?> 数据表的结构如下: 1、 create table poll ( pollid tinyint(1) default 0 not null, polltitle varchar(40) not null, polldetail varchar(200) not null, primary key (pollid), unique pollid (pollid) ); 2、 create table pollchioce ( pollid tinyint(1) default 0 not null, chioceid tinyint(1) default 0 not null, chiocename varchar(20) not null, chiocenum int(5) default 0 not null, chiocecolor varchar(6) not null );

http://www.bkjia.com/phpjc/532224.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/532224.htmltecharticle//程序名 recordvotepoll.php3 //作者:phpstudent //本程序用于记录投票数 //接口参数 $vpollid调查id,$vchioceid选项id,在提交表单中必须有着两个参数…

Posted in 未分类