Problems with PHP and Jquery

[Decibel]

Hi Folks,

Im new here. I copied from a tutorial a way to create an autosuggest in a text input. It was right. I had my files with the server connection information on the server and my local files with my local conection information in my machine. I screwed it up and uploaded the local files with the local connection information to the server.

To understand better : www.guiaojk.com

here we have two fields. one of try to suggest the itens in the left menu. If you type "aca" it should have work.

in the second field if you type "ta" the suggest will appear.

the error that happens in the local test server (Xampp) is

notice undefined property: stdclass

I know theres another topic here with the same problem but the guy has discovered where was the problem ...

any help?

[samuelcook]

trying to better understand the problem, where are the "solutions" coming from. Are you pulling words from an XML file, or database, or something else?

[Decibel]

Man I just forgot to post it.

I'm trying to SELECT the data from an MySQL db.

[samuelcook]

When using Ajax\php i always find it important to make sure I'm not forgetting a couple of things.

1. Remembering to set the type in Ajax call. Either get or post and ensuring that I am collecting those values on the phP page using the appropriate request method.

2. That I am escaping the values being sent via JavaScript. Then using rawurldecode on the php page.

3. That I am including the appropriate includes to connect to the db. I typically forget this the most.

4. That I am echoing the values in the appropriate manner that I am wanting to display them.

5. Instanciating the new id or class if I am passing them through the php page.

Is it possible to see the Ajax method and php page that is receiving/parsing this?

[Decibel]

<?php
$db = new mysqli('localhost', 'USER' ,'PASSWORD', 'DATABANK');

if(!$db)
{
echo 'Could not connect to the database.';
}
else
{

if(isset($_POST['queryString'])) 
{
	$queryString = $db->real_escape_string($_POST['queryString']);
	$nome_indexacao= $queryString;
	$nome_indexacao = str_replace("Á","A",$nome_indexacao);
	$nome_indexacao = str_replace("À","A",$nome_indexacao);
	$nome_indexacao = str_replace("Â","A",$nome_indexacao);
	$nome_indexacao = str_replace("Ã","A",$nome_indexacao);
	$nome_indexacao = str_replace("á","a",$nome_indexacao);
	$nome_indexacao = str_replace("à","a",$nome_indexacao);
	$nome_indexacao = str_replace("â","a",$nome_indexacao);
	$nome_indexacao = str_replace("ã","a",$nome_indexacao);
	$nome_indexacao = str_replace("ª","a",$nome_indexacao);
	$nome_indexacao = str_replace("É","E",$nome_indexacao);
	$nome_indexacao = str_replace("È","E",$nome_indexacao);
	$nome_indexacao = str_replace("Ê","E",$nome_indexacao);
	$nome_indexacao = str_replace("Í","I",$nome_indexacao);
	$nome_indexacao = str_replace("í","i",$nome_indexacao);
	$nome_indexacao = str_replace("é","e",$nome_indexacao);
	$nome_indexacao = str_replace("è","e",$nome_indexacao);
	$nome_indexacao = str_replace("ê","e",$nome_indexacao);
	$nome_indexacao = str_replace("Ó","O",$nome_indexacao);
	$nome_indexacao = str_replace("Ò","O",$nome_indexacao);
	$nome_indexacao = str_replace("Ô","O",$nome_indexacao);
	$nome_indexacao = str_replace("Õ","O",$nome_indexacao);
	$nome_indexacao = str_replace("ó","o",$nome_indexacao);
	$nome_indexacao = str_replace("ò","o",$nome_indexacao);
	$nome_indexacao = str_replace("ô","o",$nome_indexacao);
	$nome_indexacao = str_replace("õ","o",$nome_indexacao);
	$nome_indexacao = str_replace("º","o",$nome_indexacao);
	$nome_indexacao = str_replace("Ú","U",$nome_indexacao);
	$nome_indexacao = str_replace("Ù","U",$nome_indexacao);
	$nome_indexacao = str_replace("Û","U",$nome_indexacao);
	$nome_indexacao = str_replace("ú","u",$nome_indexacao);
	$nome_indexacao = str_replace("û","u",$nome_indexacao);
	$nome_indexacao = str_replace("ù","u",$nome_indexacao);
	$nome_indexacao = str_replace("Ç","C",$nome_indexacao);
	$nome_indexacao = str_replace("ç","c",$nome_indexacao);
	if(strlen($queryString) >0) 
	{
		$query = $db->query("SELECT * FROM subcategoria WHERE subcategoria LIKE '$nome_indexacao%' order by subcategoria_indexacao ASC LIMIT 7");
		if($query)
		{
		echo '<ul>';
			while ($result = $query ->fetch_object())
			{
    	 		echo '<li onClick="fill2(\''.addslashes($result->busca).'\');">'.$result->busca.'</li>';
    		}

		echo '</ul>';
		} 
		else 
		{
			echo 'OOPS we had a problem :(';
		}
	} 
	else 
	{
			// do nothing
	}
} 

else
{
echo 'There should be no direct access to this script!';
}
}
?>

[Decibel]

<!--autosugest-->
<script type="text/javascript" src="js/jquery.js"></script>
<script>
function suggest(inputString){
if(inputString.length == 0) {
$('#suggestions').fadeOut();
} else {
$('#busca').addClass('load');
$.post("autosuggest.php", {queryString: ""+inputString+""}, function(data){
if(data.length >0) {
$('#suggestions').fadeIn();
$('#suggestionsList').html(data);
$('#busca').removeClass('load');
}
});
}
}

function fill(thisValue) {
	$('#busca').val(thisValue);
	setTimeout("$('#suggestions').fadeOut();", 600);
}

</script>
<!-- autosugest-->