fork download 
  1. <?php
  2.  
  3. $array1 = array(1,2,3,'');
  4. $array2 = array('');
  5. $array3 = array(1,2,3);
  6.  
  7.  
  8. // Testar cenário 1
  9. $wheresql = "";
  10. $ad_ids = rtrim(implode(',', $array1), ",");
  11. if (!empty($ad_ids)) {
  12. 	$wheresql = " WHERE ad_id NOT IN (".$ad_ids.") ";
  13. }
  14. echo "Cenário 01: " . $wheresql . PHP_EOL;
  15.  
  16.  
  17. // Testar cenário 2
  18. $wheresql = "";
  19. $ad_ids = rtrim(implode(',', $array2), ",");
  20. if (!empty($ad_ids)) {
  21. 	$wheresql = " WHERE ad_id NOT IN (".$ad_ids.") ";
  22. }
  23. echo "Cenário 02: " . $wheresql . PHP_EOL;
  24.  
  25.  
  26. // Testar cenário 3
  27. $wheresql = "";
  28. $ad_ids = rtrim(implode(',', $array3), ",");
  29. if (!empty($ad_ids)) {
  30. 	$wheresql = " WHERE ad_id NOT IN (".$ad_ids.") ";
  31. }
  32. echo "Cenário 03: " . $wheresql . PHP_EOL;
Success #stdin #stdout 0.01s 20568KB
comments (?)
stdin 
Standard input is empty
stdout 
Cenário 01:  WHERE ad_id NOT IN (1,2,3) 
Cenário 02: 
Cenário 03:  WHERE ad_id NOT IN (1,2,3)
https://ideone.com/vc8pVn
language:
PHP (php 7.3.5)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!