Using PHP $date1 = date("Y-m-d"); $date2= "2005-5-15&quo

How can we know the number of days between two given dates
using PHP?
How can we know the number of days between two given dates
using MySQL?

Question Posted / abdulgafoor

6 Answers
14690 Views
I also Faced
E-Mail Answers

Answer Posted / abdulgafoor

Using PHP

$date1 = date("Y-m-d");
$date2= "2005-5-15";
$nodays = (strtotime()-strtotime())/(60*60*24);

echo "no of days are $nodays ";

Using mySql :

mysql>SELECT DATEDIFF(NOW(),'2005-5-15');
The output will give you the exact number of days.

Is This Answer Correct ?

12 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a query give example?

926

What is the capacity of mysql database?

1007

What is the use of trim function in php?

921

What is cURL in PHP?

946

Tell me how can I display text with a php script?

921

Which function(s) in PHP computes the difference of arrays?

950

Steps for the payment gateway processing?

955

Is key in array php?

954

What is difference between strstr() and stristr() in PHP?

932

What is php beginner?

921

What is php form validation?

970

How can php and javascript interact?

1217

What is PHP's configuration file called?

1143

How to remove values saved in the current session?

971

What is "echo" in php?

924