A switch between ascending and descending table rows on a tableheader click

A switch between ascending and descending table rows on a tableheader click



I've been messing with this for quite some time now, but I just can't get it to work. What I'm trying to make is ;



A clickable table header, that once clicked switches the row order from ascending to descending and back when clicked again.



The attempts I did so far didn't loop, and got stuck after one click.





How does this relate to PHP? Do you want to do the sorting on server-side? If not, then it's a JavaScript question and should be described as such.
– martynasma
Jul 2 '15 at 8:23





I'm voting to close this question as off-topic because Google has 1 million results for php javascript sort html table
– Hanky Panky
Jul 2 '15 at 8:24


php javascript sort html table





possible duplicate of Sorting HTML table with JS
– martynasma
Jul 2 '15 at 8:24





The thing is that I'm trying to do this without javascript. Just a switch that edits the query from ascending to descending and back on click.
– MTMaas
Jul 2 '15 at 8:32




1 Answer
1



Just add a link to your table header cell which contains a parameter, e.g.


<tr><th>
<a href="currentpage.php?order=<?php echo isset($_GET['order'])?!$_GET['order']:1; ?>">
Name
</a>
</th></tr>



What happens here? A link will be added, containing an order parameter which is set to the opposite of the current order value(1/true or 0/false) or to 1 as default.


order


order



In your PHP script you can now decide how to order your table using the order value:


order


$isAsc = isset($_GET['order'])? (bool) $_GET['order']: 1;



Now you can use the $isAsc boolean:


$isAsc


if ($isAsc)
// Sort data ascending
else
// Sort data descending



Or in a query:


$sql = "SELECT * FROM tabe ORDER BY name ".($isAsc?"ASC":"DESC").";";



Of course, you can extend this idea, e.g., by adding column names to sort by several columns.





Hello Andre, can you kindly help implementing this concept in this question? stackoverflow.com/q/45628071/3446280 thank you for any. But please note that my pages are already .php .
– Robert
Aug 11 '17 at 13:37



.php





Hi Robert. Rudy already updated the given solution, so it combines column and the sorting parameter. If you have further questions or the given solution still does not work for you, feel free to ask!
– André
Aug 15 '17 at 7:38






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

Help:Category

Image
Help:Category From Wikipedia, the free encyclopedia Jump to navigation Jump to search For guidelines on the use of categories in Wikipedia, see Wikipedia:Categorization. For a basic readers' guide see Help:Categories. For quick answers, see the readers' FAQ or the editors' FAQ on categories. For a list of categories, see Special:Categories. This is an information page. It describes the editing community's established practice on some aspect or aspects of Wikipedia's norms and customs. It is not one of Wikipedia's policies or guidelines, as it has not been thoroughly vetted by the community. Shortcut H:CAT Wikipedia data structure Namespaces Subject namespaces Talk namespaces 0 (Main/Article) Talk 1 2 User User talk 3 4 Wikipedia Wikipedia talk 5 6 File File talk 7 8 MediaWiki MediaWiki talk 9 10 Template Template talk 11 12 Help Help talk 13 14 Category Category talk 15 100 Portal Portal talk 101 108 Book Book tal...
Read more

How can temperature be calculated given relative humidity and dew point?

Image
How can temperature be calculated given relative humidity and dew point? While looking into the better indicator of how miserable it feels outside, either dew point or relative humidity, I came across this statement: The optimum combination for human comfort is a dewpoint of about 60 F and a RH of between 50 and 70% (this would put the temperature at about 75 F). Source: http://www.theweatherprediction.com/habyhints/190/ This led me to this calculator that will calculate the temperature given relative humidity and dew point - for example a dew point of 70 degrees F and a relative humidity of 90% results in a temperature of 73.11 degrees F. The web site for this calculator says the values are based on the August-Roche-Magnus approximation and gives the following equation to calculate temperature: $T =243.04 Large fracfrac17.625 TD243.04+TD-lnleft(fracRH100right)17.625+lnleft(fracRH100right)- frac17.625 TD243.04+TD$ Given the equation I'm still having a hard time figuring out...
Read more

I have a recursive function to validate tree graph and need a return condition

Image
I have a recursive function to validate tree graph and need a return condition I have a tree graph. Each node has attribute 'amount'. The rule governing the attribute value of root is this, The root 'amount' value is the sum of the 'amount' attribute of each of it's children. This continues to the last node with children. In other words this tree's attributes are unlike a sum tree, because the root node is not the sum of each node in the tree. Here is a toy example as graph G: nodedict = 'apples': 'amount': 5.0, 'bananas': 'amount': 10.0, 'tomato': 'amount': 50.0, 'total_fruits': 'amount': 15.0, 'total_vegetables': 'amount': 9.0, 'carrot': 'amount': 3.0, 'squash': 'amount': 6.0, 'total_fruits_and_vegetables': 'amount': 74.0 edgelist = [('total_fruits', 'apples'), ('total_fruits', 'bananas...
Read more