// Storing vote results $sql = "INSERT INTO voteentry (vote_id, votechoice_id, date, ip) " . "VALUES (" . $vote[0] . ", {$voteentry_id}, NOW() , '{$ip}')"; mysql_query($sql); } } else { echo '<form action="/voting.php" method="get" >'; } echo '<table class="voting"><tr><td class="votequestion" colspan="2">'; echo $vote[1]; echo '<tr><td>'; $votechoices = mysql_query("SELECT id, description FROM votechoice WHERE vote_id = " . $vote[0] . " ORDER BY `order`"); while ($votechoice = mysql_fetch_array($votechoices, MYSQL_NUM)) { echo '<tr>'; echo '<td class="votingdescr" valign="top">'; if ($show_results) { $count = getVoteCount($vote[0], $votechoice[0]); echo "<b>{$count}</b> - "; } else { echo '<INPUT type="radio" name="vote' . $vote[0] . '" value="' . $votechoice[0] . '"><td class="votingdescr">'; } echo $votechoice[1]; } mysql_free_result($votechoices); if (!$show_results) { echo '<tr><td colspan="2"><INPUT type="submit" value="Send">'; } echo "</table>"; if (!$show_results) { echo '</form>'; } echo '</div>';
echo '<dt class="news-datte">' . $row["create_date"] . '</dt>'; echo '<dd class="news-description"><a href="content.php?id=' . $row["id"] . '">' . mb_substr($row["title"], 0, 10) . "..." . '</a>'; echo "<hr>"; break; } $pdo = null; ?> </div> </dl> </a> <div class="box boxcolor1"> <a href="javascript:void(0);" onclick="Vote('voteId1', 'cntClass1')" class="vote" title="">1に投票する!</a> 投票数:<div class="cntClass1"><?php echo getVoteCount('voteId1'); ?> </div> </div> <?php //---------------------------------------------------------- // 投票数取得関数 //---------------------------------------------------------- function getVoteCount($id) { //ファイル名 $filename = "file/" . $id . ".cnt"; $fp = @fopen($filename, "r"); if ($fp) { $vote = fgets($fp, 9182);
<?php require_once '../includes/mysql.php'; if (isset($_POST['action']) && isset($_POST['id']) && isset($_POST['db'])) { if ($_POST['action'] == 'up') { vote($_POST['db'], $_POST['id'], 1); } else { vote($_POST['db'], $_POST['id'], -1); } echo getVoteCount($_POST['db'], $_POST['id']); }
<?php require_once '../database.php'; if (isset($_POST['action']) && isset($_POST['id']) && isset($_POST['db'])) { $c = $_POST['action'] == 'up' ? 1 : -1; vote($_POST['db'], $_POST['id'], $c); echo "<font size = \"5\" color =\"blue\">" . getVoteCount($_POST['db'], $_POST['id']) . "</font>"; } ?>