denny3d
asked on
jquery chained selects
Hello
note: sorry for my english
OK , I try to use a library jquery and plugin jquery chained select, but i have 2 problem:
1. how i can get data from database mysql?
i post code php :
**************************
<?php
$array = array();
if ($_GET['_name'] == 'tipglass1')
{
if ( $_GET['_value'] == 0 ) {// . . . . . . . . . . . . . . . . . . . . . . nullo
//$array[] = array('0' => 'Seleziona una tipologia');
} elseif ( $_GET['_value'] == 1 ) { // . . . . . . . . . . . . . . . . . . . monolitico
$array[] = array('1' => '4 chiaro');
$array[] = array('2' => '5 chiaro');
$array[] = array('3' => '6 chiaro');
} else { // . . . . . . . . . . . . . . . . . . . mstratificato
$array[] = array('1' => 'selezionare il numero di pannelli del primo vetro stratificato');
}
}
echo json_encode( $array );
?>
**************************
2. into code jquery how i can hidden the second selectbox when the first is unselect?
Now i post the code here:
**************************
<script language="JavaScript" type="text/javascript" src="js/jquery.js"></scrip
<script language="JavaScript" type="text/javascript" src="js/jquery.chainedSele
<script language="JavaScript" type="text/javascript">
$(function()
{
$('#tipglass1').chainSelec
{
before:function (target) //before request hide the target combobox and display the loading message
{
$("#loading").css("display
$(target).css("display","n
$("#glass1_li").css("displ
},
after:function (target) //after request show the target combobox and hide the loading message
{
$("#loading").css("display
$(target).css("display","i
$("#glass1_li").css("displ
}
});
});
</script>
**************************
reghards,
Denny
note: sorry for my english
OK , I try to use a library jquery and plugin jquery chained select, but i have 2 problem:
1. how i can get data from database mysql?
i post code php :
**************************
<?php
$array = array();
if ($_GET['_name'] == 'tipglass1')
{
if ( $_GET['_value'] == 0 ) {// . . . . . . . . . . . . . . . . . . . . . . nullo
//$array[] = array('0' => 'Seleziona una tipologia');
} elseif ( $_GET['_value'] == 1 ) { // . . . . . . . . . . . . . . . . . . . monolitico
$array[] = array('1' => '4 chiaro');
$array[] = array('2' => '5 chiaro');
$array[] = array('3' => '6 chiaro');
} else { // . . . . . . . . . . . . . . . . . . . mstratificato
$array[] = array('1' => 'selezionare il numero di pannelli del primo vetro stratificato');
}
}
echo json_encode( $array );
?>
**************************
2. into code jquery how i can hidden the second selectbox when the first is unselect?
Now i post the code here:
**************************
<script language="JavaScript" type="text/javascript" src="js/jquery.js"></scrip
<script language="JavaScript" type="text/javascript" src="js/jquery.chainedSele
<script language="JavaScript" type="text/javascript">
$(function()
{
$('#tipglass1').chainSelec
{
before:function (target) //before request hide the target combobox and display the loading message
{
$("#loading").css("display
$(target).css("display","n
$("#glass1_li").css("displ
},
after:function (target) //after request show the target combobox and hide the loading message
{
$("#loading").css("display
$(target).css("display","i
$("#glass1_li").css("displ
}
});
});
</script>
**************************
reghards,
Denny
ASKER
ok for the second question:
if I add
if(!$this.val() || this.val() == 0) $(target).hide();
i have this problem:
$this.val = not defined
I must:
if result of first select box = 0 , hide $("#glass1_li")
else
$("#glass1_li").css("displ
if I add
if(!$this.val() || this.val() == 0) $(target).hide();
i have this problem:
$this.val = not defined
I must:
if result of first select box = 0 , hide $("#glass1_li")
else
$("#glass1_li").css("displ
Typo
if(!($(this).val()) || $(this).val() == 0) $(target).hide();
if(!($(this).val()) || $(this).val() == 0) $(target).hide();
ASKER
no its not work.
I post code so you understand:
I would that if into selectbox id="tipglass1" the value selected is != 0 the id="glass1_li" is display:inline,
while if id="tipglass1" the value selected is == 0 the id="glass1_li" is visible display:none.
I post code so you understand:
I would that if into selectbox id="tipglass1" the value selected is != 0 the id="glass1_li" is display:inline,
while if id="tipglass1" the value selected is == 0 the id="glass1_li" is visible display:none.
html file
<script language="JavaScript" type="text/javascript">
$(function()
{
$('#tipglass1').chainSelect('#glass1','query/queryglass1.php',
{
before:function (target) //before request hide the target combobox and display the loading message
{
$("#loading").css("display","block");
$(target).css("display","none");
$("#glass1_li").css("display","none");
},
after:function (target) //after request show the target combobox and hide the loading message
{
$("#loading").css("display","none");
$(target).css("display","inline");
$("#glass1_li").css("display","inline");
}
});
});
</script>
</head>
<body>
<div id="loading">Loading ...</div>
<h2>VETRA CAMERA DOPPIO COMPOSIZIONE</h2>
<form name="dgu" method="post" action="">
<fieldset>
<legend>Vetro Camera doppio</legend>
<ol>
<li>
<label>Tipologia glass 1:</label>
<!-- tipology combobox -->
<select id="tipglass1" name="tipglass1">
<option value="0" selected>- seleziona -</option>
<option value="1">Monolitico</option>
<option value="2">Stratificato</option>
</select>
</li>
<li id="glass1_li" style="display:none">
<label>glass 1:</label>
<select name="glass1" id="glass1" style="display:none" ></select>
</li>
</ol>
</fieldset>
</form>
*****************js file selecbox
jQuery.fn.chainSelect = function( target, url, settings )
{
return this.each( function()
{
$(this).change( function( )
{
settings = jQuery.extend(
{
after : null,
before : null,
usePost : false,
defaultValue : null,
parameters : {'_id' : $(this).attr('id'), '_name' : $(this).attr('name'), '_nr' : $(this).attr('number')}
} , settings);
settings.parameters._value = $(this).val();
if (settings.before != null)
{
settings.before( target );
}
ajaxCallback = function(data, textStatus)
{
$(target).html("");//clear old options
data = eval(data);//get json array
for (i = 0; i < data.length; i++)//iterate over all options
{
for ( key in data[i] )//get key => value
{
$(target).get(0).add(new Option(data[i][key],[key]), document.all ? i : null);
}
}
if (settings.defaultValue != null)
{
$(target).val(settings.defaultValue);//select default value
} else
{
$("option:first", target).attr( "selected", "selected" );//select first option
}
if (settings.after != null)
{
settings.after(target);
}
$(target).change();//call next chain
};
if (settings.usePost == true)
{
$.post( url, settings.parameters, ajaxCallback );
} else
{
$.get( url, settings.parameters, ajaxCallback );
}
});
});
};
*****************phpfile
<?php
$array = array();
if ($_GET['_name'] == 'tipglass1')
{
if ( $_GET['_value'] == 0 ) {// . . . . . . . . . . . . . . . . . . . . . . nullo
//$array[] = array('0' => 'Seleziona una tipologia');
} elseif ( $_GET['_value'] == 1 ) { // . . . . . . . . . . . . . . . . . . . monolitico
$array[] = array('1' => '4 chiaro');
$array[] = array('2' => '5 chiaro');
$array[] = array('3' => '6 chiaro');
} else { // . . . . . . . . . . . . . . . . . . . mstratificato
$array[] = array('1' => 'selezionare il numero di pannelli del primo vetro stratificato');
}
}
echo json_encode( $array );
?>ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You will have to grab the data from the MySQL database and then encode it as JSON data.
This will require querying the database and then putting it into a form that can be JSON encoded. I recommend you create a separate topic for that.
2.
Not sure what you mean by "unselect". One of the options has to be selected.
Do you mean when you select an option with no value or value=0?:
Open in new window