PHP: DATETIME Help

PHP: DATETIME Help

I know there's ample information about datetimes on the internet but I'm having trouble using what I've been seeing.

I have a calander control hooked up to a text box. It takes it in the form 15/11/2010 (british). I use it to query datetime fields in a SQL server db in the format 15/11/2010 00:00:00.

After the capture the dates on postback I pass the values onto my method that attempts to convert the text into time format. When I query for something between 01/01/2010 and 01/07/2010 I get a number of results. When I change this to between 01/01/2010 and 30/10/2010 I get an error. The error is invalid foreach (haven't caught the error yet). I'm guessing its something to do with my formats?

function getSupportTicketsbySubIssueAndDate($subissueid, $from, $to){

    $subissueid = $this->ms_escape_string($subissueid);

    $from = date("DD/MM/YY", strtotime($from));
    $to = date("DD/MM/YY", strtotime($to));

    $connection = new Connections();
    $conn = $connection->connectToWarehouse();
    $atid = $_SESSION['saveddata']['autotaskid'];


    $tsql = "SELECT wh_task.task_id, wh_task.task_name, wh_task.task_description, wh_task.task_number, wh_task.reported_by_name, wh_task.create_time, wh_resource.first_name, wh_resource.last_name, wh_task_status.task_status_name ".
            "FROM wh_task_status INNER JOIN (wh_task INNER JOIN wh_resource ON wh_task.assigned_resource_id = wh_resource.resource_id) ON wh_task_status.task_status_id = wh_task.task_status_id ".
            "WHERE (account_id = $atid) AND (subissue_type_id = $subissueid) AND (((wh_task.create_time) Between '$from' And '$to'))".
            "ORDER BY create_time DESC";


    // set up array to hold each of the issue types and the number of tickets in each
    $ticket;

    $stmt = sqlsrv_query( $conn, $tsql);
    if( $stmt === false)
    {
             echo "Error in query preparation/execution.\n";
             die( print_r( sqlsrv_errors(), true));
    }

    $x = 0;
    /* Retrieve each row as an associative array and display the results.*/
    while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))
    {
            $ticket[$x][0] = $row['task_name'];
            $ticket[$x][1] = $row['task_description'];
            $ticket[$x][2] = $row['task_number'];
            $ticket[$x][3] = $row['reported_by_name'];
            $ticket[$x][4] = $row['first_name'];
            $ticket[$x][5] = $row['last_name'];
            $ticket[$x][6] = $row['task_status_name'];
            $ticket[$x][7] = $row['create_time'];
            $ticket[$x][8] = $row['task_id'];

            $x++;
    }

    return $ticket;
}

Any help most appreciated!

Answer:

I'm unsure if you're formatting the dates correctly. You can find all the formatting rules at the bottom through the URL posted

date("DD/MM/YY ...

That's not gonna work cause that's not how they're formatted in PHP. This:

date("d/m/y ...

will change the format to DD/MM/YY. :)

http://php.net/manual/en/function.date.php

http://stackoverflow.com/questions/4188954/php-datetime-help

PHP Datetime with MySQL datetime

by Blogger 3:07:00 AM MYSQL MySQL datetime PHP PHP DateTime

PHP DateTime issue

by Blogger 3:03:00 AM Issue PHP PHP DateTime

PHP DateTime Update

by Blogger 2:51:00 AM Datetime PHP PHP DateTime

PHP DateTime for .NET Developers

by Blogger 2:44:00 AM .NET Developers Datetime PHP PHP DateTime

PHP DateTime for .NET Developers

PHP's DateTime class has the two methods add() and sub() to add or subtract a time span from a DateTime object. This looks very familiar to me, in .NET I can do the same thing. But once I tried it, it did very strange things. I found out that in PHP, those methods will modify the object itself. This is not documented and the return value type indicates otherwise. Okay, so in some scenarios I need three lines of code instead of one, plus an additional local variable. But then PHP5's copy by reference model comes into play, too. Just copying the object isn't enough, you need to explicitly clone it to not accidently modify the original instance still. So here's the C# code:

DateTime today = DateTime.Today;
...
if (date < today.Add(TimeSpan.FromDays(7)) ...

Here's the PHP equivalent:

$today = new DateTime('today');
...
$then = clone $today;
$then->add(new DateInterval('P7D'));
if ($date < $then) ...

(I keep a copy of today to have the same time for all calculations during the method runtime. I've seen it often enough that seconds or larger time units change in that time...)

Is this it in PHP? I need to write a wrapper class for that if there's no better solution! Or I'll just stay with the good ol' time() function and just use DateTime for easier parsing of the ISO date I get from the database.

$today = time() % 86400;
...
if ($date < $today + 7 * 86400) ...

Time zones not regarded in these examples.

Update: I just found out that I can use the strtotime() function as well for parsing such dates. So what's the use for a DateTime class in PHP after all if it's so complicated to use?

Update^2: I noticed that my $today = ... thing above is garbage. Well, please just imagine some correct way of getting 'today' there instead...

Answer:

It looks like you will definitely have to make a clone of the object. There does not seem to be a way to create a copy of the DateTime object any other way.

As far as I can see, you could save one line:

$today = new DateTime('today');
...
$then = clone $today;
if ($then->add(new DateInterval('P7D')) < $then) ...

I agree this isn't perfect. But do stick with DateTime nevertheless - write a helper class if need be. It is way superior to the old date functions: It doesn't have the year 2038 bug, and it makes dealing with time zones much, much easiert.

http://stackoverflow.com/questions/4868709/php-datetime-for-net-developers

Modify microseconds of a PHP DateTime object

by Blogger 2:42:00 AM Datetime microseconds PHP PHP DateTime

Modifying a php DateTime object

by Blogger 2:39:00 AM Datetime PHP PHP DateTime

Modifying a php DateTime object

I have a question respect of the proper way to modify a php DateTime object.at the present time , I'm doing something like:

$origEvent = new DateTime(...);
$newEvent = new DateTime(...);
$someOtherEvent = new DateTime(...);

//get the time difference between the orignal event and the edited event
$diff = $origEvent->diff($newEvent);

$someOtherEvent->add($diff);

Using the DateTime::add() method seems to work whether we are adding or subtracting time from $someOtherEvent. Is this the correct way to do this? I know there is DateTime::sub() used for subtracting time, but it seems that as long as the DateInterval (produced by the $origEvent->diff()) has the inverted flag, the DateTime::add() knows to actually subtract time. Is this correct? Should I be using something like DateTime::modify?

Answer:

Actually, DateTime::diff() returns the difference between two DateTime objects in a relative manner. Thus :

If date1 is lower than date2 then date1->diff(date2) will result in a negative interval
If date2 is lower than date1 then date1->diff(date2) will result in a positive interval

So :

The use of DateTime::add() with a negative interval is equivalent to the use of DateTime::sub() with the absolute value of this same interval
The use of DateTime::sub() with a negative interval is equivalent to the use of DateTime::add() with the absolute value of this same interval

For reasons of clarity of the code you can set the second parameter of DateTime::diff() to true in order to get an absolute difference every time and then choose the best function between DateTime::add() and DateTime::sub() knowing that you have an absolute difference.

Some words about the choice between DateTime::modify() and DateTime::add(), DateTime:sub() :

As long as you are using DateTime::diff() you are assuming that your PHP version is greater than or equal to 5.3.0, and you can use all new functions available in this PHP version; that is to say DateTime::add() and DateTime::sub()
The use of DateTime::modify() is justified when your PHP version is greater than or equal to 5.2.0. (In this version DateTime::add() and DateTime::sub() are not yet available)

http://stackoverflow.com/questions/11092285/modifying-a-php-datetime-object

All In One Script

PHP: DATETIME Help

PHP: DATETIME Help

Answer:

PHP Datetime with MySQL datetime

PHP Datetime with MySQL datetime

Answer:

PHP DateTime issue

PHP DateTime issue

Answer:

PHP DateTime Update

PHP DateTime Update

Answer:

PHP DateTime for .NET Developers

PHP DateTime for .NET Developers

Answer:

Modify microseconds of a PHP DateTime object

Modify microseconds of a PHP DateTime object

Answer:

Modifying a php DateTime object

Modifying a php DateTime object

Answer:

Search This Blog

Followers

Instagram

About

Popular Posts

statcounter

statcounter