Sorting array by date and another by that one in PHP

Question

how can I sort these two arrays date wise one array has all the dates please tell me a way to fix this problem The code i tried

<?php
$date=array("2018-09-28","2018-11-26","2018-12-26","2019-01-25","2019-02-25","2019-03-25","2019-04-25","2019-05-27","2019-06-25","2019-07-25","2019-08-26","2019-09-25","2019-10-25","2019-11-25","2019-12-26","2017-05-30","2017-05-31","2017-10-26","2017-10-27","2020-01-04");
$amount=array("-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-1000","-50000","-50000","-70000","-69414","276521");
$count= count($date);
echo "<table>"
echo "<tr>";
echo "<th>DATES</th>";
echo "<th>Amount</th>";
echo "</tr>";

for($i=0;$i<$count;$i++)
{
    echo "<tr>";
    echo "<td>".$date[$i]."</td>";
    echo "<td>".$amount[$i]."</td>";
    echo "</tr>";
}

?>

So you want to keep the amount associated with the same datae after the dort I assume — RiggsFolly
– RiggsFolly, Commented Jan 8, 2020 at 18:59

AbraCadaver · Accepted Answer · 2020-01-08 19:18:10Z

1

This will sort the date array ascending and sort the amount array by the date array:

array_multisort($date, $amount);

To sort descending:

array_multisort($date, SORT_DESC, $amount);

answered Jan 8, 2020 at 19:18

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

2 Comments

SWARNADEEP PRAMANICK Over a year ago

each amount is correct with the a particular date,means for date 2018-09-28 the amount is -1000

AbraCadaver Over a year ago

I know that, that's exactly what this does. 3v4l.org/iEOHa

Paul Lemmons · Accepted Answer · 2020-01-08 19:15:22Z

0

$date = array("2018-09-28","2018-11-26","2018-12-26",
            "2019-01-25","2019-02-25","2019-03-25",
            "2019-04-25","2019-05-27","2019-06-25",
            "2019-07-25","2019-08-26","2019-09-25",
            "2019-10-25","2019-11-25","2019-12-26",
            "2017-05-30","2017-05-31","2017-10-26",
            "2017-10-27","2020-01-04");

$amount = array("-1000","-1000","-1000",
                "-1000","-1000","-1000",
                "-1000","-1000","-1000",
                "-1000","-1000","-1000",
                "-1000","-1000","-1000",
                "-50000","-50000","-70000",
                "-69414","276521");

$combinedArray = array_combine($date,$amount);
ksort($combinedArray);

foreach ($combinedArray as $dt => $amt)
   print "$dt\t$amt\n";

answered Jan 8, 2020 at 19:15

Paul Lemmons

1124 bronze badges

2 Comments

SWARNADEEP PRAMANICK Over a year ago

can't do this in other manner like Ammount Date the amount the date

AbraCadaver Over a year ago

Sure you can. After $date = array_keys($combinedArray); $amount = array_values($combinedArray);. But why not just do it this way.

Collectives™ on Stack Overflow

Sorting array by date and another by that one in PHP

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related