php live search

[matthew9090]

im am creating a live search using the w3schools tutorial. apart from im using mysql.

 

here is my current code(which works fine):

 

<?php
mysql_connect("localhost", "root", "");
mysql_select_db("dictionary");
$words = mysql_query("SELECT * FROM words");
$a = array();
while ($row = mysql_fetch_assoc($words))
{
   $a[] = $row['word'];  
}
$q = $_GET['q'];
if (strlen($q) > 0)
  {
  $hint="";
  for($i=0; $i<count($a); $i++)
    {
    if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q))))
      {
      if ($hint=="")
        {
        $hint=$a[$i];
        }
      else
      {     
        $hint = $hint . "</b><br /><br /> ".$a[$i];
        }
      }
    }
  }

// Set output to "no suggestion" if no hint were found
// or to the correct values
if ($hint == "")
  {
  $response="no suggestion";
  }
else
  {
  $response=$hint;
  }

//output the response
echo $response;
?>

 

as you can see it is edited alot. But my problem is that i need to display underneath the word, the definition aswell. I've been trying to figure this out but i can't seem to do it. I have been trying to use multidimensional arrays.

[Fadion]

I'm sure you will get along better with something like jQueryUI Auto Suggest or any jQuery plugin for that matter. The jQueryUI one is pretty simple to set up and works with a remote dataset that can be a PHP script outputting database words in JSON format. It handles the rest by itself.

[matthew9090]

i prefere to do it my self and i have got this so far:

 

<?php
error_reporting(E_ALL);
mysql_connect("localhost", "root", "");
mysql_select_db("dictionary");
$words = mysql_query("SELECT * FROM words");
$a = array();
$count = 0;
while ($row = mysql_fetch_assoc($words))
{
   $a[$count][] = $row['word'];  
   $a[$count][] = $row['definition']; 
   $count++;
}
$q = $_GET['q'];
if (strlen($q) > 0)
  {
  $hint="";
   foreach ($a as $entry){
   if (substr($a[$count][0],0,strlen($q))) //line 19<<<<<<<<<
      {
      if ($hint=="")
        {
          $hint= "<strong>" . $a[$count][0] . "</strong><br /><em>" . $a[$count][1] . "</em>"; 
        }
      else
      {     
        $hint = $hint . "</b><br /><br /> <strong>" . $a[$count][0] . "</strong><br /><em>" . $a[$count][1] . "</em>"; 
        }
      }
    }
}

// Set output to "no suggestion" if no hint were found
// or to the correct values
if ($hint == "")
  {
  $response="no suggestion";
  }
else
  {
  $response=$hint;
  }

//output the response
echo $response;
?>

 

and i get the errors:

Notice: Undefined offset: 5 in E:\wamp\www\dictionary\gethint.php on line 19

 

Notice: Undefined offset: 5 in E:\wamp\www\dictionary\gethint.php on line 19

 

Notice: Undefined offset: 5 in E:\wamp\www\dictionary\gethint.php on line 19

 

Notice: Undefined offset: 5 in E:\wamp\www\dictionary\gethint.php on line 19

 

Notice: Undefined offset: 5 in E:\wamp\www\dictionary\gethint.php on line 19