PHP - Date Check - Two Dates Must Be A Year Apart

Hi,

I've got a date picker on a form which puts data into a database in the YYYY-MM-DD format. Just wondering how I could also put the name of the month (extracted from that) as well as just the year into separate columns. Ie: To use the field race_date from the form to also fill the 'race_month' and 'race_year' columns in the database.

This code obviously only fills the 'race_date' column so far:
Code: [Select]

global $_POST;

$race_date = $_POST["race_date"] ;


....



$query = "INSERT INTO 10k_races (race_date, race_month, race_year)" . "VALUES ( '$race_date', '$race_month',  '$race_year')";

Hi all,   I have a search page where I'd like members to be able to search for races that they and their friends have entered into a database. When entering the data, users put the race date into the race_date field (Which is a DATETIME field) in the table.   I've set up the search and display pages, so users can search by a number of other criteria (first name, last name, race distance, time, etc), but am having trouble with searching by year. On my search form, is a field called race_year.   So, obviously I need some change in the code below, specifically in relation to the line $where .= " AND race_date='$race_year'"; because I want to extract the year part of the race_date column from the table and see if it matches $race_year .   Any advice would be appreciated.   Cheers, Dave  

$race_year = $_POST['race_year'];
if ($race_year != '')
{ // A year is selected
  $where .= " AND race_date='$race_year'";
}

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

Hi i have a drop down menu for date which is meant to insert all 3 values into a date column bt is only sending the year how can i fix it

<select name="date_of_birth">

    <option value="1">January

    <option value="2">February

    <option value="3">March

    <option value="4">April

    <option value="5">May

    <option value="6">June

    <option value="7">July

    <option value="8">August

    <option value="9">September

    <option value="10">October

    <option value="11">November

    <option value="12">December

</select>

<select name="date_of_birth">

    <option value="1">1

    <option value="2">2

    <option value="3">3

    <option value="4">4

    <option value="5">5

    <option value="6">6

    <option value="7">7

    <option value="8">8

    <option value="9">9

    <option value="10">10

    <option value="11">11

    <option value="12">12

    <option value="13">13

    <option value="14">14

    <option value="15">15

    <option value="16">16

    <option value="17">17

    <option value="18">18

    <option value="19">19

    <option value="20">20

    <option value="21">21

    <option value="22">22

    <option value="23">23

    <option value="24">24

    <option value="25">25

    <option value="26">26

    <option value="27">27

    <option value="28">28

    <option value="29">29

    <option value="30">30

    <option value="31">31

</select>

<select name="date_of_birth" id="year">

<?php

$year = date("Y");

for($i=$year;$i>$year-50;$i--)

{

if($year == $i)

echo "<option value='$i' selected>Current Year</option>";

else

echo "<option value='$i'>$i</option>";

}

?>

Hi,
A user selects week and a room to book. I put these into an array so I have now have an array of room numbers and dates.

I don't want them to book seperate holidays for one accommodation, I have mangaged to stop them booking a two week stay and they an extra week.  But I need a way to stop them booking two or three seperate two week holidays.  So basically I need to just give an error if the dates they have selected are not consecutive.

I have tried many variations of adding and subtracting 7 days  and comparing that in the array using a loop based on the room ids being the same.

I know the code below doesn't work but it gives an idea of how I been trying.
Also assume that the array has aan accomID and date seperated by a comma.

 function search_break_in_consec_weeks($accomCountValidCheck, $accomID, $date){

$allConsec = false;

foreach ($accomCountValidCheck as $key=>$value){

$varArray =  explode(', ', $value);

$varDate =  $varArray[1];

$varAccomID =  $varArray[0];

if($accomID == $varAccomID && date("Y-m-d", strtotime($date)) == date("Y-m-d", strtotime($varDate ."+7 days")) || date("Y-m-d", strtotime($date)) == date("Y-m-d", strtotime($varDate ."-7 days"))){

   $allConsec = true;

   break;

}else{

   $allConsec = false;

}

}

return $countStray;

}

foreach($accomCountValidCheck as $accomVal){

$varArray =  explode(', ', $accomVal);

$varAccomID  =  $varArray[0];

$varDate=  $varArray[1];

 $valReturnConsec = search_break_in_consec_weeks($accomCountValidCheck, $varAccomID, $varDate);

if($valReturnConsec){echo '<b>'.$varAccomID.'</b>'. ' consec<br />';}

if($valReturnConsec == false){echo $varAccomID .'not consec<br />';}

}

I'm trying to wrap my head around how i should go about doing this. I have two dates...2011-05-03 and 2011-05-08. I want to write a function that creates an array of the days that consist of that date range. So say something like

Code: [Select]
<?php
$start = "2011-05-03";
$end = "2011-05-08";

function get_days($start, $end)
{
//code to get the days
}

echo get_days($start, $end);

//hopefully produce something like...
$day['1'] = "2011-05-03";
$day['2'] = "2011-05-04";
$day['3'] = "2011-05-05";
$day['4'] = "2011-05-06";
$day['5'] = "2011-05-07";
$day['6'] = "2011-05-08";

anybody know any idea how to do something like this? Pretty sure i'm going to need the mktime() function to account for ranges going across months and years. 

I have got a date field in my mysql database with events, and as you know date in MYSQL uses yyyy/mm/dd but I would first like to turn this around to dd/mm/yyyy but also turn this into for example "Tuesday - May 1990" would anyone like to point me into the right direction?

Much appreciated!

I have date stored in database in any of the given forms 2020-06-01, 2020-05-01 or 2019-04-01

I want to compare the old date with current date 2020-06-14

And the result should be in days.

Any help please?

PS: I want to do it on php side. but if its possible to do on database side (I am using myslq) please share both ways🙂

Edited June 14, 2020 by 684425

I'm trying to do the following PHP. I have written it in English

if (today's date) => date1 AND <= date2 then {display image1}
elseif (today's date) => date3 AND <= date4 then {display image2}
else {display image 13}

There are 24 fixed dates and 13 fixed images.

I have tried using combinations of strtotime(), replacing the date value with variables, hard coding the dates within the program. I don't seem to be able to get any combination to work properly. I'm sure it's just a syntax error but I can't see it. When I've searched the web all the answers I've found relate to dates within databases but as I only have 24 dates it seems a bit of overkill. I would appreciate any pointers to the correct method I might be able to use. The dates need only a day and month as I would like this to repeat year after year.

<?php
$today = strtotime(date('d-m'));

if (strtotime($today) >= strtotime('28-10') && strtotime($today) <= strtotime('24-11')) {echo "<div>image1</div>";}
elseif (strtotime($today) >= strtotime('25-11') && strtotime($today) <= strtotime('22-12')) {echo "<div>image2</div>" ;}
elseif (strtotime($today) >= strtotime('23-12') && strtotime($today) <= strtotime('24-02')) {echo "<div>image3</div>" ;}
else {echo "<div>image13</div>";}
?>

The result I get from this is image1 appears on the web page but I would expect image3 as today is 22-01

Thank you in advance.

Andrew

I have a query that fetches all the dates in a date range then displays them in a Date:HH:MM;SS format.   However when displayed sometimes there are missing Hours as I don't have data for them and I would like to display it.  So right now I have something like this.

Date Column:                Revenue_Column:
07/29/2010 00:00:00   $250.00
07/29/2010 01:00:00   $150.00
07/29/2010 03:00:00   $350.00
07/29/2010 04:00:00   $450.00

As you can see 02:00:00 is missing, how can I use php or possibly mysql to fill in that gap?   I have tried creating an hours table and joining them and grouping by date however that doesn't seem to work.  Any ideas?

I would like to know the best practice to achieve the following:

I have a list of dates related to live events for performing artists.  When someone views the web page that contains a section to display the dates, I would only want to show the dates from today into the future and not show any dates from the past.

What is the best way to accomplish this?

Thanks in advance...

Hello, i have two fields.  a beginning year and an ending year.  How can i make new fields out of the years in between the beginning and ending years.  i hope that makes sense. 

Hi,

I have database stored a field of date. I want to check if the date in the DB field is the same as the current date, how to do it?

Code:

$oracle = mysqli_real_escape_string($con, $_POST['oracle']);
$query 	= mysqli_query($con, "SELECT indate FROM staff WHERE OracleID ='$oracle'");
$row	= mysqli_fetch_array($query);
$num_row = mysqli_num_rows($query);
		
	if ($num_row > 0) 
	{	
		$curdate = date();
		if ($row['indate'] !== $curdate)
		{
			$query1=mysqli_query($con, "update staff set ClockedIn = 0, ClockedOut = 0 where OracleID='$session_id'")or die('Error In Session');
			header('location:home.php');				
		}
	}

 

Hi Guys,

Need some help

I have two dates:
Now= 2011-02-08 
Expires= 2011-06-15

How can I check if we are getting close to the expire date.

For example.

Lets say we were 5 days away from 2011-06-15 ( todays date was 2011-06-10 ) for example..

How can i tell this? / return 1

Ie:
if date is 5 days or less away do ( this )

Its s essentially so i can email people when something is due to expire.

Many thanks
L

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...