473,322 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

print order of assoctive array



Ive got a series of 2 dimensional associative arrays
while(list($key, $val) = each ($results))
{
{foreach($val as $i=>$v)
print "$i = $v";
}
}
but i want to define the order that the various $i's are printed in
(not numerical/alphabetically)

arrays named
"key1_sorted_order" = keys in the order to be printed
"key2_sorted_order"

ive been experimeting with

while(list($key, $val) = each ($results))
{
{foreach($val as $i=>$v)
$ks=$i.'_sorted_order';
($cntr=0;cntr<count($ks);$cntr++ )
{ print [$ks[$cntr]] =$results[$val[$ks[$cntr]]]
}
}
}

anyone able to help me out ?

Dec 2 '05 #1
7 2135
pauld wrote:


Ive got a series of 2 dimensional associative arrays
while(list($key, $val) = each ($results))
{
{foreach($val as $i=>$v)
print "$i = $v";
}
}
but i want to define the order that the various $i's are printed in
(not numerical/alphabetically)

arrays named
"key1_sorted_order" = keys in the order to be printed
"key2_sorted_order"

ive been experimeting with

while(list($key, $val) = each ($results))
{
{foreach($val as $i=>$v)
$ks=$i.'_sorted_order';
($cntr=0;cntr<count($ks);$cntr++ )
{ print [$ks[$cntr]] =$results[$val[$ks[$cntr]]]
}
}
}

anyone able to help me out ?


Hi,

I just wrote a similar routine yesterday. :-)
Try this:

Move every element in your array to a new array, using an assoc-index of
your choice, and thus defining the ordering.
ksort ($newarray)

Works like a charm.

If the default ksort is not to your liking, use uksort.

Good luck

Regards,
Erwin Moller
Dec 2 '05 #2
Erwin Moller wrote:
Move every element in your array to a new array


Why? Just apply uksort to $val (the 2nd level array).

--
E. Dronkert
Dec 2 '05 #3
I read that but couldnt see how to apply it

the keys in the assoc array and the order id like then to appear are
('21', 'NC2', 'NC4', '28', '35', '40', '50', '60', '80', '100')

( if you are interested its the % oxygen you can administer )

Dec 2 '05 #4
pauld wrote:
the keys in the assoc array and the order id like then to appear are
('21', 'NC2', 'NC4', '28', '35', '40', '50', '60', '80', '100')


$oxchr = array('21', 'NC2', 'NC4', '28', '35', '40', '50', '60', '80',
'100');
$oxord = array_flip($oxchr);

function oxkeysort($k1, $k2) {
global $oxord;
return $oxord[$k1] - $oxord[$k2];
}

uksort($val, 'oxkeysort');

--
E. Dronkert
Dec 2 '05 #5
Ewoud Dronkert wrote:
Erwin Moller wrote:
Move every element in your array to a new array


Why? Just apply uksort to $val (the 2nd level array).


Hi Ewoud,

Yes, you are right.

The situation I was describing was an array with a complex structure per
element that it contained (more arrays actually, but complex sounds so
great).

The underlying arraystructure differed from element to element.

For some stupid reason I thought the function called by uksort could only
operate on single simple values, which turned out to be nonsense.
(I guess I guessed wrong, based on my experiences with Java, where that
logic is just implemented a little differently for sorting.)

I reread the uksort-function, and the function used just receives the
elements, which can be used to look deeper into their arrays.

Anyway, I got it now.
I will be using uksort a lot more now, so thanks.

You just made my life a little easier (and my code a little faster).
:-)

Regards,
Erwin Moller
Dec 2 '05 #6
thanks -great help. Got the first one working not sure i quite
understand it though (!)
the added problem is that I have a series of these and would ideally
like to to generate the array name dynamically.The array_push is an
attempt to make the code generic

eg for 2 of them I can do

if ($key=="oxy") {
foreach($oxysorted as $v)
{array_push($sorted,$v);}
$oxord = array_flip($sorted);
uksort($val, 'keysort');
print '<table summary="" border=2>';
foreach($val as $i=>$v){print '<tr><td>'.$i."=>".$v.'</td></tr>';
}
}
else if ($key=="physio") {
foreach($physiosorted as $v){array_push($sorted,$v);}
$oxord = array_flip($sorted);
uksort($val, 'keysort');
print '<table summary="" border=2>';
foreach($val as $i=>$v){print '<tr><td>'.$i."=>".$v.'</td></tr>';
}
}

Ive tried genertign the array name dynamically but it doesnt revognise
it as an array
eg
$varsorted=$key.'sorted';
and replacing the ($oxysorted as $v) and ($physiosorted as $v) with
($varsorted as $v) but it doenst like it .

I *think* its the php equivalent of perls $$variable that Im after

Dec 13 '05 #7
pauld wrote:
the added problem is that I have a series of these and would ideally
like to to generate the array name dynamically.


First an explanation of what I wrote earlier:

$oxchr = array(
'21', 'NC2', 'NC4', '28', '35', '40', '50', '60', '80', '100');
$oxord = array_flip($oxchr);

function oxkeysort($k1, $k2) {
global $oxord;
return $oxord[$k1] - $oxord[$k2];
}

uksort($val, 'oxkeysort');

The $oxchr array contains all the keys of the array that you want sorted,
in the order that you want them sorted. Not shown but implied by omitting
them are the numerical keys of the $oxchr array, from 0 for '21' to 9 for
'100'. 'Flipping' an array means switching each key-value pair. So $oxord
contains array('21' => 0, 'NC2' => 1, ..., '100' => 9). I loaned the
variable names from the chr() and ord() functions because $oxchr[1] gives
'NC2' while $oxord['NC2'] gives 1, much the same as chr(65) is 'A' and
ord('A') is 65. It means you can determine the order of the oxygen label
keys by accessing the $oxord array. The oxkeysort() function does just
that by returning the difference between two $oxord values. Zero means
that the same key was used, negative means that the first was smaller than
the second (ie. already sorted in ascending order) and positive the
reverse: 1 was bigger than 2, must be swapped for ascending order.
Finally, the uksort() function puts it to good use by sorting the $val
array using the supplied function for comparing the keys of $val, those
keys being the same oxygen labels defined as values in $oxchr.

Now, if you want to have more user defined sorting orders, my first
instinct would be to expand the chr and ord arrays to 2 dimensions:

$mychr = array(
'oxy' => array(
'21', 'NC2', 'NC4', '28', '35', '40', '50', '60', '80', '100'),
'physio' => array(
'John', 'Joe', 'Anne', 'Marie'));
$myord = array();
foreach ($mychr as $k => $v)
$myord[$k] = array_flip($v);

So $mychr['oxy'] is the same as $oxchr previously, likewise $myord['oxy']
and $oxord. In addition, you now have $myord['physio'].

My second idea would be to maintain the idea of my first code snippet: to
use a global variable in the user defined sort function for accessing the
sort order. But that order can now be different each time. So use a
"pointer" to the currently used one:

$curord = 'oxy';
function mykeysort($k1, $k2) {
global $myord, $curord;
return $myord[$curord][$k1] - $myord[$curord][$k2];
}

Or perhaps one level up for slightly simpler code inside the function,
although speed of execution could go either way depending on size of the
arrays and calling frequency of the different functions:

$curord = $myord['oxy'];
function mykeysort($k1, $k2) {
global $curord;
return $curord[$k1] - $curord[$k2];
}

Of course, the global $curord need not be set right away. Each time before
you call uksort(), first set the appropriate sort order:

$curord = 'oxy'; //or $curord = $myord['oxy'];
uksort($val, 'mykeysort'); //$val contains oxygen label keys

$curord = 'physio'; //or $curord = $myord['physio'];
uksort($val, 'mykeysort'); //$val contains physio label keys

As you can see, the function name inside uksort() doesn't change. You must
update $curord each time though, which I think you can do "dynamically".

--
E. Dronkert
Dec 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ricki Susic | last post by:
Hi, Can anyone help me to get my query printed when I parse ID. Here is the code: FILE: udskriv.php <?php
1
by: Sue Adams | last post by:
I have a form on an asp page and am trying to write the code to place the values of all checkboxes that have been selected, into an array. The checkbox values will be used in a dynamic sql statement...
8
by: vijay | last post by:
Hello, As the subject suggests, I need to print the string in the reverse order. I made the following program: # include<stdio.h> struct llnode { char *info;
1
by: Steff | last post by:
I am wandering if my code is making sense... I use a lot the print function. Is it weird in this case where I have to display an array ? I thought it would be better to have the entire array in php...
3
by: Eric Lilja | last post by:
Assignment: Create a 3x4 2-dimensional array of integers. Populate each element using some non-random scheme so that no two elemens contain the same value. Then create two functions for printing...
3
by: James J. Besemer | last post by:
I would like to champion a proposed enhancement to Python. I describe the basic idea below, in order to gage community interest. Right now, it's only an idea, and I'm sure there's room for...
22
by: joshc | last post by:
In an interview for an embedded software position recently I was asked to write code, in C, for printing the contents of a linked list backwards. After a few minutes I came up with the recursive...
1
by: Alan G | last post by:
I'm grateful for any help here! My program is generally quite a simple problem; must read in a list containing names and numbers and print it out like a phonebook in alphabetical order, in order...
6
by: mattmao | last post by:
Okay, this is just my exercise in order to prepare for the coming assignment regarding the damned Linked List issue... The task is simple and I am about to finish it. However, I couldn't go around...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.