설문조사

poll.php

<?php
  $mysqli = new mysqli('localhost:3307','phpuser','1234','phpuser_db');
  if($mysqli->connect_errno){
    die("Failed connect to mysql server : (".$mysqli_errno.") ".$mysqli_error);
  }
 
  $result = $mysqli->query('select * from poll order by num');
 
  echo "현재 투표 상황<br><br>";
  while($row = $result->fetch_row())
    echo $row[0]."번 : ".number_format($row[1])."<br>";
 
  $result->free();
  $mysqli->close();
 
 ?>
 
<br><br><br>
가장 선호하는 웹 프로그래밍 언어는?
<form action='savepoll.php' method='post'>
  <input type='radio' name='poll' value=1>C++
  <input type='radio' name='poll' value=2>Python
  <input type='radio' name='poll' value=3>Go
  <input type='radio' name='poll' value=4>JAVA
  <br>
  <input type=submit value="투표">
</form>
 

savepoll.php

<?php
  $poll = $_POST['poll'];
 
  if($poll){
    $mysqli = new mysqli('localhost:3307','phpuser','1234','phpuser_db');
    if($mysqli->connect_errno)
      die("Failed connect to mysql server : (".$mysqli_errno.") ".$mysqli_error);
 
    $mysqli->query('update poll set count=count+1 where num='.$poll);
    $mysqli->close();
   }
 
  header("Location:poll.php");
?>