code_junkie

Managing date formats differences between PHP and MySQL

Nov 13th, 2011
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. function mysql_date($php_date) {
  2. return date( 'Y-m-d H:i:s', $php_date );
  3. }
  4.  
  5. function php_date($mysql_date) {
  6. $val = explode(" ",$mysql_date);
  7. $date = explode("-",$val[0]);
  8. $time = explode(":",$val[1]);
  9. return mktime($time[0],$time[1],$time[2],$date[1],$date[2],$date[0]);
  10. }
  11.  
  12. $php = strtotime($mysql);
  13.  
  14. $ymdDateAdded = date('Y-m-d');
  15. $timeDateAdded = strtotime($ymdDateAdded);
  16. $userDateadded = date('j F Y', $timeDateAdded);
  17.  
  18. $Date_p = new MagicDate($php_date);
  19. $Date_m = new MagicDate($mysql_date);
  20.  
  21. $query = "UPDATE SET Date='".$Date_p->toMysql()."' "...
  22.  
  23. public function __construct($date)
  24. {
  25. $phpdate = strtotime($date);
  26. if($phpdate)
  27. {
  28. $this->phpdate = $phpdate;
  29. $this->mysqldate = $this->mysql_date($phpdate);
  30. }
  31. else
  32. {
  33. $this->phpdate = $this->php_date($phpdate);
  34. $this->mysqldate = $phpdate;
  35. }
  36. }
Add Comment
Please, Sign In to add comment