Accessing data from URL query string

Question

How can I use query string variable in second page? For example in page 'a.php' I have generated these links

<?php
  echo '<a href="www.domain.com/b.php?id=1">Comedy</a>';
  echo '<a href="www.domain.com/b.php?id=2">Family</a>';
  echo '<a href="www.domain.com/b.php?id=3">Action</a>';

Now how I can use the id in page b.php to run a query on database like

 SELECT * FROM products WHERE id =

As you can see I need to pass the id getting from the URL query string at here

score 4 · Accepted Answer · answered Nov 24 '15 at 14:08

4

The ID will be in the $_GET variable:

$sql = 'SELECT * FROM products WHERE id = ' . (int)$_GET['id'];

answered Nov 24 '15 at 14:08

KiwiJuicer

1,952
14
28

score 2 · Answer 2 · answered Nov 24 '15 at 14:07

2

$id=$_GET['id'];

"SELECT * FROM products WHERE id = $id"

answered Nov 24 '15 at 14:07

Sugumar Venkatesan

4,019
8
46
77

Thanks Sugumar, do we have to use get? I mean we can't use POST here? – Mona Coder Nov 24 '15 at 14:09
if you pass the value by url you have use GET and if you use form with method post you can use POST. $_REQUEST[]; can be used for both get and post variables. – Sugumar Venkatesan Nov 24 '15 at 14:10
You are not posting, you are passing the variables via GET. You could also use $_REQUEST['id'], that would cover a POST too. – KiwiJuicer Nov 24 '15 at 14:10
Remember to cast (int) to make sure the value is an integer as @KiwiJuicer proposed. `$id = (int)$_GET['id'];` – KEK Nov 24 '15 at 14:15
thank you kek for notifying me – Sugumar Venkatesan Nov 24 '15 at 14:16

Accessing data from URL query string

2 Answers2