PHP - Php Date() Issues...

For some reason the time is always staying the same throughout the listing tweets even when there's posts with different times. What am I doing wrong?

function getTwitterStatus($userid, $x) {
   $url = "http://twitter.com/statuses/user_timeline/$userid.xml?count=$x";

   $xml = simplexml_load_file($url) or die("could not connect");

   foreach ($xml->status as $status) {
      $text .= "<tr>";
      $text .= "<th>" . date("m/d/Y - g:ia", strtotime($xml -> status[0] -> created_at));
      "</th>";
      $text .= "<td class=\"full\">" . $status -> text . "</td>";
      $text .= "<td><img src=\"images/ball_grey_16.png\" class=\"block cr-help\" alt=\"\" title=\"Twitter Message\"/></td>";
   }

   echo $text;
}

I'm having some trouble understanding how to use date and time when updating my database.
The table is already populated with Date and Time fields in date and time format. I need to update the table based on the date and time, but I can't make it work. I tested all the variables and they are being sent correctly.
I'm pretty sure the problem lies in how I'm trying to match the Date and Time fields with $dateID and $timeID in the WHERE part of the query, but I'm not sure how to fix that!
Code: [Select]
<?php

include("opendatabase.php");

$size = count($_POST['player1']);
$i=0;
$thisyear = date("Y");

while ($i < $size)
     {
     $dateID = $_POST['date'][$i];
     $timeID = $_POST['time'][$i];
     $player1 = ($_POST['player1'][$i]);
     $player2 = ($_POST['player2'][$i]);
     $player3 = ($_POST['player3'][$i]);
     $player4 = ($_POST['player4'][$i]);
     $player5 = ($_POST['player5'][$i]);

mysql_query("
UPDATE Daysheets$thisyear
SET 
        Player1='$player1',
        Player2='$player2',
        Player3='$player3',
        Player4='$player4',
        Player5='$player5'
 
WHERE Date = '$dateID'
AND Time = '$timeID' ");
     $i++;
}

header("Location: /teetimes/publicteetimes.php?teetimedate=$dateID");

mysql_close($con)

?>Any help appreciated!
I should also mention that whenever I run this query it erases anything that was previously entered in the database except the date and time columns...

Hi everyone,

I have a basic calendar that I am trying to change to highlight the current date. I have got the current date highlighted using an if else statement inside a while clause, however, the issue arises when I use the forward/previous links to go to a different month - the same day is highlighted on those months as well.

Here is the code snippet in question (the entire code is below):


while( $day_num <= $days_in_month )
 {
 if(date('d') != $day_num) {
  echo "<td> $day_num </td>";
     $day_num++;
     $day_count++;
  }
// display today's date   
  else {
    echo "<td class=\"today\"> $day_num </td>";
    $day_num++;
$day_count++;
 }


My question is how do I get this calendar to display the current date, just on the current month. I assume there is something I am missing when it comes to handling the date(s) correctly, but what?

Any help is appreciated.

Thanks,

kaiman

Full code:


// gets today's date
$date = time () ;

// puts the day, month, and year in seperate variables
$day = date('d', $date) ;
$month = (int) ($_GET['month'] ? $_GET['month'] : date('m'));
$year = (int) ($_GET['year'] ? $_GET['year'] : date('Y'));

// generate the first day of the month
$first_day = mktime(0,0,0,$month, 1, $year) ;

// get the month name
$current_month = date('F', $first_day) ;

 // determine what day of the week the first day of the month falls on 
 $day_of_week = date('D', $first_day) ; 

 // determine blank days before start of month
 switch($day_of_week){ 

 case "Sun": $blank = 0; break; 

 case "Mon": $blank = 1; break; 

 case "Tue": $blank = 2; break; 

 case "Wed": $blank = 3; break; 

 case "Thu": $blank = 4; break; 

 case "Fri": $blank = 5; break; 

 case "Sat": $blank = 6; break; 

 }

 // determine how many days are in the current month

 $days_in_month = cal_days_in_month(0, $month, $year) ;
 
 // determine next month
 $next_month_link = '<a href="?month='.($month != 12 ? $month + 1 : 1).'&year='.($month != 12 ? $year : $year + 1).'">>></a>';
 
 // determine previous month
 $previous_month_link = '<a href="?month='.($month != 1 ? $month - 1 : 12).'&year='.($month != 1 ? $year : $year - 1).'"><<</a>';

// start building the table

 echo " <table border=0 width=294>\n";
 echo " <tr>\n";
 
// display month and year
 echo " <th> $previous_month_link </th>\n";
 echo " <th colspan=4> $current_month $year </th>\n";
 echo " <th> $next_month_link </th>\n";
 echo " </tr>\n";

// display days of week
 echo " <tr>\n";
 echo " <td width=42>S</td>\n";
 echo " <td width=42>M</td>\n";
 echo " <td width=42>T</td>\n";
 echo " <td width=42>W</td>\n";
 echo " <td width=42>T</td>\n";
 echo " <td width=42>F</td>\n";
 echo " <td width=42>S</td>\n";
 echo " </tr>\n";

 // counts the days in the week

 $day_count = 1;

 echo " <tr>\n";

 // display blank days

 while ( $blank > 0 ) 

 { 

 echo " <td></td>\n"; 

 $blank = $blank-1; 

 $day_count++;

 }
 
// sets the first day of the month to 1 

 $day_num = 1;

// count the days in the month and display them

while( $day_num <= $days_in_month )
 {
 if(date('d') != $day_num) {
  echo "<td> $day_num </td>";
     $day_num++;
     $day_count++;
  }
// display today's date   
  else {
    echo "<td class=\"today\"> $day_num </td>";
    $day_num++;
$day_count++;
 }

 // make sure we start a new row every week

 if ($day_count > 7)

 {

 echo " </tr>\n";
 echo " <tr>\n";

 $day_count = 1;

 }

 } 
 
 // finish calendar

 while ( $day_count >1 && $day_count <=7 ) 

 { 

 echo " <td>\n";
 echo " </td>\n"; 

 $day_count++; 

 } 

 echo " </tr>\n";
 echo " </table>\n";

I'm working on a project that has a lot of different timezone options, and all I have from the users is their UTC offset.

After weeks of doing tweaks, I come to new issues every time I add something, one would think it would be a lot easier to just get the correct time and day :)

The latest issue is that when I try to rewrite a date to a better fomat, it disregards the GMT offset. Like this:

4/14/19, 12:00 PM GMT+2 (=$date) becomes ... 14-04-2019 10:00 when using this code:

$bp_date_to_format = date_create_from_format('Y-m-d\TH:i:sP', $date);
echo date_format($bp_date_to_format, 'd-m-Y H:i');

I figured it would just rewrite the format, keeping the exact time. It isn't.

We do have all these sorts of localization functions as well, but because there doesn't seem to be one single standard (each 3rd party API connection we have uses its own default datetime format so it seems).

        // Remove UTC Text
        $UTC_offset = str_replace('UTC', '', $timezone);

        // Get Offset in Minutes
        if (stripos($UTC_offset, ':') !== false) {
            // Calculate seconds from offset
            list($hours, $minutes) = explode(':', $offset);
            $seconds = $hours * 60 * 60 + $minutes * 60;
        } else {
            $seconds = $UTC_offset * 60 * 60;
        }

        // Get User timezone name from seconds
        $timezone = timezone_name_from_abbr('', $seconds, 1);
        if ($timezone === false) {
            $timezone = timezone_name_from_abbr('', $seconds, 0);
        }
        // Set new TZ
        return date_default_timezone_set($timezone);

 

Isn't there any "one way"solution that can be used? It's confusing to say the least.

 

Cheers.

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack