PHP - Future Date Calculation

Hi,

This one has been driving me up the wall, so hopefully some kind person can help me.

I'm trying to make a validation script. $creststartdate comes in from a form as a UK formatted date (d/m/Y), and if $creststartdate is more than a month ahead of today, then it gets rejected. here's the code I have now...

Code: [Select]

            $today = date("m/d/y");
            $onemonth = strtotime ('+1 month', strtotime($today));
            $nextmonth = date ('d/m/Y', $onemonth);
           
            $csd = date("m/d/y", $creststartdate);
            $strcsd = strtotime($csd);
            $newdate = date ('d/m/Y', $strcsd);

            if ($newdate > $nextmonth)
                {
                    $creststartdatefailed = "The Crest Start Date cannot be more than 1 month in the future.";
                    $creststartdatevalid = "NO";
                }

As it stands, this version of the code means that nothing is getting rejected.

Please help?? 

Cheers

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!

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,

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;
?>

how to calculate the difference between the current datetime  from the stored one(ie date_field = 2020-08-09 23:13:06) in order to compare with 15min, i mean  if the resulted time exceed 15 min and not the same day(date) the provided link will show  expire message.

i.e $some_variable = $date_in_db - current_date;

if((time() - $some_variable > 15*60) && not the same day or the same day){

echo 'the link has expired';

}

 

hi,

I have some code that deals with sending out reminders for appointments due the following day.

So if today is the 21/3 then only reminders for appointments due on the 22/3 should be sent.

Currently this isn't happening...
 
If reminders are sent on 21/3 at 9.50 am, my code adds 24 hours to this datetime and sends reminders due for all
appointments that fall bewteen 21/3 9.50am and 22/3 9.49 am.

What I want to do is simply send all reminders for appointments that are on the 22/3 exclusive of time.

I'm not sure how do this in php, which uses the unix datetime format to mildy complicate issues

anhy help or solutions would be massive, thanks.how to


Code: [Select]
$days = time() + (1 * (60 * 60 * 24));
$apts = $db->fetch_all('status = 1 AND time > ? AND time < ?', array(time(), $days));

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!

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();
    }

  }
?>

Evening All,

How would I go about selecting a future date based on a date?

What I want to achieve is to take todays date, add ten days to it and then store it as the month end following that date.

For example 19th Nov + 10days = 29th November = 31st Dec


Many thanks for any pointers!

Hello.  I wanted to make a table where the dates are listed going forward at least one year.  So, at least 365 records, but each date should be unique and should start from today until one year from now.  I tried to make a date column and make it a primary key.     However, an error comes up when I try to insert more than one record.  This is for a calendar that I'm building so I need the dates listed one year in advance and it would be great if new dates could be added without my having to manually go in there and insert new records to stick to my 1 year in advance rule.     For that aspect I might have to create a php script where the date records are added every time a user logs in, to make sure they are up to date, but anyways what I don't understand is why I can't make a table with 1 year of date records in advance, where each row has a unique date starting from today.

What are your feelings regarding Linux desktop distros, and their ability to break through to mainstream usage? I started using Ubuntu about 6 or 7 years ago, and have fooled around with some other distros, but at least for me Ubuntu always seemed the best. I've got my 65 year old mom using it, and my 11 year old son playing with Kubuntu (and learning python!). I don't really consider us normal though; normal being almost too dumb to do more than check email and get on the internet.   I've managed to fully switch over to Ubuntu on all of my computers, with the exception of running Windows in a VM for Photoshop and Illustrator. Since I don't use those programs every day, there are a lot of days where I don't see Windows. I never really had a problem with Windows, except for Windows 3.1 was kind of a drag. Getting on the internet on a 56K modem on Windows 95 wasn't any fun either, but that wasn't Windows' fault. I never had the crashes and bad experiences people like to claim makes Windows suck. My main reason for abandoning Windows is just to be more involved with Linux, and hopefully reach Linux guru status someday.   I really never liked Macs. I bought one 3 or 4 years ago, and it just felt like I was paying a lot of money for a glorified (and over-hyped) linux distro. I really never liked the feel of the Finder. At the time there was no awesome text editor, and I bought a couple just to test out what I could find. Unlike Windows and Linux, it seemed like nothing is free in the Mac world. I eventually gave the Mac away. We couldn't be friends.   I'd really like to see Linux become the dominant OS. It's exciting to see how far Ubuntu has come in the years that I've used it, and I evangelize for Linux/Ubuntu quite a bit. Even still, it can sometimes seem that I am a stranger in a strange world. Do you think we can count on Linux being a bigger part of mainstream computing? One of the problems I see is that there are so many distros that a person investigating Linux may be a little overwhelmed. What do you think is keeping the masses from using Linux desktops?

Hello!

I've managed to solve that the content is shown AFTER 6 hours when added to the SQL. But I want to add many things on the same (current time) but I don't want everything to pop up after 6 hours. I want a 6 hour delay on EACH content I add. How do I solve this?

Here is my code:


$six_hours_ago = time() - 21600;
$sql = "SELECT * FROM Trailers WHERE Genre LIKE '%".$_GET['show']."%' AND time < '".$six_hours_ago."' ORDER BY `Trailers`.`sort` DESC";


insert.php
$sql="INSERT INTO Trailers (Poster, Title, Year, Genre, IMDB, Actors, Plot, Youtube, time)
VALUES
('".mysql_real_escape_string($_POST['Poster'])."','".mysql_real_escape_string($_POST['Title'])."','".$_POST['Year']."','".mysql_real_escape_string($_POST['Genre'])."','".$_POST['IMDB']."','".mysql_real_escape_string($_POST['Actors'])."','".mysql_real_escape_string($_POST['Plot'])."','".$_POST['Youtube']."', '".time()."')";


Thanks!

Hi everyone,

I'm writing a science fiction wordpress blog set 10 years into the future.
I basically need all posts to display as if they are 10 years from now.

Eg. posts needs to display as:
February 7, 2021 instead of
February 7, 2011

This will be for every post that I write.


How can I automatically add 10 years to every post date?
(And where would I put that code?)

Currently, the wordpress php is calling the date with `<?php the_time(__('M j, Y')) ?>`

I realise it's a bit of an odd request, but it's necessary for this particular project. I know it's possible - but I'm brand new to php and am not sure how. =)

I hope someone out there can help. It would be very much appreciated.

many thanks in advance

Luke