Reformatting a 24h timestamp

JUMC_Webmaster

This is a repost of something I put into a thread that was marked RESOLVED around the time I submitted this.

I'm trying to correctly format a time, given a date and a time in the form of HH:MM:SS (pulled from a MySQL query). The time is the third element in each record, so this code is executed when i equals 2.


echo "<table border=\"1\">";
$fields = mysql_num_fields($result);

while ($array = mysql_fetch_array($result))
{
       echo "<tr>";

  //time is second record, and I'm only using the second, third and fourth records of all selected.  May change in the future 
  for ($i=2; $i <= 4; $i++)
  {
                   if ($i == 2)
                   {
                      //time is in HH:MM:SS format, need to explode it
                      $j = explode(":", $array[i]);
                      //used for debugging, nothing printed when uncommented.
                      //print "$j[0] $j[1] $j[2]";

                      //want to display in 12h format with no leading zeroes in the hour.
                      //x is an exploded date passed to the function from another PHP file. 
                      $newtime = date("g:i:s A", mktime($j[0], $j[1], $j[2], $x[0], $x[1], $x[2], -1));
                      echo "<td>$newtime</td>";
                   }

                   //if not a time record, echo the contents of that field as text.
                   else
                   {
                     echo "<td>$array[$i]</td>";
                   }

                   if ( $i < $fields ) echo "<td></td> ";
  }  
  echo "</tr>";
}   

echo "</table>";

When this code is executed, the time displays as "6:59:59 PM" for all entries selected in the query.

DeltaRho2K

This part is throwing me off:

$j = explode(":", $array[i]);

Where is the coming from?

Is that the name of the field from your $array's table? If so, try:

$j = explode(":", $array['i']);

JUMC_Webmaster

$i is an index counter for the iterative loop that generates the table. My fault that wasn't clear. I'm only doing the date formatting when $i == 2 because the time is the third field in the record.

JUMC_Webmaster

Consider this resolved. Turns out the problem was I didn't have $i specified as a variable when referencing the array.

DeltaRho2K

Good to see you got it resolved... That's where I was heading with my question anyhow, because it was the only part of the code that wasnt clear...

Be sure to mark this thread as resolved (If you haven't already)

barand

if ($i == 2)
{
//time is in HH:MM:SS format, need to explode it
$j = explode(":", $array);
//used for debugging, nothing printed when uncommented.
//print "$j[0] $j[1] $j[2]";

                      //want to display in 12h format with no leading zeroes in the hour. 
                      //x is an exploded date passed to the function from another PHP file. 
                      $newtime = date("g:i:s A", mktime($j[0], $j[1], $j[2], $x[0], $x[1], $x[2], -1)); 
                      echo "<td>$newtime</td>"; 
                   } [/QUOTE]

a simpler alternative is

if ($i == 2) {
    $newdate = date('g:i:s A', strtotime($array[$i]));
    echo "<td>$newtime</td>"; 
}

hth