[RESOLVED] mktime returns wrong minutes

[2005]

Hello,

I am getting crazy. Please help.

$hours = "15";
$minutes = "16";
$seconds = "17";

$months = "05";
$days = "10";
$years = "2009";

$mydate = mktime($hours, $minutes, $seconds, $months, $days, $years);

$result=mysql_query("INSERT INTO articles VALUES (NULL,'$mydate')") or die(mysql_error());

echo "$minutes"; //this returns the correct number - 16

$check= mysql_query( "SELECT mydate FROM articles");
list($mydate) = mysql_fetch_row($check);

<?php echo date("Y-m-d H:m:s", $mydate);?> //this returns 2009-05-10 15:05:17

As you can see, mktime instead of "16" minutes saved into DB "05" minutes. I spent several hours trying to understand what I am doing wrong, but no success. I can not save the correct the values of minutes - all values are replaced with "05" or "06" or "07". At the same time php echo still shows the correct value after mysql query.

Thanks for reading.

[NogDog]

Just to make sure, is the table empty when you do that? If not, then your second query is retrieving every row in the table but you are only outputting the first one it retrieved, which more than likely is not the last one you inserted.

[Drakla]

Take a look at this: "Y-m-d HⓂs" that's your problem.

[roscor]

try this instead from one of our knowledgeable moderators which i adapted for my own use,

 

 if(preg_match('/^[0-9_-]{1,}$/i', $_POST['day'])){
        $day = $_POST['day'];
        } else {
        $error1 .= "Day req";
        $errcount++; 
        }

     if(preg_match('/^[0-9_-]{1,}$/i', $_POST['month'])){
     $month = $_POST['month'];
     }
     else {
    $error2 .= "Month req";
    $errcount++; 
    }


      if(preg_match('/^[0-9_-]{1,}$/i', $_POST['year'])){
      $year = $_POST['year'];
      }
      else {
    $error3 .= "YYYY Required!";
    $errcount++; 
    }
    if(isset($_POST['year'])){
    $dob = $_POST['day'] . "-" . $_POST['month'] . "-" . $_POST['year'];

    //eg $dob = '07-09-1974';
 list($day,$month,$year) = explode("-",$dob);
    $year_diff  = date("Y") - $year;
    $month_diff = date("m") - $month;
    $day_diff   = date("d") - $day;
    if ($month_diff < 0 || ($month_diff == 0 && $day_diff < 0))
      $year_diff--;
       if($year_diff < 18) {
       $error4 .= "Person must be 18+!";
       $errcount++;

}
else {

$dob = $_POST['day'] . "-" . $_POST['month'] . "-" . $_POST['year'];
} 

Obviously this works with a form, I am sure you will be able to make it work for your purposes!

[NogDog]

Drakla;10879135 wrote:

Take a look at this: "Y-m-d HⓂs" that's your problem.

Heh, I didn't notice that (obviously). I wonder how many people have been bitten by that one in the history of PHP's date() function. 🙂

(PS: try "i" instead of "m" for the minutes.)

[crazylegsmurphy]

sorry.

[2005]

Thak you for your replies.

NogDog,

No, the table is not empty. I wrote this query in my previous post just to make things not so complicated for forum readers.

The real query is:

$check= mysql_query( "SELECT id, title, arttext, mydate FROM articles order by id DESC limit $start, $step");
while(list($aid, $title, $arttext, $mydate) = mysql_fetch_row($check)) {

}

field "mydate" contains time information when article vill be available for reading - it's always in the future.

I wrote to the DB some 20 test articles with publication time in 5-10-15-20 minutes.
First I noticed this problem in this situation:

$time = time();
if ($mydate < $time) {
echo "Article published";
} else {
echo "Article not published yet";
}

It looked strange to me that all test articles appared as published. That's why I used the date function to check the date and time. I submitted all tests with different values of minutes - 15, 17, 20, 25, 35, but date function returns only 3 values - 05 or 06 or 07.

Drakla, I don't understand why "Y-m-d HⓂs" should be a problem.

[NogDog]

2005;10879144 wrote:

...Drakla, I don't understand why "Y-m-d HⓂs" should be a problem.

"m" is the month number, but you have it in both the month and minutes positions. You want "i" for the minutes position.

[2005]

Thank you, NogDog,
Yes, this was the problem.

I just discovered that server time is +2 hours, so that's why all articles appeared as published.