online poll help

Anon

Sorry to bug you guys with this, I know you probably get way too many questions about this sort of thing. I'm new to PHP (this is my 4th day). I'm trying to build an online poll using radio buttons. I've used some help from this forum but I still can't get it to work. Could someone look through my code and tell me whats wrong, or if I'm even in the right ballpark with this? Thanks.

<body bgcolor="#ffffff">
<?php
$radio_newjersey_checked = " ";
$radio_pittsburgh_checked = " ";
$radio_colorado_checked = " ";
$radio_stlouis_checked = " ";
$submit = " ";

if ($submit) {

$db = mysql_connect("localhost", "login", "passwd");
mysql_select_db("my_db",$db);

// process form
if ($radio_button == "newjersey") {

$radio_newjersey_checked = "CHECKED";
$sql = "UPDATE poll SET newjersey = newjersey +1";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
}
elseif ($radio_button == "pittsburgh") {

$radio_pittsburgh_checked = "CHECKED";
$sql = "UPDATE poll SET pittsburgh = pittsburgh +1";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
}
elseif ($radio_button == "colorado") {

$radio_colorado_checked = "CHECKED";
$sql = "UPDATE poll SET colorado = colorado +1";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
}
elseif ($radio_button == "stlouis") {

$radio_stlouis_checked = "CHECKED";
$sql = "UPDATE poll SET stlouis = stlouis +1";
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";

} else {

// display form

?>
<form method="post" name="poll" id="poll" action="<?php echo $PHP_SELF?>">
<table bgcolor=black>
<tr>
<td bgcolor=black colspan=2>
<font face=verdana color=white size=3>
<p><b>Who do you think will win the Stanley Cup?</b><hr color=red></td>
<tr><td bgcolor=black valign=top><font face=verdana color=white size=3>
<input type="radio" name="radio_button" value="<?php \'newjersey\' $radio_newjersey_checked ?>">New Jersey<br>
<input type="radio" name="radio_button" value="<?php \'pittsburgh\' $radio_pittsburgh_checked ?>">Pittsburgh<br></td>
<td bgcolor=black valign=top><font face=verdana color=white size=3>
<input type="radio" name="radio_button" value="<?php \'colorado\' $radio_colorado_checked ?>">Colorado<br>
<input type="radio" name="radio_button" value="<?php \'stlouis\' $radio_stlouis_checked ?>">St. Louis</p></td></tr>
<tr><td bgcolor=black><font face=verdana color=white size=3><a href="">results</a></td><td bgcolor=black><input type = "submit" value ="<?php \'submit\' $submit ?>"></td></tr>

<?php

} // end if

</body>

dannys

The bit for checking if the form has been submitted is bit odd. I usually use

if ($REQUEST_METHOD=="POST")
{
	bla....
}
else
{
	bla2...
}

Hope this helps

samudasu

Here's a way you won't need to use so many if else statements. You can put this into a single script later if you feel the need. This form doesn't check if any value is set for $myvote the form is submitted so you may need to do that, possibly using the
isset() function.

Table structure

create table poll(
id tinyint not null auto_increment,
name varchar(30) not null,
num_votes smallint not null,
primary key(id));

would look something like this when you have your values entered:

id name num_votes

1 colorado 6
2 St.Louis 7
3 Pittsburgh 8

4 New Jersey 9

form page stanleycup.html

<body bgcolor="#ffffff">
Who do you think will win the Stanley Cup?
<br>
<form action="stanleycup.php" method="post">
<input type="radio" name="myvote" value="New Jersey">New Jersey<br>
<input type="radio" name="myvote" value="Pittsburgh">Pittsburgh<br>
<input type="radio" name="myvote" value="St. Louis">St. Louis<br>
<input type="radio" name="myvote" value="Colorado">Colorado<br>
<input type="submit" name="submit" value="vote">
</form>
</body>

process the form: stanleycup.html

<body>
Poll results for the Stanley Cup
<br>
<?php
mysql_connect(localhost,username,password);
mysql_select_db(databasename);
mysql_query("update poll set num_votes = num_votes + 1
where name = '$myvote'");
echo "We've included your vote for $myvote";
?>
</body>

then i'd do one more query and display the total results for all votes.

Hope this helps.
Sam

Anon

Pls. help about online vote which you can get information coming from the user. how can i make it for my web.
Pls help me.

Thanx