Login   Register  
PHP Classes
elePHPant
Icontem

File: example_5.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Panos Kyriakakis  >  AJAXed list boxes  >  example_5.php  >  Download  
File: example_5.php
Role: Example script
Content type: text/plain
Description: Use last select box's onChange event to get values for further use
Class: AJAXed list boxes
Generate AJAXed linked select inputs
Author: By
Last change:
Date: 7 years ago
Size: 3,912 bytes
 

Contents

Class file image Download
    <html>
        <head>
            <title>Salix.gr - Linked selected boxes demo page</title>
            <META NAME="author" CONTENT="Panos Kyriakakis">
            <meta name="description" lang="en" content="Demo page. Linked selected boxes that load items from database using AJAX">
            <meta name="keywords" lang="en" content="Demo page, Linked selected boxes, Content management, Components and tools to manage content, AJAX, Interact with the Web server without page reloading">
            <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
            <META name="verify-v1" content="2CKKXxDtxsHjE7TjmXjWJSzMj5xqXOvTrnZ27goGJSE=" />
            <META name="robots" content="follow,index" />
            <link href="http://www.salix.gr/forAll.css" rel="stylesheet" type="text/css"></link>
        </head>
        <body>
        <script src="prototype.js" type="text/javascript"></script>
        <h2><a href="http://www.salix.gr/ajax_linked_selectboxes">Salix.gr - Ajax Linked Select boxes Demo 2</a></h2>
        <p>
        Now all data are on the same table.
        </p> 
        <pre>
        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;
        </pre>
        <p>
        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.
        </p>
        <?php
        
        
include("top_script.php");    
        include(
"sc_classes.php");
        
        
$sc_ajax_select_boxes = new sc_ajax_select_boxes();     
        
$sc_ajax_select_boxes->add_select_box('lsd_demo_2','rec_id','descr','rec_id',2,'sel1','sel_id_1','''parent_id=0');
        
$sc_ajax_select_boxes->add_select_box('lsd_demo_2','rec_id','descr','rec_id',11,'sel2','sel_id_2','');
        
$sc_ajax_select_boxes->add_select_box('lsd_demo_2','rec_id','descr','rec_id',43,'sel3','sel_id_3','');
        
$sc_ajax_select_boxes->link_select_boxes('sel1','sel2''parent_id',2);
        
$sc_ajax_select_boxes->link_select_boxes('sel2','sel3''parent_id',10);
        
$sc_ajax_select_boxes->place_jscripts();
        
$sc_ajax_select_boxes->show_select_box('sel1');
        
$sc_ajax_select_boxes->show_select_box('sel2');
        
$sc_ajax_select_boxes->show_select_box('sel3');
        
?>

    <p>
    To use select box onChange event:<br /><br />
    </p>
    <pre>
    &lt;script type="text/javascript"&gt;
        Event.observe(window, 'load', initSearch, false);
        
        function initSearch() {
            Event.observe('sel_id_3', 'change', dosearch, false);
            window.alert('ads');
        }
        function dosearch(){
            var val1, val2, val3;
            val1='';
            val2='';
            val3='';
            if( $('sel_id_1')!=null);
            val1= $('sel_id_1').value;
            if( $('sel_id_2')!=null);
            val2= $('sel_id_2').value;
            if( $('sel_id_3')!=null);
            val3= $('sel_id_3').value;
            if( val1!='0' && val2!='0' && val3!='0' ) 
                window.alert("sel1=val1&sel2=val2&sel3=val3");
            }
    &lt;/script&gt;

    </pre>

    <script type="text/javascript">
        Event.observe(window, 'load', initSearch, false);
        
        function initSearch() {
            Event.observe('sel_id_3', 'change', dosearch, false);
        }
        function dosearch(){
            var val1, val2, val3;
            val1='';
            val2='';
            val3='';
            if( $('sel_id_1')!=null);
            val1= $('sel_id_1').value;
            if( $('sel_id_2')!=null);
            val2= $('sel_id_2').value;
            if( $('sel_id_3')!=null);
            val3= $('sel_id_3').value;
            if( val1!='0' && val2!='0' && val3!='0' ) 
                window.alert("sel1=val1&sel2=val2&sel3=val3");
        }
    </script>

        </body>
    </html>