PHP 中的 SQL 是否有等效的 NOT IN 運(yùn)算符？if(count($result1) > 0) { $query_transline_conflict = "SELECT * FROM transaction_line as tl LEFT JOIN transaction as t ON tl.transaction_id = t.transaction_id LEFT JOIN resources as r ON tl.resource_id = r.resource_id WHERE t.equipment_class_id = '$equipment_class_id' AND tl.returned = '0'"; $result_transline_conflict = mysqli_query($conn, $query_transline_conflict); $result2 = mysqli_fetch_all($result_transline_conflict,MYSQLI_ASSOC); $x = 0; foreach($result2 as $row){ $already_booked_range = getDatesFromRange($row['start_date'],$row['end_date']); $new_array_already_booked[$x] = $already_booked_range; $x++; }我有一個(gè)正在輸入的 start_date 和 end_date。現(xiàn)在$new_array_already_booked存儲(chǔ)將被比較的日期范圍。所以我想使用 NOT IN 運(yùn)算符來比較 php。我希望我說得通。仍然是初學(xué)者并試圖學(xué)習(xí)。Array([0] => Array ( [0] => 2019-07-25 [1] => 2019-07-26 [2] => 2019-07-27 )[1] => Array ( [0] => 2019-07-30 [1] => 2019-07-31 [2] => 2019-08-01 ))
2 回答
湖上湖
TA貢獻(xiàn)2003條經(jīng)驗(yàn) 獲得超2個(gè)贊
如果要檢查一個(gè)數(shù)組的任何元素是否在另一個(gè)數(shù)組中，可以使用array_intersect：
$a = Array('bird', 'butterfly', 'bat');
$b = Array('ball', 'helmet', 'bat');
if (!array_intersect($a, $b)) echo 'not in';
- 2 回答
- 0 關(guān)注
- 133 瀏覽
添加回答
舉報(bào)
0/150
提交
取消