[RESOLVED] problem with date() and mktime()

VisionsOfCody

I'm trying to write a jump menu that displays all the days in the current 3 months

i found a bit of code on the web that outputs consecutive days and I'm trying to adapt it for my purposes

I've almost got it to work - i use explode() to chop up the $timestamp variable into an array then output three of those elements in my jump menu

the problem is that when it gets to the 10th day of each month all the array elements shift sideways by 1 index - i really can't see why this should be

here's the code :

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>menu test</title>
<script type="text/javascript">
<!--
function setStartDate(y,m,d){
	document.forms["spec_form"].elements["_START_DATE"].value = d+"-"+m+"-"+y;
}

function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>

</head>

<body>


 <form name="form1" id="form1">
   <select name="menu1" onchange="MM_jumpMenu('parent',this,0)">


 <?php
define ('DATE_ENUM_DAY', 1);
define ('DATE_ENUM_MONTH', 2);
/*
 * enumerate a date and call a user function
 * dateBeginTS, dateEndTS : Timestamp date
 * callbackfunc : name of the php function to callback
 *  this cb function receive 2 parameters : the current enumerated date (timestamp) and the $param parameter
 * step : DATE_ENUM_DAY or DATE_ENUM_MONTH
 * param : a user parameter
 */
function date_enumeration($dateBeginTS, $dateEndTS, $callbackfunc, $step, $param = NULL)
{
   $cur = $dateBeginTS;
   while($cur <= $dateEndTS)
   {
       $callbackfunc($cur, $param);

   if ($step == DATE_ENUM_DAY)
   {
       $cur = mktime(
           date('h', $cur),
           date('i', $cur),
           date('s', $cur),
           date('m', $cur),
           date('d', $cur) + 1,
           date('Y', $cur));
   }
   else if ($step == DATE_ENUM_MONTH)
   {
       $cur = mktime(
           date('h', $cur),
           date('i', $cur),
           date('s', $cur),
           date('m', $cur) + 1,
           date('d', $cur),
           date('Y', $cur));
   }
   else
   {
       die ('No step specified');
   }
   }
}

/// SAMPLE USAGE
function cb_test($timestamp, $param)
{
   //echo date('r', $timestamp), ' ', $param, "<br>\n";
   $date_parts = explode(" ",date('r', $timestamp));
   echo "<option>".$date_parts[2]."-".$date_parts[3]."-".$date_parts[4]."</option><br>\n";
}

date_enumeration(
   mktime(0,0,0,1,1,2006),
   mktime(0,0,0,4,1,2006),
   'cb_test',
   DATE_ENUM_DAY
);

?>
       </select>
     </form>
</body>
</html>

can anyone see what i need to do here ?

and btw can i just ask for your opinion on another simple matter ? : what's the best format for saving dates in a MySQL db to make searching by date as simple as possible ? is it better to enter the day, month, year in separate fields ?

thanks for any help you can give !

Installer

Would this do what you're trying for?

echo date_enumeration(3, 'days');

function date_enumeration($num_mos, $step)
{
    $ret = '';
    $cur_ts = strtotime(date('Y') . date('m') . '01');
    $end_ts = strtotime('+' . $num_mos . ' months', $cur_ts);
    do {
        $ret .= '<option>' . date('M j, Y', $cur_ts) . '</option><br />';
    } while (($cur_ts = strtotime('+1 ' . $step, $cur_ts)) < $end_ts);
    return $ret;     

}

Use the DATE type in MySQL.

VisionsOfCody

yes that's great - much smaller than the code i had

I was looking at it and trying to work out why it doesn't start with today's date even though you seem to have defined today's date in the $cur_ts variable - well, at least that's as far as i can understand it - but I'm not sure i've completely understood everything that your code does

and i can't seem to get it to work with setlocale(LC_TIME, "fr_FR"); - is this simply because it won't work with that or am i not using it properly ?

VisionsOfCody

ok ok
I've worked out how to make it use today's date with

(date('Y') . date('m') . date('d'));

but do you know how i can convert it to local settings with setlocale(LC_TIME, "fr_FR");

Installer

I thought you meant three months starting from the first of the current month. You fixed that good.

"$cur_ts" is a little confusing, I guess. I meant it as current in each iteration of the do loop.

To get the locale to work, change this line:

$ret .= '<option>' . date('M j, Y', $cur_ts) . '</option><br />';

to:

$ret .= '<option>' . strftime("%b %d, %Y", $cur_ts) . '</option>';

That should take care of that. 🙂

Edit: Here's a better version that might also be easier to follow:

setlocale(LC_TIME, 'fr_FR', 'fra_fra');
echo date_enumeration(); 

function date_enumeration($num_mos = 3, $step = 'days')  // Or 'weeks', 'fortnights', 'months', etc. 
{ 
    $ret = '';
    $cur_ts = time(); 
    $end_ts = strtotime('+' . $num_mos . ' months', $cur_ts);
    while ($cur_ts < $end_ts) { 
        $ret .= '<option>' . strftime("%b %d, %Y", $cur_ts) . '</option>'; 
        $cur_ts  = strtotime('+1 ' . $step, $cur_ts);
    }
    return $ret;      

}

VisionsOfCody

yes - that's absolutely perfect and easier to understand for a medium noob such as myself

many thanks !

🙂