PHP sql statement where clause to multiple array values

Question

How do i use where clause for array if value[3] has multiple data stored

$fsql="select * from Error where RptDatime = 201706091000 and partnumber like  ('$value[3]')";
$getResults = $conn->prepare($fsql);        
$getResults->execute();
$results = $getResults->fetchAll(PDO::FETCH_BOTH);    

foreach($results as $row)
{         
    $mac = $row['Machine'];                
    $id = $row['Id'];                
    echo 'ID:'.$id.'Machine Number :'.$mac;
}

Please learn about prepared Statements. What you are doing is not what prepared Statements means — Jens, Jun 09 '17 at 07:33
Check this link:- https://stackoverflow.com/questions/19368033/prepared-statements-with-dynamic-where-clause — Ravi Hirani, Jun 09 '17 at 07:41

score 0 · Answer 1 · answered Jun 09 '17 at 07:55

You can use regex function instead of like. Below is the sample code for you.

$partnumner = [];

    foreach($value[3] as $v)
    {
        $partnumber[] = "*.".$v.".*";
    }

    $fsql="select * from Error where RptDatime = 201706091000 and partnumber REGEXP  '".implode("|",$partnumber)."'";

If you still wish to use like, you can follow the answer here

score -1 · Answer 2 · answered Jun 09 '17 at 07:53

I assume that you have array of numbers so, first you should validate for expected data and then to implode it into comma separated string.

if(!isset($value[3])){
    return false;
}
if(!is_array($value[3])){
    return false;
}
foreach($value[3] as $number){
    if(!is_numeric($number)){
        return false;
    }
}
$numbers = implode(",",$value[3]);
$fsql=sprintf("select * from Error where RptDatime = 201706091000 and partnumber in  (%s)",$numbers);
$getResults = $conn->prepare($fsql);        
$getResults->execute();
$results = $getResults->fetchAll(PDO::FETCH_BOTH);    

foreach($results as $row)
{         
    $mac = $row['Machine'];                
    $id = $row['Id'];                
    echo 'ID:'.$id.'Machine Number :'.$mac;
}

PHP sql statement where clause to multiple array values

2 Answers2

Linked