PHP - Create And Add To An Array, Then Sort By A Key.

i need some help sorting my arrays. i have a class that selects data from database, and holds it inside a class to be used multiple times. rather then executing multiple queries. i know how to sort an array. but i am sorting arrays inside an array



$data = arrray(

array(

'id'=>1,

'_name'=>'Server A',

'_date_added'=>1298207645.5424,

);

array(

'id'=>2,

'_name'=>'Server B',

'_date_added'=>1298247384.4839,

);

array(

'id'=>3,

'_name'=>'Server C',

'_date_added'=>1298218493.0493,

);
);



i want to sort my array descending by key _date_added
hope you understand...

Hi, I have an array of type array_name[roll_number][aggregate_marks]. How do I sort such array on 'aggregate_marks'? My attempts on sort, asort haven't worked.

Hi freaks,

Got a simple one for ya, I THINK?

I have a multi-array that resembles this..
Code: [Select]
$_SESSION["book_array"] = array(0 => array("plantID" => $plantID, "botanicalName" => $botanicalName, "commonName" => $commonName, "use" => $use));

I would like to sort it by the botanicalName key of the inner array before I call the forech loop that renders the display so that after it renders the table the items will be seen alphabetically, code below..
Code: [Select]
<?php 
$bookOutput = "";
//$plant_use_array = '';
if (!isset($_SESSION["book_array"]) || count($_SESSION["book_array"]) < 1) {
    $bookOutput = '<tr><td colspan="4"><h6>Your Book is EMPTY!</h6></td></tr>';
} else {
// Start the For Each loop
$i = 0; 
    foreach ($_SESSION["book_array"] as $each_item) { 
$plantID = $each_item['plantID'];
$botanicalName = $each_item['botanicalName'];
$botanicalName = stripslashes($botanicalName);
$commonName = $each_item['commonName'];
$commonName = stripslashes($commonName);
$use = $each_item['use'];
//$x = $i + 1; 
// Dynamic table row assembly
$bookOutput .= "<tr>";
$bookOutput .= '<td><a href="plant_details.php?plantID=' . $plantID . '" id="bodyLink">' . $botanicalName . '</a></td>';
$bookOutput .= '<td>' . $commonName . '</td>';
$bookOutput .= '<td><strong>' . $use . '</strong></td>';
$bookOutput .= '<td><form action="book.php" method="post"><input name="removeBtn" type="submit" value="Remove"/><input name="index_to_remove" type="hidden" value="' . $i . '" /></form></td>';
$bookOutput .= '</tr>';
$i++; 
    } 
}
?>

Any help would be much appreciated!  Thanks in advance.

Hi, i have an issue to sort gallery photos by date. Right now its sort by Value (Name).   here is the code    index.php contains :  

<div>

	<?php foreach($categories_array as $photo_category=>$photos_array){?>
    
    	<?php 
		$category_thumbnail = $gallery_url."/layout/pixel.gif";
		if(file_exists('files/'.$photo_category.'/thumbnail.jpg')){
			$category_thumbnail = $gallery_url.'/'.$photo_category.'/thumbnail.jpg';
		}
		
		$category_url = $gallery_url.'/'.$photo_category;
		?>
        
  		<span class="category_thumbnail_span" style="width:<?php echo $settings_thumbnail_width;?>px; height:<?php echo $settings_thumbnail_height+20;?>px;">
        <a class="category_thumbnail_image" href="<?php echo $category_url;?>" style="width:<?php echo $settings_thumbnail_width;?>px; height:<?php echo $settings_thumbnail_height;?>px; background-image:url('<?php echo $gallery_url;?>/layout/lens_48x48.png');" title="<?php echo htmlentities(ucwords(str_replace('-', ' ', $photo_category)));?>">
        <img src="<?php echo $category_thumbnail;?>" width="<?php echo $settings_thumbnail_width;?>" height="<?php echo $settings_thumbnail_height;?>" alt="<?php echo htmlentities(ucwords(str_replace('-', ' ', $photo_category)));?>" />
        </a>
        <a class="category_thumbnail_title" href="<?php echo $category_url;?>" title="<?php echo htmlentities(ucwords(str_replace('-', ' ', $photo_category)));?>">
        <?php echo htmlentities(str_replace('-',' ', truncate_by_letters($photo_category, 16, '..')), ENT_QUOTES, "UTF-8");?> (<?php echo count($photos_array);?>)
        </a>
        </span>
    

	<?php } ?>

</div>

the sort function :

ksort($categories_array);

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 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.

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>

I have an array I want to define in Php and then sort it.
I am pretty new to Php and don't know the syntax or what funcs to use.

Here's the array I want:

user_email, user_name, hours_worked_per_week, total_earned

There will be about 120 users, and I want to sort them ascending alphabetically  on  user_email

I am running a script to retrieve numerical value from a webpage, the script echoes the numbers. However I need to add all the numbers to an array or txt file and then have them sorted from highest value to lowest value. Any hints or tips to how I would achieve this?

Hi all,

I have a multi-dimensional array looking somewhat like the following:


Array
(
    [0] => Array
        (
            [id] => 853
            [title] => item 853
            [price] => 17.99            
            [createdtime] => yyyy-mm-dd 00:00:00 
        )

    [1] => Array
        (
            [id] => 854
            [title] => item 854
            [price] => 11.99            
            [createdtime] => yyyy-mm-dd 00:00:00 
        )
...


I need to re-order this array so that any items with the 'createdtime' within a month from todays date are at the top, followed by all of the other items in the original order.  I would usually amend the sql but I need to do this with the array.

What would be the best way to do this? I found array_multisort but im not too sure how to adapt this to my needs.

Thank you for any help with this!

Hello , i am trying to sort a 2d dimensional array by the first column(id) and i havent find anything till now

This is my code for the 2d array:

$username = $_SESSION['username'];
$c = 0;

$row=1;
$col=1;
$users_array = array();
$get_from = mysql_query("SELECT id FROM my_activity WHERE from_user='$username'");
while($fetch1 = mysql_fetch_array($get_from)){
$id[$c] = $fetch1[0];
$get_from_user = mysql_query("SELECT * FROM my_activity WHERE id='$id[$c]'");
$get_user_rows = mysql_num_rows($get_from_user);
while($guser = mysql_fetch_array($get_from_user)){
$user[$c] = $guser['to_user'];
$users_array[$id[$c]][$user[$c]]= $id[$c].".".$user[$c];
$c++;
}


}

$get_to = mysql_query("SELECT * FROM my_activity WHERE to_user='$username'");
while($fetch2 = mysql_fetch_array($get_to)){
$id[$c] = $fetch2[0];
$get_to_user = mysql_query("SELECT from_user FROM my_activity WHERE id='$id[$c]'");
while($tuser = mysql_fetch_array($get_to_user)){
$user[$c] = $tuser[0];
$users_array[$id[$c]][$user[$c]]= $id[$c].".".$user[$c];
$c++;
}


}


This is what i get if i simply loop the array to get the result:

Code: [Select]
Array
(
    [6] => Array
        (
            [checkdate] => 6.checkdate
        )

    [25] => Array
        (
            [asdsadsad] => 25.asdsadsad
        )

    [7] => Array
        (
            [webuser] => 7.webuser
        )

    [9] => Array
        (
            [newuser] => 9.newuser
        )

    [10] => Array
        (
            [bot77un] => 10.bot77un
        )
)

I am trying to sort it by the ids 6,25,7,9,10 in DESC

Hi there.

I am trying to sort values in a combo box stored in an array. The array is written in t his way. Here this is in proper sorting:


 $WeightArray = array('' => '',
    '100gOrLess' => '100g or Less',
    '101g-250g' => '101g to 250g', 
    '251g-500g' => '251g to 500g',
    '501g-1kg' => '501g to 1kg',
    '1kg-2kg' => '1kg to 2kg',
    '2kg-3kg' => '2kg to 3kg',
    '3kg-4kg' => '3kg to 4kg',
    '4kg-5kg' => '4kg to 5kg',
    '5kg-6kg' => '5kg to 6kg',
    '6kg-7kg' => '6kg to 7kg',
    '7kg-8kg' => '7kg to 8kg', 
    '8kg-9kg' => '8kg to 9kg',  
    '9kg-10kg' => '9kg to 10kg',
    '10kg-11kg' => '10kg to 11kg', 
    '11kg-12kg' => '11kg to 12kg' 
    );


Now when I call this array and put in a combo it is displayed as shown in the Screenshot. It is displaying as, 10kg, 11kg 1kg ... in the incorrect order.

I tried few sort() functions but I am not able to sort the array as shown in the screenshot attached.

Kindly let me know how I can sort the values in the Combo box.

Thank you!!

I have a multidimensional array that I want to sort by "price" then by "date".  Here is an example of the array:
Code: [Select]
$productArray   = array ( array ("Bus", "1/1/2010", 15.99),
                                        array ("Train", "2/1/2010", 14.99),
                                        array ("Car", "3/1/2010", 18.00),
                                        array ("Plane", "3/1/2010", 15.99),
                                        array ("Bike", "3/1/2010", 9.99),
                                        array ("Truck", "1/1/2010", 19.99)
);
//sort by date
function sortElement1Asc($x, $y)
{
if ( $x[1] == $y[1] )
  return 0;
        else if ( $x[1] < $y[1] )
  return -1;
        else
  return 1;
}
//sort by price
function sortElement2Asc($x, $y)
{
if ( strtotime($x[2]) == strtotime($y[2]) )
  return 0;
else if ( strtotime($x[2]) < strtotime($y[2]) )
  return -1;
else
  return 1;
}
usort($productArray, 'sortElement1Asc');
usort($productArray, 'sortElement2Asc');

Unfortunately this is just sorting by price (or whatever i sort last).

Any ideas?

Hello,

I'm making a imagegallery and when someone upload a new image that image has to appear as first picture of the gallery.
I'm using an array for the files, but how can I sort the files on date, newest first.?

<?php
$n = 0;
$pathToThumbs = "images/tekeningen/";
$dir = opendir( $pathToThumbs );
while (false !== ($fname = readdir($dir))){
      
      // strip the . and .. entries out
     if ($fname != '.' && $fname != '..'){
     $tekeningen[$n] = $fname;
    } echo $tekeningen[$n]."<br />"; 
     $n = $n +1;
}
   closedir( $dir );
?>


I found solutions with ksort and filemtime, but I don't understand them and/or they didn't work for me.

Hi guys,
I'm just working on a script to get menu items from a database, sorted by a sort column. Each item needs to be checked to see if it has a parent, then paired with the parent.

Would it be best to get all of the items at once and pair them with PHP, or get the children of each item when as a separate array?

id label link parent sort 1 Home index.php 0 10 2 About about.php 0 20 3 Contact Us contact.php 2 10