-
autosuggest + mysql
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>';
}
?>
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks