/* 
** Config .php 
*/ 

<?php 
/********************************* 
*  Script:   Woonplaats Database * 
*  Versie:   1.0                 * 
*  Author:   SkYcE               * 
*  Released: 08-12-2006          * 
*********************************/ 

/* Alle errors weergeven */ 
error_reporting(E_ALL); 

/* Database variabelen */ 
define('dbServer',   'localhost'); 
define('dbUser',     'naam'); 
define('dbPasswd',   'wachtwoord'); 
define('dbDatabase', 'databasenaam'); 

/* Verbinding naar database */ 
mysql_connect(dbServer, dbUser, dbPasswd) or die('Error in de connectie naar de database:<br>'.mysql_error()); 
mysql_select_db(dbDatabase) or die('Error in het selecteren van de database:<br>'.mysql_error()); 
?> 



/* 
** Index.php 
*/ 
<?php 
/********************************* 
*  Script:   Woonplaats Database * 
*  Versie:   1.0                 * 
*  Author:   SkYcE               * 
*  Released: 08-12-2006          * 
*********************************/ 

/* Include config file */ 
if (file_exists("config.php")) { 
    include_once("config.php"); 
} else { 
    die("Config file vergeten, deze is verplicht!"); 
} 
?> 

<script type="text/javascript"> 
var http = getXmlHttpRequestObject(); 
var url  = "ajax_woonplaats.php?letter="; 

function getXmlHttpRequestObject(){ 
    if(window.XMLHttpRequest){ 
        return new XMLHttpRequest(); 
    }else if(window.ActiveXObject){ 
        return new ActiveXObject("Microsoft.XMLHTTP"); 
    }else{ 
        alert("Explorer error"); 
    } 
} 

function handleHttpResponse() { 
    if(http.readyState == 4){ 
        if(http.responseText != ""){ 
            var results = http.responseText.split(","); 
            
            document.getElementById("woonplaats").options.length = 0; 
            
            for(i=0; i<results.length-1; i++) { 
                var result = results[i].split("|"); 
                document.getElementById("woonplaats").options[i] = new Option(result[1],result[0]); 
               } 
        } else { 
            alert("Voor deze letter zijn geen resultaten gevonden."); 
        } 
    } 
} 

function getCitys(letter) { 
    http.open("GET", url + letter, true); 
    http.onreadystatechange = handleHttpResponse; 
    http.send(null);    
} 
</script> 

<b>Woonplaats:</b><br /><br /> 
<?php 
$letters = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); 

foreach($letters as $key => $waarde) { 
    echo '<a href="javascript:getCitys(\''.$waarde.'\');">'.$waarde.'</a> '; 
} 
?><br /> 
<select name="woonplaats" id="woonplaats" style="margin-top:3px;"> 
    <?php 
    $get_data = mysql_query("SELECT id, 
                                    name 
                               FROM ws_citys 
                              WHERE name LIKE 'a%' 
                           ORDER BY name ASC;"); 
    
    while ($show_data = mysql_fetch_object($get_data)) { 
        echo '<option value="'.$show_data->id.'">'.$show_data->name.'</option>'; 
    } 
    ?> 
</select> 



/* 
** Ajax_woonplaats.php 
*/ 
<?php 
/********************************* 
*  Script:   Woonplaats Database * 
*  Versie:   1.0                 * 
*  Author:   SkYcE               * 
*  Released: 08-12-2006          * 
*********************************/ 

/* Include config file */ 
if (file_exists("config.php")) { 
    include_once("config.php"); 
} else { 
    die("Config file vergeten, deze is verplicht!"); 
} 

if(isset($_REQUEST['letter'])) { 
    $letter = $_REQUEST['letter']; 
    $letter = strip_tags($letter); 
    
    $get_data = mysql_query("SELECT id, 
                                    name 
                               FROM ws_citys 
                              WHERE name LIKE '".$letter."%' 
                           ORDER BY name ASC;"); 
    
    while ($show_data = mysql_fetch_object($get_data)) { 
        echo $show_data->id."|".$show_data->name.","; 
    } 
} else { 
    echo 'Er is geen letter opgegeven.'; 
} 
?>