* @package dmsAutoComplete * @version 1.0 */ $dbh = new PDO('mysql:host=localhost;dbname=dmsac', 'user', 'passwd'); if (class_exists('DOMDocument')){ //Adapta o script para PHP4 //Criar documento XML atraves de DOM //Create XML Doc through DOM $xmlDoc = new DOMDocument('1.0', 'utf-8'); $xmlDoc->formatOutput = true; //Criar elementos Raíz do XML //Create root XML element $root = $xmlDoc->createElement('root'); $root = $xmlDoc->appendChild($root); }else{ $xmlDoc = ''; $xmlDoc .= ''; } /** * :pt-br: * Definir Lista (itens) a ser mostrada. * * Neste passo podemos realizar buscas em banco de dados, filtrar arrays * Ou qualquer outra tarefa que retorne um resultado baseado no string * recebido * * :en: * Define list to be returned * * In this step we could do a database search, filter arryas or perform * other actions which would return a resultig list based on an input * string */ if ($_POST['string'] != ''){ $results = $dbh->query("SELECT id,word FROM fromdb WHERE word LIKE '".$_POST['string']."%'"); //Construir elementos ITEM //built ITEM elements while ($row = $results->fetch(PDO::FETCH_ASSOC)){ if (class_exists('DOMDocument')){ //Cadastrar na lista //Add to list $item = $xmlDoc->createElement('item'); $item = $root->appendChild($item); $item->setAttribute('id', $row['id'] ); $item->setAttribute('label',rawurlencode( $row['word'] )); //rawurlencode evita problemas de charset //rawurlencode avoids charset problems }else{ $xmlDoc .= ''; } } } //Retornar XML de resultado para AJAX //Return XML code for AJAX Request header("Content-type:application/xml; charset=utf-8"); if (class_exists('DOMDocument')){ echo $xmlDoc->saveXML(); }else{ $xmlDoc .= ''; echo $xmlDoc; } ?>