Select where a column value is included in a string (or array)

Asked Jul 06 '23 at 20:25

Active Jul 06 '23 at 20:25

Viewed 14 times

let ids = $.map($('.atitle'), (e) => $(e).attr('data-id'));
console.log(ids);
// ['6493e687161e0', '64a6776077613', '6489c85b3e6b1']
$.post('index_pro.php', {fn: 'btn_mails', args: [ids]}, function(data){
    console.log(data);
    //  error
});

error:

Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1367 Illegal double '6493e687161' value found during parsing in...

php

Need to select distinct mail where mail is not empty and id is in the above array

function btn_mails($ids){
    global $db;
    $str = implode(', ', $ids);
    $sq = "select distinct mail from arts where mail <> '' and id in (" . $str . ")";
    $st = $db->prepare($sq);
    $st->execute();
    $arr = $st->fetchAll();
    $str = '';
    foreach($arr as $el){$str .= $el['mail'] . "\n";}
    $str = rtrim($str, "\n");
    echo $str;
}

asked Jul 06 '23 at 20:25

provance

You want `WHERE FIND_IN_SET(id, :ids)` – Barmar Jul 06 '23 at 20:32
You shouldn't put space after the comma in `$str`. – Barmar Jul 06 '23 at 20:32
The reason for your error is because you didn't put quotes around the array elements when you created `$str`. So it's trying to parse them as numbers, but they're not valid numbers. – Barmar Jul 06 '23 at 20:35
If you had done `echo $sq` you would have seen the problem – Barmar Jul 06 '23 at 20:35
@Barmar - you probably mean -` WHERE FIND_IN_SET(id, :str)`. Anyway, solved, thanks a lot – provance Jul 06 '23 at 21:07
1

I intended that you would do `bindParam(':ids', $str)` – Barmar Jul 06 '23 at 21:09

Select where a column value is included in a string (or array)

0 Answers0