how to change the day date in 00 hours?

mark103

Hi all,

I need your help with my PHP, I have got the date and time format especially the year, month, day date, hours, minutes and seconds. I have got a little problem with the day date.

Most of the day date are correct, but some of them are not correct.

Example: 20140407230000, 20140408233000, 20140408000000, 20140408003000.

If you can take a look an the 20140408230000, you will see that 2014 is the year, 04 is the month, 08 is the day date, 23 is the hours, 00 is the minutes and seconds.

From what I have got, the day date are wrong. I have the 08 day date when I'm on the 23 hours at the same day which is correct, but when I have the 00 hours I should have the day date 09 instead of 08.

Here is the code:

<?php
   ini_set('max_execution_time', 300);
   $errmsg_arr = array();
   $errflag = false;
   $link;
   include ('simple_html_dom.php');
   $html = file_get_html("http://www.mysite.com/get-listing.php?channels=" . $channel . "&id=" . $my_id);


   $time1 = $html_two->find('span[id=time1]',0)->plaintext; 
   $time1i = strtotime($time1);
   $title1 = $html_two->find('span[id=title1]',0)->plaintext;


   $hours = $hoursMinutes[0];
   $minutes = $hoursMinutes[1];


   $program_list[$count]['start_time1'] = date('YmdHis',$time1i);


   $xml .= "
  <channel id='" . $my_id. " " . $channel . "'>";
   $xml .= "
    <display-name>" . $my_id. " " . $channel; 
   $xml .= "</display-name>";
   $xml .= "
  <programme channel='" . $my_id. " " . $channel . "' start='" . $program_list[$i]['start_time1'] . "' stop='" . $program_list[$i]['end_time1'] . "'>";
   $xml .= "
  </programme>";
   $xml .= "
  </channels>";
  echo $xml;
?>

Can you please tell me how I can change the day date to the next day date when I am on the 00 hours using with my code?

Thanks in advance.

bradgrafelman

What does the original string (i.e. what you pass to [man]strtotime/man) look like for the "00" hour example that doesn't appear to be working?

mark103

bradgrafelman;11040011 wrote:
What does the original string (i.e. what you pass to [man]strtotime/man) look like for the "00" hour example that doesn't appear to be working?

The original string for the $time1 is:

6:00 PM 
6:00 PM 
7:00 PM 
6:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM 
7:00 PM

I'm converting the original time to a timestamp, because I want to get the 24 hours time, but the day date won't change. The 00 hours is working when I use the code in my first post.

However, I tried this:

//time1
  $time1 = $html_two->find('span[id=time1]',0)->plaintext;

  $title1 = $html_two->find('span[id=title1]',0)->plaintext;

  $hoursMinutes = explode(":", $time1[0]);
  $hours = $hoursMinutes[0];
  $minutes = $hoursMinutes[1];

  $time1 = explode(" ", $time1);
  $hoursMinutes = explode(":", $time1[0]);
  $hours = $hoursMinutes[0];
  $minutes = $hoursMinutes[1];


  if($time1[1] == "PM")
  {
    $time1[0] = date("Ymd") . ((int)($hours) + 12) . $minutes . "00";
  } 
  else 
  {
    $time1[0] = date("Ymd") . $hours . $minutes . "00";
  }
  $program_list[$count]['start_time1'] = $time1[0];

It wont let me to change the day date and also it won't let me to have the 24 hours clock, only 12 hours.

Can you please tell me what change I need to make in order i can make the 24 hours clock and change the day date depends on the current day?

johanafm

It seems you are doing a lot of unnecessary work. It would most likely be a lot easier to reuse existing code that handles datetimes and formatting. [man]datetime.createfromformat[/man], [man]datetime.format[/man]

Assuming you want to do it yourself, it would seem the error is because you do not handle 12 AM properly and that you do not handle 12 PM properly.

12 AM is in the middle of the night which in 24 hour format translates to 0. 12 AM -> 0 is a -12 difference.
12 PM is just after noon, which in 24 hour format translates to 12. 12 PM -> 12 is a 0 difference.

You are adding 12 to 12PM while doing nothing to 12 AM. Moreover, you are doing so with no regard at all for dates.

mark103

johanafm;11040021 wrote:
It seems you are doing a lot of unnecessary work. It would most likely be a lot easier to reuse existing code that handles datetimes and formatting. [man]datetime.createfromformat[/man], [man]datetime.format[/man]

Assuming you want to do it yourself, it would seem the error is because you do not handle 12 AM properly and that you do not handle 12 PM properly.

12 AM is in the middle of the night which in 24 hour format translates to 0. 12 AM -> 0 is a -12 difference.
12 PM is just after noon, which in 24 hour format translates to 12. 12 PM -> 12 is a 0 difference.

You are adding 12 to 12PM while doing nothing to 12 AM. Moreover, you are doing so with no regard at all for dates.

Dude!!! I didn't code it most of it, but it was the PHP developer who coded it for me. I have the proof if you don't believe it, the link is: http://pastebin.com/a0wQsnch

I found out that he had done a dodgy work, many of the code I found are unnecessary. I have to recode it myself by finding the list of code that I actually needs and what code I do not need it. So my code is working much better than his which I have list for every channels where he doesn't have the list for every channels. There are something in my code that need a little bit of modify to make the changes that's all. The main thing is he has got the day date change with a 24 hours clock, e.g.: 20140408230000, 20140409000000, 20140409010000, 20140409230000, 20140410000000 and so on. I can't figure it out where it is. I hope you will be able to help me where to find it.

Apart from this, I'm fetching the time data from my get-listing.php script where I fetch the data from the TV guide website. I'm splitting the time into the hours and minutes. So I need to convert the hours into 24 hours and I also need to change the day date. If you can help me how I can convert the hours into 24 hours when I'm fetching the time data and also to change the day date depends on what day it have in the variable, e.g.: if the time in the $time1 variable have the 23 hours and the day date is 09, then in the $time2 variable it will have the 00 hours and the day date would be 10. I would be very grateful if you could help me out.