PHP Code
- From: Edgar Lozano <1419goku@xxxxxxxxx>
- To: programmingblind@xxxxxxxxxxxxx
- Date: Tue, 2 Aug 2011 13:28:32 -0500
Hello all.
Hope yall don't mind me throwing some PHP code out there. Could you
please give me some suggestions?
I'm trying to create a voting page for my website. The files are as follows:
A config.php file
An index.php file,
An vote.php file
And a voteprocessing.php file.
The contents of the config.php file are as follows:
<?php
$host="localhost";
$user="user";
$pass="password";
$edgar=mysql_connect($host,$user,$pass);
if(!$edgar)
{
die("Cannot connect properly. " . mysql_error());
}
$db="database2";
$db2=mysql_select_db($db,$edgar);
if(!$db2)
{
die("Error: cannot find Database. " . mysql_error());
}
The contents of the Index.php file are as follows:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd";>
<html lang="en-US">
<head>
<title>Voting page</title>
</head>
<body>
<div id="main">
<p>
Hello. Welcome to my voting page. <br>
On this page, you are allowed to vote on your favorite music!<br>
Everyday, I have a song of the day, and I would like more interaction
for that section.<br>
I can't come up with any ideas of music that other people will like,
so everyday, I will put options for you to vote on.<br>
</p>
<p>
Rules<br><br>
In order for you to vote, you will need to have an account on my Forum!<br>
To log into my forum,
<a href="http://edgar.ueuo.com/forum/login.php";>Click Here.</a><br>
If you would like to register, to take advantage of all these cool
things, you can register
<a href="http://edgar.ueuo.com/forum/register.php";>Here.</a><br>
Finally, if you want to vote,
<a href="http://edgar.ueuo.com/music/vote.php";>Click Here.</a><br>
Thank you for your interest, and participation in my website.
</p>
</div>
© by Edgar Lozano<br>
All Rights Reserved
</body>
</html>
The contents of the vote.php file are as follows:
<?php
include("config.inc");
$question = "What would you like the song of the day to be for tomorrow?";
$a1 = "A wrap song";
$a2 = "A Country Song";
$a3 = "Another genre";
$a4 = "Random song";
$a5 = "I cannot decide give me more options";
$insert = "INSERT INTO Polls
VALUES('', '$question', '$a1', '$a2', '$a3', '$a4', '$a5')";
if(!mysql_query($insert))
{
die("Error: " . mysql_error());
}
?>
<html>
<head>
<title>Song of The Day Voting Page</title>
</head>
<body>
<p>To vote, just select your option, and click on the submit button.</p>
<?php
echo $question . "<br>";
?>
<form action="voteprocessing.php" method="post">
<?php echo $a1 . "<br>"; ?> <input type="radio" name="answer1"/>
<?php echo $a2 . "<br>"; ?> <input type="radio" name="answer2"/>
<?php echo $a3 . "<br>"; ?> <input type="radio" name="answer3"/>
<?php echo $a4 . "<br>"; ?> <input type="radio" name="answer4"/>
<?php echo $a5 . "<br>"; ?> <input type="radio" name="answer5"/>
<input type="submit" name="submit" value="vote"/>
</form>
</body>
</html>
And finally, the contents of the voteprocessing.php file are as follows:
<?php
include("config.inc");
echo "Thanks for voting.";
echo "The results are as follows!";
$answer1 = $_post['answer1'];
$answer2 = $_post['answer2'];
$answer3 = $_post['answer3'];
$answer4 = $_post['answer4'];
$answer5 = $_post['answer5'];
$submit = $_post['submit'];
$sql = mysql_query("insert into pollAnswers
(pk_id, pollID, answer, visitorIP)
values('', '', '$submit', '')");
if(!$sql)
{
die("error: " . mysql_error());
}
?>
As you can see, I have already created two tables. pollAnswers and
polls. I want Polls to contain the poll question and the five answers
to that question. I want the PollAnswers table to contain the pollID
and pk_id with the visitors IP address and the answer that they chose.
Can someone direct me in the right path to how to construct the rest
of this voteprocessing.php file?
I would greatly appreciate it!
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
