如何使用日期mysql添加从数据库中检索的天数

Question

i have start_date and number_of_days_to _complete stored in database.now i want to echo finish_date by adding this two dynamically.i added a constant date as follows

<?php
           $date = strtotime("+7 day");
           echo date('d/m/Y', $date);
 ?>

what should be the syntax for my requirement??? i guessed a syntax but it returns wrong date.the format is as follows

$date=strtotime("+<?php $row->day_number; ?> day");
echo date('Y-m-d', $date); ?>

Answer 1

Change it to this :

$requiredDayString = '+'+$row->day_number;
$date=strtotime("$requiredDayString day",strtotime("2016-04-06"));
echo date('Y-m-d', $date); ?>

or to make it more dynamic pass as a variable :

$requiredDayString = '+'+$row->day_number;
$inputDate = "2016-04-06";
$date=strtotime("$requiredDayString day",strtotime($inputDate ));
echo date('Y-m-d', $date); ?>