Guest User

Untitled

a guest
Nov 16th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. <?php
  2. $format = 'YYYY-MM-DD';
  3. $query = $db->prepare("SELECT TO_CHAR(NOW(), '" . $format . "') AS DATETIME");
  4.  
  5. if($query->execute()) {
  6. echo 'valid';
  7. else
  8. echo 'invalid';
  9.  
  10. //Result valid;
  11.  
  12. <?php
  13. $format = 'abcdefg';
  14. $query = $db->prepare("SELECT TO_CHAR(NOW(), '" . $format . "') AS DATETIME");
  15.  
  16. if($query->execute()) {
  17. echo 'valid';
  18. else
  19. echo 'invalid';
  20. //Result valid
  21.  
  22. //sql
  23. SELECT TO_CHAR(NOW(), 'YYYY-MM-DD') AS DATETIME;
  24. //query executed
  25. //Result
  26. 2018-11-16
  27.  
  28. //sql
  29. SELECT TO_CHAR(NOW(), 'abcdefg') AS DATETIME;
  30. //query executed
  31. //Result
  32. aad6efg
Add Comment
Please, Sign In to add comment