blocks|key|1995212|text|如果你想在搜索后排序，你可以使用usort()函数：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1995213|function+myComparer($a,+$b)
{
++++if+($GLOBALS['SEARCH_TYPE']+==+'PRICE')
++++{
++++++++$valueA+=+floatval($a['price']);
++++++++$valueB+=+floatval($b['price']);
++++}
++++else+($GLOBALS['SEARCH_TYPE']+==+'EXPIRATION-DATE')
++++{
++++++++//+time+string+to+UNIX+timestamp+integer+value
++++++++$valueA+=+strtotime($a['expiration_date']);
++++++++$valueB+=+strtotime($b['expiration_date']);
++++}

++++if+($valueA+==+$valueB)+{
++++++++return+0;
++++}

++++return+($valueA+<+$valueB)+?+-1+:+1;
}

include+'./get_search_type.php';
//+is+stored+in+array+$GLOBALS['SEARCH_TYPE']

include+'./get_search_result.php';+xyz+is+the+field+name
//+is+stored+in+array+$GLOBALS['SEARCH_RESULT'][xyz]

usort($GLOBALS['SEARCH_RESULT'],+myComparer);|code-block|syntax|javascript|1995214|顺便说一下:在我看来，生成一个动态查询来按DBMS排序会更好(这会容易得多)：|1995215|if+($GLOBALS['SEARCH_TYPE']+==+'PRICE')
{
++++$query+=+"SELECT+*+FROM+Products+ORDER+BY+price;";
}
else+($GLOBALS['SEARCH_TYPE']+==+'EXPIRATION-DATE')
{
++++$query+=+"SELECT+*+FROM+Products+ORDER+BY+expiration_date;";
}|1995216|entityMap|0|LINK|mutability|MUTABLE|url|http://de3.php.net/manual/en/function.usort.php^0|G|7|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

If you want to sort after search you can use <a href="http://de3.php.net/manual/en/function.usort.php" rel="nofollow">usort()</a> function:

<pre><code>function myComparer($a, $b)
{
 if ($GLOBALS['SEARCH_TYPE'] == 'PRICE')
 {
 $valueA = floatval($a['price']);
 $valueB = floatval($b['price']);
 }
 else ($GLOBALS['SEARCH_TYPE'] == 'EXPIRATION-DATE')
 {
 // time string to UNIX timestamp integer value
 $valueA = strtotime($a['expiration_date']);
 $valueB = strtotime($b['expiration_date']);
 }

 if ($valueA == $valueB) {
 return 0;
 }

 return ($valueA &lt; $valueB) ? -1 : 1;
}

include './get_search_type.php';
// is stored in array $GLOBALS['SEARCH_TYPE']

include './get_search_result.php'; xyz is the field name
// is stored in array $GLOBALS['SEARCH_RESULT'][xyz]

usort($GLOBALS['SEARCH_RESULT'], myComparer);
</code></pre>

btw: In my opinion it is better to generate a dynamic query to sort by DBMS (thats much easier):

<pre><code>if ($GLOBALS['SEARCH_TYPE'] == 'PRICE')
{
 $query = "SELECT * FROM Products ORDER BY price;";
}
else ($GLOBALS['SEARCH_TYPE'] == 'EXPIRATION-DATE')
{
 $query = "SELECT * FROM Products ORDER BY expiration_date;";
}
</code></pre>

blocks|key|1781545|text|服务器端将php查询结果存储到一个数组中，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1781546|//+if+you+want+to+sort+by+column+'name',+store+them+by+format:+$dataset[{pid}]+=+{name};
//+pid++name
//++1+++test1
//++2+++alpha1
//++5+++candy1
while+(...)+//+read+query+result
{
++++$dataset[$row['pid']]+=+new+array($row['name']+=>+$row);
}++++
//+now,+use+sort()
sort($dataset);

//+then+foreach+array+to+get+sorted+data;
foreach+($datasetas+$key+=>+$val)+{
++++echo+$val."\n";
}|code-block|syntax|javascript|1781547|客户端读取数据，并以JSON格式和响应方式存储。然后，在您的页面中，使用javascript+json库对它们进行排序。|1781548|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

[Server Side]
Store php query result into an array like below: 

<pre><code>// if you want to sort by column 'name', store them by format: $dataset[{pid}] = {name};
// pid name
// 1 test1
// 2 alpha1
// 5 candy1
while (...) // read query result
{
 $dataset[$row['pid']] = new array($row['name'] =&gt; $row);
} 
// now, use sort()
sort($dataset);

// then foreach array to get sorted data;
foreach ($datasetas $key =&gt; $val) {
 echo $val."\n";
}
</code></pre>

[Client Side]
Read data and store them by JSON format and response. Then, in your page, use javascript json library to sort them.

I am writing a query for mysql database having 2 parameters.

Its a basic search but the problem is I want to sort the order of the results on the basis of the selection.
So after I've clicked the search button and the browser displayied the result set I want to order this specific result set by expiration-date or by price depending wich button i click.

<pre><code> //SELECTION DATA FORM 
 &lt;form action="EVENTS_SELECTION.PHP"&gt;
 &lt;select name="Type"&gt;
 &lt;option value=""&gt;SPORT
 &lt;option value=""&gt;CULTURE 
 &lt;option value=""&gt;LEISURE
 &lt;option value=""&gt;GASTRONOMY
 &lt;/select&gt; 

 &lt;select name="WHERE"&gt;
 &lt;option&gt;ROME ALL
 &lt;option&gt;ROME SOUTH
 &lt;option&gt;ROME WEST
 &lt;option&gt;ROME EAST
 &lt;option&gt;ROME NORTH
 &lt;/select&gt;

 &lt;input type="submit" value="search"&gt; 
 &lt;/form&gt; 
</code></pre>

how can I achieve that??
thanks
Luca

how to sort mysql result set after the query's done

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在为mysql数据库写一个有2个参数的查询。这是一个基本的搜索，但问题是我想在选择的基础上排序结果的顺序。因此，在我单击了搜索按钮，浏览器显示了结果集之后，我想要根据过期日期或价格对这个特定的结果集进行排序，这取决于我单击的按钮。 //SELECTION DATA FORM <form action="E...

问如何在查询完成后对mysql结果集进行排序
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在查询完成后对mysql结果集进行排序EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在查询完成后对mysql结果集进行排序
EN