<?php
//Update database information according to your server settings
$conn=mysql_connect('localhost', '...', '...') or
die("Can't connect to mysql host"); //Select the database to use
if(!$_POST['poll'] || !$_POST['pollid']){
$query=mysql_query("SELECT id, ques FROM questions ORDER BY id LIMIT 1");
//display question
echo "<font size=\"+2\"><p class=\"pollques\" style=\"padding:5px\">".$row['ques']."</p></font>"; $poll_id=$row['id'];
}
if($_GET["result"]==1 || $_COOKIE["voted".$poll_id]=='yes'){
//if already voted or asked for result
showresults($poll_id);
}
else{
//display options with radio buttons
$query=mysql_query("SELECT id, value FROM options WHERE ques_id=$poll_id"); echo '<div id="formcontainer" style="width:660px;margin-left:0px" ><form method="post" id="pollform" action="'.$_SERVER['PHP_SELF'].'" >'; echo '<p><input type="hidden" name="pollid" value="'.$poll_id.'" /><br/>'; echo '<div style="background:#059419;border:#ccc solid 2px;padding:5px"> <input class="bar1" style="float:left;font-size:15px;color:#ccc;width:200px;height:25px;padding:0px;opacity:0.4" type="radio" name="poll" value="'.$row['id'].'" id="option-'.$row['id'].'" /> <label style="margin-top:20px;font-size:25px;font-family:Helvetica;" for="option-'.$row['id'].'" >'.$row['value'].'</label></p></div><br/>';
}
echo '<div class="yourvote" style="width:630px;height:30px;border:red solid 2px;margin-top:20px;padding:10px;font-size:20px;font-family:Helvetica;margin-left:2px"><center>Zogłosuj i zobacz wyniki</center><input style="width:640px;height:65px;opacity:0;margin-top:-70px" type="submit" value="" /></div></form>'; echo '<br/><center><p><font color="#ccc" size="+0px"> <em>Musisz oddać głos żeby zobaczyć wyniki sondy.</em></font></p></centar></div>'; }
}
}
else{
if($_COOKIE["voted".$_POST['pollid']]!='yes'){
//Check if selected option value is there in database?
$query="INSERT INTO votes(option_id, voted_on, ip) VALUES('".$_POST["poll"]."', '".date('Y-m-d H:i:s')."', '".$_SERVER['REMOTE_ADDR']."')"; {
//Vote added to database
}
else
}
}
showresults
(intval($_POST['pollid']));}
function showresults($poll_id){
$query=mysql_query("SELECT COUNT(*) as totalvotes FROM votes WHERE option_id IN(SELECT id FROM options WHERE ques_id='$poll_id')"); $total=$row['totalvotes'];
$query=mysql_query("SELECT options.id, options.value, COUNT(*) as votes FROM votes, options WHERE votes.option_id=options.id AND votes.option_id IN(SELECT id FROM options WHERE ques_id='$poll_id') GROUP BY votes.option_id"); $percent=round(($row['votes']*100
)/$total); echo '<br/><div class="option" style="font-size:15px;color:#ccc;margin-top:-5px;margin-left:0px" ><p style="margin-left:15px">'.$row['value'].' (<em>'.$percent.'%, '.$row['votes'].' głosów</em>)</p>'; echo '<div class="bar1 '; if($_POST['poll']==$row['id']) echo ' yourvote'; echo '" style="width: '.$percent.'%;margin-left:2px;margin-top:5px;width:97% " ></div></div><br/>'; }
echo '<br/><p style="float:right;margin-top:-17px;margin-right:10px"><font style="font-size:17px;color:#f6f6f6">Ilość oddanych głosów: '.$total.'</font>'.'</p>'; }
?>
To jest plik sondy ---wyswietla wszytskie sondy jest ich w bazie 5 chyba
To jest plik wyswietlajacy artykul tz php tego pliku . Nie bede tu sciezek wstawial css i htmla .
<?php
$id = $_GET['id'];
}
switch($id){
case 1204:
case 1200:
case 1201:
echo include_once 'index_poll.php'; break;
case 1185:
case 1202:
echo include_once 'index_chemik.php'; break ;
case 1191: case 1193:
echo include_once 'index_LM.php'; break ;
case 1207:
echo include_once 'index_Skra.php'; break ;
}
?>
-------------------------------------------
próbowałem do pliku sondy wstawic zapytanie takie :
select * from news30_story s left join questions q on s.id = q.id where s.id = {Twoj id};
próbowałem tez
select * from news30_story s left join questions q on s.id = q.id order by s.id
nie trybi.
Niby proste ;
pojawia sie artykul ktore dodaje systemem newsow . ta sonada pojawia sie poza systemem bo on nie czyta php .
czyli jakis artykul np.
http://siatkowkaweb.pl/ramki/ramka.php?id=1200ma w sobie sonde z innym id ktory powinien miec ! bo powinnna wyswietlic sie sonda z id=1200
a wyswietla sie pierwsza wpisana . chyba wszytsko opisalem
To jest pewnie cos prostego ale naogół te najprstsze sprawiaja mi najwieksze problemy .