Sort and print in a table multidimensional array array in PHP

Question

I need to print this full multidimensional array in a table and sort it by name [A-Z].

//Example not sorted:
//Id - Name - Last name -      Email        - Phone number
   2 - Bldo -  Surname  - [email protected] - 23452524352
   6 - Cldo -  Surname  - [email protected] - 23452524352
   3 - Aldo -  Surname  - [email protected] - 23452524352

//Example sorted:
//Id - Name - Last name -       Email       - Phone Number
   3 - Aldo -  Surname  - [email protected] - 23452524352
   2 - Bldo -  Surname  - [email protected] - 23452524352
   6 - Cldo -  Surname  - [email protected] - 23452524352

Here is the array.

// Array with the contacts details
$contacts = array (

    [0] => Array ( 
        [0] => 2
        [1] => "Bldo" 
        [2] => "Surname" 
        [3] => "[email protected]"
        [4] => 3243125152 
    )

    [1] => Array ( 
        [0] => 6
        [1] => "Cldo" 
        [2] => "Surname" 
        [3] => "[email protected]"
        [4] => 3243125152 
    ) 

    [2] => Array ( 
        [0] => 3
        [1] => "Aldo" 
        [2] => "Surname" 
        [3] => "[email protected]"
        [4] => 3243125152 
    ) 
);

Here is the html.

<?php
    <!-- Resoults from db -->
    <table> 

        <thead>
            <tr>
                <th>Checkbox</th>
                <th>First name</th>
                <th>Last name</th>
                <th>Email</th>
                <th>Phone number</th>
                <th>Update</th>
            </tr>
        </thead>

        <tbody>

            <?php
            // Print contacts here
            ?>

        </tbody>

    </table>
?>

I tried only with one array and it works, but I can't figure it out how to make it with the multidimensional array.

Possible duplicate of How to Sort Multi-dimensional Array by Value? — Umair Khan
– Umair Khan, Commented Nov 20, 2019 at 12:05
You can use PHP function array_multisort. In the examples, you find enough suggestions how to use it. For example, have a look at php.net/manual/en/function.array-multisort.php#114076 — RWC
– RWC, Commented Nov 20, 2019 at 15:33

RuiVBoas · Accepted Answer · 2019-11-20 15:25:56Z

1

Start by creating an array with values of what you want to sort by, in this case by name.

Then assign the values of $contacts to an array where the keys will be names and values will be the contacts values

Then you only need to sort the results and it's done.

$contacts = array (
    array(2,"Bldo","Surname","[email protected]",3243125152),
    array(6,"Cldo","Surname","[email protected]",3243125152),
    array(2,"Aldo","Surname","[email protected]",3243125152));

$names = array();
foreach($contacts as $contact) {
    array_push($names,$contact[1]);
}

$result = array();
foreach($names as $key => $val) {
    $result[$val] = $contacts[$key];
}

array_multisort($result);

print_r($result);

Try this.

answered Nov 20, 2019 at 15:25

RuiVBoas

3944 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RuiVBoas Over a year ago

If you want you can avoid the first foreach and use only $names = array_column($contacts, '1');

Erwan Sturzenegger · Accepted Answer · 2019-11-20 12:01:26Z

0

Create your own sorting function and apply it on the array.

Then

    <tbody>
        <?php
          foreach ($contact as &$value) {
            //do what you want with your contact ($value)
          }
        ?>
    </tbody>

answered Nov 20, 2019 at 12:01

Erwan Sturzenegger

212 bronze badges

Comments

Aksen P · Accepted Answer · 2019-11-20 12:39:19Z

0

Data sorting could be done with array_multisort and array_column functions Demo:

$keys = array_column($contacts, 1);
array_multisort($keys, SORT_ASC, $contacts);

In table you can use simple foreach. Put next between tbody tags:

<?php foreach($contacts as $record): ?>
 <tr>
    <?php foreach($record as $item): ?>
         <td><?= $item; ?></td> 
    <?php endforeach; ?>
         <td>..stuff for update button..</td>
 </tr>
<?php endforeach; ?>

edited Nov 20, 2019 at 12:39

answered Nov 20, 2019 at 12:33

Aksen P

4,6153 gold badges16 silver badges27 bronze badges

Collectives™ on Stack Overflow

Sort and print in a table multidimensional array array in PHP

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related