PDA

View Full Version : autosuggest + mysql



guif
09-17-2008, 09:45 AM
I would like to make a simple autosuggest but i don't understand why my code is not running.
Help me please!

here is the code:

<?php
require_once('db.php');
include('classes/stem.php');
include('classes/cleaner.php');

if( !empty ( $_POST['search'] ) ):

$string = $_POST['search'];

$stemmer = new Stemmer;
$stemmed_string = $stemmer->stem ( $string );

$clean_string = new jSearchString();
$stemmed_string = $clean_string->parseString ( $stemmed_string );

$new_string = '';
foreach ( array_unique ( split ( " ",$stemmed_string ) ) as $array => $value )
{
if(strlen($value) >= 3)
{
$new_string .= ''.$value.' ';
}
}

$new_string = substr ( $new_string,0, ( strLen ( $new_string ) -1 ) );

if ( strlen ( $new_string ) > 3 ):

$split_stemmed = split ( " ",$new_string );

mysql_select_db($database);

$sql = "select pkey from jiraissue where project = '10040' and pkey like '%".$val."%'";

if($total>0){
echo '<ul>';
while ( $row = mysql_fetch_assoc ( $query ) ){
echo '<li>'."\n";
echo $row['pkey'];
echo '</li>';
}
echo '</ul>';
}
?>