// mysql $DB_HOST = "localhost"; $DB_USER = "aanketa_antifetfest_cz"; $DB_PASS = "Anketa"; $DB_NAME = "aanketa_antifetfest_cz"; // pripojenie k db + nastavenie znakovej sady mysql_connect($DB_HOST,$DB_USER,$DB_PASS) or die (mysql_error()); mysql_select_db($DB_NAME) or die (mysql_error()); // hlasovani if (!empty($_GET['poll']) && is_numeric($_GET['poll']) && !empty($_GET['id']) && is_numeric($_GET['id'])) { // hlasoval jsem uz? $hlasoval_jsem=mysql_query("SELECT COUNT(`poll_id`) AS `jsem` FROM `poll` WHERE `poll_id`='".mysql_real_escape_string(stripslashes($_GET['poll']))."' AND `ip`='".$_SERVER['REMOTE_ADDR']."'"); $hlasoval=mysql_fetch_object($hlasoval_jsem); if ($hlasoval->jsem!=0) { $alert='Už jste hlasoval v této anketě!'; } else { mysql_query("INSERT INTO `poll` (`poll_id`,`vote_for`,`ip`) VALUES ('".mysql_real_escape_string(stripslashes($_GET['poll']))."','".mysql_real_escape_string(stripslashes($_GET['id']))."','".$_SERVER['REMOTE_ADDR']."')"); } } // pocet vsech hlasu $pocet_hlasu=mysql_query("SELECT COUNT(`poll_id`) AS `hlasu` FROM `poll` WHERE `poll_id`=1"); $pocet=mysql_fetch_object($pocet_hlasu); $hlasovalo=$pocet->hlasu; $a=simplexml_load_file('/home/httpd/antifetfest.cz/rs/antifetfest-poll/moznosti.xml'); foreach ($a as $v) { $pozadi=$pozadi==false ? true : false; $hlasovalo==0 ? $hlasovalo=1 : ''; $hlasu=mysql_query("SELECT COUNT(`poll_id`) AS `hlasu` FROM `poll` WHERE `poll_id`=1 AND `vote_for`='".mysql_real_escape_string(stripslashes((string)$v->id))."'"); $moznost_hlasu=mysql_fetch_object($hlasu); $out.='
'; } echo '