PHP - Date Difference Calculate Days From Two Dates

Hi, I have this code :-

$datestarted = $row['datestarted'];
$datestart=date("l d/m/Y @ H:i:s",strtotime($datestarted)); 

Which is been echo'd like this :-

echo '
<tr align="center"'.$rowbackground.'>
<td>'.$datestart.'</td>							
<td align="center">
';

So for example I get this output :-Sunday 18/04/2021 @ 10:45:26

The data in the DB for the above is stored like this :-2021-04-18 10:45:26

 

What I'd like to do is also echo how many days ago this date was, all of the examples I've tried don't seem to work though?

Hey guys im stuck in a bind and need some input.

What im trying to do is display a number based from community levels.
ex:    This user need another 2 tasks to get next level.

here are the levels

1- 0-2 task     new
2- 2-5 tasks    beginer
3- 5-7 tasks    pro
4- 7+ tasks     advanced

The way it works is by two different tasks. basicly i wanna know which is the higher number in the tasks either how many posts or comment and figure out based on our levels how many tasks he need to complete in order for him to reach the next level.

the first query sees how many post this user has
the second check how many comment he has

I wanna take the highest number and that belongs to whicheber catgory, do a calculation. and have this kind of output

This user is level 2 and need 1 more task to reach the next level.

Like i know if he need one more that he has 4 tasks done.

I know im all over the place with this one im just trying to get someone who might have an idea of my issue and point me in the right direction. Either if this is a known ?? does this procedure has a specific name anything will help me.

Hi I'm trying to get this to work. 

I have known date in MySQL database entered as 2019-08-01 and I need to calculate from that date to current time. 

What I have is this code

$date_ts = strtotime($row['date_ts']); //Timestamp
$date_str = date("M-d-Y", $date_ts); //String in format MMM-DD-YYYY
$TotalTime = floor((time() - $date_ts)/(60*60*24)) . ' days';//Total in days

but my result showing as ==> 18367 days

Could someone please help me get this to work so it shows the right number of days. thank you

 

Hello,   I want to calculate the difference between 2 textbox value live.    I found this solution for adding http://forums.phpfre...xt-box-values/  , but dont know how to convert this for subtracting   here is my form

echo '<tr><td></td><td style="text-align:center;">TOTAL</td><td style="text-align:center;"><input type="text" readonly="readonly" name="payamount" value='.$total.' style="text-align:center; font-weight:bold; font-size:13px;" ></td></tr>';
echo'<form name="form1" method="post" action="" >
<tr><td></td><td style="text-align:center;">Advance</td><td style="text-align:center;"><input type="text" name="advance" ></td></tr>
<tr><td></td><td style="text-align:center;">Discount</td><td style="text-align:center;"><input type="text" name="discount" ></td></tr>
<tr><td></td><td style="text-align:center;">Total Payable</td><td style="text-align:center;"><input type="text" name="total" id="total"/></td></tr>
<tr><td><input type="submit" name="submit" value="PAY NOW" >

when i enter the value for advance and discount, it should subtract these values with Total and should get entered in Total Payable text box

hi all,

i'm trying to calculate the time difference between two dates in hours, for example: 2010-12-13 15:26:56 and 2011-12-13 15:26:56
i tried mktime but wasn't able to get a working function.

Thanks for the help

Hi,

I have a job listing website which displays the closing date of applications using:

$expired_date

(This displays a date such as 31st December 2019)

I am trying to show a countdown/number of days left until the closing date.

I have put this together, but I can't get it to show the number of days.

                    <?php 
                    $expired_date = get_post_meta( $post->ID, '_job_expires', true );
                    $hide_expiration = get_post_meta( $post->ID, '_hide_expiration', true );
                    if(empty($hide_expiration )) {
                        if(!empty($expired_date)) { ?>
                                <span><?php echo date_i18n( get_option( 'date_format' ), strtotime( get_post_meta( $post->ID, '_job_expires', true ) ) ) ?></span>
                    
                    <?php
                                        $datetime1 = new DateTime($expired_date);
                                        $datetime2 = date('d');
                                        $interval = $datetime1->diff($datetime2);
                                        echo $interval->d;

                     ?>
                        <?php }
                    } 
                    ?>

Can anyone help me with what I have wrong?

Many thanks

I want to see if a date is more than 10 days overdue.

if ($row['duedate'] < "todays date plus 10 days"){

How do I do that?  I put in quote sup there in "english" what I want...

i have a table that shows payments made but  want to the payments only showing from a set date(06/12/14) and before this date i dont want to show   this is my sql that doesnt seem to work and is showing dates before the specified date. .

"SELECT * FROM payments2014, signup2014, editprop2014 WHERE signup2014.userid = payments2014.payment_userid AND editprop2014.prop_id = signup2014.prop_id AND signup2014.userid !='page1' AND signup2014.userid !='page6' AND signup2014.userid !='page4' AND payments2014.payment_transaction_status !='none' AND payments2014.payment_transaction_status !='CANCELLEDa' AND payments2014.payment_type !='deposit' AND payments2014.payment_paid_timestamp NOT LIKE '%2012%' AND payments2014.payment_paid_timestamp NOT LIKE '%2011%' AND payments2014.payment_paid_timestamp >= '06/12/14' ORDER BY payments2014.payment_id DESC"

i have some other parts in the statment but this one that should be filtering is 

host_payments2014.payment_paid_timestamp >= '06/12/14' 

thanks in advance

I have a SQL row that has a date field: ex: 2010-11-01.
When a car is sold there either is a 30 day warranty, a 60 day warranty, or 0 day warranty.
What I'm trying to do is display when the vehicles warranty expires, based on the date it was sold, or when did it expire based on the same sold date pulled from the database.

Example using last months date: 2010-10-01

60 day: "Expires 11-30-10"
30 day: "Expired 11-01-10"

I can not seem to use the date function properly...
Any help would be greatly appreciated.

Hi guys, I've hit a brick wall here and am in need of your help.

I'm pretty new to PHP and have limited knowledge to say the least. I'll explain what it is I'm trying to do.

Set start date as 01/01/2004 (dmY) $oFour
Set how many days has it been since then? $today
Set how many days it was from $ofour 30 days ago. $today -30 = $thirtyDaysAgo


But the problem is I don't know how to make date('z'); work from 2004 and not 01/01/2010.

So $today will be how many days it has been since the start of 2004 and $thirtyDaysAgo will be $today -30. I can set up $thirtyDaysAgo no problem but it's just finding out how to get the $today number...


Hope anyone can offer a little light to my situation :/

Mav

Hi fellas, this is really kicking my arse and i know its so simple!

I retrieve a date from the database, done!
I am manipulating it to display as i want, done!
How the hell do i add 365 days to this date?

$date= ($row['date']);
$subscription = strtotime($date);
echo
"<p>Subscription renewal date: ". date('l jS F Y', $subscription) . "</p>";

Hi, I am trying to get the number of days between the current date and a date in the future specified by column 'end_date'. The code I have seems to be working but it displays the number of days as a negative number, how do I change this to be a positive number? I have tried simply changing $days = $now - $end_date; to $days = $end_date - $now; but that doesn't work as I thought it would! Thanks in advance..

Code: [Select]
$now = time();
      $end_date = strtotime($row['end_date']);
      $days = $now - $end_date;
      echo floor($days/(60*60*24));

is there an easy way to add weekdays to a stored date ... so far i have

echo date ( 'Y-m-j' , strtotime ( '5 weekdays' ) );

this adds 5 weekdays to the current date , can i have it add 5 weekdays to say $TableDate 1;

Thanks in advance...

I was wondering if there was a way to have the MAX function NOT return a Date that is more than 2 days into the future (from the current day)?  If there is a Date that is more than 2 days into the future I would like to return the one closest to the current day.  Here is the code I have:

Code: [Select]
<?php

mysql_connect("local", "xxx", "xxx") or die(mysql_error());
mysql_select_db("pricelink") or die(mysql_error());



// Get a specific result from the "ft9_fuel_tax_price_lines" table
$query ="SELECT ItemNumber,TableCode,Cost, MAX(`Date`) as `max_date`, MAX(`Time`) as 'max_time' FROM `ft9_fuel_tax_price_lines`
         GROUP BY `ItemNumber`,`TableCode`";

$result = mysql_query($query) or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>ItemNumber</th> <th>TableCode</th> <th>Date</th> <th>Time</th> <th>Cost</th> </tr>";


// keeps getting the next row until there are no more to get
while($row=mysql_fetch_array($result))
{

// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['ItemNumber'];
        echo "</td><td>";
        echo $row['TableCode'];
        echo "</td><td>";
        echo $row['max_date'];
        echo "</td><td>";
        echo $row['max_time'];
        echo "</td><td>";
        echo $row['Cost'];
echo "</td></tr>"; 


} 

echo "</table>";
?>

Any help would be appreciated.
Thanks!

Hi...

Good day!

I have table that has a field from_date and to_date.

Now I just want to know if how can I display as table format the dates between from_date to_date.

Like this

from_date: 2011-12-16
to_date: 2011-12-31

I want to display it:

16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 // table format.

Thank you