Espero que tenham tido um bom final de ano.
Estou com o seguinte problema: Peguei uma função chamada "Dynamic Client Lookup" que preenche um formulário com os dados, a partir do ID digitado. Essa função pode ser conhecida aqui http://www.dhtmlgood....html?page=ajax e http://www.dhtmlgood...ent-lookup.html .
Fiz as minhas alterações conforme necessário e ela funciona muito bem até certo ponto. Quando o registro (linha) no banco de dados contém algum campo com palavras acentuadas como "ã", "á", "é", é mostrado como caracteres "estranhos".
Como por exemplo, a palavra "São Paulo" é mostrada "S�Paulo".
O curioso é que quando uma palavra que contenha o "Ó" (ex. Freguesia do Ó) o script todo não funciona!!
Antes de postar o código vou deixar claro que todo o site utiliza o padrão de caracteres ISO-8859-1 (charset=iso-8859-1). As tabelas do banco de dados estão como "Latim1_general_ci" e todos os arquivos salvos em codificação ANSI.
Segue o código:
O Javascript no <HEAD>:
<script type="text/javascript" src="AJAX/ajax.js"></script> <script type="text/javascript"> /************************************************************************************************************ Ajax client lookup Copyright (C) 2006 DTHMLGoodies.com, Alf Magne Kalleland This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version. This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details. You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA Dhtmlgoodies.com., hereby disclaims all copyright interest in this script written by Alf Magne Kalleland. Alf Magne Kalleland, 2006 Owner of DHTMLgoodies.com ************************************************************************************************************/ var ajax = new sack(); var currentClientID=false; function getClientData() { var clientId = document.getElementById('idsolicitante').value.replace(/[^0-9]/g,''); if(clientId.length>0 && clientId!=currentClientID){ currentClientID = clientId ajax.requestFile = 'getClient.php?getClientId='+clientId; // Specifying which file to get ajax.onCompletion = showClientData; // Specify function that will be executed after file has been found ajax.runAJAX(); // Execute AJAX function } } function showClientData() { var formObj = document.forms['pedido']; eval(ajax.response); } function initFormEvents() { document.getElementById('idsolicitante').onblur = getClientData; document.getElementById('idsolicitante').focus(); } window.onload = initFormEvents; </script>
O arquivo PHP que roda a query no banco e retorna os valores:
<?php /* Replace the data in these two lines with data for your db connection */ require "../../sistema/functions.php"; db_connect(); $res2 = mysql_query("SELECT * FROM tb_distri_ender WHERE id_distribuidor = ".$_GET['getClientId']) or die(mysql_error()); $inf2 = mysql_fetch_array($res2); if(isset($_GET['getClientId'])){ $res = mysql_query("SELECT * FROM tb_distribuidor WHERE id_distribuidor = ".$_GET['getClientId']) or die(mysql_error()); if($inf = mysql_fetch_array($res)){ echo "formObj.nome.value = '".$inf["nm_nome"]."';\n"; echo "formObj.endereco.value = '".$inf2["nm_endereco"]."';\n"; echo "formObj.complemento.value = '".$inf2["nm_complemento"]."';\n"; echo "formObj.bairro.value = '".$inf2["nm_bairro"]."';\n"; echo "formObj.cidade.value = '".$inf2["nm_cidade"]."';\n"; echo "formObj.estado.value = '".$inf2["nm_estado"]."';\n"; echo "formObj.cep.value = '".$inf2["nm_cep"]."';\n"; }else{ echo "formObj.nome.value = 'ID não Encontrado!';\n"; echo "formObj.endereco.value = '';\n"; echo "formObj.complemento.value = '';\n"; echo "formObj.bairro.value = '';\n"; echo "formObj.cidade.value = '';\n"; echo "formObj.estado.value = '';\n"; echo "formObj.cep.value = '';\n"; } } ?>
O arquivo ajax.js:
/* Simple AJAX Code-Kit (SACK) v1.6.1 */ /* ©2005 Gregory Wild-Smith */ /* www.twilightuniverse.com */ /* Software licenced under a modified X11 licence, see documentation or authors website for more details */ function sack(file) { this.xmlhttp = null; this.resetData = function() { this.method = "POST"; this.queryStringSeparator = "?"; this.argumentSeparator = "&"; this.URLString = ""; this.encodeURIString = true; this.execute = false; this.element = null; this.elementObj = null; this.requestFile = file; this.vars = new Object(); this.responseStatus = new Array(2); }; this.resetFunctions = function() { this.onLoading = function() { }; this.onLoaded = function() { }; this.onInteractive = function() { }; this.onCompletion = function() { }; this.onError = function() { }; this.onFail = function() { }; }; this.reset = function() { this.resetFunctions(); this.resetData(); }; this.createAJAX = function() { try { this.xmlhttp = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e1) { try { this.xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e2) { this.xmlhttp = null; } } if (! this.xmlhttp) { if (typeof XMLHttpRequest != "undefined") { this.xmlhttp = new XMLHttpRequest(); } else { this.failed = true; } } }; this.setVar = function(name, value){ this.vars[name] = Array(value, false); }; this.encVar = function(name, value, returnvars) { if (true == returnvars) { return Array(encodeURIComponent(name), encodeURIComponent(value)); } else { this.vars[encodeURIComponent(name)] = Array(encodeURIComponent(value), true); } } this.processURLString = function(string, encode) { encoded = encodeURIComponent(this.argumentSeparator); regexp = new RegExp(this.argumentSeparator + "|" + encoded); varArray = string.split(regexp); for (i = 0; i < varArray.length; i++){ urlVars = varArray[i].split("="); if (true == encode){ this.encVar(urlVars[0], urlVars[1]); } else { this.setVar(urlVars[0], urlVars[1]); } } } this.createURLString = function(urlstring) { if (this.encodeURIString && this.URLString.length) { this.processURLString(this.URLString, true); } if (urlstring) { if (this.URLString.length) { this.URLString += this.argumentSeparator + urlstring; } else { this.URLString = urlstring; } } // prevents caching of URLString this.setVar("rndval", new Date().getTime()); urlstringtemp = new Array(); for (key in this.vars) { if (false == this.vars[key][1] && true == this.encodeURIString) { encoded = this.encVar(key, this.vars[key][0], true); delete this.vars[key]; this.vars[encoded[0]] = Array(encoded[1], true); key = encoded[0]; } urlstringtemp[urlstringtemp.length] = key + "=" + this.vars[key][0]; } if (urlstring){ this.URLString += this.argumentSeparator + urlstringtemp.join(this.argumentSeparator); } else { this.URLString += urlstringtemp.join(this.argumentSeparator); } } this.runResponse = function() { eval(this.response); } this.runAJAX = function(urlstring) { if (this.failed) { this.onFail(); } else { this.createURLString(urlstring); if (this.element) { this.elementObj = document.getElementById(this.element); } if (this.xmlhttp) { var self = this; if (this.method == "GET") { totalurlstring = this.requestFile + this.queryStringSeparator + this.URLString; this.xmlhttp.open(this.method, totalurlstring, true); } else { this.xmlhttp.open(this.method, this.requestFile, true); try { this.xmlhttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded") } catch <img src='http://forum.wmonline.com.br/public/style_emoticons/<#EMO_DIR#>/envelope.gif' class='bbc_emoticon' alt='(e)' /> { } } this.xmlhttp.onreadystatechange = function() { switch (self.xmlhttp.readyState) { case 1: self.onLoading(); break; case 2: self.onLoaded(); break; case 3: self.onInteractive(); break; case 4: self.response = self.xmlhttp.responseText; self.responseXML = self.xmlhttp.responseXML; self.responseStatus[0] = self.xmlhttp.status; self.responseStatus[1] = self.xmlhttp.statusText; if (self.execute) { self.runResponse(); } if (self.elementObj) { elemNodeName = self.elementObj.nodeName; elemNodeName.toLowerCase(); if (elemNodeName == "input" || elemNodeName == "select" || elemNodeName == "option" || elemNodeName == "textarea") { self.elementObj.value = self.response; } else { self.elementObj.innerHTML = self.response; } } if (self.responseStatus[0] == "200") { self.onCompletion(); } else { self.onError(); } self.URLString = ""; break; } }; this.xmlhttp.send(this.URLString); } } }; this.reset(); this.createAJAX(); }
Acredito que não tenha faltado nada.
E reforço que esse scritp funciona bem quando não tenho acentos nas palavras.