PHP - Date/time Calculation In Php

Hi,

Im trying to calculate days between two dates and add that to the php code below.


I have this code that pulls records from my database and outputs it as json.

<?php
$servername = "localhost";
$username = "xxxxx";
$password = "xxxxx";
$dbname = "xxxxx";
$connect = mysqli_connect("localhost", "xxxxx", "xxxxx","xxxxx");
$sql = "SELECT * FROM solstice";
$result = mysqli_query($connect, $sql);
$json_array = array();
while($row = mysqli_fetch_assoc($result))
{
$json_array[] = $row;
}
/*echo '<pre>';
print_r('records:');
echo '</pre>';*/
echo json_encode($json_array);
?>

Basically I was thinking something like this but I don't know how I can add this to php above that produces json . This information is calculated on the fly. I need to add TotalTime and Date3

$Date1_ts = strtotime($row['Date1']); //Timestamp
$Date1_str = date("M-d-Y", $Date1_ts); //String in format MMM-DD-YYYY
$TotalTime = floor((time() - $Date1_ts)/(60*60*24)) . ' days';//Total in days
$start_ts = strtotime($row['Date1']);
$end_ts = strtotime($row['Date2']);
$date_diff = ($end_ts - $start_ts);
$Date3= ($date_diff>0) ? floor($date_diff/ (60*60*24)) : ''; // days difference from start to finish

I would be really grateful if someone could help me with this.
Thank you.

Hi guys,

$T_Start_Date = "2011-10-23";
$P_Days = "30";

I tried this Its working:
$T_End_Date = date('Y-m-d', strtotime("+$P_Days days");

but why am not getting this:
$T_End_Date = date($T_Start_Date, strtotime("+$P_Days days"));


thanks

Hi

I don't understand what I'm doing wrong, I want to subtract 6 months from my date, but I get 1969/07 as an answer?

Code: [Select]
<?php
$date = date('Y/m');
echo $date;
echo "<br/>";
$date1 = date ("Y/m", strtotime("-6 month", strtotime($date)));
echo $date1;
?>

Hi i was wondering if its possible to not display negative values or maybe there some other way to do this when date is calculated. in this case i have days, and the result brings "- 123" or "- 56" i just want it to show anything that's not negative. thanks.

Code: [Select]
$start_ts = strtotime($row['Applied']); // when process started
$end_ts = strtotime($row['Approval']); // when process finished
$Approval = floor(($end_ts - $start_ts) / (60*60*24)); // days difference from start to finish

Hi.  I am writing software to choose employees for drug testing.  Originally it was choosing 5 per day, Mon-Thu.  No problem there, that's easy.  Now, they want to ensure everyone gets tested each calendar year.  So now I need the program to look at the date and calculate the days between now and 12/31 then divide the people that haven't been tested by days to get number per day that need testing so it gets all done by the end of the year.   The snag I hit is how to calculate it.  I can easily get days to 12/31, but I need to drop the Fridays, Saturdays and Sundays of each week.  That has me a little perplexed.  Is there a way to make that kind of calculation?  Thanks!

I was wondering if someone could help me out with calculating and displaing dates. Below i posted html of my page and also php for it. It has a field called "DATE1" thats where visitors input the date, after that it gets posted to db and i pull it and disply it in a grid on my site. I would also like to have a column that shows time elapsed between the "DATE1" and current date.

I sorta figured how to calculate the dates using the php, but really stuck on how do i actually display it now. from what i been told so far i shouldn't create a new column for that, instead calculate and display the values on the fly, could some step me through this please, or get me started... thanks so much!

my html
Code: [Select]
<form id="signupForm" method="POST" action="processform.php">
  <div>
    <fieldset>
      <legend>Signup Form</legend>
      <label for="Country">*Country:</label>
      <select name="Country">
      <option value="">-----</option>
      <option value="Canada">Canada</option>
      <option value="UK">UK</option>
      <option value="France">France</option></select></div></p>

      <p><label for="Nationality">*Nationality:</label>
      <div><select name="Nationality">
      <option value="">-----</option>
      <option value="Afghanistan">Afghanistan</option>
      <option value="Albania">Albania</option>
      <option value="Algeria">Algeria</option></select></div></p>

      <p><label for="Province">*Province:</label>
      <div><select name="Province">
      <option value="">-----</option>
      <option value="British Columbia">British Columbia</option>
      <option value="Alberta">Alberta</option>
      <option value="Saskatchewan">Saskatchewan</option></select></div></p>
     
      <p><label for="DATE1">*Date:</label>
      <div><select name="day" id="Date1" class="regularfont"><option value="" selected="selected"></option>
      <option value="1">01</option>
      <option value="2">02</option>
      <option value="3">03</option></select>

      <select name="month" id="Date2" class="regularfont"><option value="" selected="selected"></option>
      <option value="1">January</option>
      <option value="2">February</option>
      <option value="3">March</option></select>

      <select name="year" id="Date3" class="regularfont"><option value="" selected="selected"></option>
      <option value="2014">2014</option>
      <option value="2013">2013</option>
      <option value="2012">2012</option></select>
    </fieldset>
  </div>
  <p>
    <div align="center"><input type="submit" name="submit" value="Submit your entry"></div>
  </p>
</form>
<p>

Code: [Select]
<?PHP
$hostname = "localhost";
$db_user = "";
$db_password = "";
$database = "";
$db_table = "";
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);
//here i use this to calculate the date but really unsure how to further display the results
Code: [Select]
if (isset($_REQUEST['submit'])) {
    // Get current time, or input time like in $date2
    $date1 = time();

    // Get the timestamp of DATE1
    $date2 = mktime(0,0,0,date($_POST['month']),date($_POST['day']),date($_POST['year']));

$dateDiff = $date1 - $date2;
    $TotalTime = floor($dateDiff/(60*60*24));
    echo "$TotalTime";
}

for posting to db
Code: [Select]
  if(isSet($_POST['submit'])) {
    $country     = mysql_real_escape_string($_POST['Country']);
    $nationality = mysql_real_escape_string($_POST['Nationality']);
    $province    = mysql_real_escape_string($_POST['Province']);
    $date        = $_POST['day'].'-'.$_POST['month'].'-'.$_POST['year'];

    $myQuery = "INSERT INTO {$db_table} (`Country`,`Nationality`,`Province`,`DATE1`) VALUES ('{$country}','{$nationality}','{$province}','{$date}')");

    if(mysql_query($myQuery)) {
      echo 'Record inserted.';
    } else {
      echo 'An error has occurred: '.mysql_error();
    }

  }
?>

Hi,

I want to calculate the future month, i have used following code to calculate the date
$date = date('Y-m-d',strtotime(date("Y-m-d", strtotime('2010-01-31')) . " +3 month"));

It gives me 2010-03-03

But i need to get 2010-02-28

OR just month is enough like 2010-02

Thank you
Nikhil

ok, i had some great help from this forum recently so i hope for the same outcome this time

probably a rather easy question for most of you,

i have a form that visitors use to input date using php (submission_date) in to db. date is then entered in db as a VARCHAR (i.e. Mar-15-2011), what i would like is to have another field which would calculate time elapsed. Since calculation can be only done on date not varchar ( i assume), i would need to have submission date also as a DATE and then passed on to a new field for calculating total time. does that make sense? lol

I would really appreciate any pointers or help with this, not sure if im going in the right direction, but thats a start

thank you!

Ok so I basically have two textfields and a submit button.

The first text field basically allows the user to input a duration of an event in the format of Hours:Minutes:Seconds such as: 02:30:00 is two and a half hours.

The second textfield allows the user to put in an average time 'something' does something in the same format as above. So for example 00:20:00 is 20 minutes.

1st Textfield: Code: [Select]
<input name="tmarrtextfield" type="text" class="textbox" id="tmarrtextfield" value="00:00:00">
2nd Textfield: Code: [Select]
<input name="tmatttextfield" type="text" class="textbox" id="tmatttextfield" value="00:00:00">
What I need is for when the form is submitted to the same page.. the code to...:

1. Convert the normal text info into actual time data.
2. Divide the duration by the average timing so for example: 02:30:00 (150 minutes) / 00:20:00 (20 minutes) = 7.5 (Would return a rounded down number or up, doesn't matter) then store the number as a variable that will be echoed later.

Harry.

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

OK So I've got a datepicker that sends a date in d/m/y format. My DB stores the data in Unix Timestamp Which I can convert the date to with strtotime however this does the exact date & time.

All I want is the actual day. I've spent hours trying to convert this with just the day with mixed results...

Thanks.

I am having a problem with PHP displaying the correct date and time. It updates as it should, but is fast by 4min and is always displaying a date in 2004. I ran a basic php script to make sure the application im using itself is not wrong. go to lunenburgledger.com/time.php

Anybody had any ideas on where to check? The system time on the Windows Server 2003 is correct. The only thing I can think of is that it was converted to a virtual machine on vmware esxi, but the system time stayed right. Any ideas?

Thanks!

Hey,

I need help with date, I have stored dates in my table in this format:
i.e. 22.10.2011 but now use timestamp to store dates.

Problem is with this query the WHERE clause will find dates in the old format
and I want to change that to the new format.

Code: [Select]
for($i = $count; $i > 0; $i--)
{
$day = date("d.m.Y", mktime(0, 0, 0, date("m"), date("d") - $i, date("Y")));
$tmp = mysql_fetch_array(safe_query("SELECT count FROM ".PREFIX."counter_stats WHERE dates LIKE '%".$day."'"));
$array[] = $tmp['count'] ? $tmp['count'] : 0;
}

Am I making sense ?

I have a batch script that reads from a timestamp.txt file to determine the last time it ran and I need to modify that by two hours.
What happens is the script will run to look for changes in the county records and their server time is two hours different from mine.

Code: [Select]
$fr=fopen("xml/timestamp.txt",'r');
$mydate=fread($fr, 50);
if ($incremental_updates == 1){
$default_template_file="xml/incremental_template.xml";
$default_config_name="xml/incremental.xml";
$contest=file_get_contents($default_template_file);
$contest=str_replace("{DATE_TAG}", $mydate, $contest);
$f=fopen($default_config_name,'w+');
fwrite($f, $contest);
fclose($f);
fclose($fr);
$fw=fopen("xml/timestamp.txt",'w');
fwrite($fw, substr(date('c'), 0, 19));
fclose($fw);
}else{
$default_config_name = "xml/full_update.xml";
}

I tried making a time stamp update look like $cur_timestamp=date("Y-m-d H:i:s", time() +14400); which is correct but it doesn't write to the text file properly.

Using the above fwrite($fw, substr(date('c'), 0, 19));
I get the correct results in the timestamp.txt file for my server time. I need it to be +14400

2011-05-25T08:27:51 would essentially become 2011-05-25T10:27:51 when it writes to the timestamp.txt

I hope that makes sense.

J

Hey,

I need help with my date & time string.
I need to edit it do show in a string + also use it for calculating things like when the date has passed.

The string is like this:
Code: [Select]
<?php $string = '2011-01-01 00:00 AM'; ?>

So i wanted to check if there was a function that can automatically convert it, so it would say for example:


Quote

Sunday, 1st of January 2011
00:00 AM



But at the same time compare $string against server time to see if the date has expired?

Hope you can help