vi riporto qualche codice
pippo.php
codice:
<script type="text/javascript">
var $j = jQuery.noConflict();
$j(document).ready(function(){
var scegli = '<option value="0">Scegli...</option>';
var attendere = '<option value="0">Attendere...</option>';
$j("select#comuni").html(scegli);
$j("select#comuni").attr("disabled", "disabled");
$j("select#cap").html(scegli);
$j("select#cap").attr("disabled", "disabled");
$j("select#province").change(function(){
var regione = $j("select#province option:selected").attr('value');
$j("select#comuni").html(attendere);
$j("select#comuni").attr("disabled", "disabled");
$j("select#cap").html(scegli);
$j("select#cap").attr("disabled", "disabled");
$j.post("punti_vendita/select.php", {provincia:regione}, function(data){
$j("select#comuni").removeAttr("disabled");
$j("select#comuni").html(data);
});
});
$j("select#comuni").change(function(){
var provincia = $j("select#comuni option:selected").attr('value');
$j.post("punti_vendita/select.php", {MYCITY:provincia}, function(data){
/*$("select#puntiv").removeAttr("disabled");*/
$("#puntiv").html(data);
});
});
});
</script>
<?php
include_once 'select.class.php';
$opt = new SelectList();
?>
<div style="clear:both"></div>
<form action="?" id="myform">
<div class="sel">Seleziona una Provincia:<br />
<select id="province" >
<?php echo $opt->ShowProvince(); ?>
</select>
</div>
<div class="sel">Seleziona una Città:<br />
<select id="comuni" >
<option>Scegli...</option>
</select>
</div>
</form>
<div id="puntiv"> </div>
SELECT.CLASS.php
Codice PHP:
<?php
class SelectList
{
protected $conn;
public function __construct()
{
$this->DbConnect();
}
protected function DbConnect()
{
include "db_config.php";
$this->conn = mysql_connect($host,$user,$password) OR die("Impossibile connettersi al database");
mysql_select_db($db,$this->conn) OR die("Impossibile selezionare il database $db");
return TRUE;
}
public function ShowProvince()
{
$sql = "SELECT DISTINCT provincia FROM prodotto_p_vendita order BY provincia ";
$res = mysql_query($sql,$this->conn);
$regioni = '<option value="0">scegli...</option>';
while($row = mysql_fetch_array($res))
{
$regioni .= '<option value="' . $row['provincia'] .'">'. utf8_encode($row['provincia']) .'</option>';
}
return $regioni;
}
public function ShowComuni()
{
$sql = "SELECT DISTINCT city FROM prodotto_p_vendita WHERE provincia='$_POST[provincia]' ORDER BY city ASC";
$res = mysql_query($sql,$this->conn);
$province = '<option value="0">scegli...</option>';
while($row = mysql_fetch_array($res))
{
$province .= '<option value="' . $row['city'] . '">'. utf8_encode($row['city']) . '</option>';
}
return $province;
}
/******/
public function ShowPuntivenditaCITY()
{
$sql = "SELECT distinct name, address, phoneno, cap, city
FROM prodotto_p_vendita WHERE city='$_POST[MYCITY]' order BY name";
$res = mysql_query($sql,$this->conn);
$puntiv = '<p>PUNTI VENDITA:</p><div class="rowtop"><div class="col1">Nome</div><div class="col2">Indirizzo</div><div class="col3">Telefono</div><div class="col3">Mappa</div></div>';
while($row = mysql_fetch_array($res))
{
$puntiv .= '<div class="rowe"><div class="col1"><b>'.$row['name'].'</b></div><div class="col2">' . $row['address'] . '</div><div class="col3"><a id="chiama_pv" onClick="ga(\'send\', \'event\', \'punti_vendita\', \'chiamata_pv\',\'' .$row['name'] .'\',1);" href="tel:'. utf8_encode($row['phoneno']) .'">'. utf8_encode($row['phoneno']) .'</a></div><div class="col3"><a href="https://www.google.it/maps/place/'.$row['city'] .' '.$row['cap'] .' '.$row['address'].'" target="_blank">mostra mappa</a></div></div>';
}
return $puntiv;
}
}
?>