blocks|key|1483385|text|你需要|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1483386|SELECT+*+
FROM+autocomplete+
WHERE+name+LIKE+'%25$text%25'+
ORDER+BY+(name+LIKE+'$text%25')+DESC,+
+++++++++name+ASC|code-block|syntax|javascript|1483387|第一个order子句是一个布尔值，如果名称以$text开头，则为0，所以当您按DESC顺序排序时，以$text开头的值将移到列表的前面(其他地方只包含$text的值将移到末尾)。然后，第二个子句按字母顺序对两个“子列表”进行排序。|offset|length|style|CODE|1483388|entityMap^0|0|0|M|5|W|1|13|4|1E|5|23|5|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]|$I|V|J|W|K|L]|$I|X|J|Y|K|L]|$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$]]

You would need

<pre><code>SELECT * 
FROM autocomplete 
WHERE name LIKE '%$text%' 
ORDER BY (name LIKE '$text%') DESC, 
 name ASC
</code></pre>

The first ORDER BY clause is a BOOLEAN value that is <code>1</code> when name starts with <code>$text</code> and <code>0</code> otherwise, so when you sort by that in <code>DESC</code> order, values starting with <code>$text</code> will be moved to the front of the list (and those only containing it elsewhere will be moved to the end). The second clause then sorts both "sublists" alphabetically again.

blocks|key|2783571|text|Update.似乎需要以输入的前缀开头的建议才能首先出现在列表中，因此需要使用用户排序函数。我已经更新了代码来匹配这个。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2783572|如果要在PHP中执行排序，则需要创建一个带有结果的数组，并通过一个PHP数组排序函数对其进行排序。下面是使用usort()函数的修改代码：|CODE|2783573|$term+=+$_GET['term'];
$text+=+$mysqli->real_escape_string($term);

$query+=+"SELECT+*+FROM+autocomplete+WHERE+name+LIKE+'%25$text%25'+ORDER+BY+name+ASC";
$result+=+$mysqli->query($query);

$results+=+array();
while($row+=+$result->fetch_assoc())
{
++++$results[]+=+$row['name'];
}

usort($results,+function($item1,+$item2)+use($term)+{
++++//+prefixed+items+need+to+go+first
++++$item1HasPrefix+=+strpos($item1,+$term)+===+0;
++++$item2HasPrefix+=+strpos($item2,+$term)+===+0;

++++if($item1HasPrefix+&&+$item2HasPrefix)+{
++++++++//+if+both+items+have+the+prefix,+sort+them
++++++++return+strcmp($item1,+$item2);
++++}+elseif($item1HasPrefix)+{
++++++++return+-1;
++++}+elseif($item2HasPrefix)+{
++++++++return+1;
++++}+else+{
+++++++return+strcmp($item1,+$item2);
++++}
});

echo+json_encode($results);|code-block|syntax|javascript|2783574|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/array.sorting.php^0|0|7|0|1I|7|X|9|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Y|8|@$9|Z|A|10|B|H]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|I|3|J|5|K|7|14|8|@]|D|@]|E|$L|M]]|$1|N|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|O|$P|$5|Q|R|S|E|$T|U]]]]

Update. As it seems that you need suggestions that start with the entered prefix to appear first in the list, you'll need to use a user-sorting function. I've updated the code to match this.

If you want to do the sort in PHP, you need to create an array with the results, and sort it via one the <a href="http://php.net/manual/en/array.sorting.php" rel="nofollow">PHP array sorting function</a>. Here's your modified code that uses the <code>usort()</code> function:

<pre><code>$term = $_GET['term'];
$text = $mysqli-&gt;real_escape_string($term);

$query = "SELECT * FROM autocomplete WHERE name LIKE '%$text%' ORDER BY name ASC";
$result = $mysqli-&gt;query($query);

$results = array();
while($row = $result-&gt;fetch_assoc())
{
 $results[] = $row['name'];
}

usort($results, function($item1, $item2) use($term) {
 // prefixed items need to go first
 $item1HasPrefix = strpos($item1, $term) === 0;
 $item2HasPrefix = strpos($item2, $term) === 0;

 if($item1HasPrefix &amp;&amp; $item2HasPrefix) {
 // if both items have the prefix, sort them
 return strcmp($item1, $item2);
 } elseif($item1HasPrefix) {
 return -1;
 } elseif($item2HasPrefix) {
 return 1;
 } else {
 return strcmp($item1, $item2);
 }
});

echo json_encode($results);
</code></pre>

blocks|key|438138|text|您可以在客户端尝试bootstrap-typeahead+JS自动完成库。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|438139|https://twitter.github.io/typeahead.js/examples/|438140|entityMap|0|LINK|mutability|MUTABLE|url^0|9|J|0|0|1C|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@$9|S|A|T|1|U]]|E|$]]|$1|H|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|G]]]]

You can try bootstrap-typeahead JS autocomplete library in Client Side.

<a href="https://twitter.github.io/typeahead.js/examples/" rel="nofollow">https://twitter.github.io/typeahead.js/examples/</a>

I want to sort autocomplete suggestions by first letter alphabetical.

Now it look like this: <a href="http://i.imgur.com/EevFyv2.png" rel="nofollow">http://i.imgur.com/EevFyv2.png</a>

If i type letter C i want to show tag suggestions like this:

<ul>
<li>C</li>
<li>C++</li>
<li>Active Directory</li>
<li>Apple Script</li>
<li>BlueCoat</li>
</ul>

Code:

<pre><code>$text = $mysqli-&gt;real_escape_string($_GET['term']);

$query = "SELECT * FROM autocomplete WHERE name LIKE '%$text%' ORDER BY name ASC";
$result = $mysqli-&gt;query($query);
$json = '[';
$first = true;
while($row = $result-&gt;fetch_assoc())
{
 if (!$first) { $json .= ','; } else { $first = false; }
 $json .= '{"value":"'.$row['name'].'"}';
}
$json .= ']';

echo $json;
</code></pre>

I hope someone could help, thanks in advance.

Sort autocomplete suggestions by first letter alphabetical

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我想按字母顺序对自动完成的建议进行排序。现在它看起来像这样：如果我输入字母C，我想显示如下的标签建议：CC++活动目录苹果脚本BlueCoat代码：$text = $mysqli->real_escape_string($_GET['term']);$query = "SELECT * FROM autocomplet...

问按首字母字母排序自动完成建议
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问按首字母字母排序自动完成建议EN