PHP calculate days Between 2 different dates

Question

Hello and thanks for the help. I have a table in mysql with 2 columns (date1),(date2).I want to find the days between these two days and calculate a price of 10 dollars for each day through php

This has been asked here **a lot**. Search this site and you'll find the code you need. — John Conde, Apr 24 '13 at 19:35
You can do this both with MySQL or with PHP, search around there's a lot of code — blackbird, Apr 24 '13 at 19:37

DiverseAndRemote.com · Accepted Answer · 2013-04-24T19:43:22.480

1

here you go:

$dt1 = new DateTime("@{$date1}");
$dt2 = new DateTime("@{$date2}");
$interval = $dt1->diff($dt2);
$price = 10 * $interval->d;

This assumes that you are saving your dates $date1and $date2 as unix timestamps

edited Apr 24 '13 at 19:43

answered Apr 24 '13 at 19:38

DiverseAndRemote.com

19,314
10
61
70

i will try it, i need to get the dates from mysql – marina Apr 24 '13 at 19:39

score 1 · Answer 2 · answered Apr 24 '13 at 19:39

Try this..

<?php
     $first_date = strtotime("2013-04-10");
     $last_date = strtotime("2013-04-01");
     $datediff = $first_date - $last_date;
     echo "Days : ". floor($datediff/(60*60*24))."<br>";
     echo "Price : $". (floor($datediff/(60*60*24)))*10;
?>

Output

Days : 9
Price : $90

PHP calculate days Between 2 different dates

2 Answers2

Linked

Related