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>&nbsp;</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">&nbsp;</td>
<td width="608"><div align="center">VIEW THE UPDATED TOP TEN CARS</div></td>
</tr>

<tr>
<td>&nbsp;</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 Like 37 Dislike
Previous forums Next forums
Other forums

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

Onclick problem in Firefox
Hi,
I am using a . It doesn't seem to

Echoing a Variable from a Object
How do I get a variable from the new User Class to echo out in this clasS?

class MyApp
{

How to make URL loads only on login
On my page, when a user login he's redirects to user_home.php. I made it also to open the chat scree

Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g
I am investigating how to run a Java stored procedure in multithread mode.
I know that if I chang

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

AutoChoosing a CSS file based on URL
Hey everyone,

I have a site that has multiple URLs and CSS files.

Based on the URL tha

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



 
© indyaspeak.com. All Rights Reserved.
Play Free Quiz and Win Cash