Codeigniter-PHP : How to Change table week Dates , On change of input date

Question

<input type = "date" name = "myDate" onchange = ""> //this is input date

When the user picks a date then it wants to change based on above date How to change based on given date please help me..!

<table class="table table-bordered" id="thbg">

<thead><td></td>

<th>Project</th>

<th>Activity</th>

<th>Bill Type</th>

<?php

$day = "1";
$month = "11";
$year = "2017";

$start_date = $day."-".$month."-".$year;
$start_time = strtotime($start_date);

$end_time = strtotime("+1 week", $start_time);

for($i=$start_time; $i<$end_time; $i+=86400)
{
  print  '<th align="center"> '. date("m-d-Y  l", $i). '</th>';
}
?>
<th>Hours</th>      
</thead>
</table>

And the output is also getting wrong dates, e.g. I am getting two Sundays at a time

Can anyone suggest a solution?

Just a comment - your HTML is technically invalid. You should have a <tr> around all your <td>s and <th>s - i.e. table cells must be within a table row, which can itself be within a <thead> or <tbody>, and those must be within a <table> element. — ADyson
– ADyson, Commented Nov 30, 2017 at 11:21
Yaa i changed my code with <table>, but this is not my solution — Narsimhulu
– Narsimhulu, Commented Nov 30, 2017 at 11:39
I know it's not, that's why I made it a comment not an answer :-) — ADyson
– ADyson, Commented Nov 30, 2017 at 11:40

Atural · Accepted Answer · 2017-11-30 12:32:06Z

1

Not sure what you try to achieve here but a better option would be to use the DateTime Class

something like that should work

$day = "1";
$month = "11";
$year = "2017";
$objDateStart = DateTimeImmutable::createFromFormat('j-m-Y', $day."-".$month."-".$year);
$objDateEnd = $objDateStart->modify('+1 week');

$objDateRange = new DatePeriod($objDateStart, new DateInterval('P1D'), $objDateEnd);
foreach($objDateRange as $objDate)
{
    echo  '<th align="center"> '. $objDate->format("m-d-Y l"). '</th>';
}

answered Nov 30, 2017 at 12:32

Atural

5,4505 gold badges21 silver badges36 bronze badges

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

Comments

Ayyappa amara · Accepted Answer · 2017-11-30 12:16:02Z

0

As it is i have executed your code, i am getting proper output without any repeated values. 

echo "<table><thead>

        <th>Project</th>

        <th>Activity</th>

        <th>Bill Type</th>";


        $day = "1";
        $month = "11";
        $year = "2017";

        $start_date = $day."-".$month."-".$year;
        $start_time = strtotime($start_date);

        $end_time = strtotime("+1 week", $start_time);

        for($i=$start_time; $i<$end_time; $i+=86400)
        {
          print   '<th align="center"> '. date("m-d-Y  l", $i). '</th>';
        }
        echo "<th>Hours</th>
        </thead>";

edited Nov 30, 2017 at 12:16

answered Nov 30, 2017 at 11:40

Ayyappa amara

4123 silver badges16 bronze badges

4 Comments

Narsimhulu Over a year ago

but iam getting like this: 11-01-2017 Wednesday 11-02-2017 Thursday 11-03-2017 Friday 11-04-2017 Saturday 11-05-2017 Sunday 11-05-2017 Sunday 11-06-2017 Monday 11-07-2017 Tuesday

Narsimhulu Over a year ago

i got two sundays at a time

Ayyappa amara Over a year ago

if it is possible please try to post full code... then we can find the mistake. As of now what i have posted with code that is working fine. have you tried my code?

Narsimhulu Over a year ago

please see my picture above

ourmandave · Accepted Answer · 2017-11-30 12:31:51Z

0

The date command is repeating Nov 5th because that was daylight saving time and it's rounding down the hours to 00:00:00.

Try using the datetime object instead.

Here's an answer that loops through a date range with it.

https://stackoverflow.com/a/29765247/3585500

answered Nov 30, 2017 at 12:31

ourmandave

1,5852 gold badges16 silver badges55 bronze badges

Collectives™ on Stack Overflow

Codeigniter-PHP : How to Change table week Dates , On change of input date

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related