//CAPTCHA: vidu.php
<?php
session_start();
//phát sinh 6 ký tự ngẫu nhiên:
$dodai=6;
$chuoi="QWERTYUIOPASDFGHJKLZXCVBNM0123456789";
$capt="";
for($i=1;$i<=$dodai;$i++)
{
$vitri=rand(0,35);
$capt.=substr($chuoi,$vitri,1);
}
$_SESSION['captcha']=$capt;
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<form action="xuly.php" name="form1"id="form1" method="post">
<p>
<label for="textfield">Ho Ten:</label>
<input type="text" name="textfield" id="textfield">
</p>
<p>
<label for="textfield2">Mat Khau:</label>
<input type="text" name="textfield2" id="textfield2">
</p>
<p>
<label for="textfield3">Nhap ma xac nhan:</label>
<input type="text" name="maxn" id="maxn"><span><?php echo $capt;?></span>
</p>
<p>
<input type="submit" name="thuchien" id="submit" value="Đăng Nhập">
</p>
</form>
</body>
</html>
//CAPTCHA: xuly.php
<?php
session_start();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
if(isset($_POST['maxn'])&&$_POST['maxn']==$_SESSION['captcha'])
{
echo "Nhập đúng mã xác nhận!";
}
else
echo "Nhập sai mã";
?>
</body>
</html>
//BÌNH CHỌN: binhchon.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Binh chon</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="xuly.php">
<p><?php
include("../connect.php");
$sl="select * from binhchon where AnHien=1 limit 0,1";
$kq=mysqli_query($link,$sl);
$d=mysqli_fetch_array($kq);
echo "Cau hoi: ".$d['MoTa']."<br>";
$slpa="select * from phuongan where idBC=".$d['idBC'];
$kqpa=mysqli_query($link,$slpa);
$i=0;
while($dpa=mysqli_fetch_array($kqpa))
{
?>
<label>
<input type="radio" name="binhchon" value="<?php echo $dpa['idPA'];?>" id="binhchon_<?php echo $dpa['idPA'];?>" <?php if($i==0) echo "checked='checked'";$i++;?> />
<?php echo $dpa['MoTa'];?></label>
<br />
<?php }?>
</p>
<p>
<input type="submit" name="thuchien" id="thuchien" value="Binh chon" />
<input type="button" name="button" id="button" value="Xem ket qua" onclick="location.href='ketquabinhchon.php'" />
</p>
</form>
</body>
</html>
//BÌNH CHỌN: xuly.php
<?php ob_start();
if(isset($_POST['binhchon']))
{
include("../connect.php");
$sl="update phuongan set SoLanChon=SoLanChon+1 where idPA=".$_POST['binhchon'];
if(mysqli_query($link,$sl))
header("location:ketquabinhchon.php");
else
echo "Binh chon that bai";
}
?>
//BÌNH CHỌN: ketquabinhchon.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="600" border="1">
<tr>
<td colspan="3">Cau hoi: <?php
include("../connect.php");
$sl="select * from binhchon where AnHien=1 limit 0,1";
$kq=mysqli_query($link,$sl);
$d=mysqli_fetch_array($kq);
echo $d['MoTa'];
//Tinh tong so lan chon:
$kqtsbc=mysqli_query($link,"select sum(SoLanChon) as tongso from phuongan where idBC=".$d['idBC']);
$dtsbc=mysqli_fetch_array($kqtsbc);
?></td>
</tr>
<?php
$slpa="select * from phuongan where idBC=".$d['idBC'];
$kqpa=mysqli_query($link,$slpa);
while($dpa=mysqli_fetch_array($kqpa))
{
?>
<tr>
<td><?php echo $dpa['MoTa'];?></td>
<td width="210"><table width="200" border="0">
<tr>
<td bgcolor="#FF0000" width="<?php echo round($dpa['SoLanChon']*200/$dtsbc['tongso'],0)?>"> </td>
<td> <?php echo round($dpa['SoLanChon']*100/$dtsbc['tongso'],2)?>%</td>
</tr>
</table></td>
<td>So lan:<?php echo $dpa['SoLanChon'];?></td>
</tr>
<?php }?>
<tr>
<td colspan="3" align="right">Tong so lan chon:<?php echo $dtsbc['tongso'];?></td>
</tr>
</table>
</body>
</html>
VID DỤ MẪU GOOLE: piechart.php
<?php
include("../connect.php");
$sl="select * from binhchon where AnHien=1 limit 0,1";
$kq=mysqli_query($link,$sl);
$d=mysqli_fetch_array($kq);
//Lấy các phương án theo câu hỏi bình chọn:
$slpa="select * from phuongan where idBC=".$d['idBC'];
$kqpa=mysqli_query($link,$slpa);
?>
<html>
<head>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Mô tả', 'Số lần bình chọn']<?php
while($dpa=mysqli_fetch_array($kqpa)) {?>,
['<?php echo $dpa['MoTa'];?>', <?php echo $dpa['SoLanChon'];?>]<?php }?>
]);
var options = {
title: '<?php echo $d['MoTa']?>'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="piechart" style="width: 900px; height: 500px;"></div>
</body>
</html>
Comments
Post a Comment