source: trunk/admin/modules/Elezioni/ele_desc_fasce.php@ 362

<?php 

/************************************************************************/
/* Eleonline - Raccolta e diffusione dei dati elettorali                */
/* by Roberto Gigli & Luciano Apolito                                   */
/* http://www.eleonline.it                                              */
/* info@eleonline.it  luciano@aniene.net rgigli@libero.it               */
/************************************************************************/
/* Modulo Autorizzazione Comuni                                         */
/* Amministrazione                                                      */
/************************************************************************/
if (isset($_GET['id_conf'])) $id_conf=intval($_GET['id_conf']);  else $id_conf=1;
if (isset($_GET['fascia'])) $fasciacom=intval($_GET['fascia']);  else $fasciacom=0;
include("../../config.php");
        try{
        $dbi = new PDO("mysql:host=$dbhost;charset=latin1", $dbuname, $dbpass, array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); 
        $sql = "use $dbname";
        $dbi->exec($sql);
        }
        catch(PDOException $e)
        {
            echo $sql . "<br>" . $e->getMessage();
        }                                                                                               
        $sql="SELECT id_fascia,abitanti from ".$prefix."_ele_fasce where id_conf='$id_conf'";
        $sth = $dbi->prepare("$sql");
        $sth->execute();                        
        echo "<select name=\"idfascia\">";
        echo "<option value=\"0\"> ";
        $inffascia=0;
        while(list($id,$abitanti)=$sth->fetch(PDO::FETCH_NUM)){
                $sel='';
                if ($id == $fasciacom) $sel="selected"; elseif ($id==1) $sel="selected";
                echo "<option value=\"$id\" $sel>$inffascia - $abitanti";
                $inffascia=$abitanti;
        }
        echo "</select>";

?>