sorting using php

Question

I brought all values from the db and showed them on a page. Now, if I click the column it should sort ascending or descending.

How do I do this?

Does your dataset fit into one page or it will be paginated? If so - do you want to sort whole dataset or one page only? — Your Common Sense
– Your Common Sense, Commented Jan 28, 2011 at 6:30
Please go through stackoverflow.com/search?q=sort+column+php and after that point out what you still have problems with. — Gordon
– Gordon, Commented Jan 28, 2011 at 8:57
possible duplicate of How can I sort by column header if clicked on and then sort in reverse order when clicked on again? — Gordon
– Gordon, Commented Jan 28, 2011 at 8:58

roflwaffle · Accepted Answer · 2011-01-28 06:17:16Z

4

If you want to do this solely in PHP you will need to add parameters onto the query string in the URL.

www.example.com/table.php?col=mycolumn&sort=desc

That would be in the anchor tag for that column, then in table.php you would have the logic to handle sorting.

answered Jan 28, 2011 at 6:17

roflwaffle

30.8k21 gold badges76 silver badges97 bronze badges

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

8 Comments

Your Common Sense Over a year ago

Remember not to put these values into query directly to avoid SQL injection

fddsf Over a year ago

Now ,i have bought them in anchor tag.How to pass them in query string

Your Common Sense Over a year ago

@fddsf here i posted an example: stackoverflow.com/questions/2993027/… there is only field name mentioned but for the direction the code would be all the same

Alfred Over a year ago

@Schrapnel this can be easily avoided by checking for desc and asc only. Even better would be to use PDO to avoid it altogether.

Alfred Over a year ago

@Col It has everything to do here. you started comment with SQL-injections. The best way to prevent that is to use PDO! the query-string could be unsafe(even to XSS).

|

sdleihssirhc · Accepted Answer · 2011-01-28 06:15:57Z

0

You'll be using JavaScript. I suggest sorttable.

answered Jan 28, 2011 at 6:15

sdleihssirhc

42.6k6 gold badges56 silver badges67 bronze badges

4 Comments

Your Common Sense Over a year ago

JS has very limited use, just for one-page sized datasets

sdleihssirhc Over a year ago

@Col. What does "one-page" mean? That there would be so many tr elements to keep track of, JavaScript just isn't feasible for larger datasets?

Your Common Sense Over a year ago

mean like Stackoverflow. there are many pages with questions and no browser can hold them all - so, for each another page another request to the server being made. and to sort all questions in another direction will require another request to the server as well

sdleihssirhc Over a year ago

@Col. I still don't understand. Why are pages an issue at all? Wouldn't the table be a single table element on a single page? Are you talking about a paginated table with lots and lots of rows in it?

Chris Pennycuick · Accepted Answer · 2011-01-28 08:22:30Z

0

Expanding on roflwaffle's post, you will want to use query string vars. From these build a string which you add into your query.

$querySort = array();
if (isset($_GET['colName'])) {
    $s = $_GET['colName'];
    $snext = '';
    switch ($s) {
        case '':     $snext = 'desc'; break;
        case 'desc': $snext = 'asc';  break;
        case 'asc':  $snext = ''; break;
        default:     $snext = '';
    }
    if (!empty ($snext)) {
        $querySort[] = "colName $snext";
    }
    $colName_link = "colName=$snext";
    $colName_text = $snext;
}

// Further column checks

if (count($querySort) == 0) {
    // Default sort if no sort is given.
    $querySort[] = "colName asc";
}

$sort = implode (', ', $querySort);

$query = mysql_query ("SELECT * FROM table ORDER BY $sort");

So given the following query string,

www.example.com/table.php?colName=desc

the query would look like this

SELECT * FROM table ORDER BY colName desc LIMIT 0, 15

and the category link would look like this

echo "<a href='?$colName_link'>Column Name</a> <small>$colName_text</small>";

edited Jan 28, 2011 at 8:22

answered Jan 28, 2011 at 7:14

Chris Pennycuick

3371 silver badge4 bronze badges

6 Comments

fddsf Over a year ago

@Gutter ball.i need to do asce or descen by clicking column header

Chris Pennycuick Over a year ago

@fddsf make the column header a hyperlink.

fddsf Over a year ago

@Gutter ball:I have done it but what php code to pass through the link.

Chris Pennycuick Over a year ago

@fddsf I have edited my post so that hopefully its a little more helpful for you. The code for the link is at the end of my example.

Your Common Sense Over a year ago

It seems the task is too hard for him :) You have to either write and test whole code, or give up :) One have to have some basic knowledge on web-development before asking such questions.

|

Alfred · Accepted Answer · 2011-01-28 09:50:37Z

0

The best way to do this is by using javascript(no need to refresh page). Yahoo!'s YUI3 has a very nice datatable component. I can not make up from your question if you got the complete dataset on your PHP page but I will assume this for now. You should have a look at YUI3's Column Sorting page to get you started.

edited Jan 28, 2011 at 9:50

answered Jan 28, 2011 at 9:13

Alfred

62k33 gold badges151 silver badges186 bronze badges

2 Comments

Your Common Sense Over a year ago

Wow! Do you have such a short users list that it fits into just one page? My condolences ;)

Alfred Over a year ago

Lol Okay maybe not such a good example :P. I think I should remove the query altogether ;)

enam · Accepted Answer · 2011-01-28 11:34:17Z

0

Please take a look at THIS link.Check the Example HERE. I use it in one of my project for the same purpose , hope it will help you too.

answered Jan 28, 2011 at 11:34

enam

1,1771 gold badge10 silver badges24 bronze badges

Comments

Mark · Accepted Answer · 2011-01-28 06:57:32Z

-3

request: www.example.com/table.php?col=mycolumn&sort=desc

//may be some check , about the column is in  the table field
//sort is in the set of (asc , desc)

$q = "select * from mytable where mycond order by addslashes($_GET['mycolumn']) addslashes($_GET['sort'])";

answered Jan 28, 2011 at 6:57

Mark

11 bronze badge

2 Comments

Logan Bailey Over a year ago

Shouldn't use addslashes, should use prepared statements

Your Common Sense Over a year ago

@Logan Bailey LOL! Are you sure you understand the question?

Collectives™ on Stack Overflow

sorting using php

6 Answers 6

8 Comments

4 Comments

6 Comments

2 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

8 Comments

4 Comments

6 Comments

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related