$('#btnmails').on('click', function(){ let ids = $.map($('.atitle'), (e) => $(e).attr('data-id')); ids = JSON.stringify(ids); console.log(ids); // ["26","25","24","23","22","21"] $.post('pro.php', {fn: 'btn_mails', args: [ids]}, function(data){ console.log(data); // 0 - but it is not true }); });
pro.php
function btn_mails($ids){ global $db; $sq = "select distinct mail from clients where id in ('" . $ids . "')"; $st = $db->prepare($sq); $st->execute(); $arr = $st->fetchAll(); echo count($arr); }
I have all six IDs in the table, each with a different mail
So the result should be 6 instead of 0
please help
I think your problem lies in your php function
Maybe
$ids
is an array, so you have to useimplode
to convert it to a stringlike this