My API written in PHP (Codeigniter) outputs users based on a selected keyword how can I sort this array in alphabetical order before it outputs to JSON.
This is the output:
Thankful for all input!
3
-
Why not sorting it directly in your query at Model?toopay– toopay2011-08-20 18:22:19 +00:00Commented Aug 20, 2011 at 18:22
-
I cannot. The array is a combination of different queries.Jonathan Clark– Jonathan Clark2011-08-20 20:31:12 +00:00Commented Aug 20, 2011 at 20:31
-
I need to sort by first name.Jonathan Clark– Jonathan Clark2011-08-22 06:10:39 +00:00Commented Aug 22, 2011 at 6:10
Add a comment
|
2 Answers
This one works. Tried, tested, and true:
function sort_by_lastname($a, $b) {
$a = trim($a['user']['basic'][0]['lastname']);
$b = trim($b['user']['basic'][0]['lastname']);
return strcmp($a,$b);
}
uasort($array['contacts'],'sort_by_lastname');
2 Comments
RiaD
You may use strcmp instead of two-times comparation
SeanCannon
@RiaD thanks, forgot that it also returned 0 when equal. Code updated.
You can use usort for this: http://php.net/manual/en/function.usort.php
Which enables you to sort using your own function.
Example:
$users = $your_array['contacts'];
// or $users = $your_array->contacts;
usort ($users, 'sort_by_lastname');
$your_array['contacts'] = $users;
// or $your_array->contacts = $users; if it's json instead of array
function sort_by_lastname($a, $b)
{
return strcmp($a['user']['basic']['lastname'], $b['user']['basic']['lastname']);
}
8 Comments
Jonathan Clark
Sounds very interesting! I have looked a bit on it and I cannot construct a function that works with my array. Is it possible that you can show me how to use it?
Jonathan Clark
Can I place the sort_by_lastname function in a helper and then use usort function in the controller? How can I use the code? I get error: Use of undefined constant sort_by_lastname - assumed 'sort_by_lastname'.
Jonathan Clark
Still having problems I´m afraid.
PeeHaa
@Jonathan Clark: perhaps it's best if we go to chat to see what the problem is
RiaD
why not just
usort ($your_array['contacts'], 'sort_by_lastname'); ?? |