Sort multi-dimensional array built from CSV data using PHP

Question

Trying to sort an array in PHP that is being populated from a CSV. I would also, ideally, LOVE to be able to control the sort by clicking on tabs in the table here .. Right now, though, my first task at hand is just sorting the damn thing.. been working on this for over 3 days now.. any help is GREATLY appreciated!! Cheers!

PHP

<?php 

$fp = fopen("https://spreadsheets.google.com/pub?key=0AjZgwY03sLMGdHVoWjhucGowWWJBb2g2NnQzVG9HZFE&hl=en&single=true&gid=0&output=csv","r"); 
$rows = array(); 
while (($row = fgetcsv($fp)) !== FALSE) { 
    $rows[] = $row; 
}
fclose($fp); 

$headers = array_shift($rows);
foreach ($rows as $row) : list($ShowKey, $ShowFeedURL, $ShowLink, $ShowIcon, $ShowTitle, $ShowTag, $ShowCategory, $ShowEps, $ShowLastUpdate, $ShowNew) = $row;

$oddpost = ( empty( $oddpost ) ) ? '_odd' : ''; ?>

I would look in to usort with a custom callback function.

Brad Christie
– Brad Christie

2010-12-07 18:43:36 +00:00
Commented Dec 7, 2010 at 18:43 — Brad Christie
– Brad Christie, Commented Dec 7, 2010 at 18:43

CrowderSoup · Accepted Answer · 2010-12-07 18:50:11Z

1

I recently did this. I had a multi-dimensional array of records from a database, and I needed to sort them based off of one specific column in the array. Here's what I did:

foreach($TimeRecords as $key => $value)
{
   $Rates[$key] = $value['rate'];
}
array_multisort($Rates, SORT_ASC, $TimeRecords);

I build an array of only the column I need, then I use the array_multisort() function to sort the array based off of that column.

You can write functions that will do this in PHP and then just call them with javascript ajax calls and reload that part of the page when it's done sorting.

answered Dec 7, 2010 at 18:50

CrowderSoup

1645 silver badges16 bronze badges

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

1 Comment

Dɑvïd Over a year ago

Ha! Seven years later and this was what I needed ... after hours of searching!

ChrisJ · Accepted Answer · 2010-12-07 18:48:52Z

0

Instead of sorting the table in PHP, you may consider doing it client-side in Javascript. For instance have a look at this jQuery plugin: http://tablesorter.com/

answered Dec 7, 2010 at 18:48

ChrisJ

5,28127 silver badges20 bronze badges

4 Comments

Ryan Over a year ago

wow, thanks chris.. I'm going to check into this right now.. I like it a lot and it looks pretty simple to implement. I'll let you know if this works for me..

Ryan Over a year ago

Table Sorter plugin is awesome but, after implementing it I realized that the odd/even colored rows will move as well so it breaks up the pattern I'm trying to achieve with the design.. nonetheless.. this plugin saves heaps of time and I've definitely bookmarked it.. Thanks!!

Ryan Over a year ago

I got it working, Chris! There is a widget called "Zebra" and it has to be activated via javascript and then the classes "odd" and "even" are added to TRs and TDs in the table automatically.. THANK YOU SO MUCH!!

ChrisJ Over a year ago

My pleasure :-) Good to hear it's useful to you.

Kel · Accepted Answer · 2010-12-07 18:43:30Z

0

You may find usort() function helpful. It accepts callback argument, which may be used for sorting by specific field.

answered Dec 7, 2010 at 18:43

Kel

7,8103 gold badges32 silver badges39 bronze badges

2 Comments

Ryan Over a year ago

Thank you, Kel -- I am quite a novice at PHP and tried using usort() but couldn't quite figure out how/where to implement it in my code. It almost seemed that array_multisort() would have been the better choice but again, couldn't figure out how to make it work. Do you know, does the " foreach ($rows as $row) : list (..." portion of my code define the data keys for each array within my master array?

Kel Over a year ago

array_multisort() may be used as well - see answer from CrowderSoup. I did not get the question about "foreach" portion of code. list() function just allows to assign values from array to bunch of variables at once. You may take a look at ru.php.net/manual/en/function.list.php for details.

NotJay · Accepted Answer · 2012-08-29 14:48:34Z

I had a similar issue to this today. Basically what I ended up doing is creating a temporary table which I loaded in the rows from the csv file that I needed. From there, I used php to sort and organize the data and update or add to the table I needed to alter.

Example, I made a table called 'temp' and loaded in all the rows of the category I needed. Then, once this was in the table, I made a php script which sorted the information by number of total sales in descending order. From there, I did a query to update my main table and used a limit to control this (only the top 200 items by number of sales).

It was very easy to do and hopefully it will help you or someone else.

Keep in mind. If you're going to do this more than once, you will need to truncate the temporary table to remove the old rows first.

Collectives™ on Stack Overflow

Sort multi-dimensional array built from CSV data using PHP

4 Answers 4

1 Comment

4 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related