客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
投票分类 <!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<?php
$db= new Mysqli("localhost","root","root","db_0808");
$sql= "select * from fenlei";
$result=$db->query($sql);
$data_c= $result->fetch_all();
?>
<table border="1">
<?php
foreach ($data_c as $i){
echo" <tr><th><a href='vote.php?id={$i[0]}&is_radio={$i[2]}'>{$i[1]}</a></th></tr>";
}
?>
</table>
</body>
</html>
投票界面 <!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<?php
$id=$_GET['id'];
$is_radio=$_GET['is_radio'];
$db= new Mysqli("localhost","root","root","db_0808");
$sql= "select * from toupiao WHERE category_id='{$id}'";
$result=$db->query($sql);
$data=$result->fetch_all();
?>
<form action="tongji.php" method="post">
<table>
<tr>
<td>名字</td>
<td>投票</td>
</tr>
<?php
if ($is_radio==1){
foreach ($data as $i){
echo "<tr>
<td>{$i[1]}</td>
<td><input type='radio' name='r' value='{$i[0]}'></td>
</tr>";
}
}else{
foreach ($data as $i){
echo "<tr>
<td>{$i[1]}</td>
<td><input type='checkbox' name='r[]' value='{$i[0]}'></td>
</tr>";
}
}
?>
</table>
<input type="submit" value="提交">
</form>
</body>
</html>
投票处理 <!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<table>
<tr>
<td>名字</td>
<td>票数</td>
</tr>
<?php
//$db= new Mysqli("localhost","root","root","db_0808");
require_once "../ZY/YIN.class.php";
$db = new YIN();
$ip=$_SERVER['REMOTE_ADDR'];//获取ip
$sql="select count(*) from table2 where ip='{$ip}'";
$data = $db->StrQuery($sql);
if($data!='0'){
echo "每个人一天只能投一次";
$r=$_POST['r'];
if (is_array($r)){
$s=implode(',',$r);
$sq="select * from toupiao where id in ({$s})";
}else{
$sq="select * from toupiao where id = {$r}";
}
$qurle=$db->Query($sq);
foreach ($qurle as $i){
echo "<tr><td>{$i[1]}</td><td>{$i[2]}</td></tr>";
}
}else{
$sql = "INSERT INTO table2 VALUES (null,'{$ip}',DEFAULT)";
$squel=$db->strQuery($sql,0);
if($squel){
// $upsql=update table_name set votes = votes + 1 where ...
//然后把数据insert into 到table2中
$r=$_POST['r'];
if (is_array($r)){
$s=implode(',',$r);
$sql="update toupiao set count=(count+1) where id in ({$s})";
}else{
$sql="update toupiao set count=(count+1) where id = {$r}";
}
$data=$db->query($sql,0);
if ($data){
//echo "success";
if (is_array($r)){
$s=implode(',',$r);
$sq="select * from toupiao where id in ({$s})";
}else{
$sq="select * from toupiao where id = {$r}";
}
$qurle=$db->Query($sq);
foreach ($qurle as $i){
echo "<tr><td>{$i[1]}</td><td>{$i[2]}</td></tr>";
}
}
}
}
?>
</table>
</body>
</html>
|
2022-08-17
2022-07-18
2022-11-06
2022-08-17
2022-07-30
ewiger/mlab: Mlab is a high-level python to Matlab® bridge that lets Matlab loo
你是否在寻找一些免费且多功能的Delphi组件为你的程序添加更强的功能？不用再寻找了，
IvonaTau/emotionaldan: Deep Neural Network for joint emotion classification and
Edditoria/notepad-plus-plus-localization-hong-kong: Hong Kong Cantonese localiza
我的笔顺是什么？我的笔顺笔画顺序怎么写？还有我的拼音及意思是什么，好多初学练字者
square/bazel_maven_repository: A bazel ruleset creating a more idiomatic bazel r
工商年报、企业所得税汇算清缴如期而至，又到了每年会计最忙的时节了。工商及税务机关
Multiple vulnerabilities in the web-based management interface of Cisco Small Bu
danipascual/GNSS-matlab: Matlab codes to generate GNSS PRNs, secondary codes, da
win7系统电脑使用过程中有不少朋友表示遇到过win7系统自动完成分区的状况，当出现win7
请发表评论