Coder Forum

JavaScript Code

function handleResponseProjekte() {
 
  if(req.readyState == 4){
    document.getElementById('Projekte').innerHTML = req.responseText;
  }
  else
  alert("loading" + ajax.readyState);
}

JavaScript Code

function sendRequest(choice) {
        try {
                req = window.XMLHttpRequest?new XMLHttpRequest():
                new ActiveXObject("Microsoft.XMLHTTP");
        } catch (e) {
                //Kein AJAX Support
        }
 
        if(choice == "Projekte") {
                req.onreadystatechange = handleResponse;
                req.open("GET", 'includes/function/ajax/projekte.php?s='+ document.getElementById('Kunden').value);
        } else if(choice == "Bauteile") {
                req.onreadystatechange = handleResponse;
                req.open("GET", 'includes/function/ajax/bauteile.php?s='+ document.getElementById('Projekte').value);
        }
 
        req.send(null);
}
 
function handleResponse() {
        if ((req.readyState == 4) && (req.status == 200)) {
                var update = new Array();
                var response = req.responseText;
                if(response.indexOf('||' != -1)) {
                        update = response.split('||');
                        document.getElementById(update[0]).innerHTML = update[1];
                }
        }
}

PHP Quellcode

<form method="post" action="includes/function/functionuser/taetigkeit/inserttaetigkeit.php" name="Eingabeformular"><table border="0" cellpadding="0" cellspacing="0">
		<tr>
			<td>Kunde:</td>
			<td><select name="hersteller" id="Kunden" onChange="sendRequest('Projekte')" size="1">
<?php
$sql = 'SELECT * FROM kunde where kunde_status = "1"';
$ergebnis = mysql_query($sql);
while($data = mysql_fetch_array($ergebnis)){
?>
			<option value="<?php echo $data["kunde_id"]; ?>"
			<?php if ($data["kunde_id"] == $kunde) {?> selected <?php } ?>><?php echo $data["kunde_nr"]; ?>&nbsp;-&nbsp;<?php echo $data["kunde_name"]; ?></option>
<?php } ?>
        			</select></td>
		</tr>
		<tr>
			<td>Projekt:</td>
			<td><select name="projekt" id="Projekte" onChange="sendRequest('Bauteile')" size="1">
			</select></td>
		</tr>
		<tr>
			<td>Bauteil:</td>
			<td><select name="bauteil" id="Bauteile" size="1">
			</select></td>
		</tr>
		<tr>
			<td>Art der Tätigkeit:</td>
			<td><select name="art" size="1">

PHP Quellcode

<?php
//Kunden laden
include_once("../../../config/configdaten.php");
include_once("../../checkuser.php");
echo 'Bauteile||';
$result = mysql_query('SELECT * FROM bauteil WHERE bauteil_projektid = "'.$_GET['s'].'" AND bauteil_status = "1";');
while($row = mysql_fetch_object($result))
{
	echo '<option value="'.$row->bauteil_id.'">'.$row->bauteil_bezeichnung.'</option>';
}
?>

PHP Quellcode

<?php
//Kunden laden
include_once("../../../config/configdaten.php");
include_once("../../checkuser.php");
echo 'Projekte||';
$result = mysql_query('SELECT * FROM projekt WHERE projekt_kundenid = "'.$_GET['s'].'" AND projekt_aktiv = "1";');
while($row = mysql_fetch_object($result))
{
	echo '<option value="'.$row->projekt_id.'">'.$row->projekt_bezeichung.'</option>';
}
?>

JavaScript Code

function handleResponseProjekte() {
 
  if(req.readyState == 4){
    document.getElementById('Projekte').innerHTML = req.responseText;
  }
  else
  alert("loading" + ajax.readyState);
}
function handleResponseBauteile() {
 
  if(req.readyState == 4){
    document.getElementById('Bauteile').innerHTML = req.responseText;
  }
  else
  alert("loading" + ajax.readyState);
}