ecco il codice option.class.php
Codice PHP:
<?php
class Option
{
public $conn;
public function __construct()
{
$this->DbConnectAndSelect();
}
protected function DbConnectAndSelect()
{
include_once "db_config.php";
$this->conn = mysql_connect($db_host,$username,$password);
mysql_select_db($db_name, $this->conn);
return TRUE;
}
public function ShowMarca()
{
echo 'Seleziona una marca:
';
echo '<select id="sel_manufacturer" name="sel_manufacturer"><option value="no">Scegli...</option>';
$sql = "SELECT manufacturer FROM IT_Trade group BY manufacturer ASC";
$res = mysql_query($sql,$this->conn);
while($row = mysql_fetch_array($res))
{
echo '<option value="' . $row['ID'] . '">'. $row[manufacturer] . '</option>';
}
echo '</select>';
}
public function ShowModello()
{
if($_POST['manufacturer'] == "no")
{
die;
}
$sql = "SELECT ID,ModelNo FROM IT_Trade WHERE manufacturer=$_POST[manufacturer]";
$res = mysql_query($sql,$this->conn);
echo'<option value="no">Scegli...</option>';
while($row = mysql_fetch_array($res))
{
echo '<option value="' . $row['ID'] . '">' . $row[ModelNo] . '</option>';
}
echo '</select>';
}
public function ShowResult()
{
if($_POST['ID'] == "no")
{
die;
}
echo '
Hai scelto il modello: ';
$sql = "SELECT ModelNo,Trade_Price FROM IT_Trade WHERE id=$_POST[id]";
$res = mysql_query($sql,$this->conn);
$row = mysql_fetch_array($res);
echo $row[ModelNo];
//calcolo aumento prezzo al pubblico
{
$num1=20;
$num2=100;
{$x = (($num1 / $num2)* $row['Trade_Price']);}
{$y = ($row['Trade_Price'] + $x)+10; }
//fine calcolo
echo " - Euro: " . round($y, 2) . ""; //visualizzazione risultato
}
}
}
?>
e questo l'index
Codice PHP:
<html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<script type="text/javascript" src="./jquery-1.3.2.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#sel_manufacturer').change(function(){
var cont = $('#sel_manufacturer').attr('value');
$.post("selection.php", {manufacturer:cont}, function(data){
$("#sel_modelno").empty();
$("div#result").empty();
$("#sel_modelno").prepend(data);
});
});
$('#sel_modelno').change(function(){
var id_naz = $('#sel_modelno').attr('value');
$.post("result.php", {id:id_naz}, function(data){
$("div#result").empty();
$("div#result").prepend(data);
});
});
});
</script>
</head>
<body>
<div id="continenti">
<?php
include_once 'option.class.php';
$obj = new Option();
$obj->ShowMarca();
?>
</div>
<div id="nazioni">
Seleziona un modello:
<select id="sel_modelno" name="sel_modelno"><option value="no">Scegli...</option>
</select>
</div>
<div id="result"></div>
</body>
</html>
Rispondi quotando
