Skip to main content

Date Difference in PHP

There is a easy method for find date difference in php.

But this method didn't work after i hosted my files.

So i came up with following. it is generating difference in days. but you can use other calculations for generate Months, years. This is a simple method.

$from = date("Y-m-d",strtotime('2011-04-01'));

$to= date("Y-m-d",strtotime('2011-04-06'));

$diff = strtotime($from )-strtotime($to);

echo floor($diff / (60*60*24));

60*60*24 = Generate Days (86400)

"year" = 29030400,

// seconds in a year (12 months)
"month" = 2419200, // seconds in a month (4 weeks)
"week" = 604800, // seconds in a week (7 days)
"day" = 86400, // seconds in a day (24 hours)
"hour" = 3600, // seconds in an hour (60 minutes)
"minute" = 60, // seconds in a minute (60 seconds)
"second" = 1 // 1 second


Labels:

Comments

  1. PHP programmingApril 13, 2011 at 5:59 AM

    Honestly say,great blog with good picture gallery and also detail explain every topic for the viewers of this blog,I like subscribe this blog. Thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

How To Disable Export Button In Crystal Report When you are taking crystal report printouts through a program, such as program written using vb6. you might have a problem how to disable Export button in print preview. All you have to change following property to false or Uncheck the Export option in Property Pages. You CR.WindowShowExportBtn = False Crystal Report Object in Visual Basic 6. (CR is refer to Crystal Report Object ) You can go to Property Pages by right click and choose Properties on Crystal Report Object After you done those things you crystal Report print preview will showing like follows. I was face to above problem. We implemented a software program which is written using vb6. Cashier can take daily sale print out. before printing it is showing a preview to the user. So when the time pass user click export button and saved that report as a excel file. Then he modified the values and took printout to the management. That gives Security problem to the program a...
Post a Comment
Read more

Execute *.sql with .NET

Do you ever want to execute slq statements at once. I mean SQL Script file. Normally we are using like following commands to Execute Single SQL statement. SqlCommand cmd = new SqlCommand(sSQL, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); but this way you can execute one command at a time. We cannot execute SQL script using above command. Normal SQL Script Like this. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__titleauth__au_id__0519C6AF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF GO CREATE TABLE [dbo].[authors] ( [au_id] [id] NOT NULL , [au_lname] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [address] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [city] [varchar] (20) COLL...
4 comments
Read more

Magento DB access denied

I got this error suddenly while accessing the magento site. SQLSTATE[HY000] [1129] Host 'user.workgroup' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' Solution use below command in console mysqladmin flush-hosts or log in to  mysql with a different host if its implemented on network environment and use below statement; FLUSH HOSTS; Or Restart the mysql server
Post a Comment
Read more