Coder Forum

PHP Quellcode

$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : 0;
 
// (1) example array with four main categories
for($i=0; $i<4; $i++) {
	// four subcategories each
	for($j=($i*10); $j<($i*10)+3; $j++) {
		$idx = $j+1;
		$data[$i][$j] = array(
			'id' => $idx,
			'text' => sprintf('cat %d (parent:%d)', $idx, $i),
		);
 
		// with three childs eiter
		for($k=($idx*10); $k<($idx*10)+3; $k++) {
			$data[$idx][$k] = array(
				'id' => $k,
				'text' => sprintf('subcat %d (parent:%d)', $k, $idx),
			);
		}
	}
}
 
// access the childs with its parent index
$return = $data[$id];
 
echo json_encode($return);

PHP Quellcode

<?php
$Child_id_Array=array("0");
     $sql = "SELECT unterkklasse_id
               FROM klasse_zu_unterklasse
              WHERE parent_id = :id";
     $ERG = @mysql_query($sql);
     for($f=0;$f<mysql_num_rows($ERG);$f++){
       $Child_id_Array[$f]= @mysql_result($ERG,$f,'Knd_id');
     }
 
$child_names_array=array("0");
    for($g=0;$g<count($Child_id_Array);$g++)
    {
        $Names_SQL = 'SELECT klassen_id, klassen_name, klassen_beschreibung
                        FROM klassentabelle
                       WHERE klassen_id='$Child_id_Array[$g]'
                         AND klassen_Creator = '.$_SESSION['client_id'].') 
                          OR (klassen_public = 1)';
        $child_names_array[$g]= = @mysql_query($Names_SQL);
    } 
$return = $child_names_array->fetchAll();
 
echo json_encode($return)
?>

JavaScript Code

var url             = "ajax/";
 
function sendRequest(domref, target) {
	// skip if no target specified
	if(!target) return false;
 
	// save reference to next target
	if(domref) domref.followup = target;
 
	var req;
	try {
		req = window.XMLHttpRequest ? new XMLHttpRequest():
			new ActiveXObject("Microsoft.XMLHTTP");
	} catch (e) {
            alert( "Ihr Webbrowser unterstuetzt leider kein Ajax!" );
	}
	req.onreadystatechange = function() {
		if ((req.readyState == 4) && (req.status == 200)) {
			// merge empty line with response
			var data = eval('(' + req.responseText + ')');
			var targetRef = document.getElementById(target);
			var targetSel = targetRef.getElementsByTagName('select')[0];
 
			// make it visible
			targetRef.style.display = 'block';
 
			// clear old data
			clearSelect(targetSel);
 
			// fill with data from json response
			var i=0;
			for(var x in data) {
				targetSel.options[i++] = new Option(
					data[x].klassen_beschreibung,
                                        data[x].klassen_name,
					data[x].klassen_id
				);
			}
 
			// clear all followups
			while(targetSel.followup) {
				targetRef = document.getElementById(targetSel.followup);
 
				// make it hidden
				targetRef.style.display = 'none';
 
				// mark next select
				targetSel = targetRef.getElementsByTagName('select')[0];
 
				// clear old data
				clearSelect(targetSel);
			}
		}
	}
 
	req.open('post', 'ajax.php');
	req.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
 
	// send empty post with initial load
	req.send(domref !== null ? 'id='+domref.value+'&name='+domref.name : '');
 
	return false; // return false to avoid reload/recentering of the page
}

PHP Quellcode

<?php
 
$ausgabe='<form method="post" action="" id="ajaxSelect">
            <table>
                <tr>
                        <td>
                            text
                        </td>
                </tr>
                <tr>
                        <td>
                            &nbsp;
                        </td>
                </tr>
		<tr id="elem1" style="display:none">
			<td>HauptKategorie:</td>
			<td><select name="hauptkategorie" onchange="sendRequest(this, 'elem2')"><option value=""></option></select></td>
		</tr>
		<tr id="elem2" style="display:none">
			<td>UnterKategorie:</td>
			<td><select name="unterkategorie" onchange="sendRequest(this, 'elem3')"><option value=""></option></select></td>
		</tr>
		<tr id="elem3" style="display:none">
			<td>UnterUnterKategorie1:</td>
			<td><select name="unterunterkategorie" onchange="sendRequest(this, 'elem4')"><option value=""></option></select></td>
		</tr>
		<tr id="elem4" style="display:none">
			<td>UnterUnterKategorie2:</td>
			<td><select name="unterunterunterkategorie" "><option value=""></option></select></td>
		</tr>
            </table>
 
            <div>
                <input type="submit" />
            </div>
        </form>
        ';
 
echo $ausgabe;
?>

PHP Quellcode

echo' <tr>
                    <td>
                        <table>
                            <tr id="hauptkategorie" style="display:block">
                                <td>HauptKategorie:</td>
                                <td><select name="hauptkategorie" size="1" onChange=\'javascript:sendSelBoxRequest(this, document.getElementById("unterkategorie"));\'><option value="">'.$arbmkat_select_option.'</option></select></td>
                            </tr>
                        </table>
                    </td>
                    <td>
                        <table>
                            <tr id="unterkategorie" style="display:block">
                            	<td>UnterKategorie:</td>
                                <td><select name="unterkategorie" size="1" onChange=\'javascript:sendSelBoxRequest(this, document.getElementById("unterunterkategorie"));\'><option value=""></option></select></td>
                            </tr>
                        </table>
                    </td>
                </tr>';

PHP Quellcode

<?php
 
$Child_id_Array=array("0");
$f=0;
     $sql = "SELECT unterklasse_id
               FROM klasse_zu_unterklasse
              WHERE parent_id = :id";
     $ERG = @mysql_query($sql, $central_datenbank->central_verbindung);
     while($zeile = mysql_fetch_row($ERG))
       $Child_id_Array[$f]= $zeile[1];
     }
 
$child_array=array("0");
    for($g=0;$g<count($Child_id_Array);$g++)
    {
        $Names_SQL = 'SELECT Klassen_id, Klassen_name
                        FROM Klassentabelle
                       WHERE Klassen_id='$Child_id_Array[$g]'
                         AND Klassen_Creator = '.$_SESSION['client_id'].') 
                          OR (Klassen_public = 1)';
        $child_array[$g]= @mysql_query($Names_SQL);
    }
echo 'Hallo!!! ';
echo json_encode($child_array);
 
?>