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>
PHP Surveys
I really would like some advice.If you have a client come to you asking for a survey to be done with 117 questions each has 4 radio button check boxes, and a overall percentage needs to be tallyed up.
JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using phpThe page will end up looking like thisPart Number Diameter Effective focal back focal cntr thickness
"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP that does this? I see them on Wordpress and Joomla and such but I've been trying to learn exactly how
Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thought I could use the ASCII function, but SELECT ASCII('é') FROM DUAL in Oracle gives me 50089.
Can I use a loop
Hi buddies!
getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, echoing within a text input, etc) so i would just like to get rid of them.turn: bob's houseinto: bobs
shift numbers with paging
HiHow would i be able to display 10 numbers 1 2 3 4 5 6 7 8 9 10 and when I click next then 2 3 4 5 6 7 8 9 10 11 and click next then 3 4 5 6 7 8 9 10 11 12are displayed.i am using a for loop to echo
i have no idea why this isn't working
Code: <?phpsession_start();include("connect.php");error_reporting(E_ALL);ini_set('display_errors', '1'); $username = "Master";$password = "pword";$host =
Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place.
Spliting paragraph into sentences and attach in
Here is what I am trying to doexample: Para1[123.456.789!] 3 sentences Para2[abc?defghij.klmnop! etc] 3+ sentencesIt should split the paras into sentences based on delimiters (.?!), count