Query in PHP with 'and' or 'or' as variable

Question

I would like to do search for advanced search. The Search feature has and/or for every category. User can choose any combination of and n or. Here i give the screenshot

I store the and/or into variable call $pil, $pil1,$pil2 and $pil3. And will put them in query. it's better than validate one by one every condition of and/or

So this is my query using postgresql in PHP

$query = pg_query("SELECT   evaluationdate,onlinename,channel,topik,reviewername,sourceevaluation,evaluation 
from AgentPerformance 
where onlinename like '%".$VEOn1."%'
".$pil." reviewername like '%".$VERev1."%' 
".$pil1." channel like '%".$VEChan1."%' 
".$pil2."sourceevaluation like '%".$VESource1."%'
".$pil3."evaluationdate between '".$VEStart1."' and '".$VEEnd1."'");

EDIT :

The problem now, All the variables must not be empty or the query will be error. any way to trick this?

may be your `$pil` or any variable will be empty. Have you checked this ? — jitendrapurohit, Dec 30 '15 at 07:21
geez. that's the problem. they all must be chosen. cant be empty. i'll update the question — Elbert, Dec 30 '15 at 07:35

score 2 · Accepted Answer · edited Feb 26 '16 at 05:58

2

You've missed some spaces near sourceevaluation and evaluationdate
Try with this query :

$query = pg_query("SELECT   evaluationdate,onlinename,channel,topik,reviewername,sourceevaluation,evaluation 
from AgentPerformance 
where onlinename like '%".$VEOn1."%'
".$pil." reviewername like '%".$VERev1."%' 
".$pil1." channel like '%".$VEChan1."%' 
".$pil2." sourceevaluation like '%".$VESource1."%'
".$pil3." evaluationdate between '".$VEStart1."' and '".$VEEnd1."'");

edited Feb 26 '16 at 05:58

marc_s

732,580
175
1,330
1,459

answered Dec 30 '15 at 07:29

Halayem Anis

7,654
2
25
45

U re right. it helps. But the main problem hasnt been solved – Elbert Dec 30 '15 at 07:36
I will validate them. Thank for ur help – Elbert Dec 30 '15 at 07:46

score 0 · Answer 2 · answered Dec 30 '15 at 07:45

0

Simply. Use validation for each $pil whether it is empty or not. it makes me validate 4 times, but it solves the problem. The syntax error has been solved too

answered Dec 30 '15 at 07:45

Elbert

516
1
5
15

you can use this to verify `$pil1...$pilN` variables: `for($i=1 ; $i<4 ; $i++) { if (empty(${"pil" . $i})) { print "pil" . $i . " is empty "; } }` – Halayem Anis Dec 30 '15 at 07:54

Query in PHP with 'and' or 'or' as variable

2 Answers2