Salix.gr - Ajax Linked Select boxes Demo 2

Now all data are on the same table.

        CREATE TABLE lsd_demo_2 (
          rec_id int(11) NOT NULL auto_increment,
          parent_id int(11) NOT NULL default '0',
          descr varchar(50) collate latin1_bin NOT NULL default '',
          PRIMARY KEY  (rec_id)
        ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
        

Items for first (parent) select box parent_id=0. Using the new parameter to set an extra field in where clause parent items are filtered.

Example's code

<?php
$sel_val_1='';
$sel_val_2='';
$sel_val_3='';

if( isset($_POST['sel1']) )
	$sel_val_1 = $_POST['sel1'];
if( isset($_POST['sel2']) )
	$sel_val_2 = $_POST['sel2'];
if( isset($_POST['sel3']) )
	$sel_val_3 = $_POST['sel3'];

echo 'sel_val_1='.$sel_val_1.'<br />';
echo 'sel_val_2='.$sel_val_2.'<br />';
echo 'sel_val_3='.$sel_val_3.'<br />';

$sc_ajax_select_boxes = new sc_ajax_select_boxes();     
$sc_ajax_select_boxes->add_select_box('lsd_demo_2','rec_id','descr','rec_id',$sel_val_1,'sel1','sel_id_1','', 'parent_id=0');
$sc_ajax_select_boxes->add_select_box('lsd_demo_2','rec_id','descr','rec_id',$sel_val_2,'sel2','sel_id_2','','');
$sc_ajax_select_boxes->add_select_box('lsd_demo_2','rec_id','descr','rec_id',$sel_val_3,'sel3','sel_id_3','','');
$sc_ajax_select_boxes->link_select_boxes('sel1','sel2', 'parent_id',$sel_val_1);
$sc_ajax_select_boxes->link_select_boxes('sel2','sel3', 'parent_id',$sel_val_2);
$sc_ajax_select_boxes->place_jscripts();
?>
<form name="main" method="POST" action="example_2.php">
<?php
$sc_ajax_select_boxes->show_select_box('sel1');echo '<br />';
$sc_ajax_select_boxes->show_select_box('sel2');echo '<br />';
$sc_ajax_select_boxes->show_select_box('sel3');echo '<br />';
?>
  <input type="submit" value="POST" />
</form>