Du må være registrert og logget inn for å kunne legge ut innlegg på freak.no
X
LOGG INN
... eller du kan registrere deg nå
Dette nettstedet er avhengig av annonseinntekter for å holde driften og videre utvikling igang. Vi liker ikke reklame heller, men alternativene er ikke mange. Vær snill å vurder å slå av annonseblokkering, eller å abonnere på en reklamefri utgave av nettstedet.
  7 1059
Noen som skjønner hvorfor ikke resultatet vises når jeg åpner index.php3?vispoll=sant, men bare spørsmålene? Arghh!! It's driving me nuts!

<?
//////////////////////////////////////////////////////////////////////
//
// phpPolls - A voting booth for PHP3 (configuration module)
//
// Copyright (c) 1999 Till Gerken (tig@skv.org)
//
//////////////////////////////////////////////////////////////////////
$poll_scriptVersion = "1.0.3"; // current version
$poll_baseURL = "http://www.fotball.net/molde/innhold/poll"; // base path of script
// NO slash at the end!
$poll_mySQL_host = "hehe..."; // hostname of MySQL database
$poll_mySQL_user = "hehe..."; // MySQL username
$poll_mySQL_pwd = "hehe..."; // MySQL password
$poll_dbName = "moldenytt"; // database to store the tables in
$poll_descTableName = "poll_description"; // name of table that keeps poll descriptions
$poll_dataTableName = "poll_data"; // name of table that keeps all poll data
$poll_IPTableName = "poll_ip"; // name of table that keeps IP locking info
$poll_logTableName = "poll_log"; // name of table that keeps logging info
$poll_maxOptions = 10; // maximal number of options allowed
$poll_logging = 0; // do you want phpPolls to log every vote?
$poll_IPLocking = 0; // do you want phpPolls to additionally use IP locking?
$poll_IPLockTimeout = 600; // number of seconds for one IP to be locked
$poll_resultBarHeight = 12; // height in pixels of percentage bar in result table
$poll_resultBarScale = 1; // scale of result bar (in multiples of 100 pixels)
$poll_resultBarFile = "phpPollBar.gif"; // name of the image that contains the bar
$poll_setCookies = 1; // 1 - sets a cookie not allowing a user to vote
// twice for the same poll
// 0 - does not set a cookie nor does it check for one
$poll_warnCheaters = 0; // 1 - if a cookie is present and a user tries
// to vote for this poll, a warning is issued
// 0 - silently ignores the vote
$poll_usePersistentConnects = 1; // 1 - uses persistent connects to the database
// (always leaves a link open)
// 0 - uses open/close sequences for database
// accesses
$poll_cookiePrefix = "phpPoll"; // prefix for cookie names

function poll_generateUI($poll_id, $poll_forwarder)
{
global $poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd;
global $poll_dbName, $poll_dataTableName, $poll_maxOptions;
global $poll_usePersistentConnects, $poll_baseURL;
// connect to database
if($poll_usePersistentConnects == 0)
$poll_mySQL_ID = mysql_connect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
else
$poll_mySQL_ID = mysql_pconnect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
// setup a form
echo "<form action=\"$poll_baseURL/phpPollCollector.php3\" method=\"post\">";
echo "<input type=\"hidden\" name=\"poll_id\" value=\"".$poll_id."\">";
echo "<input type=\"hidden\" name=\"poll_forwarder\" value=\"".$poll_forwarder."\">";
// no default selected yet
$poll_default = 0;
// cycle through all options
for($i = 1; $i <= $poll_maxOptions; $i++)
{
// select next vote option
$poll_result = mysql_db_query($poll_dbName, "SELECT * FROM $poll_dataTableName WHERE (pollID=$poll_id) AND (voteID=$i)");
if(!$poll_result)
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
return(0);
}
// fetch field
$poll_object = mysql_fetch_object($poll_result);
if(is_object($poll_object))
{
$poll_optionText = $poll_object->optionText;
if($poll_optionText != "")
{
echo "<input type=\"radio\" name=\"poll_voteNr\" value=\"".$i."\" ";
// set the first button as default
if($poll_default == 0)
{
$poll_default = 1;
echo "checked ";
}
echo "> $poll_optionText <br>";
}
}
}
// show submit button
echo "<br>";
echo "<center><input type=\"submit\" value=\"Vote\"></center>";
echo "<br><center><a href=\"http://www.fotball.net/molde/index.php3?vispoll=sant\" style=\"color: 000000\">Vis resultat</a></center>";
// close form
echo "</form>";
// close link to database
if($poll_usePersistentConnects == 0)
mysql_close($poll_mySQL_ID);
return(1);
}

function poll_viewResults($poll_id, $poll_tableHeader="<table border=0 cellspacing=1 cellpadding=0>", $poll_rowHeader="<tr>", $poll_dataHeader="<td>", $poll_dataFooter="</td>", $poll_rowFooter="</tr>", $poll_tableFooter="</table><br>")
{
global $poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd, $poll_usePersistentConnects;
global $poll_dbName, $poll_descTableName, $poll_dataTableName, $poll_maxOptions;
global $poll_resultBarScale, $poll_resultBarHeight, $poll_resultTableBgColor;
global $poll_resultBarFile, $poll_baseURL;
// connect to database
if($poll_usePersistentConnects == 0)
$poll_mySQL_ID = mysql_connect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
else
$poll_mySQL_ID = mysql_pconnect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
$poll_result = mysql_db_query($poll_dbName, "SELECT SUM(optionCount) AS SUM FROM $poll_dataTableName WHERE pollID=$poll_id");
if(!$poll_result)
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
return(0);
}
$poll_sum = (int)mysql_result($poll_result, 0, "SUM");
mysql_free_result($poll_result);
echo $poll_tableHeader;
// cycle through all options
for($i = 1; $i <= $poll_maxOptions; $i++)
{
// select next vote option
$poll_result = mysql_db_query($poll_dbName, "SELECT * FROM $poll_dataTableName WHERE (pollID=$poll_id) AND (voteID=$i)");
if(!$poll_result)
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
return(0);
}
// fetch field
$poll_object = mysql_fetch_object($poll_result);
if(is_object($poll_object))
{
$poll_optionText = $poll_object->optionText;
$poll_optionCount = $poll_object->optionCount;
echo $poll_rowHeader;
if($poll_optionText != "")
{
echo "<td colspan=\"2\">";
echo "$poll_optionText";
echo $poll_dataFooter;
echo $poll_rowFooter;
echo $poll_rowHeader;
if($poll_sum)
$poll_percent = 100 * $poll_optionCount / $poll_sum;
else
$poll_percent = 0;
echo $poll_dataHeader;
if ($poll_percent > 0)
{
$poll_percentScale = (int)($poll_percent * $poll_resultBarScale / 2);
echo "<img src=\"$poll_baseURL/$poll_resultBarFile\" height=$poll_resultBarHeight width=$poll_percent>";
}
echo $poll_dataFooter;
echo $poll_dataHeader;
printf(" %.2f %% (%d)", $poll_percent, $poll_optionCount);
echo $poll_dataFooter;
}
echo $poll_rowFooter;
}
}
echo $poll_rowHeader;
echo $poll_dataHeader;
echo $poll_dataFooter;
echo $poll_rowFooter;
echo $poll_tableFooter;
// close link to database
if($poll_usePersistentConnects == 0)
mysql_close($poll_mySQL_ID);
return(1);
}

function poll_getResults($poll_id)
{
global $poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd, $poll_usePersistentConnects;
global $poll_dbName, $poll_descTableName, $poll_dataTableName, $poll_maxOptions;
$ret = array();

// connect to database
if($poll_usePersistentConnects == 0)
$poll_mySQL_ID = mysql_connect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
else
$poll_mySQL_ID = mysql_pconnect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
$poll_result = mysql_db_query($poll_dbName, "SELECT SUM(optionCount) AS SUM FROM $poll_dataTableName WHERE pollID=$poll_id");
if(!$poll_result)
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
return(0);
}
$poll_sum = mysql_result($poll_result, 0, "SUM");

$poll_result = mysql_db_query($poll_dbName, "SELECT pollTitle FROM $poll_descTableName WHERE pollID=$poll_id");
if(!$poll_result)
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
return(0);
}

$poll_title = mysql_result($poll_result, 0, "pollTitle");

$ret[0] = array("title"=>$poll_title, "votes"=>$poll_sum);

// select next vote option
$poll_result = mysql_db_query($poll_dbName, "SELECT * FROM $poll_dataTableName WHERE pollID=$poll_id");
if(!$poll_result)
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
return(0);
}
while ($row = mysql_fetch_array($poll_result))
{
$ret[] = array("text"=>$row["optionText"], "votes"=>$row["optionCount"]);
}
// close link to database
if($poll_usePersistentConnects == 0)
mysql_close($poll_mySQL_ID);
return($ret);
}

function poll_listPolls()
{
global $poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd;
global $poll_usePersistentConnects, $poll_dbName, $poll_descTableName;
// connect to database
if($poll_usePersistentConnects == 0)
$poll_mySQL_ID = mysql_connect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
else
$poll_mySQL_ID = mysql_pconnect($poll_mySQL_host, $poll_mySQL_user, $poll_mySQL_pwd);
// select all descriptions
$poll_result = mysql_db_query($poll_dbName, "SELECT * FROM $poll_descTableName ORDER BY timeStamp");
if(!$poll_result)
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
return;
}
$counter = 0;
// cycle through the descriptions until everyone has been fetched
while($poll_object = mysql_fetch_object($poll_result))
{
$resultArray[$counter] = array($poll_object->pollID, $poll_object->pollTitle);
$counter++;
}
if($poll_usePersistentConnects == 0)
mysql_close($poll_mySQL_ID);
return($resultArray);
}
//////////////////////////////////////////////////////////////////////

if($vispoll == "sant")

{

poll_viewResults(1);

}

else

{

poll_generateUI(1, "http://www.fotball.net/molde/index.php3?vispoll=sant");

}

?>

[This message has been edited by dephic (edited 12 January 2001).]
hvilken host bruker du..?
Trådstarter
Subnett... Men funksjonen HAR funket, men så klusset jeg litt med koden, og så... argh! Det er heller ikke noe problem med lagringen av data i MySql-databasen, resultatene kommer bare ikke opp, det er nok på slutten det er noe feil! Men jeg skjønner bare ikke hva! For meg ser det helt greit ut...
▼ ... noen uker senere ... ▼
Alt jeg kan i php er noe sånt som <? include("navn.fil") ?> og det er jeg meget stolt av http://www.iblis.nu/ubb/biggrin.gif
det er asp jeg er mest geni i, så jeg er ikke helt sikker. du kan i alle fall sjekke at det ikke er enkle sett med {,( og "...
Trådstarter
Har fått det til, men takker uansett!

zeth: stå på!! http://www.iblis.nu/ubb/smile.gif

------------------
Welcome to the real world
.:dephic:.
▼ ... noen måneder senere ... ▼
Originally posted by dephic
zeth: stå på!!
Vis hele sitatet...
jupp
Better than thou.
Bare 6-7 månder senere replyet han med; jupp .