dbx_sort

(PHP 4 >= 4.0.6, PHP 5 < 5.1.0, PECL dbx >= 1.1.0)

dbx_sort — Sort a result from a dbx_query by a custom sort function

说明

dbx_sort ( object $result , string $user_compare_function ) : bool

Sort a result from a dbx_query() call with a custom sort function.

参数

result

A result set returned by dbx_query().

user_compare_function

The user-defined comparison function. It must accept two arguments and return an integer less than, equal to, or greater than zero if the first argument is considered to be respectively less than, equal to, or greater than the second.

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

范例

Example #1 dbx_sort() example

<?php
function user_re_order($a, $b) 
{
    $rv = dbx_compare($a, $b, "parentid", DBX_CMP_DESC);
    if (!$rv) {
        $rv = dbx_compare($a, $b, "id", DBX_CMP_NUMBER);
    }
    return $rv;
}

$link   = dbx_connect(DBX_ODBC, "", "db", "username", "password")
    or die("Could not connect");

$result = dbx_query($link, "SELECT id, parentid, description FROM tbl ORDER BY id");
    // data in $result is now ordered by id

dbx_sort($result, "user_re_order");
    // data in $result is now ordered by parentid (descending), then by id

dbx_close($link);
?>

注释

Note:

It is always better to use ORDER BY SQL clause instead of dbx_sort() if possible.

参见

相关文章
php cubrid mysql 兼容性函数 get column information from a result and return as an objectphp cubrid 函数 get result of next query when executing multiple sql statementsphp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp dbx 函数 send a query and fetch all results if any php dbx 函数 sort a result from a dbx query by a custom sort functionphp frontbase 函数 get column information from a result and return as an objectphp grapheme 函数 function to extract a sequence of default grapheme clusters from a text buffer which must be encoded in utf 8php firebird/interbase 函数 fetch a result row from a query as an associative arrayphp ingres 函数 get the type of a field in a query resultphp ldap 函数 sort ldap result entries on the client sidephp maxdb 函数 prepare next result from multi queryphp maxdb 函数 transfers a result set from the last queryphp 多字节字符串 函数 retrieve the result from the last multibyte regular expression matchphp oci8 函数 returns the next child statement resource from a parent statement resource that has oracle database 12c implicit result setsphp runkit 函数 specify a function to capture and/or process output from a runkit sandboxphp sqlite 函数 fetches a column from the current row of a result setphp sqlite 函数 fetches the current row from a result set as an arrayphp uopz 函数 gets the static variables from function or method scopephp mysqli stmt reads the next result from a multiple queryphp swish 函数 get an array of stopwords removed from the query
关注编程学问公众号