Coder Forum

PHP Quellcode

<?php
echo '<select name="bundesland">';
$result = mysql_query("SELECT title,text FROM `inhalte` WHERE `gruppe` = '$_GET[s]'; ");
while($row = mysql_fetch_object($result)) {
    echo '<option value="'.$row->title.'">'.$row->title.'</option>';
}
echo '</select>';
?>

JavaScript Code

<script type="text/Javascript">
 
<!--
function sendRequest() {
 
        try 
		{
                req = window.XMLHttpRequest?new XMLHttpRequest():
                new ActiveXObject("Microsoft.XMLHTTP");
        } 
 
		catch (e) 
		{
                //Kein AJAX Support
        }
 
		req.onreadystatechange = handleResponse;
        id = document.getElementById('berufsgruppe').value;
        req.open('get', 'func.php?s='+ id);
        req.send(null);
}
 
function handleResponse() {
        if ((req.readyState == 4) && (req.status == 200)) 
		{
                document.getElementById('inhalt').innerHTML = req.responseText;
        }
}
 
//-->
 
</script>

PHP Quellcode

<?php
      include "action/verb.php";
      //Inhalte laden
      $result = mysql_query("SELECT * FROM berufe WHERE gruppe = '$_GET[s]'") or die(mysql_error());
      while($row = mysql_fetch_object($result))
      {
              $beruf = $row->bezeichnung;
	      echo "<option value=\"".$beruf."\">".$beruf."</option>";
 
      }
?>

HTML Code

<select id="inhalt" class="form" name="beruf">
 
</select>

JavaScript Code

req.open('get', 'func.php?s='+ id + '&anti_cache=' + Math.random());

Source code

$allObjectArts = explode (',',$_POST['objectType']);
$result = mysql_query("SELECT * FROM isz1_1_object_arts");
while($row = mysql_fetch_object($result)) 
{
	if(in_array($row['itemID'], $allObjectArts)) {
		echo '<option value="0">test</option>';
	}
}

SQL Code

SELECT * FROM TABLE WHERE COLUMN IN (1,2,3)

Source code

echo '<option value="'.$row->itemID.'">'.$row->itemName.'</option>';

Source code

echo '<option value="'.$row->itemID.'">{lang}'.$row->itemName.'{/lang}</option>';