autosuggest + mysql

Discussion in 'PHP' started by guif, Sep 17, 2008.

  1. guif

    guif New Member

    Joined:
    Jul 25, 2008
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    0
    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:
    <?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 ) -) );

    if ( 
    strlen $new_string ) > ):

    $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>';
    }
    ?>
     
    Last edited by a moderator: Sep 17, 2008
  2. codestorm

    codestorm New Member

    Joined:
    May 20, 2008
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    India
    Are you getting any specific errors??
     
  3. guif

    guif New Member

    Joined:
    Jul 25, 2008
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    0
    I give this code in the web, and i change some code. But, i think that's some parts are not correct.
    For example, in the Select, at the final:, what it's $val???
    and the <li> is correct???

    i don't see and specific error because I don't see nothing
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice