Writing MySql Where clause inside php foreach loop

Question

How to write mysql where clause inside php foreach loop. here is my code

$outPut = Array ( [0] => 'intel' [1] => 'amd' );
$Query = select * from laptop
foreach($outPut as $Filtervalues)
{
  $Query .= "where processor like '%$Filtervalues%'";
}

echo $Query;

But my output is not correct.

i want output to be as

select * from laptop where (processor like '%intel%' or processor like '%amd%')

@Armand i am getting out put as select * from laptop where processor like '%intel%' where processor like '%amd%' — Ragavendran Ramesh
– Ragavendran Ramesh, Commented Sep 27, 2013 at 12:14
@All: variables in php are case sensitive $outPut differs from $output I guess that's another mistake. — Christoph Diegelmann
– Christoph Diegelmann, Commented Sep 27, 2013 at 12:17

Adam · Accepted Answer · 2013-09-27 12:48:31Z

4

foreach not needed:

<?
$output = Array ( 'intel', 'amd' );
$Query = echo 'select * from laptop where processor LIKE \'%'.join($output,'%\' OR processor LIKE \'%').'\'%';
?>

Hope this helps

edited Sep 27, 2013 at 12:48

Adam

1,3712 gold badges11 silver badges12 bronze badges

answered Sep 27, 2013 at 12:21

Claude Janz

2202 silver badges4 bronze badges

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

1 Comment

bansi Over a year ago

if you use quotes properly you can avoid the backslashes and make code more readable.

xlecoustillier · Accepted Answer · 2013-09-27 12:25:02Z

1

You have to put the WHERE clause only for the first filter parameter:

$output = Array ( 'intel', 'amd' );
$Query = select * from laptop
$firsttime=true;

foreach($output as $Filtervalues)
{
    if($firsttime){
        $Query .= "where";
        $firsttime=false;
    }
    else
        $Query .= "or";

    $Query .= " processor like '%Filtervalues%' ";
}

echo $Query;

edited Sep 27, 2013 at 12:25

answered Sep 27, 2013 at 12:11

xlecoustillier

16.4k15 gold badges64 silver badges88 bronze badges

Comments

Adam · Accepted Answer · 2013-09-27 12:22:23Z

1

try this:

<?php 

$output = Array ( 'intel' , 'amd' );
$Query = 'select * from laptop where ';
foreach($output as $Filtervalues)
{
  $whereQuery .= "processor like '%".$Filtervalues."%' OR ";
}

echo $Query . substr($whereQuery, 0, -3);


?>

WORKING CODE

edited Sep 27, 2013 at 12:22

answered Sep 27, 2013 at 12:09

Adam

1,3712 gold badges11 silver badges12 bronze badges

3 Comments

Nadeem_MK Over a year ago

That will result to error if there's no $filterValues. The where should be added only if $filterValues has a count more than 0

Adam Over a year ago

@Nadeem_MK $output = Array ( [0] => 'intel' [1] => 'amd' ); count($output) = 2 -> NOT 0

xlecoustillier Over a year ago

@Adam ok, but you can't assume it will remain this way. If $outputwas to remain fixed, OP could as well hard code his query.

Christoph Diegelmann · Accepted Answer · 2013-09-27 12:27:42Z

1

Try the following:

$output = Array ( 'intel', 'amd' );
$Query = "select * from laptop ";

if(count($output)>0){
    $Query .= "WHERE";

    foreach($output as $Filtervalues){
        $Query .= " processor like '%$Filtervalues%' OR";
    }
    $Query = trim($Query, " OR");
}

echo $Query;

edited Sep 27, 2013 at 12:27

Christoph Diegelmann

2,03416 silver badges27 bronze badges

answered Sep 27, 2013 at 12:15

user2577405

855 bronze badges

Comments

Armand · Accepted Answer · 2013-09-27 12:34:09Z

1

Try this

$counter = 0;
$output = Array ( [0] => 'intel' [1] => 'amd' );
$Query = "select * from laptop ";
if(count($output) > 0)
     $Query .= " where ( ";
foreach($outPut as $Filtervalues)
{
    $counter++;
    $Query .= "processor like '%$Filtervalues%'";
    if($counter != count($output))
        $Query .= " or ";
    else
        $Query .= ")";
}

echo $Query;

edited Sep 27, 2013 at 12:34

answered Sep 27, 2013 at 12:07

Armand

10.3k9 gold badges46 silver badges77 bronze badges

6 Comments

Nadeem_MK Over a year ago

That will produce several where! Only 1 where should be added before the loop, in case $Filtervalues is not empty

Adam Over a year ago

parse erreor in line 3 :)

Nadeem_MK Over a year ago

That will result to error if there's no $filterValues. The where should be added only if $filterValues has a count more than 0

Christoph Diegelmann Over a year ago

@Nadeem_MK you mean $output.

Nadeem_MK Over a year ago

@Christoph Yeah sorry ;)

|

bansi · Accepted Answer · 2013-09-27 13:03:21Z

1

You could add all conditions to an array and just join its elements later.

$output = array ( 'intel', 'amd' );
$Query = 'select * from laptop';
$likes = array();
foreach($output as $Filtervalues)
{
  $likes[] = "processor like '%$Filtervalues%'";
}
if(!empty($likes))
    $Query .= ' where ('.implode(' or ', $likes) . ')';
echo $Query;

edited Sep 27, 2013 at 13:03

bansi

57.3k6 gold badges44 silver badges52 bronze badges

answered Sep 27, 2013 at 12:13

Nebril

8978 silver badges17 bronze badges

1 Comment

Nebril Over a year ago

@Christoph: Thanks for the edit. I prematurely submitted and was doing the same.

Collectives™ on Stack Overflow

Writing MySql Where clause inside php foreach loop

6 Answers 6

1 Comment

Comments

3 Comments

Comments

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

3 Comments

Comments

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related