php order by code example

Example 1: MySQL ORDER BY

SELECT 
   select_list
FROM 
   table_name
ORDER BY 
   column1 [ASC|DESC], 
   column2 [ASC|DESC],
   ...;

Example 2: php sort()

<?php

$fruits = array("Zitrone", "Orange", "Banane", "Apfel");
sort($fruits);
foreach ($fruits as $key => $val) {
    echo "fruits[" . $key . "] = " . $val . "\n";
}

?>

Example 3: php array sort

function aasort (&$array, $key) {
    $sorter=array();
    $ret=array();
    reset($array);
    foreach ($array as $ii => $va) {
        $sorter[$ii]=$va[$key];
    }
    asort($sorter);
    foreach ($sorter as $ii => $va) {
        $ret[$ii]=$array[$ii];
    }
    $array=$ret;
}

aasort($your_array,"order");

Example 4: php array sort

// Fonction de comparaison
function cmp($a, $b) {
    if ($a == $b) {
        return 0;
    }
    return ($a < $b) ? -1 : 1;
}

Example 5: array sort php

// array sort php
$room_details = array(
      "2020-09-27": [
                {
                    "content": "how are you",
                    "detail_id": "1",
                    "time": "17:57:28",
                    "chat_time": "2020-09-24 17:57:28",
                    "width": "0",
                    "height": "0",
                    "type": "1",
                    "distance_time": "26 days ago",
                    "avatar": "uploads/MemberImage/20200922-1436-image-5f699b536f438-0.png",
                    "position": 2
                },
                {
                    "content": "I am fine, thanks",
                    "detail_id": "2",
                    "time": "17:57:45",
                    "chat_time": "2020-09-24 17:57:45",
                    "width": "0",
                    "height": "0",
                    "type": "1",
                    "distance_time": "26 days ago",
                    "avatar": "uploads/MemberImage/20200922-1436-image-5f699b536f438-0.png",
                    "position": 2
                },
      ],
	 "2020-09-24": [
                {
                    "content": "how are you",
                    "detail_id": "1",
                    "time": "17:57:28",
                    "chat_time": "2020-09-24 17:57:28",
                    "width": "0",
                    "height": "0",
                    "type": "1",
                    "distance_time": "26 days ago",
                    "avatar": "uploads/MemberImage/20200922-1436-image-5f699b536f438-0.png",
                    "position": 2
                },
                {
                    "content": "I am fine, thanks",
                    "detail_id": "2",
                    "time": "17:57:45",
                    "chat_time": "2020-09-24 17:57:45",
                    "width": "0",
                    "height": "0",
                    "type": "1",
                    "distance_time": "26 days ago",
                    "avatar": "uploads/MemberImage/20200922-1436-image-5f699b536f438-0.png",
                    "position": 2
                },
      ],
);

sort($room_details);

// result
// array sort php
$room_details = array(
      "2020-09-24": [
                ...
      ],
	 "2020-09-27": [
               ...
      ],
);