Link structure for sorting an HTML table built using PHP

Question

I appreciate any help I can get with this problem:

I have 2 search forms, one does a keyword search and the other does a search by country, state and city (with an input for each)
The results are output to a table. The header row contains a link for sorting each column.
Problem is I don't know how to build my GET url string for sorting and assign them to the links in the headers

Here is some code to get started (I am using MVC)

Functions

function searchkeyword()
{
    /* get keyword an query and output paginated result */
}

function searchcategory()
{
    /* get categories and query and output paginated result */
}

function sort()
{
    $sortby = $_GET['sortby'];
}

function paginate()
{
}

View

<th>
    <a href="sort.php?XXXX">Sort Column</a>
</th>

I'm not sure what should go in XXXX to sort the results.

@Ygam: what did you tried so far, look to me to a give me the code question ... — RageZ
– RageZ, Commented Nov 20, 2009 at 5:13

Brandon Henry · Accepted Answer · 2009-11-20 05:35:11Z

1

if you want it to fit in $sortby = $_GET['sortby']; then you will need to use:

sort.php?sortby=param

where param is any of the possible sortby fields.

make sure that before putting this an any sql order by you check it yourself, so you don't get errors or attacks. ie:

switch $sortby:
    case 'city':
        $sort_string = 'ORDER BY `city`;
    ...

answered Nov 20, 2009 at 5:35

Brandon Henry

3,7492 gold badges27 silver badges32 bronze badges

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

Comments

wallyk · Accepted Answer · 2009-11-20 05:30:19Z

0

Do you have to use the server to perform the sort? You could do it in Javascript on the client.

For an example, see any Wikipedia article which allows table sorting, such as this.

answered Nov 20, 2009 at 5:30

wallyk

58.1k17 gold badges92 silver badges155 bronze badges

1 Comment

yretuta Over a year ago

yes that is true but I want to try it the non-JS way...in the office they are strict with the concept or progressive enhancements:)

Collectives™ on Stack Overflow

Link structure for sorting an HTML table built using PHP

Functions

View

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Functions

View

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related