文章目录[隐藏]
输入其它字符都能正常显示
就是输入00或000的时候就显示不了，数据库里面有相关的数据
我估计是不是把000当成空值了？请各位大神帮我看看
<meta http-equiv="Content-Type" content="text/html; charset=GBK" /><title>仿百度搜索输入框提示JS代码</title><link href="css/jquery.autocomplete.css" type=text/css rel=stylesheet><script type="text/javascript" src="js/jquery.js"></script><script type="text/javascript" src="js/jquery.autocomplete.js"></script><script language="javascript"> $(document).ready(function() { $("#keyword").autocomplete("getajaxtag.php", { delay:10, minChars:1, matchSubset:1, matchContains:1, cacheLength:10, onItemSelect:selectItem, onFindValue:findValue, formatItem:formatItem, autoFill:false } ); }); function findValue(li) { if( li == null ) return alert("No match!"); if( !!li.extra ) var sValue = li.extra[0]; else var sValue = li.selectValue; } function selectItem(li) { findValue(li);} function formatItem(row) { return row[0];//return row[0] + " (id: " + row[1] + ")"//如果有其他参数调用row[1]，对应输出格式Sparta|896 } function lookupAjax(){ var oSuggest = $("#keyword")[0].autocompleter; oSuggest.findValue(); return false; }</script><body><div class="sidebarBlock" style="margin:0 auto;text-align:center"> <h3>仿百度搜索输入框提示JS代码（基于jquery.autocomplete.js插件）</h3> <div class="sidebarSearch"> </div> </div>
回复讨论(解决方案)
include_once ('conn.php');$keyword = $_GET ['q'] ;$sql = mysql_query ( "SELECT DISTINCT(item_code) FROM sku_rule WHERE item_code LIKE '" . $keyword . "%' LIMIT 0,10" );$myaf = mysql_affected_rows();while ( $value = mysql_fetch_array ( $sql ) ) <i>本文@来#源gaodai$ma#com搞$$代**码网</i><strong>搞代gaodaima码</strong>{ echo $keyword = iconv ( 'utf-8', 'utf-8', $value ['item_code'] ) . "\n";}if($myaf<10){$li=10-$myaf;$sql_sku = mysql_query ( "SELECT DISTINCT(sku) FROM sku_rule WHERE sku LIKE '" . $keyword . "%' LIMIT 0,$li" );$myaf_sku = mysql_affected_rows();while ( $value_sku = mysql_fetch_array ( $sql_sku ) ) { echo $keyword = iconv ( 'utf-8', 'utf-8', $value_sku ['sku'] ) . "\n";}$as=$myaf+$myaf_sku;if($as<10){$as=10-$as;$sql_as = mysql_query ( "SELECT DISTINCT(asin) FROM sku_rule WHERE asin LIKE '" . $keyword . "%' LIMIT 0,$as" );while ( $value_as = mysql_fetch_array ( $sql_as ) ) { echo $keyword = iconv ( 'utf-8', 'utf-8', $value_as ['asin'] ) . "\n";}}}
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：仿百度提示框的问题
转载请注明原文链接：仿百度提示框的问题
