Boa tarde pessoal. Essa semana tive um problema com o jquery autocomplete, que retornava NULL para as strings acentuadas. Fiz diversas buscas no google, por fim a solu\u00e7\u00e3o foi muito simples.<\/p>\n
Solu\u00e7\u00e3o:<\/strong><\/p>\n Exemplo da chamada do autocomplete:<\/p>\n No arquivo autocompletarNomePessoa.php devemos adicionar a seguinte linha, antes <\/strong>da consulta sql<\/p>\n O arquivo fica assim:<\/p>\n Espero ajudar muita gente com esse post, pois na internet tem muitas d\u00favidas sobre isso, e solu\u00e7\u00f5es meio “exageradas”.<\/p>\n","protected":false},"excerpt":{"rendered":" Boa tarde pessoal. Essa semana tive um problema com o jquery autocomplete, que retornava NULL para as strings acentuadas. Fiz diversas buscas no google, por fim a solu\u00e7\u00e3o foi muito simples. Solu\u00e7\u00e3o: Exemplo da chamada do autocomplete: $(“#txNomePessoa”).autocomplete({ source: “autocompletarNomePessoa.php”,…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[18,21,33,78,105,109,110,144,152,159,163,164,165,166,192,193],"class_list":["post-142","post","type-post","status-publish","format-standard","hentry","category-php-e-javascript","tag-acentos","tag-acentuacao","tag-autocomplete","tag-erro","tag-iso-8859-1","tag-jquery","tag-json","tag-null","tag-php","tag-problema","tag-retorna","tag-retorno","tag-return","tag-returns","tag-utf-8","tag-utf8"],"_links":{"self":[{"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=\/wp\/v2\/posts\/142"}],"collection":[{"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=142"}],"version-history":[{"count":1,"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=\/wp\/v2\/posts\/142\/revisions"}],"predecessor-version":[{"id":231,"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=\/wp\/v2\/posts\/142\/revisions\/231"}],"wp:attachment":[{"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.l9web.com.br\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}$(\"#txNomePessoa\").autocomplete({\n\t\t\t\tsource: \"autocompletarNomePessoa.php\",\n\t\t\t\tminLength: 1,\n\t\t\t\tselect: function( event, ui ) {\n \t\t\t$(\"#txtIdPessoa\").val(ui.item.codigo);\n \t\t\t}\n});\n\n<\/pre>\nmysql_query('SET CHARACTER SET utf8');\n<\/pre>\n< ?php\n$return_arr = array();\n$dbhost = 'enderecodoservidor';\n$dbuser = 'usuariodobanco';\n$dbpass = 'senhadobanco';\n$dbname = 'nomedobanco';\n\n$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');\nmysql_select_db($dbname);\n\/* If connection to database, run sql statement. *\/\nif ($conn)\n{\n\tmysql_query('SET CHARACTER SET utf8');\n\t$fetch = mysql_query(\"SELECT * FROM pessoas WHERE nomepessoa LIKE '%\" . $_GET['term'] . \"%'\"); \n\n\t\/* Retrieve and store in array the results of the query.*\/\n\n\twhile ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {\n\t\t$row_array['label'] = $row['nomepessoa'];\n\t\t$row_array['value'] = $row['nomepessoa'];\n\t\t$row_array['codigo'] = $row['idpessoa'];\n\n array_push($return_arr,$row_array);\n }\n\n}\n\/* Free connection resources. *\/\nmysql_close($conn);\n\n\/* Toss back results as json encoded array. *\/\necho json_encode($return_arr);\n?>\n\n<\/pre>\n