2 pitanja u vezi MySQL-a i PHP-a u vezi datuma

[misko_]

Evo koda sa kojim sam ovo za datme rijesio mozda netkome zatreba.

PHP kôd:

<?php

    class MySQL_date 
    {
        // site::http://boonedocks.net/mike/archives/137-Creating-a-Date-Range-Array-with-PHP.html
        public static function createDateRangeArray($strDateFrom, $strDateTo) 
        {
            // takes two dates formatted as YYYY-MM-DD and creates an
            // inclusive array of the dates between the from and to dates.

            // could test validity of dates here but I'm already doing
            // that in the main script

            $aryRange=array();

            $iDateFrom=mktime(1,0,0,substr($strDateFrom,5,2),     substr($strDateFrom,8,2),substr($strDateFrom,0,4));
            $iDateTo=mktime(1,0,0,substr($strDateTo,5,2),     substr($strDateTo,8,2),substr($strDateTo,0,4));

            if ($iDateTo>=$iDateFrom) {
                array_push($aryRange,date('Y-m-d',$iDateFrom)); // first entry

                while ($iDateFrom<$iDateTo) {
                $iDateFrom+=86400; // add 24 hours
                array_push($aryRange,date('Y-m-d',$iDateFrom));
                }
            }
            
            return $aryRange;
        }
     
        // convert string in format dd.mm.YYYY to MySQL format http://dev.mysql.com/doc/refman/5.0/en/datetime.html YYYY-MM-DD
        // example 18.04.2008 to 2008-04-18
        public static function ddmmYYYYtoYYYYMMDD($date)
        {
            $parts = explode(".", $date);
            
            $new_date = $parts[2] . '-' . $parts[1] . '-' . $parts[0];
            
            return $new_date;
        } 
        
    }
      
?>