$('#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);
}
我在表中擁有所有六個 ID，每個 ID 都有不同的郵件
# 所以結果應該是 6 而不是 0
請幫忙
我認為你的問題出在你的 php 函數
可能
$ids是一個數組，因此您必須使用implode將其轉換為字串#像這樣
function btn_mails($ids){ global $db; $sq = "select distinct mail from clients where id in (" . implode(', ', $ids) . ")"; $st = $db->prepare($sq); $st->execute(); $arr = $st->fetchAll(); echo count($arr); }