fork download
  1. <?php
  2. $state_sql=null;
  3. $city_sql="SELECT pkg_id FROM package_city where city_id in (1)";
  4. $category_sql="SELECT pkg_id FROM package_category where category_id in (2)";
  5. $sub_category_sql=null;
  6. $package_sql="SELECT pkg_id FROM package where id in (3, 4)";
  7.  
  8. $sql_get_any_packages = array(
  9. $state_sql,
  10. $city_sql,
  11. $category_sql,
  12. $sub_category_sql,
  13. $package_sql);
  14. $sql_get_any_packages = array_filter($sql_get_any_packages);
  15. $sql_get_any_packages = implode(" union ", $sql_get_any_packages);
  16. echo($sql_get_any_packages);
  17. ?>
Success #stdin #stdout 0.03s 13112KB
stdin
Standard input is empty
stdout
SELECT pkg_id FROM package_city where city_id in (1) union SELECT pkg_id FROM package_category where category_id in (2) union SELECT pkg_id FROM package where id in (3, 4)