How to get selected category id after 1st page in pagination?

Answer 1

Do you pass though category in the request? You haven't given us that information (what is the value of qstr in the javascript?), but I'd guess not.

You're also passing it straight into an SQL query, which leaves you open to injection.
You should use mysql_escape_string() to fix that.

Answer 2

• Post it with the AJAX call and return it
• Store it in a local JS variable
• Add it to the URL
• ...

Answer 3

You seem to be aware that $_GET['p'] gets the value of the 'p' parameter passed in the querystring. Well $_REQUEST['category'] is doing the same thing. (Technically $_REQUEST checked everything in $_POST, $_GET and $_COOKIE).

So if you haven't set the 'category' in the querystring then it wont contain anything in your code.

Answer 4

1. You should add ?category=XXX&sid=RAND... to your url
2. Better use $category = isset($_GET['category']) ? (int)$_GET['category'] : 0;