[RESOLVED] Auto suggest >>> HELP !

vidz

This is my auto suggest script. But its not working. There is no error msg shown. plss help me to make my code work

autosuggest.php

<?php
	<?php
	//Start session
	session_start();


define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASSWORD', 'admin');
define('DB_DATABASE', 'temp');


//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
	die("Unable to select database");
}


if(isset($_POST['queryString'])) 
{
$queryString = real_escape_string($_POST['queryString']);
	if(strlen($queryString) >0) 
	 {
		$q="SELECT country FROM countries WHERE country LIKE '$queryString%' LIMIT 10"; 

		 if($query=mysql_query($q))
		 {
		  echo '<ul>';
			while($result  = mysql_fetch_array( $query)) 
			 {
				 echo '<li onClick="fill(\''.addslashes($result['country']).'\');">'.$result['country'].'</li>';

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

index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title></title>


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

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

</script>

<style>
#result {
	height:20px;
	font-size:16px;
	font-family:Arial, Helvetica, sans-serif;
	color:#333;
	padding:5px;
	margin-bottom:10px;
	background-color:#FFFF99;
}
#country{
	padding:3px;
	border:1px #CCC solid;
	font-size:17px;
}
.suggestionsBox {
	position: absolute;
	left: 0px;
	top:40px;
	margin: 26px 0px 0px 0px;
	width: 200px;
	padding:0px;
	background-color: #000;
	border-top: 3px solid #000;
	color: #fff;
}
.suggestionList {
	margin: 0px;
	padding: 0px;
}
.suggestionList ul li {
	list-style:none;
	margin: 0px;
	padding: 6px;
	border-bottom:1px dotted #666;
	cursor: pointer;
}
.suggestionList ul li:hover {
	background-color: #FC3;
	color:#000;
}
ul {
	font-family:Arial, Helvetica, sans-serif;
	font-size:11px;
	color:#FFF;
	padding:0;
	margin:0;
}

.load{
background-image:url(loader.gif);
background-position:right;
background-repeat:no-repeat;
}

#suggest {
	position:relative;
}

</style>
</head>

<body>




 <form id="form" action="#">
    <div id="suggest">Start to type a country: <br />
      <input type="text" size="25" value="" id="country" onkeyup="suggest(this.value);" onblur="fill();" class="" />

  <div class="suggestionsBox" id="suggestions" style="display: none;"> <img src="arrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" />
    <div class="suggestionList" id="suggestionsList"> &nbsp; </div>
  </div>
   </div>
</form>



</body>
</html>

table structure

SET NAMES latin1;
SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE `countries` 

(
  `id` int(6) NOT NULL auto_increment,
  `country` varchar(250) NOT NULL 

default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=243 

DEFAULT CHARSET=latin1;

insert into `countries` values('1','Afghanistan'),


('2','Aringland Islands'),
 ('3','Albania'),
 ('4','Algeria'),
 ('5','American Samoa'),


('6','Andorra'),
 ('7','Angola'),
 ('8','Anguilla'),
 ('9','Antarctica'),
 ('10','Antigua and 

Barbuda'),
 ('11','Argentina'),
 ('12','Armenia'),
 ('13','Aruba'),
 ('14','Australia'),


('15','Austria'),
 ('16','Azerbaijan'),
 ('17','Bahamas'),
 ('18','Bahrain'),


('19','Bangladesh'),
 ('20','Barbados'),
 ('21','Belarus'),
 ('22','Belgium'),
 ('23','Belize'),


('24','Benin'),
 ('25','Bermuda'),
 ('26','Bhutan'),
 ('27','Bolivia'),
 ('28','Bosnia and 

Herzegovina'),
 ('29','Botswana'),
 ('30','Bouvet Island'),
 ('31','Brazil'),
 ('32','British 

Indian Ocean territory'),
 ('33','Brunei Darussalam'),
 ('34','Bulgaria'),
 ('35','Burkina 

Faso'),
 ('36','Burundi'),
 ('37','Cambodia'),
 ('38','Cameroon'),
 ('39','Canada'),


('40','Cape Verde'),
 ('41','Cayman Islands'),
 ('42','Central African Republic'),


('43','Chad'),
 ('44','Chile'),
 ('45','China'),
 ('46','Christmas Island'),
 ('47','Cocos 

(Keeling) Islands'),
 ('48','Colombia'),
 ('49','Comoros'),
 ('50','Congo'),


('51','Congo'),
 ('52',' Democratic Republic'),
 ('53','Cook Islands'),
 ('54','Costa 

Rica'),
 ('55','Ivory Coast (Ivory Coast)'),
 ('56','Croatia (Hrvatska)'),
 ('57','Cuba'),


('58','Cyprus'),
 ('59','Czech Republic'),
 ('60','Denmark'),
 ('61','Djibouti'),


('62','Dominica'),
 ('63','Dominican Republic'),
 ('64','East Timor'),
 ('65','Ecuador'),


('66','Egypt'),
 ('67','El Salvador'),
 ('68','Equatorial Guinea'),
 ('69','Eritrea'),


('70','Estonia'),
 ('71','Ethiopia'),
 ('72','Falkland Islands'),
 ('73','Faroe Islands'),


('74','Fiji'),
 ('75','Finland'),
 ('76','France'),
 ('77','French Guiana'),
 ('78','French 

Polynesia'),
 ('79','French Southern Territories'),
 ('80','Gabon'),
 ('81','Gambia'),


('82','Georgia'),
 ('83','Germany'),
 ('84','Ghana'),
 ('85','Gibraltar'),
 ('86','Greece'),


('87','Greenland'),
 ('88','Grenada'),
 ('89','Guadeloupe'),
 ('90','Guam'),


('91','Guatemala'),
 ('92','Guinea'),
 ('93','Guinea-Bissau'),
 ('94','Guyana'),


('95','Haiti'),
 ('96','Heard and McDonald Islands'),
 ('97','Honduras'),
 ('98','Hong 

Kong'),
 ('99','Hungary'),
 ('100','Iceland'),
 ('101','India'),
 ('102','Indonesia'),


('103','Iran'),
 ('104','Iraq'),
 ('105','Ireland'),
 ('106','Israel'),
 ('107','Italy'),


('108','Jamaica'),
 ('109','Japan'),
 ('110','Jordan'),
 ('111','Kazakhstan'),
 ('112','Kenya'),


('113','Kiribati'),
 ('114','Korea (north)'),
 ('115','Korea (south)'),
 ('116','Kuwait'),


('117','Kyrgyzstan'),
 ('118','Lao People\'s Democratic Republic'),
 ('119','Latvia'),


('120','Lebanon'),
 ('121','Lesotho'),
 ('122','Liberia'),
 ('123','Libyan Arab 

Jamahiriya'),
 ('124','Liechtenstein'),
 ('125','Lithuania'),
 ('126','Luxembourg'),


('127','Macao'),
 ('128','Macedonia'),
 ('129','Madagascar'),
 ('130','Malawi'),


('131','Malaysia'),
 ('132','Maldives'),
 ('133','Mali'),
 ('134','Malta'),
 ('135','Marshall 

Islands'),
 ('136','Martinique'),
 ('137','Mauritania'),
 ('138','Mauritius'),


('139','Mayotte'),
 ('140','Mexico'),
 ('141','Micronesia'),
 ('142','Moldova'),


('143','Monaco'),
 ('144','Mongolia'),
 ('145','Montserrat'),
 ('146','Morocco'),


('147','Mozambique'),
 ('148','Myanmar'),
 ('149','Namibia'),
 ('150','Nauru'),


('151','Nepal'),
 ('152','Netherlands'),
 ('153','Netherlands Antilles'),
 ('154','New 

Caledonia'),
 ('155','New Zealand'),
 ('156','Nicaragua'),
 ('157','Niger'),


('158','Nigeria'),
 ('159','Niue'),
 ('160','Norfolk Island'),
 ('161','Northern Mariana 

Islands'),
 ('162','Norway'),
 ('163','Oman'),
 ('164','Pakistan'),
 ('165','Palau'),


('166','Palestinian Territories'),
 ('167','Panama'),
 ('168','Papua New Guinea'),


('169','Paraguay'),
 ('170','Peru'),
 ('171','Philippines'),
 ('172','Pitcairn'),


('173','Poland'),
 ('174','Portugal'),
 ('175','Puerto Rico'),
 ('176','Qatar'),


('177','Runion'),
 ('178','Romania'),
 ('179','Russian Federation'),
 ('180','Rwanda'),


('181','Saint Helena'),
 ('182','Saint Kitts and Nevis'),
 ('183','Saint Lucia'),


('184','Saint Pierre and Miquelon'),
 ('185','Saint Vincent and the Grenadines'),


('186','Samoa'),
 ('187','San Marino'),
 ('188','Sao Tome and Principe'),
 ('189','Saudi 

Arabia'),
 ('190','Senegal'),
 ('191','Serbia and Montenegro'),
 ('192','Seychelles'),


('193','Sierra Leone'),
 ('194','Singapore'),
 ('195','Slovakia'),
 ('196','Slovenia'),


('197','Solomon Islands'),
 ('198','Somalia'),
 ('199','South Africa'),
 ('200','South 

Georgia and the South Sandwich Islands'),
 ('201','Spain'),
 ('202','Sri Lanka'),


('203','Sudan'),
 ('204','Suriname'),
 ('205','Svalbard and Jan Mayen Islands'),


('206','Swaziland'),
 ('207','Sweden'),
 ('208','Switzerland'),
 ('209','Syria'),


('210','Taiwan'),
 ('211','Tajikistan'),
 ('212','Tanzania'),
 ('213','Thailand'),


('214','Togo'),
 ('215','Tokelau'),
 ('216','Tonga'),
 ('217','Trinidad and Tobago'),


('218','Tunisia'),
 ('219','Turkey'),
 ('220','Turkmenistan'),
 ('221','Turks and Caicos 

Islands'),
 ('222','Tuvalu'),
 ('223','Uganda'),
 ('224','Ukraine'),
 ('225','United Arab 

Emirates'),
 ('226','United Kingdom'),
 ('227','United States of America'),


('228','Uruguay'),
 ('229','Uzbekistan'),
 ('230','Vanuatu'),
 ('231','Vatican City'),


('232','Venezuela'),
 ('233','Vietnam'),
 ('234','Virgin Islands (British)'),
 ('235','Virgin 

Islands (US)'),
 ('236','Wallis and Futuna Islands'),
 ('237','Western Sahara'),


('238','Yemen'),
 ('239','Zaire'),
 ('240','Zambia'),
 ('241','Zimbabwe');

SET 

FOREIGN_KEY_CHECKS = 1;

Bonesnap

$queryString = real_escape_string($_POST['queryString']);

Should be:

$queryString = mysql_real_escape_string($_POST['queryString']);

vidz

sry for the late reply and thanku for ur help Bonesnap.
I have corrected it as u said. But still its not working 🙁

jeepin81

In addition to Bonesnap's suggestion you have a couple other issues:

1.) you're declaring <?php twice.

2.) Your if statement checking the query isn't really checking anything. I would check that like the this:

$q="SELECT country FROM countries WHERE country LIKE '$queryString%' LIMIT 10"; 
			$query=mysql_query($q)
             			or die("ERROR:&nbsp;" . mysql_error());

		 if(!$query){ 
         	echo 'OOPS we had a problem :('; 
         }
		 else{
		 	echo '<ul>'; 

            while($result  = mysql_fetch_array( $query)){ 
            	echo '<li onClick="fill(\''.addslashes($result['country']).'\');">'.$result['country'].'</li>'; 
            } 

			echo '</ul>';  	
		 }

Also, I would switch to MySQLi. See member Derokorian's signature, there is a link to a good tutorial he wrote.

Derokorian

jeepin81;11006049 wrote:
Also, I would switch to MySQLi. See member Derokorian's signature, there is a link to a good tutorial he wrote.

Thanks for the compliment jeepin! And to make it easier to find my signature - well its just below this text =D

vidz

@ & Derokorian thank u !
I have made changes as jeepin81 said but still it isnt working 🙁
Second thing is my other php pages use MySql if i switch to mysqli will it be a problem.?

@ ur blog is realy amazing 😃

jeepin81

What's happening or not happening? Are you getting any errors? Do you have error reporting turned on?

vidz

@jeepin
Iam 100% sure its not php error now. Becos i have remove JS action and see what we have input in index page wil create correct out put.
eg if i give d as input i can have
Denmark
Djibouti
Dominica
Dominican Republic

as results. so it couldnt be a php error. IT must be a JS error.

vidz

YEAH finaly i got the error 😃 it was a little syntax error. U guys help me lot luv uuuuuuuu :HUGS:🙂 🙂 😃

Derokorian

vidz;11006069 wrote:
@ ur blog is realy amazing 😃

Thanks! I'm not sure I agree, but I do appreciate it! And glad to hear you got this solved, sorry I wasn't able to actually provide help at this time.'

As far as mixing mysql/mysqli goes you can use them both as you work on switching over, just realize they each need their own connection and there are some differences between the two api's. Differences include:

mysqli_* has the connection as the first parameter and is required for all procedural calls.
Object-oriented interface
Support for Prepared Statements
Support for Multiple Statements
Support for Transactions
Enhanced debugging capabilities
Embedded server support

You could use both in the same script even. IE this would work, but there's no reason to ever use both (or the old library for that matter):

$mysql = mysql_connect($dbhost,$dbuser,$dbpass,$dbname);
$mysqli = mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);

mysql_query("SELECT 1",$mysql);
mysqli_query($mysqli,"SELECT 1");

Note you can't connect with mysql and query with mysqli and vice versa. You can't mix the functions in anyway they are completely separate libraries. If you have any problems stepping up to mysqli_* please, I implore you to post your struggles so that we may help you along.

vidz

Thanku again.

Your blog is really wonderful. It is well focused on the point. So it is really important to people who don't like to read big paras and also people who are not native English speakers like me.

sorry I wasn't able to actually provide help at this time.

never mind.Iam really lucky to get in to this forum and get experts help like u 😃