Zdravim ,
celkom surne by som potreboval vyriesit problem pri vybere z databazi pomocou AJAX.
mam vytvorenu tabulku
prices_value so stlpcami:
id | value_prices | value_type | value_format | value_gramaz | value_price | value_piece | value_printVsetko funguje pokial vyberam len dve polozky , teda kliknem na typ ktory mi zobrazi hned , napriklad A5 a pod nim sa mi nacita <select> s gramazou papiera A5 ,
dalej vsak potrebujem spravit to , ze po zvoleni gramaze nacita typ papiera (teda musi hladat format + gramaz) a vypisat typy papiera v s tymto formatom a gramazou ,
a nasledne opat po vybrani typu papiera vypisat z databazy moznosti tlace (obojstranna/jednostranna) podla formatu gramaze a typu ... a tak dalej a tak dalej az po konecnu cenu podla vyberov v select.
Viete mi pomoct ?Zatial mam toto.
Toto je script na automatické vybratie gramaze podla zvoleneho formatu papiera. Podla formatu papiera vybere gramaze pre ten papier urcene.
Script:Kód:
$(document).ready(function() {
$('#papier').change(function() {
var format = $(this).val();
var data = 'format='+format;
$.ajax({
type: "POST",
url: "fill.php",
data: data,
cache:false,
success: function(html)
{
$('#gramaz_papiera').html(html);
}
});
});
});
Script v indexe pre vyber poloziek:Kód:
<form method="post">
<select name="papier" id="papier">
<?php
$query = @MySQL_Query("SELECT * FROM prices_value WHERE value_prices LIKE '2'");
$formaty = Array();
while($row = mysql_fetch_array($query)) {
if (!in_array($row['value_format'], $formaty)) {
$formaty[]=$row['value_format'];
echo "<option value='".$row['value_format']."'>".$row['value_format']."</option>";
}
}
?>
</select>
<br />
<br />
<select name="gramaz_papiera" id="gramaz_papiera" >
<option selected="selected"></option>
</select>
<br />
<br />
<select name="typ_papiera" id="typ_papiera" >
<option selected="selected"></option>
</select>
<select name="tlac_papiera" id="tlac_papiera" >
<option selected="selected"></option>
</select>
<select name="pocet_papiera" id="pocet_papiera" >
<option selected="selected"></option>
</select>
<select name="cena_papiera" id="cena_papiera" >
<option selected="selected"></option>
</select>
</form>
fill.php (vkladany script pre vyber z databazy):
Kód:
include 'func/func_uni_db.php';
if(isset($_POST['format'])) {
$gramaz_papiera = @MySQL_Query("SELECT * FROM prices_value WHERE value_prices LIKE '2' AND value_format LIKE '".$_POST['format']."'");
$$gramaz_papiera_array = Array();
while($gramaz = mysql_fetch_array($gramaz_papiera)) {
if(!in_array($gramaz['value_gramaz'],$gramaz_papiera_array)){
$gramaz_papiera_array[]= $gramaz['value_gramaz'];
echo "<option value='".$gramaz['value_gramaz']."'>".$gramaz['value_gramaz']."</option>";
}
}
} else echo "error";
