maprangsoft

การค้นหาแบบ 2 เงื่อนไข

Mar 7th, 2020
235
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.23 KB | None | 0 0
  1. $productName = "%มาม่า%";
  2. $dateStart = "2020-03-01 00:00:00";
  3. $dateEnd = "2020-03-07 00:00:00";
  4.  
  5. $query = "
  6. SELECT * FROM products
  7. WHERE name LIKE '$productName'
  8. AND created_at BETWEEN '$dateStart' AND '$dateEnd'
  9. ";
Advertisement
Add Comment
Please, Sign In to add comment