1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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