list
I kept getting varied results using natcasesort and sort on mixed arrays -- per the descriptions.
Sometimes simple is better:
A little snippet of code:
<?php if($responders->num_rows) {
$i=0;
while($row= $responders->fetch_assoc()) {
$user=getUserName($row['responderID']);
$r[$i]= array("sortname"=>strtolower($user),"userName"=>$user, "userID"=>$row['responderID'], "responderID"=>$row['idresponders']);
$i++;
}
sort($r);
print_r($r);
}
?>
I simply created a lower cased sort field at the front of the result set and then sort by it -- which provides the expected result and leaves the actual needed fields unchanged.
For the curious: all user information is kept completed in another database (and table) from the content database due to security reasons. The getUser functions we have written allow us to pull only what is legally allowed without exposing anything else.
This is why a left join or something wasn't used and we have to build a pseudo result array here from both databases.
natcasesort
(PHP 4, PHP 5)
natcasesort — "자연순" 알고리즘으로 대소문자를 구분하지 않고 배열 정렬
설명
bool natcasesort
( array &$array
)
natcasesort()는 대소문자를 구분하지 않는 natsort()입니다.
이 함수는 키/값 연결을 유지하면서 사람이 하는 순서로 알파벳-숫자 문자열을 정렬하는 알고리즘을 구현합니다. 이 알고리즘을 "자연순"이라고 한다.
인수
- array
-
입력 배열.
반환값
성공할 경우 TRUE를, 실패할 경우 FALSE를 반환합니다.
예제
Example #1 natcasesort() 예제
<?php
$array1 = $array2 = array('IMG0.png', 'img12.png', 'img10.png', 'img2.png', 'img1.png', 'IMG3.png');
sort($array1);
echo "일반 정렬\n";
print_r($array1);
natcasesort($array2);
echo "\n자연순 정렬 (대소문자 구분 없음)\n";
print_r($array2);
?>
위 예제의 출력:
일반 정렬
Array
(
[0] => IMG0.png
[1] => IMG3.png
[2] => img1.png
[3] => img10.png
[4] => img12.png
[5] => img2.png
)
자연순 정렬
Array
(
[0] => IMG0.png
[4] => img1.png
[3] => img2.png
[5] => IMG3.png
[2] => img10.png
[1] => img12.png
)
추가 정보: Martin Pool의 » 자연순 문자열 정렬 페이지.
참고
- sort() - 배열 정렬
- natsort() - "자연순" 알고리즘으로 배열 정렬
- strnatcmp() - "자연순" 알고리즘을 이용한 문자열 비교
- strnatcasecmp() - "자연순" 알고리즘을 이용한 대소문자 구분 없는 문자열 비교
add a note
User Contributed Notesnatcasesort
shawn at shawnwilkerson dot com
06-May-2009 02:03
06-May-2009 02:03
claude at schlesser dot lu
07-Jan-2009 05:41
07-Jan-2009 05:41
Here a function that will natural sort an array by keys with keys that contain special characters.
<?php
function natksort($array)
{
$original_keys_arr = array();
$original_values_arr = array();
$clean_keys_arr = array();
$i = 0;
foreach ($array AS $key => $value)
{
$original_keys_arr[$i] = $key;
$original_values_arr[$i] = $value;
$clean_keys_arr[$i] = strtr($key, "ÄÖÜäöüÉÈÀËëéèàç", "AOUaouEEAEeeeac");
$i++;
}
natcasesort($clean_keys_arr);
$result_arr = array();
foreach ($clean_keys_arr AS $key => $value)
{
$original_key = $original_keys_arr[$key];
$original_value = $original_values_arr[$key];
$result_arr[$original_key] = $original_value;
}
return $result_arr;
}
?>
Hope it will be useful to somebody :)
Kim
03-Dec-2008 12:45
03-Dec-2008 12:45
If your array already is sorted ASC or DESC, then natcasesort, ksort and sort (I only tested those) will invert the sorting order.
This is most troublesome since its impossible to force a sorting order. I had to use array_multisort instead and lose the natrual sorting.
Natcasesort expects a single dimension array, so if your value is an array then it will report a "Array to string conversion" notice per key/value set.
php at method5 dot de
07-Nov-2003 03:56
07-Nov-2003 03:56
hi all,
this is my first post at php.net first of all thank you for this huge site :)
ok i found it usefull to post this for others. in the german language we have words like ' ' its called "umlaute" and it was a problem to me to "naturally" sort an huge array correctly so i coded this small block to get me helped, if anyone has an better idea please post and let us know as i am not a real crack :)
1. change each "umlaut" () into its "nearest" equivalent
2. natcasesorting it naturally
3. re-assiging the correct sorted array with the original-words again while keeping track of the KEY...
example-array:
$aSupplier = array(3 => "MAN",2 => "Atlas",16 => "Chevrolet",17 => "Chrysler",19 => "Citroen",24 => "DAF",25 => "Daihatsu",27 => "Daewoo",28 => "Demag",30 => "Dodge",36 => "Schierling",208 => "HIAB",38 => "Hffermann",39 => "Gergen",40 => "Kubato",41 => "Faun",43 => "Kleindienst",44 => "Swing",45 => "Neuhaus",46 => "Unimog",47 => "Meiller",48 => "Pfau-Johnston",49 => "Geesink",50 => "Schrling",51 => "Demag-Witting",53 => "Helmers",54 => "Ellermann",55 => "Jacobsen",56 => "Biki",57 => "Hansa",58 => "Kramer",59 => "Schmitz",60 => "Toro",61 => "Iseki",62 => "Haller",63 => "Kuka",64 => "Brock",65 => "Ambross",66 => "Sobernheimer",67 => "Pietsch",68 => "Kpper",69 => "Weisser",71 => "Wackenhut");
foreach ( $aSupplier as $key => $value )
{
$aSupplier2[$key] = strtr($aSupplier[$key], "", "AOUaous");
}
natcasesort($aSupplier2);
foreach ( $aSupplier2 as $key => $value )
{
if ( $aSupplier2[$key] != "" )
$aSupplier3[$key] = $aSupplier[$key];
}
echo "<pre>";
print_r($aSupplier3);
echo "</pre>";
greetz
tim
vbAlexDOSMan at Yahoo dot com
12-Sep-2003 05:21
12-Sep-2003 05:21
Ulli at Stemmeler dot net: I remade your function -- it's a little more compact now -- Enjoy...
function ignorecasesort(&$array) {
/*Make each element it's lowercase self plus itself*/
/*(e.g. "MyWebSite" would become "mywebsiteMyWebSite"*/
for ($i = 0; $i < sizeof($array); $array[$i] = strtolower($array[$i]).$array[$i], $i++);
/*Sort it -- only the lowercase versions will be used*/
sort($array);
/*Take each array element, cut it in half, and add the latter half to a new array*/
/*(e.g. "mywebsiteMyWebSite" would become "MyWebSite")*/
for ($i = 0; $i < sizeof($array); $i++) {
$this = $array[$i];
$array[$i] = substr($this, (strlen($this)/2), strlen($this));
}
}
dslicer at maine dot rr dot com
03-Jun-2003 10:41
03-Jun-2003 10:41
Something that should probably be documented is the fact that both natsort and natcasesort maintain the key-value associations of the array. If you natsort a numerically indexed array, a for loop will not produce the sorted order; a foreach loop, however, will produce the sorted order, but the indices won't be in numeric order. If you want natsort and natcasesort to break the key-value associations, just use array_values on the sorted array, like so:
natcasesort($arr);
$arr = array_values($arr);
tmiller25 at hotmail dot com
26-Apr-2002 11:55
26-Apr-2002 11:55
add this loop to the function above if you want items which have the same first characters to be listed in a way that the shorter string comes first.
--------------------
/* short before longer (e.g. 'abc' should come before 'abcd') */
for($i=count($array)-1;$i>0;$i--) {
$str_a = $array[$i ];
$str_b = $array[$i-1];
$cmp_a = strtolower(substr($str_a,0,strlen($str_a)));
$cmp_b = strtolower(substr($str_b,0,strlen($str_a)));
if ($cmp_a==$cmp_b && strlen($str_a)<strlen($str_b)) {
$array[$i]=$str_b; $array[$i-1]=$str_a; $i+=2;
}
}
--------------------
Ulli at Stemmeler dot net
06-Apr-2002 01:01
06-Apr-2002 01:01
natcasesort didn't work first time I needed something like this.
Not on my local server, not on my server on the web.
I needed an array sorted ignoring upper and lower cases. In the end lower case array-members stayed at the end of the array.
I replaced it with this function:
---------
function ignorecasesort(&$array) {
$separator="|<>|";
for($i=0;$i<sizeof($array);$i++) { $array[$i]=strtolower($array[$i]).$separator.$array[$i]; }
sort($array);
for($i=0;$i<sizeof($array);$i++) { $this=$array[$i]; $this=explode($separator,$this); $array[$i]=$this[1]; }
}
---------