Poll
| From: | Manesh | Date: | Fri, 20 Apr 2001 21:41:22 +0000 |
| Subject: | Poll | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-6935@lists.php.net to get a copy of this message | ||
Warning: Undefined variable: submit in c:\inetpub\wwwroot\poll.php on line
44
Warning: Supplied argument is not a valid MySQL result resource in
c:\inetpub\wwwroot\poll.php on line 74
i get error and inside my poll.php is this
<?php
//
// Vendor Ratings System 1.0
// Copyright (C) 2000, AtoZnet.com
// Author: Clayton McGow
// mrwilder@atoznet.com
//
// You may use and alter this code, but do
// not distribute altered code without
// adding a comment section similar to this
// one stating the nature of the changes made
// and do not remove anything above this line.
//
// The purpose of this script is to rate
// "items" on a scale from one to ten.
// The result of each vote is counted,
// tabulated, averaged, and displayed in
// the resulting html code.
// You must add an SQL database called
// "vendors" with a Drop Table called
// "RECORDS" having these fields (in order):
// ID = int autoincrement primary key,
// Name = varchar (32), Description =
// varchar(255), VoteCount = int(11),
// VoteTotal = int(11).
// Now add some records to the database
// for your surfers to "vote" on.
//
?>
<html>
<head>
<title>title</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<FORM method="post" action="<?php echo $PHP_SELF?>">
<?php
$db = mysql_connect("localhost", "test","test"); // don't forget
to
customize this line
mysql_select_db("vendors",$db); // you must create the database called
"vendors"
if ($submit) { // if they have just voted,
// process the new info from the form
while (list($name, $value) = each($HTTP_POST_VARS)){ // by stepping
through the all the args
if ($name!="submit"){ // except the submit button.
if ($value!=0){ // If they voted on a particular item,
// tally up the new total score
// and increment the number of
// votes counted for that item
$theQuery=sprintf("%s%s\0","SELECT * FROM RECORDS where ID=", $name) ;
$result= mysql_query($theQuery,$db);
$myrow = mysql_fetch_row($result);
$VoteCount=$myrow[3];
$VoteCount++;
$theQuery=sprintf("%s%d%s%d\0","UPDATE RECORDS SET VoteCount=",$VoteCount
," where ID=", $name);
$result = mysql_query($theQuery,$db);
$oldVoteTotal= $myrow[4];
$newVoteTotal=$oldVoteTotal+$value;
$theQuery=sprintf("%s%d%s%d\0","UPDATE RECORDS SET
VoteTotal=",$newVoteTotal ," where ID=", $name);
$result = mysql_query($theQuery,$db);
} // end if value !=0
} // end if $name!=submit
} // end while list http_vars
} //end if submit
$result = mysql_query("SELECT * FROM RECORDS",$db);
while ($myrow = mysql_fetch_row($result)) { // list all the data
// for every item in the "RECORDS" table
printf("<p>ID: <b>%d</B><br>Name: %s<br>Description:
%s<br>VoteCount:
%s<br>VoteTotal: %s</p>\n", $myrow[0], $myrow[1], $myrow[2], $myrow[3],
$myrow[4]);
// the next line divides VoteTotal by VoteCount
// and shows is as a "floored" or rounded down int
// unless noone voted on it yet - avoid the
// division by zero condition
if ($myrow[3]!=0) printf("<p>The average score for this vendor is %d
</p>\n", $myrow[4]/$myrow[3]);
else printf("<p>This vendor has not received any votes yet.</p>\n");
// the following html code offers a chance for
// the surfer to vote on each item in the database
// by presenting a row of radio buttons from one to ten.
// Each radio button is given the same name as the
// "ID" field of the item in question... in this case
// it'll be the same as the record number
?>
<p><b>Now <u>you</u> rate this vendor!</b></p>
<table width="75%" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td width="8%">
<div align="center">Worst </div>
</td>
<td width="8%">
<div align="center">1
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="1">
</div>
</td>
<td width="8%">
<div align="center">2
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="2">
</div>
</td>
<td width="8%">
<div align="center">3
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="3">
</div>
</td>
<td width="8%">
<div align="center">4
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="4">
</div>
</td>
<td width="8%">
<div align="center">5
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="5">
</div>
</td>
<td width="8%">
<div align="center">6
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="6">
</div>
</td>
<td width="8%">
<div align="center">7
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="7">
</div>
</td>
<td width="8%">
<div align="center">8
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="8">
</div>
</td>
<td width="10%">
<div align="center">9
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="9">
</div>
</td>
<td width="8%"> 10
<input type="radio" name="<?php echo($myrow[0]) ?>"
value="10">
</td>
<td width="10%">
<div align="center">Best </div>
</td>
</tr>
</table>
<hr>
<?php // now finish up the html form with
// a "submit" button, and close the session
} // end while (from up above the table html code)
echo ("<input type=\"submit\" name =\"submit\" value
=\"submit\">\n");
echo ("</form>\n");
MYSQL_CLOSE();
?>
</body>
</html>
PLEASE HELP!