| | |
| Stránka: 1 z 1
| [ Príspevok: 1 ] | |
Autor | Správa |
---|
Registrovaný: 26.07.06 Prihlásený: 20.03.16 Príspevky: 1378 Témy: 90 Bydlisko: Slovakia-Ko... | Napísal kmsa: 23.02.2007 16:20 | |
|
potreboval by som toto moje male votovanie trosku prenastavit tak aby som register_globals nemusel nastavit na hodnotu On
Kód: <tr> <td width="248" class="page"> <? include "poll/settings.inc"; $poll = mysql_connect("$db_host", "$db_username", "$db_password") or die ("Could not connect"); mysql_select_db ("kmsa") or die ("Could not select database"); $checkforcurrent = mysql_query("select id,dateactive from polls where active='yes' order by question limit 1"); $current_poll = mysql_fetch_row($checkforcurrent); $curpollid = $current_poll[0]; $dateactive = $current_poll[1]; $today=date("Y-m-d 00:00"); $date1=strtotime( "$dateactive 00:00" ); $date2=strtotime("$today"); $datediffer = (($date2-$date1)/86400); if ($datediffer>=$interval){ $lookfornext = mysql_query("select id from polls where active='no' order by id limit 1"); $getnextid = mysql_fetch_row($lookfornext); $nextpollid = $getnextid[0]; if ($nextpollid){ $date = date("Y-m-d"); mysql_query("update polls set active='end' where id=$curpollid"); mysql_query("update polls set active='yes', dateactive='$date' where id=$nextpollid"); mysql_query("delete from poll_ip"); } }
function writeresults (){ $getquestion = mysql_query("select id,question,votes from polls where active='yes' order by question limit 1"); $question = mysql_fetch_row($getquestion); echo "<font class=\"nleft2\"><b>".$question[1]."</b></font><br><font class=\"left\">"; $totalvotes = $question[2]; $getresults = mysql_query("select votes, alternative from poll_alternatives where poll_id='$question[0]'"); $imageid=1; while ($result = mysql_fetch_array($getresults)){ if ($totalvotes!=0){ $percentage = (round(($result["votes"]/$totalvotes)*10000))/100; } $imagewidth = round($percentage*2); echo "<b>".$result["alternative"]."</b> - $percentage% (".$result["votes"]." hlasov)<br>"; echo "<img src=\"poll/$imageid.gif\" width=\"$imagewidth\" height=\"10\" style=\"border:1px solid black\"><br>"; $imageid++; } echo "<br>Spolu hlasov: $totalvotes</font>"; }
if (!$submit && !$results) { ?> <form method="post" action="<?=$PHP_SELF ?>" target="_top"> <?
$getquestion = mysql_query("select id,question from polls where active='yes' order by question limit 1"); $question = mysql_fetch_row($getquestion); $pollid = $question[0]; $dateactive = $question[2]; $question = $question[1]; echo "<font class=\"nleft2\"><b>$question</b></font><br><font class=\"left\">"; $getalternatives = mysql_query("select id, alternative from poll_alternatives where poll_id='$pollid'"); while ($writeit = mysql_fetch_array($getalternatives)){ echo "<input type=\"radio\" name=polloption value=\"".$writeit["id"]."\""; if (!$checkedvar){ echo "checked"; $checkedvar=1; } echo ">"; echo " ".$writeit["alternative"]."<br>"; } echo "<input type=\"hidden\" name=\"pollid\" value=\"$pollid\"></font>"; echo "<br><center><input type=\"Submit\" value=\"Hlasovať\" name=\"submit\">"; echo "</center></font>"; } elseif ($submit){ $checkforip = mysql_query("select ip from poll_ip where ip='$REMOTE_ADDR'"); if (mysql_num_rows($checkforip)==0){ mysql_query ("update poll_alternatives set votes=votes+1 where id='$polloption'"); mysql_query ("update polls set votes=votes+1 where id='$pollid'"); mysql_query ("insert into poll_ip (ip) values ('$REMOTE_ADDR')"); echo "<font class=\"left\">Tvoj hlas bol prijatý<br><p></font>"; } else { echo "<font class=\"left\">Jeden hlas na jednu IP adresu<br><p></font>";} // skriva ut resultat writeresults(); }
elseif($results){ writeresults(); } mysql_close($poll); ?> </td> </tr>
a este jeden problem server som akos tak nastavil , ale potrebujem este jednu vec nastavit neviem preco ale na stranke mi clanky normalne zobrazi ale clanky z databaze vitiahnute mi neviem preco nedava spravnu diakritiku pricom v databaze zobrazuje dobre.
Na icecku mi to ide dobre
|
|
| Stránka: 1 z 1
| [ Príspevok: 1 ] | |
| Nemôžete zakladať nové témy v tomto fóre Nemôžete odpovedať na témy v tomto fóre Nemôžete upravovať svoje príspevky v tomto fóre Nemôžete mazať svoje príspevky v tomto fóre
|
|