Pass two or more URL parameters in a PHP/MySQL query

Question

This works:

searchR.php?status=pending

and this works:

searchR.php?status=rerun

but this doesn't (lists only "pending"):

searchR.php?status=pending&rerun

I am aiming to build a query that will list records from both terms ("pending" and "rerun")

What should the URL look like?

the ampersand signifies a new variable / parameter. What you have here is a parameter called rerun with no value — Professor Abronsius, Aug 02 '15 at 11:17
`searchR.php?status=pending&rerun` gives you `status=pending` and `rerun=null` — splash58, Aug 02 '15 at 11:17
you could perhaps restructure it so that the query has comma separated values and account for thetat in searchR.php. ie: `searchR.php?status=pending,rerun` — Professor Abronsius, Aug 02 '15 at 11:18
use like this searchR.php?status=2 ... and u can write code base on that in php — user1844933, Aug 02 '15 at 11:19
sampleIQ/searchR.php?status=pending&status=rerun lists only "rerun" — gungu, Aug 02 '15 at 11:22
you can write so `?status[]=b&status[]=c`. Will get you `$_GET['status'] = [a,b];` — splash58, Aug 02 '15 at 11:30
possible duplicate of [How to get PHP $\_GET array?](http://stackoverflow.com/questions/1833330/how-to-get-php-get-array) — stdob--, Aug 02 '15 at 11:35

score 0 · Answer 1 · answered Aug 02 '15 at 11:20

0

Use the ampersand to introduce a new variable and parameter to the url. example

searchR.php?status=$pending&rerun=$running

answered Aug 02 '15 at 11:20

Alexander Omoruyi

sampleIQ/searchR.php?status=pending&status=rerun lists only "rerun" – gungu Aug 02 '15 at 11:24
i am using $_GET['status'] – gungu Aug 02 '15 at 11:31

score 0 · Answer 2 · answered Aug 02 '15 at 11:36

0

searchR.php?status=pending&rerun

gives you status=pending and rerun=null

searchR.php?status=pending&status=rerun

gives the last value status=rerun

searchR.php?status[]=pending&status[]=rerun

will give ayrrya $_GET['status'] = [pending,rerun];

answered Aug 02 '15 at 11:36

splash58

but this requires array to string conversion which i prefer to avoid – gungu Aug 02 '15 at 11:52
But then what you want receive in script? – splash58 Aug 02 '15 at 11:55
what input will be undeerstanded by search script? – splash58 Aug 02 '15 at 12:04
$Recordset1 = $_GET['status']; $query_Recordset1 = ("SELECT * FROM table WHERE status = '$Recordset1' "); – gungu Aug 02 '15 at 12:33
No. what should be in status for some words - `a,b` or `a or b` or `a and b` or `a&b` ? – splash58 Aug 02 '15 at 12:35

score 0 · Accepted Answer · answered Aug 02 '15 at 13:01

0

the sending page

searchR.php?status=pending|rerun

the receiving page

$Recordset1 = $_GET['status']; 
$query = ("SELECT * FROM sampleOA WHERE status REGEXP '$Recordset1' ");

i used the "REGEXP" expression to achieve the objective in the question

answered Aug 02 '15 at 13:01

gungu

3 Answers3