multiple values in like query mysql php

Question

I have this code:

<?php 
$agenti = $_GET['agenti'];
$agen = array();
if (is_array($agenti)) {foreach($agenti as $val) { $agen[] = "ch.employeename LIKE '" . $val . "'"; }} else {$agen[] = 'true';}

    $raw_results = mysql_query("SELECT distinct ch.employeename, ch.customername, 
                                       ch.customerowner, ch.QuestionnaireName, ch.parentgroupname,
                                       ch.groupname, ch.visitdate from chestionare ch
                                    WHERE ch.visitdate >= '".$_GET['from']."' AND ch.visitdate <= '".$_GET['to']."' 
                                    AND (" . implode(' OR ', $agen) . ")
                                    AND ch.customerowner like '$clienti' 
                                    AND ch.class like '$task' 
                                    AND ch.parentgroupname like '$categorie' 
                                    ") 
                                or die(mysql_error());

    if(mysql_num_rows($raw_results) > 0){ 
        while($results = mysql_fetch_array($raw_results)){ ?>

What can I do if $agenti has multiple values (60 values). Values came from another file with <select multiple="multiple"> <option value="test"> test </option>< /select>

Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement — mickmackusa
– mickmackusa ♦, Commented Jun 27, 2022 at 21:26

Paul · Accepted Answer · 2014-05-12 11:51:29Z

3

If $agenti is dynamic array. Simple example :

$agen = array();

foreach ($agenti as $val) {
    $agen[] = "ch.employeename like '" . $val . "'"; 
}

$raw_results = mysql_query(
           "SELECT distinct ch.employeename, ch.customername, 
               ch.customerowner, ch.QuestionnaireName, ch.parentgroupname,
               ch.groupname, ch.visitdate from chestionare ch
            WHERE ch.visitdate >= '".$_GET['from']."' AND ch.visitdate <= '".$_GET['to']."' 
            AND (" . implode(' OR ', $agen) . ")
            AND ch.customerowner like '$clienti' 
            AND ch.class like '$task' 
            AND ch.parentgroupname like '$categorie' 
         ");
or die(mysql_error());

answered May 12, 2014 at 11:51

Paul

7852 gold badges14 silver badges22 bronze badges

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

4 Comments

zmeul Over a year ago

hi paul. can you help me with your script, it dosen't return results. i have modified the foreach like this: if(is_array($agenti)) { .... } but still nothing.

Paul Over a year ago

@rozatrra if(is_array($agenti)) { .... } else {$agen[] = 'true';} Should work fine

zmeul Over a year ago

if i put the else condition, it returns all agents, i have update the script.

mickmackusa Over a year ago

For the record, this is NOT a secure or stable querying script. Do not use this in any real application (or even if you are just practicing).

Sina R. · Accepted Answer · 2014-05-12 11:47:11Z

1

I think you can use OR like

if you meant $agenti is an array so it may be like this :

$agenti=array(John,Tommy,Mark);

which means this:

$agenti=array(
    0=>John,1=>Tommy,2=>Mark
);

so you should point to its elements like $agenti[0]

$raw_results = mysql_query("SELECT distinct ch.employeename, ch.customername, ch.customerowner, ch.QuestionnaireName, ch.parentgroupname,
  ch.groupname, ch.visitdate from chestionare ch
   WHERE ch.visitdate >= '{$_GET['from']}' AND ch.visitdate <= '{$_GET['to']}' 
    AND (
         ch.employeename like '{$agenti[0]}' 
         OR ch.employeename like '{$agenti[1]}' 
         OR ch.employeename like '{$agenti[2]}' 
    )
    AND ch.customerowner like '{$clienti}' 
    AND ch.class like '{$task}' 
    AND ch.parentgroupname like '{$categorie}' 
 ") or die(mysql_error());

answered May 12, 2014 at 11:47

Sina R.

1,7782 gold badges19 silver badges38 bronze badges

2 Comments

zmeul Over a year ago

thx, but i keep agenti(employees) in another file with select multiple option and there are 60 of them.

Sina R. Over a year ago

@rozatrra - if Paul's answer is what you were looking for maybe you should accept it. (-:

Jignesh Rawal · Accepted Answer · 2014-05-12 13:13:39Z

1

<?php
            $agenti = array('sam','robin','sugar');
            $qry = "SELECT distinct ch.employeename, ch.customername, 
                     ch.customerowner, ch.QuestionnaireName, ch.parentgroupname,
                      ch.groupname, ch.visitdate from chestionare ch
                    WHERE ch.visitdate >= '".$_GET['from']."' AND ch.visitdate <= '".$_GET['to']."' 
                    AND ch.employeename IN('".implode("','",$agenti)."')  
                    AND ch.customerowner 
                    AND ch.class like '$task' 
                    AND ch.parentgroupname like '$categorie'
                                    ";

            /* Always use this way so it becomes easier for you to echo the query*/                         
            $raw_results = mysql_query($qry);
?>

edited May 12, 2014 at 13:13

answered May 12, 2014 at 11:56

Jignesh Rawal

5497 silver badges21 bronze badges

7 Comments

Sina R. Over a year ago

please complete your answer and make it reach with an example and I would put you a +1.

Sina R. Over a year ago

ok here is +1 and I have also edited your answer adding description and links.

Sina R. Over a year ago

@ Jignesh Rawal - please add some description of what the new code does and how the IN Clause works.

Jignesh Rawal Over a year ago

dev.mysql.com/doc/refman/5.6/en/…. Use the link to get it further cleared up.

Sina R. Over a year ago

you know you can edit your post to add the link and the description and also the php close (?>) tag is not seen as a code try to put some spaces before it.

|

Collectives™ on Stack Overflow

multiple values in like query mysql php

3 Answers 3

4 Comments

2 Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

2 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related