Tweet
<?php error_reporting(E_ALL);
$db_host = "";
$db_user = "";
$db_pass = "";
$db_name = "";
$link = mysqli_connect($db_host, $db_user, $db_pass, $db_name) or die('Cannot connect to database server');
// if this is a postback ...
if(isset($_POST['color_name'])) {
// create array of acceptable values
$ok = array('red', 'green', 'blue', 'black');
// if we have an acceptable value for color_name ...
if(in_array($_POST['color_name'], $ok)) {
// update the counter for that color
$q = mysql_query("UPDATE colorcounter SET colorcount = colorcount + 1 WHERE colorname = '" . $_POST['color_name'] . "'") or die ("Error updating count for " . $_POST['color_name']);
}
}
// get current color click counts
$rs = mysql_query("SELECT * FROM colorcounter") or die('Cannot process SQL count totals query');
if(mysql_num_rows($rs) > 0) {
while($row = mysql_fetch_array($rs)) {
$count[$row['colorname']] = $row['colorcount'];
}
}
?>
<html xmlns="http://www.w3.org/1999/xhtml"> <head> </head> <body> <form id="myform" name="myform" method="post" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>"> <p>Select a color:</p> <label id="l_red"><input type="radio" id="r_red" name="color_name" value="red" onclick="this.form.submit();" />Red</label> (<label id="c_red"><?php echo $count['red']; ?></label>) | <label id="l_green"><input type="radio" id="r_green" name="color_name" value="green" onclick="this.form.submit();" />Green</label> (<label id="c_green"><?php echo $count['green']; ?></label>) | <label id="l_blue"><input type="radio" id="r_blue" name="color_name" value="blue" onclick="this.form.submit();" />Blue</label> (<label id="c_blue"><?php echo $count['blue']; ?></label>) | <label id="l_black"><input type="radio" id="r_black" name="color_name" value="black" onclick="this.form.submit();" />Black</label> (<label id="c_black"><?php echo $count['black']; ?></label>) </form> </body> </html>
Kommentar