php display date from sql

Question

I'm currently working on a page, where I've got a problem with getting the date from the database table.

It looks like, i have now an own kinda array for the datetime column.

print_r of my database:

        $projwebt = $viewmanager->getViewPageProjwebtProjekte();
        echo "<pre>";
        print_r($projwebt);
        echo "</pre>";

Output:

        Array
        (
        [0] => viewPageProjwebtProjekte Object
        (
        [id] => 1
        [projectnumber] => 1
        [name] => Title
        [progress] => 37
        [status] => 1
        [responsible] => user
        [customer] => user
        [definition] => 1
        [effort] => 15
        [priority] => 12
        [startdate] => DateTime Object
            (
                [date] => 2016-11-25 00:00:00.000000
                [timezone_type] => 3
                [timezone] => Europe/Belgrade
            )

        [targetdate] => DateTime Object
            (
                [date] => 2017-08-31 00:00:00.000000
                [timezone_type] => 3
                [timezone] => Europe/Belgrade
            )

works fine:

        <?php
        foreach ( $projwebt as $projobject )
        {
        ?>
            <tr class="<?=$projobject->status?>">
                <th colspan="2"><h2><a href="#"><?=$projobject->name?></a></h2></th>
                <th colspan="2"><h2><?=$projobject->definition?></h2></th>
                <th colspan="2"><h2><?=$projobject->progress?>%</h2></th>
            </tr>
         <?php
         }
         ?>

here it breaks, because of the startdate:

            <tr>
                <td class="responsible">Zuständig:</td>
                <td class="responsibleName"><?=$projobject->responsible?></td>
                <td class="effort">Aufwand:</td>
                <td><?=$projobject->effort?> MT</td>
                <td class="start">Start:</td>
                <td class="startDate"><?=$projobject->startdate?></td>
            </tr>

datamapper:

            $pageProjwebtProjekte->startdate = $row['startdate'];
            $pageProjwebtProjekte->targetdate = $row['targetdate'];

viewmanager:

            $viewPageProjwebtProjekte->startdate = $value->startdate;
            $viewPageProjwebtProjekte->targetdate = $value->targetdate;

when I pick the date to display (object oriented) it breaks.

So is there a way to pick the date element of the array startdate/ targetdate? what do i have to set in my classes (viewmanager/ mapper...)?

I have no problem, when I try to display definition or effort and so on.

Thank you for having a look!

Try using format method() php.net/manual/en/datetime.format.php — ka_lin
– ka_lin, Commented Oct 27, 2016 at 11:54
Somewhere your code is converting the datetime from the database to a php DateTime object. That does not happen automatically, you are doing that yourself and you can format its value using the format() method. — jeroen
– jeroen, Commented Oct 27, 2016 at 11:55
Thank you very much for these informations! helped me a lot for understanding! — SteelNation
– SteelNation, Commented Oct 27, 2016 at 12:26

junkfoodjunkie · Accepted Answer · 2016-10-27 11:54:54Z

3

You have a DateTime object, not a regular array. Do something like this:

<?= $startdate = $projobject->startdate->format('Y-m-d'); ?>

answered Oct 27, 2016 at 11:54

junkfoodjunkie

3,1861 gold badge22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SteelNation Over a year ago

This was exactly the solution for my problem, thank you very much! will keep that in mind, for the next time.

gbestard · Accepted Answer · 2016-10-27 11:55:00Z

3

If you want to echo the date from a DateTime object you should use the format method.

Ex. echo $projobject->startDate->format('Y-m-d');

You can see the documentation here: http://php.net/manual/es/class.datetime.php

answered Oct 27, 2016 at 11:55

gbestard

1,17713 silver badges30 bronze badges

Collectives™ on Stack Overflow

php display date from sql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related