PHP - How To Sort Array With Files On Date

ok so my problem is i need my data to be sorted by date which comes first.. how do i do it..can someone help me..if possible elaborate some codes? thxx..

so this is my program

Code: [Select]

<?
$b=$_GET['b'];
$m=$_GET['m'];
$y=$_GET['y'];

if  ($b <> '' && $m <> '' && $y <> '') {

$branch=$b;
$leavemonth=$m;
$leaveyear=$y;
}
else
{
$branch=$_POST['branch'];
$leavemonth=$_POST['leavemonth'];
$leaveyear=$_POST['leaveyear'];
}



$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


   
    $query="SELECT * from tblworkgroup";
    $result=mysql_query($query);?>


        &nbsp;&nbsp;Branch&nbsp;
        <select name="branch" >
<option value="all">ALL Branches</option>       
        <? while($row=mysql_fetch_array($result)) { ?>       
    <option value= "<?=$row['WorkGroupID']?>" <? if ($branch==$row['WorkGroupID']){ echo 'selected'; } ?> ><?=$row['WorkGroupName']?></option>
     <? } ?>
        </select>
           </td>
          </tr>
       <br><br><br>
  &nbsp;&nbsp;Month &nbsp;&nbsp;
<select name="leavemonth" >
<option value = "1" <? if ($leavemonth==1){ echo 'selected'; } ?>>January</option>
<option value = "2" <? if ($leavemonth==2){ echo 'selected'; } ?>>February</option>
<option value = "3" <? if ($leavemonth==3){ echo 'selected'; } ?>>March</option>
<option value = "4" <? if ($leavemonth==4){ echo 'selected'; } ?>>April</option>
<option value = "5" <? if ($leavemonth==5){ echo 'selected'; } ?>>May</option>
<option value = "6" <? if ($leavemonth==6){ echo 'selected'; } ?>>June</option>
<option value = "7" <? if ($leavemonth==7){ echo 'selected'; } ?>>July</option>
<option value = "8" <? if ($leavemonth==8){ echo 'selected'; } ?>>August</option>
<option value = "9" <? if ($leavemonth==9){ echo 'selected'; } ?>>September</option>
<option value = "10" <? if ($leavemonth==10){ echo 'selected'; } ?>>October</option>
<option value = "11" <? if ($leavemonth==11){ echo 'selected'; } ?>>November</option>
<option value = "12" <? if ($leavemonth==12){ echo 'selected'; } ?>>December</option>
</select>

&nbsp;&nbsp;
Year &nbsp;&nbsp;
<select name="leaveyear" >
<option value = "2010" <? if ($leaveyear==2010) { echo 'selected';} ?>>2010</option>
<option value = "2011" <? if ($leaveyear==2011) { echo 'selected';} ?>>2011</option>
<option value = "2012" <? if ($leaveyear==2012) { echo 'selected';} ?>>2012</option>
<option value = "2013" <? if ($leaveyear==2013) { echo 'selected';} ?>>2013</option>
<option value = "2014" <? if ($leaveyear==2014) { echo 'selected';} ?>>2014</option>
<option value = "2015" <? if ($leaveyear==2015) { echo 'selected';} ?>>2015</option>
<option value = "2016" <? if ($leaveyear==2016) { echo 'selected';} ?>>2016</option>
<option value = "2017" <? if ($leaveyear==2017) { echo 'selected';} ?>>2017</option>

</select>


  &nbsp;&nbsp;

<input type='submit' name='submit' value='Preview' Class="button" onclick='return validate()'>
   
   </div>

</form>


<br /><br />

<div id="box" valign="top">
                <h3>&nbsp;<strong>Leave Application Details</strong>&nbsp;&nbsp</h3>
<br><br>

                <table width="80%" align="center" >
<thead>
<tr>
<th width="700px" align="left">Name</a></th>
                           
<th width="800px" align="center"></a>Application Date</th>
                           
<th width="500x" align="right"></a>Reason</th>
</tr>
</thead>
<tbody>
<?
/*echo "branch:".$branch.'<br />';
echo "leavemonth:".$leavemonth.'<br />';
echo "leaveyear:".$leaveyear.'<br />';*/
//--------------------------------------------------
if ($leavemonth =='' ||  $leaveyear =='' || $branch == '') {
// one value missing, so don't display
}
else
{
// start display data
$branchtracker = '';

if ($branch=='all'){
$branch = '%';
}

$rs = mysql_query( " call vwleavereport('$leavemonth', '$leaveyear', $branch, 0);");
$query="SELECT *,
MONTH(tblleaveapplication.DateFrom) as DFMonth,
MONTH(tblleaveapplication.DateTo) as DTMonth,
YEAR(tblleaveapplication.DateFrom) as DFYear
FROM `tblleaveapplication`
LEFT JOIN `tblemployee`
ON tblleaveapplication.employeeid = tblemployee.id
WHERE WorkGroupID LIKE '".$branch."'
AND (
(MONTH(tblleaveapplication.DateFrom)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
OR
(MONTH(tblleaveapplication.DateTo)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
)
ORDER BY WorkGroupID
";

$result = mysql_query($query);
if ((mysql_num_rows($result))>0){
?>
<FORM name="printbutton" method="post" align="left" action="report_print.php" target="_blank">
<input type="hidden" name="leavemonth" value="<?php echo $leavemonth; ?>">
<input type="hidden" name="leaveyear" value="<?php echo $leaveyear; ?>">
<input type="hidden" name="branch" value="<?php echo $branch;?>">
<Input type = "Submit" Name = "Submit1" Class="button" VALUE = "Print Leave Details">
</form>
<?
while($row=mysql_fetch_array($result))
{
if ($branchtracker<>$row['WorkGroupID']){
echo '<tr><td colspan=4 style="background-color: #e8e8e8; font-weight: bold;">'.$row['WorkGroupID'].'</td></tr>';
$branchtracker = $row['WorkGroupID'];
}
echo '<tr>';
echo '<td>'.$row['EmployeeName'].'</td>';
echo '<td>'.$row['DateFrom'].'  -  '.$row['DateTo'].'</td>';
echo '<td>'.$row['Purpose'].'</td>';
echo '</tr>';
}
}
}
?>

I'm trying to pull data from a mysql db. I've stored data on the mysql with the date/time property. So How can I pull the mysql data by date/time?

I am retrieving data using AJAX. I would like to sort them from newest to oldest date. Currently they show from oldest to newest.

How do I do that?

<div id="output"></div>
<script>
  $(document).ready(function(){
    $.ajax ({
      type: 'GET',
      url: "https://3rdpartywebsite.com/api/getcustomers",
      dataType: 'json',
      success: function(data) {
       $.each(data, function(i, v) {

         var customerId 		   = v.customerId;
         var firstName 			   = v.firstName;
         var lastName  			   = v.lastName;
         var createdDateTime 	   = v.createdDateTime;

          $('#output').append('<ul class="output-ul">' + '<li>' + customerId + '</li>' + '<li>' + firstName + '</li>' + '<li>' + lastName + '</li>' +   '<li>' + createdDateTime + '</li>' + '</ul>');
       });
      }
    });
  });
</script>

 

I have designed a simple page to get meeting room details to display on our dashboards.

I would like to filter for today's date (start date) and then sort by room name (name) if possible:

(if you believe this could be written better (the server is on php 5.4) then also please let me know:

$ch = curl_init($url); 
   
//curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

$response = curl_exec($ch);
curl_close($ch);

$response = strip_tags($response);
$response = trim(preg_replace('/\s+/', ' ', $response));
$bookingArray = json_decode($response, true);
$timezone = date_default_timezone_get();

{
foreach($bookingArray["result"]["bookings"] as $booking)
{
echo
$booking["name"] 
. " - " .  
$booking["eventStatus"]["type"]
. " - ".
substr($booking["startDate"], -20)
. " - " .
substr($booking["endDate"], -20)
. " - " .  
$booking["eventName"]
. " - ".
$booking["primaryContact"]["givenName"]
. " " .
$booking["primaryContact"]["surName"]
. "<br>";
}
}

?>

</body>
</html>

Hello I am using a DOMDocument to retrieve information from an XML file. The information is setup like so:

<person>
<name>John Smith</name>
<born>March 15th, 1987</born>
</person>
<person>
<name>Eric Lee</name>
<born>July 18th, 1949</born>
</person>
<person>
<name>Michael Arnold</name>
<born>April 2nd, 2003</born>
</person>

At the moment I am displaying just the names of each of these groups on the page. How would I display the names of each of these people according to when they were born? (Youngest to oldest or oldest to youngest)

I believe it has something to do with strtotime() and sort() but can someone explain or give an example?

Hi,
I've done a search and cant find anything related to my problem.
I have a newsfeed on my site and i want it to display with the latest news at the top.
I have this code:
Code: [Select]
$get_news = "SELECT title, text, DATE_FORMAT(datetime, '%e %b %Y at %T') AS datetime FROM newsfeed ORDER BY datetime DESC";
This works fine on one of my sites but on another i've just hit a problem. It seems to sort only by the day, not the rest of the date.
I made a news post today with date and time of "27 Mar 2011 at 12:54:02" but a post from "28 Jan 2011 at 19:59:52" is above it.

Any ideas why this is happening?

Thanks,
Alex

Hello


I have a simple question about file handling...


Is it possible to list all files in directories / subdirectories, and then read ALL files in those dirs,
and put the content of their file into an array?

Like this:

array:
[SomePath/test.php] = "All In this php file is being read by a new smart function!";
[SomePath/Weird/hello.txt = "Hello world. This is me and im just trying to get some help!";

and so on, until no further files exists in that rootdir.

All my attempts went totally crazy and none of them works... therefore i need to ask you for help.


Do you have any ideas how to do this?
If so, how can I be able to do it?


Thanks in Advance, pros

Hi guys,

I'm trying to sort an array. The array has information about listings. ID, name, info etc.

An unrelated set of data also contains the listing ID's and I have made a function to sort this array and show an new order for the ID's. I now need to sort the original array by this new ID order...

This snippet shows that the original listings array can be sorted by link_id:
sort($this->links, $this->link->link_id); //This works. It sorts links by link ID!

In a foeach loop I have created this:
$sleeps_array[] = array("ID" => $link->link_id, "Sleeps" => $sleeps); // Makes an array of arrays of a custom field with listing ID.

It makes this:
array ( 0 => array ( 'ID' => '9', 'Sleeps' => '2', ), 1 => array ( 'ID' => '3', 'Sleeps' => '4', ), 2 => array ( 'ID' => '6', 'Sleeps' => '6', ), )

I can then sort this array of arrays with this function:

function compare_sleeps($a, $b){
return strnatcmp($a['Sleeps'], $b['Sleeps']);
} # sort alphabetically by name
usort($sleeps_array, 'compare_sleeps');

It then gives me a sorted array according to "Sleeps" (as in, the number of people a property can cater for). It has the correct order of ID to then output but how do I organise the original array by ID with this new array?

Sounds complicated, I hope you got that!

Cheers, RJP1

Is there a way to use sort($Array) on numbers but reverse it. So instead of 1 to 3 itll do 3 to 1 ? AKA descending order?

Can't find a function that would do unless theres a second sort function ?

Thanks

Why does krsort return the array as "1"?

Code: [Select]
$m = array('34' => 1122, '6' => 1944, '9' => 1710);
print_r($m); //outputs: Array ( [34] => 1122 [6] => 1944 [9] => 1710 )
print_r(krsort($m)); //outputs: 1

What i need is the output to be

Array ( [6] => 1944 [9] => 1710 [34] => 1122)

hi,

i'm trying to sort an array of associative arrays, based on one of the keys.

if the value of the key is a primitive, normal sorting occurs - this works fine.

if the value of the key is an array, i'd like to have it sorted by "groups"

here's an example:

Code: [Select]
<?php

$data[] = array('name' => 'h', 'list' => array(1,2));
$data[] = array('name' => 'g', 'list' => array(1));
$data[] = array('name' => 'a', 'list' => array(1,3));
$data[] = array('name' => 'f', 'list' => array(2));
$data[] = array('name' => 'e', 'list' => array(2,3));
$data[] = array('name' => 'b', 'list' => array(3));
$data[] = array('name' => 'c', 'list' => array(1,2,3,4));
$data[] = array('name' => 'd', 'list' => array(3,4));

function deep_sort($array, $sorton){

usort($array, function($a, $b) use($sorton) {

$a = $a[$sorton];
$b = $b[$sorton];

if(is_array($a) && is_array($b)){

// this bit is obviously flawed - only included for illustrative purposes
$a = implode('', $a);
$b = implode('', $b);

}

return ($a == $b) ? 0 : ($a > $b) ? 1 : -1;

});

return $array;

}

$sorted_by_name = deep_sort($data, 'name');

print '<pre>';

print_r($sorted_by_name);

print '</pre>';

$sorted_by_list = deep_sort($data, 'list');

print '<pre>';

print_r($sorted_by_list);

print '</pre>';

?>
the sorted_by_name bit is fine - but for sorted_by_list, what i want returned is all the array ordered as follows:

all those with "1" (or the lowest if none have "1") in it's list value first, then all those remaining that have the next highest ("2"), etc.

so right now, the returns for sort_by_list look like this:

Code: [Select]
Array
(
    [0] => Array
        (
            [name] => g
            [list] => Array
                (
                    [0] => 1
                )

        )

    [1] => Array
        (
            [name] => f
            [list] => Array
                (
                    [0] => 2
                )

        )

    [2] => Array
        (
            [name] => b
            [list] => Array
                (
                    [0] => 3
                )

        )

    [3] => Array
        (
            [name] => h
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                )

        )

    [4] => Array
        (
            [name] => a
            [list] => Array
                (
                    [0] => 1
                    [1] => 3
                )

        )

    [5] => Array
        (
            [name] => e
            [list] => Array
                (
                    [0] => 2
                    [1] => 3
                )

        )

    [6] => Array
        (
            [name] => d
            [list] => Array
                (
                    [0] => 3
                    [1] => 4
                )

        )

    [7] => Array
        (
            [name] => c
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                    [3] => 4
                )

        )

)whereas i'd like to get back:
Code: [Select]
Array
(
    [0] => Array
        (
            [name] => g
            [list] => Array
                (
                    [0] => 1
                )

        )

    [1] => Array
        (
            [name] => h
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                )

        )

    [2] => Array
        (
            [name] => c
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                    [3] => 4
                )

        )

    [3] => Array
        (
            [name] => a
            [list] => Array
                (
                    [0] => 1
                    [1] => 3
                )

        )

    [4] => Array
        (
            [name] => f
            [list] => Array
                (
                    [0] => 2
                )

        )

    [5] => Array
        (
            [name] => e
            [list] => Array
                (
                    [0] => 2
                    [1] => 3
                )

        )

    [6] => Array
        (
            [name] => b
            [list] => Array
                (
                    [0] => 3
                )

        )   

    [7] => Array
        (
            [name] => d
            [list] => Array
                (
                    [0] => 3
                    [1] => 4
                )

        )

)
TYIA for any suggestions

I've got a multidimensional array that has 2 columns.  The first column is numerical (country_id), and the second column is text (country_name), which may or may not be data that will be turned into an array. 

Looks something like this:

column 1 (index 0) = 42
column 2 (index 1) = Great Britain|England

I use a while loop to create an array of these rows, then a use a foreach loop to go through index[1] of each row.  If there is a single name for a country, it is added to a new array, but if there is more than one name for a country, then both names are added to the new array. So, for example, if we had this data:

row1
column 1 (index 0) = 12
column 2 (index 1) = Algeria

row2
column 1 (index 0) = 22
column 2 (index 1) = Ethiopia

row3
column 1 (index 0) =42
column 2 (index 1) = Great Britain|England

Then the final array would look like this:

index[0] = 12  index[1] = Algeria
index[0] = 22  index[1] = Ethiopia
index[0] = 42  index[1] = Great Britain
index[0] = 42  index[1] = England

Now I would like to sort by index[1] to get the following alphabetical order:

index[0] = 12  index[1] = Algeria
index[0] = 42  index[1] = England
index[0] = 22  index[1] = Ethiopia
index[0] = 42  index[1] = Great Britain

What do I use?  I've fooled around with sort, usort, asort ... can't figure it out.

Thanks in advance.

I have a bunch of PDF's, some of them having Uppercase first letters and some having lowercase first letters. Right now my code is alphabetizing all of the Uppercase first letters first then all of the lowercase. I want them to be mixed.

$dir = "../../forms/pdf/";
foreach(glob($dir.'*.pdf') as $pdf){
    $files[] = str_replace($dir, '', $pdf);
}

then:
<select name="current_pdf" id="current_pdf">
            <option value="">Please Select a PDF to replace</option>
            <?php
            foreach($files as $file) {
                echo "<option value=\"$file\">" . $file . "</option>";
            }
            ?>
            </select>

Hello,

Im struggling with this, probably because of my lack of fundamental knowledge of arrays.

What i want to do is:
make an array with two keys. 'id' and 'distance'.

I want to sort the results by distance, displaying the id's...

im looking at ksort() as the solution, however i don't think im implementing it properly as i dont think i have set the array up properly!!

what i have is not good...

Code: [Select]
<?php
while ($row = mysql_fetch_array($result)) {
//get the photographers postcode and split it into 2 pieces
$p_postcode = explode(' ',$row['address_post_code']);
//get the photographers postcode and split it into 2 pieces
$u_postcode_a = explode(' ',$u_postcode);
//run the two postcodes throught the function to determin the deistance
$final_distance = return_distance($u_postcode_a[0], $p_postcode[0]);
//start the variable so we can add to it later on
$photographers_inrange = "";
//declare this variable to help with the comma spacing too EDIT LOOK TO LINE 46
//$i2 = 1;
$photographers_inrange = array();
//if the distance is smaller or equal to the distance the photographer covers
if($final_distance <= $row['cover_distance']){
//get their id
$photographers_inrange['id'] = $row['ID'].',';
$photographers_inrange['distance'] = ''.$final_distance;
//echo $photographers_inrange;
//EDIT: this method does not work when just one result is returned. now i use substr -1.
//if this isnt the last result
//if($i++ <= $i2++){
//then add a comma for the sql statement
//$photographers_inrange .= ',';
//}
}

ksort($photographers_inrange);
foreach ($photographers_inrange as $key => $val) {
    echo "togs[" . $key . "] = " . $val . "<br/>";
}
 ?>
with $photographers_inrange being where it is, i am getting alot of empty arrays. not what i want.
i just need to know how to add to the original array, and how to then sort it.

thanks for your ongoing help!!

I've tried various sort methods on this array. And seem to be failing.
Code: [Select]
Array
(
    [monkey quest] => 8
    [monkey] => 2
    [monkey sports] => 0
    [monkey go happy] => 0
    [monkey go happy 3] => 1
    [monkey joes] => 0
    [monkey games] => 2
    [monkey bread recipe] => 1
    [monkey go happy 2] => 3
    [monkey quest trailer] => 4
    [monkey quest guide] => 5
    [monkey quest nick] => 6
)

What I want to do or attempt to do rather is sort the array by the => value from highest to lowest (or maybe in reverse as well, but one thing at a time)

My last failed attempt I was trying out usort() as my concept..
Code: [Select]
function cmp($a, $b)
{
    if ($a == $b)
{
        return 0;
    }
    return ($a < $b) ? -1 : 1;
}

echo "<pre>";
print_r(usort($kw, "cmp"));
echo "</pre>";

But the only thing I am left with on the page is just 1 everything else seems to be getting lost, or I dunno whats going on. So I think I've done stumped my self. Now I'm looking for idea's assuming I am tackling this all wrong.