please, need help coding this voting for your favorite car polling system.
Posted on
16th Feb 2014 07:03 pm by
admin
hi, my code needs a lot of work, but i want to be able to let users vote on their favorite car, update the database, and display the new updated data for the top ten cars listed. i want to prevent multiple votes by ip but i dont know how, but any help with the voting part of the code GREATLY appreciated, as my google tutorials seem to only show premade code.
here is the page so far.
Code: <?php
include("connect1.php");
ini_set('display_errors', 1);
error_reporting(E_ALL); // GREAT SNIPPET FOR DEBUGGING OUTPUTS ERRORS TO SCREEN */
////////////////////////////////////////
////////////////////////////////////////
// escape username and password for use in SQL//person said on board "looks fine" like this
//to prevent sql injections
$make= $_POST['make'];
$model = $_POST['model'];
$year = $_POST['year'];
$color = $_POST['color'];
$make = mysql_real_escape_string($make);
$model = mysql_real_escape_string($model);
$year = mysql_real_escape_string($year);
$color = mysql_real_escape_string($color);
$find = $_POST['find'];
if(isset($_POST['Submit'])){
$vote=0;
$vote++;
echo (" You have voted for a ".$color. " ".$make." ".$model. " ...year: ".$year.".");
mysql_query("INSERT INTO cars (make, model, year ,color , vote ) VALUES('$make','$model', '$year' , '$color',' $vote'"); //ON DUPLICATE KEY UPDATE courtesy = courtesy + $courtesy, stability = stability + $stability, loyalty = loyalty + $loyalty, attitude = attitude + $attitude, votes = votes + $votes");
}//end isset
//output the cars row into an array and the list the top ten
if(isset($_POST['submit'])){
$query="SELECT make, model, year, color, vote
FROM cars
WHERE votes (is the most number of votes) ;
$result=mysql_query($query);
if(mysql_num_rows($result) > 0)
{
$topcars = mysql_fetch_array($result); //put cars row into an array $topcars
}
echo( "Top ten cars ". $carone."
".$cartwo."
". $carthree. "
".$carfour."
".
$carfive."
".$carsix. "
". $carseven. "
".$careight."
".$carnine."
".$carten .
");
}//end isset
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Top ten .com </title>
</head>
<body>
</p>
<div align="center">welcome to <strong>vote your cars</strong> </div>
<p>Please enter your vote your favorite car.<span class="style4"></span><br />
</p>
<form id="form1" name="form1" method="post" action="cars.php">
<table border="0">
<tr>
<td>Make</td>
<td>
<input name="make" type="text" id="make" /></td>
</tr>
<tr>
<td>Model</td>
<td>
<input name="model" type="text" id="model" /> </td>
</tr>
<tr>
<td>Year</td>
<td><input name="year" type="text" id="year" /></td>
</tr>
<tr>
<td>Color</td>
<td><input type="color" name="textfield" id="color" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Submit" /></td>
</tr>
</table>
</form>
<form id="form2" name="form2" method="post" action="cars.php">
<table width="666" border="1">
<tr>
<td width="42"> </td>
<td width="608"><div align="center">VIEW THE UPDATED TOP TEN CARS</div></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" id="submit" value="submit" /></td>
</tr>
</table>
</form>
</body>
</html>
No comments posted yet
Your Answer:
Login to answer
309 
37 
Other forums
how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt ?
how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt and so on 200-300 into file 3.txt ?help retrieiving results and doing pagination
Having some trouble trying to get the results to show on more than just one page.
What is ha
SAP Business Suite
Hi all:
Within the SAP Business Suite solution I would like to ask you the main differenc
Problem writing URL into database
How would I write this into the database?
<?php echo "http://".$_SERVER['SER
how make 2 column in table with data tybe long row
hi every one
I want make in my table 2 column with data tybe long raw
how thi
Calculus Help (and by help I mean homework)
Hrmmm, I hate posting about math homework, partly because it's homework, and partly because I hate w
New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan
How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.
Plz tell me how to assign
Problem assigning value to variable in "IF" function
Does this script makes sense? I am trying to take the value that is set to "authenticat" a
Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I
