PHP sort tables with click and on another click sort reverse

Question

I want to sort my table by clicking a header of my table, I have already figured out how to do that here : How to sort rows of HTML table that are called from MySQL

However I am wondering, is there away, that by clicking a second time on that button, the sort will go reverse and by clicking a third time back to normal, etc ?

Set a boolean GET/POST variable that will adjust the order of your query. Dynamically set the link/submit depending on the boolean value as well. — Josh, Jul 22 '11 at 16:01

score 3 · Accepted Answer · edited Jan 13 '14 at 13:21

This can be done like this:

switch($_GET['dir']){

  case "asc":
    $orderBy = " ORDER BY colName ASC"
    break;

  case "desc":
    $orderBy = " ORDER BY colName DESC"
    break;

  default:
    $orderBy = " ORDER BY colName ASC"
    break;
}

$sql = "SELECT FieldNames from MyTable" . $orderBy;

Then you just provide a link with a querystring changing the dir item each time. So your link would become:

<a href="myFile.php?dir=asc">Order ascending</a>

or

<a href="myFile.php?dir=desc">Order descending</a>

Hope this helps.

score 2 · Answer 2 · edited Jan 13 '14 at 13:19

2

You can do this by sending an attribute in url sort=asc , sort=desc. And in php: if($_GET['sort']='asc') sort must be desc. Else sort must be asc.

www.example.com?sort=asc

edited Jan 13 '14 at 13:19

aksu

5,221
5
24
39

answered Jul 22 '11 at 16:03

Emil Condrea

9,705
7
33
52

score 2 · Answer 3 · answered Jul 22 '11 at 16:13

2

Well, if you only want to sort the table then you don't have to reload the page (which might be relatively slow) - there is options to do it client side using JavaScript, ie SortTable by Stuart Langridge

answered Jul 22 '11 at 16:13

ain

22,394
3
54
74

score 1 · Answer 4 · answered Jul 22 '11 at 17:18

1

Consider using DataTables, it is very handy.

answered Jul 22 '11 at 17:18

Tomas

57,621
49
238
373

score 0 · Answer 5 · edited May 23 '17 at 11:55

0

Exactly what you want, is here

https://stackoverflow.com/a/15827728/2220389

with the first click, your table will be sorted ascending, with another click - descending.

edited May 23 '17 at 11:55

Community

1
1

answered Apr 05 '13 at 07:02

T.Todua

53,146
19
236
237

score 0 · Answer 6 · answered Jul 22 '11 at 16:08

Best way is to change the anchor in header using a JS link:

if(/* current sorting is asc */) {
  document.write("<p>Type".link("mypage.php?sort=desc") + "</p>");
}else if(/* current sorting is desc */) {
  document.write("<p>Type".link("mypage.php?sort=normal") + "</p>");
}else if(/* current sorting is normal */){
  document.write("<p>Type".link("mypage.php?sort=asc") + "</p>");

PHP code will remain the same as in the previous question You asked at SO.

PHP sort tables with click and on another click sort reverse

6 Answers6