php 手写代码题目,简单PHP投票系统 手写代码

简单PHP投票系统 手写代码

voto.html代码：

Document

投票标题
1
2
3

添加投票入库：addvoto.php<?php

header("Content-type:text/html;charset=utf8");

$pdo=new PDO("mysql:host=127.0.0.1;dbname=test","root","root");

isset($_POST['title']) ? $title = $_POST['title'] : $title='' ;

isset($_POST['key1']) ? $key1 = $_POST['key1'] : $key1='' ;

isset($_POST['key2']) ? $key2 = $_POST['key2'] : $key2='' ;

isset($_POST['key3']) ? $key3 = $_POST['key3'] : $key3='' ;

$option = array(

'key1' => $key1,

'key2' => $key2,

'key3' => $key3

);

$option=json_encode($option);

$sql = "INSERT INTO `vote` (`title`,`option`) VALUES ('$title','$option') ";

$num=$pdo->exec($sql);

if($num>0){

echo "";

}

显示投票：showvoto.php<?php

header("Content-type:text/html;charset=utf8");

$pdo=new PDO("mysql:host=127.0.0.1;dbname=test","root","root");

isset($_GET['vid']) ? $v_id = $_GET['vid'] : $v_id=0 ;

$sql = "SELECT * FROM `vote` WHERE id = $v_id ";

$v_result=$pdo->query($sql)->fetch(PDO::FETCH_ASSOC);

$arr=json_decode($v_result['option'],true);

?>

Document

问题1： = $v_result['title'] ?>

$i=1;

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

?>

= $i ?> . = $v ?>

$i++;

}

?>