我能夠綁定 1 個(gè)數(shù)組作為參數(shù)沒問題。但是，我正在嘗試將 2+ 個(gè)數(shù)組綁定為參數(shù)，但效果不是很好。解包后我不斷收到無法使用位置參數(shù)的錯(cuò)誤。如何將數(shù)組組合為參數(shù)？$query="SELECT price FROM products WHERE status='1'";if(isset($_POST['category'])){ $category_filter = join(',', array_fill(0, count($_POST['category']), '?')); $sql .= ' AND category IN ('.$category_filter.')';}if(isset($_POST['location'])){ $location_filter = join(',', array_fill(0, count($_POST['location']), '?')); $sql .= ' AND location IN ('.$location_filter.')';}$stmt = $conn->prepare($query);$stmt->bind_param(str_repeat('ss', count($_POST['category'],$_POST['location'])), ...$_POST['category'],...$_POST['location']);$stmt->execute();$stmt->bind_result($price);
1 回答
心有法竹
TA貢獻(xiàn)1866條經(jīng)驗(yàn) 獲得超5個(gè)贊
您將不得不將兩個(gè)列表組合在一起，然后將它們一次性綁定......
$params = array_merge($_POST['category'],$_POST['location']);
$stmt->bind_param(str_repeat('s', count($params)), ...$params);
- 1 回答
- 0 關(guān)注
- 113 瀏覽
添加回答
舉報(bào)
0/150
提交
取消