分类自动完成数据 [英] Categorize auto complete data
问题描述
我在搜索文本框中使用了自动完成框.它对我来说正常工作...这是我的脚本.
I used auto complete box to my searching text box. Its working properly for me... this is my script..
<?php
require_once('database.php');
if(isset($_POST['queryString'])) {
$queryString = $dbc->real_escape_string($_POST['queryString']);
if(strlen($queryString) >0) {
$q = "SELECT keyword
FROM (
SELECT tname AS keyword FROM t
UNION
SELECT sname AS keyword FROM sub
UNION
SELECT cname AS keyword FROM c
UNION
SELECT iname AS keyword FROM i
) s
WHERE keyword LIKE '%$queryString%'
LIMIT 10";
$r = mysqli_query ( $dbc, $q);
if($q) {
while ($row = mysqli_fetch_array($r, MYSQL_ASSOC)) {
echo '<li onClick="fill(\''.$row['keyword'].'\');">'.$row['keyword'].'</li>';
}
} else {
echo 'ERROR: There was a problem with the query.';
}
} else {
}
} else {
echo 'There should be no direct access to this script!';
}
?>
问题是我的自动完成框显示所有结果,包括相关关键字的主题,教师姓名,机构等.现在,我想在自动完成框中对它们进行分类.例如:学科类别下的学科,学科类别下的导师姓名等.我想做的事情类似于Facebook搜索选项.
problem is my autocomplete box display all result in subjects,tutor names, institutes etc to related keyword. Now I want to categorize them in autocomplete box.. ex: subjects under subject category, tutor name under tutor category etc... what i am trying to do is something similar to facebook search option..
这是我的jQuery:
This is my jQuery:
<script type="text/javascript">
function lookup(inputString) {
if(inputString.length == 0) {
$('#suggestions').hide();
} else {
$.post("rpc.php", {queryString: ""+inputString+""}, function(data){
if(data.length >0) {
$('#suggestions').show();
$('#autoSuggestionsList').html(data);
}
});
}
}
function fill(thisValue) {
$('#inputString').val(thisValue);
setTimeout("$('#suggestions').hide();", 200);
}
</script>
有人可以帮我吗? 谢谢.
can anybody help me to this? Thank you.
推荐答案
使用搜索文本输入附近的下拉列表选择类别或多个复选框,以查看您将要进行的合并.我会建议您Sphinx http://sphinxsearch.com/
Use a drop down near the search text input to select category or multiple checkbox to see what union you would have to make? I would recommend you Sphinx http://sphinxsearch.com/
尝试
SELECT 1 as type,tname AS keyword FROM t
UNION
SELECT 2 as type,sname AS keyword FROM sub
UNION
SELECT 3 as type,cname AS keyword FROM c
UNION
SELECT 4 as type,iname AS keyword FROM i
foreach($results as $result)
{
switch($result['type'])
{
case 1:
$cat_1[]=$result;
break;
case 2:
$cat_2[]=$result;
break;
}
}
这篇关于分类自动完成数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!