Question

I ve got a bit of Pget and J Query which establishs the Autocomplete form:

<?
mysql_select_db($database_database_connection, $database_connection);
$query = "SELECT * FROM Device_tbl";
$result=mysql_query($query, $database_connection) or die(mysql_error());
$findrow = array();
while($row = mysql_fetch_assoc($result)){
    $manufac = $row[ Manufacturer ];
    $mod = $row[ Model ];
    $string = $manufac.   .$mod;
    $findrow[] = $string;
}

?>

<script type="text/javascript">
$(document).ready(function() {
  $("#search_input").watermark("Begin Typing to Search");

  var availableTags = <? echo json_encode($findrow);?>;
  $( "#search_input" ).autocomplete({
            source: availableTags
            });


    $("#search_input").bind("autocompleteselect", function() {
        var search_input = $(this).val();
        if (search_input ==  ) search_input = * ;
        var dataString =  keyword= +search_input;

        if (search_input.length > 2 || search_input== * ) {
           $.ajax({
                type: "GET",
                url: "core/functions/searchdata.php",
                data: dataString,
                success: function(server_response) {
                    $( #searchresultdata ).empty();
                    $( #searchresultdata ).append(server_response);
                    $( span#category_title ).html(search_input);
                }
            });
        }

        return false;
    });
    $("#search_input").trigger( keyup );
});
</script>

searchdata.php

mysql_select_db($database_database_connection, $database_connection);
$query = "SELECT Image, Manufacturer, Model FROM Device_tbl WHERE Manufacturer LIKE  %$keyword%  OR Model LIKE  %$keyword% ";
if ($keyword== * ) $query = "SELECT Image, Manufacturer, Model FROM Device_tbl";
$result=mysql_query($query, $database_connection) or die(mysql_error());

if($result){
    if(mysql_affected_rows($database_connection)!=0){
          while($row = mysql_fetch_object($result)){
?>
     <div class="hold-cont">
        <div class="holder">
            <div class="image-hold" >
                <img class="image-icon" src="<? echo $deviceimg.($row->Image); ?>"/>
</div>
        </div>
        <div class="device-name devicename-txt"><? echo($row->Manufacturer.     .$row->Model);  ?></div>
    </div>
     <?
    }
    }else {
        echo  No Results for :" .$_GET[ keyword ]. " ;
    }

}
else {
    echo  Parameter Missing ;

汽车零件进行罚款,然而,我可以做些什么是按选定价值操作。例如,如果我开始打上“Apple iMac”的字句,则只算“Ap”。不过,当我点击建议时,该建议会是“Ap”问题,即它唯一处理的是关于什么类型而不是点击的问题。

在用户点击电离层射线照射时,我如何做这项工作?

Answer 1

$( "#search_input" ).autocomplete({
    source: availableTags,
    select: function(event, ui) {
        sendSelected(ui.item.value);
        }
    });

function sendSelected(_val){
    var search_input = _val;
    if (search_input ==  ) search_input = * ;
    var dataString =  keyword= +search_input;

    if (search_input.length > 2 || search_input== * ) {
       $.ajax({
            type: "GET",
            url: "core/functions/searchdata.php",
            data: dataString,
            success: function(server_response) {
                $( #searchresultdata ).empty();
                $( #searchresultdata ).append(server_response);
                $( span#category_title ).html(search_input);
            }
        });
    }
}

检索数据:

$splitKeyword = explode(" ", $keyword);
if(sizeof($splitKeyword)==3){
    $splitKeyword[1] = $splitKeyword[1]." ".$splitKeyword[2];
 }
$query = "SELECT Image, Manufacturer, Model FROM Device_tbl WHERE Manufacturer LIKE  %".$splitKeyword[0]."%  OR Model LIKE  %".$splitKeyword[1]."% ";

友情链接