PHP - Compare Current Date Within A Range Of 24 Dates Using If Else

I have this code that compares date times but im not sure if its correct.

if("2008-08-10 00:00:00.0" > strtotime("now")) {
        echo "here";
    }


The code echo's here, but it shouldn't because the time is less than the current time. Any ideas?

hi
i am am making a leave calendar ...i want to compare dates and if the matches the background will be changed .
i am try to do is i got two loops first for  12 months and seconds for numbers of days in that month and i am using $num = cal_days_in_month(CAL_GREGORIAN, $Month, $cYear)
 this will give be numbers of days in that month...
 then there is a my sql query which will select that dates and other data from database ..
now problem i am have is that numbers of days are not increment  it show date like 2011-1-1 ,2011-1-1 and so on instead of 2011-1-1, 2011-1-2....
please help me ..here

<<pre lang="xml">table >
<?php for($Month=01;$Month <= 12;) { ?>
    <tr>
        <td  width="18%"  colspan="2"><strong><?php echo $monthNames[$Month-1]; ?></strong></td>
        <td  width="12%"  colspan="2"><strong>Division</strong></td>
        <?php
        $num = cal_days_in_month(CAL_GREGORIAN, $Month, $cYear); // 31
        //$dates = date("$cYear-$Month-1");
            $sql ="SELECT leave_date,leave_status,leave_comments,leave_type_id FROM `hs_hr_leave` WHERE employee_id = $emplid ";
            $res = mysql_query($sql);

        for($i=1;$i<=$num;$i++)
        {   $dates = date("$cYear-$Month-$i");
                //echo $dates."<br/>";
            while ($row = mysql_fetch_row($res, MYSQL_NUM)) {
                 $time2=date("Y-n-j",strtotime ($row[0])).'<br/>';
                echo    "<td bgcolor='red'>".$dates."--".$time2."</td>";
                //echo  "<td>".$row[1]."</td><br/>";
                //echo  "<td>".$row[1]."</td><br/>";
                //echo  "<td>".$row[2]."</td><br/>";
                                }
            echo "<td width='26' height='20px' align='center' valign='middle' >".$i."</td>";
        }
        //echo "<br/>";
        $Month++;
    }
?>
    </tr>
</tabl

Hi All,

I'm hoping someone can help as I've got myself in a muddle on some code.

Basically, the form has a date field (date moved in).

If the date entered is over 3 years old, all's ok

However, if the date entered is less than 3 years old, the user needs to complete a list field. The list field is essentially a repeater field with a date and address field.

If the user adds a date and address and this (plus the original date) is more than 3 years combined history - happy days!

If the user adds a date and address and they've still not hit 3 years history, then I need to increase the number of rows (this is handled by another function which works by incrementing a field on the form.

As it stands, it works until I need another field to appear i.e. they've entered the first date, then entered a date within the list/repeater field but still not got 3 years worth.

I think it's more or less there but seem to have muddled some of the logic (I think/hope!). A fresh pair of eyes would be great:

Here's my code:

function dateDiffInDays($date1, $date2) { 
    # Calulating the difference in timestamps 
    $diff = strtotime($date2) - strtotime($date1); 
      
    # 1 day = 24 hours 
    # 24 * 60 * 60 = 86400 seconds 
    return abs(round($diff / 86400)); 
} 

add_filter( 'gform_pre_render_2', 'applicant_2_previous_address_history' );
add_filter( 'gform_pre_validation_2', 'applicant_2_previous_address_history' );
function applicant_2_previous_address_history( $form ) {

	#get the value from the form date input d/m/Y so need to change
	$get_moved_in_date = rgpost( 'input_1' );
	if ( $get_moved_in_date ) {
		#convert the date format
		$moved_in_date = date_format(date_create_from_format('d/m/Y', $get_moved_in_date), 'd-m-Y'); 	
		#echo "New date format is: ".$moved_in_date. "<br/>"; 
	}
	
	#get todays date
	$today = date("d-m-Y");
	#echo "<h3>Today: ".$today."</h3>";
	
	#calculate the difference in days
	$dateDiff = dateDiffInDays($today, $moved_in_date); 	
	#printf("<p>Difference between two dates: " . $dateDiff . " Days</p>"); 	

	#check if we moved in less than 3 years ago
	if ( $dateDiff < 1095 ) {
		
		#less than 3 years, so need to loop through the list fields, compare dates and tally totals days
		if ( $days_sum < 1095 ) {
			
			# get the input from the list
			$list_values = rgpost( 'input_2' );
			$i = 0; #use this to get even rows only due to the way data is stored :(
			$sum = 0; #use this to increment the no. of rows in the list
			$previous = null; #use this to calc date difference between rows
			$days_sum = $dateDiff; #set the total number of days. Don't start at 0, start from current date - time at current residence
			if ( $list_values ) {
				foreach ( $list_values as $key => $value ){
					#get even rows only
					if($i%2 == 0){
						
						#$sum = $sum + 1; #increment our rows
						
						if ( $value ) {
							#convert the date format
							$additional_date = date_format(date_create_from_format('d/m/Y', $value), 'd-m-Y');
							#echo "<h3>Date: ".$additional_date."</h3>";
						}			
								
						if ( $previous !== null ){ # if it's null, we're in the first loop
						
							#convert the date format
							$previous_date = date_format(date_create_from_format('d/m/Y', $previous), 'd-m-Y');
							
							$dateDiff2 = dateDiffInDays($additional_date, $previous_date); 	
							printf("<p>Next Iteration Difference between " . $additional_date . " and " . $previous_date . " is: " . $dateDiff2 . " Days</p>"); 	
							
							$days_sum = $days_sum + $dateDiff2;
							
						} else {
							
							#convert the date format
							$dateDiff1 = dateDiffInDays($additional_date, $moved_in_date); 	
							printf("<p>1st Iteration Difference between " . $additional_date . " and " . $moved_in_date . " is: " . $dateDiff1 . " Days</p>"); 	
							
							$days_sum = $days_sum + $dateDiff1;
							
						}
						
						$previous = $value; # set the current value, so it will be saved for the next iteration
			
					}
					$i++;
				} #end foreach $list_values
			} #endif $list_values
			$sum = $sum + 1; #increment our rows
			echo "<p>Total no of days = " .$days_sum.'</p>';
			
		} #endif $days_sum < 1095	
	
		echo '<p>Not enough days so loop through list</p>';
		$flag = 'true';
		
	} else {
		
		echo '<p>Were ok!</p>';
		$flag = 'false';	
		
	} #endif $dateDiff < 1095



	/*
	if ( $dateDiff < 1095 ) {
		$value = 'yes';
	} else {
		$value = 'no';	
	}	
	*/

	#we moved in less than 3 years ago, so get history
	if ( $flag == 'false' ) {		
        return $form;
    } 

    foreach ( $form['fields'] as &$field ) {
        if ( $field->id == 2 ) {
            $field->isRequired = true;
        }
		echo "<p>The sum of array element is = " .$sum.'</p>';
		if ( $field->id == 3 ) {
			$_POST['input_3'] = $sum;
		}
		
    }

    return $form;
	
}

Thanks

I want to do something like this-

$days_passed = daysPassed ($last_datetime); //returns (float)number of days (6 hours returns .25 days, 12 hours returns 0.5)
$last_datetime = $getCurrentTime();

I will then store $last_datetime in the database for next time.

I'm a bit overwhelmed by all the different time and date functions.  Does someone have ready made functions that will work here?

Hi, I am trying to write an SQL to XML converter, so so far I have all the records inputted into the db tables, and now I want to append a child, but I don't know how to compare current row's field value with the next row below it, specifically I want to check if a current row is parent of the next row. I have already got the XML to SQL function working (some bugs but for the most part it's working)

So for eg:
<?php
$query=mysql_query("SELECT * FROM edge");
while($row=mysql_fetch_assoc($query) ) {
     if($row['target'] is parent of the next row),  then
                append the next row as child of current row
}

?>

Table edge is one of the tables that hold target node/source(aka: parent) nodes.

Any help much appreciated!

Hi,

I want to check entered dates and times that a user selects against my "book-off" calendar which is a Google Calendar.
The dates&times from Google is in the form: 2011-04-29T23:00:00.000+02:00

The dates in my booking software (ABPro) is in the form: 2011-04-29
Times in form: 23:00:00

All I want the function to return is a number other than 0 if any of the dates/times in Google feed overlap the requested date/time entered in the booking.

So I add a function and get the feed from Google:
Code: [Select]
function checkOverlapG($calendarID, $startdate, $starttime, $enddate, $endtime){
// Create an instance of the Calendar service using an unauthenticated
//HTTP client
$service = new Zend_Gdata_Calendar();
//Retrieving events in order of start time
$query = $service->newEventQuery();
$query->setUser('calendarID');
// Set to $query->setVisibility('private-magicCookieValue') if using MagicCookie auth
$query->setVisibility('public');
$query->setProjection('full');
$query->setOrderby('starttime');
$query->setSortOrder('ascending');                  //start with first event in future
//seFutureevents must be commented out when using start and end times.
$query->setFutureevents('true');
$query->setSingleEvents('true');
$query->setMaxResults('200');      //Guess this could be anything, but can possibly make things slower. Default 25 events
//$query->setStartMin('2006-12-01');
//$query->setStartMax('2006-12-16);  // setStartMax is exclusive, will not include last date. Must add +1 day.
// Retrieve the event list from the calendar server
try {
$eventFeed = $service->getCalendarEventFeed($query);
               }  catch (Zend_Gdata_App_Exception $e) {
echo "Error: " . $e->getMessage();
return null;
}

Now I want to compare the dates and times and see if any of them collide or overlap. I want to add a counter, and if any of the events overlap, I want the counter to add one number.
1. the first thing I do is check if the event feed include. any events.
2. then I add a counter
3. then I run a foreach to retrieve events one at a time
4. then I change the date and time format from Google Event to match the date and time format form the booking.
5. If fullday event from google, no time information is added, so I add this
6. COMPARE DATES AND TIMES and if overlapping events --> n++;

I've not gotten this code to work. Probably I'm doing something wrong, and I'm sorry but I'm completely new to this.
Getting the Google Calendar data is working fine, and so is changing the format of the dates/times to be same format as request data.
After that (and before, I don't know).

Code: [Select]
$gCount = count($eventFeed);
$n = 0;
if (gCount>0){
foreach($eventFeed as $event){
foreach ($event->when as $when) {
//Getting rid of extra 00's and time zone info for now
$startGevent = $when->startTime;
$startGevent = str_replace('.000+02:00',"",$startGevent);
$endGevent = $when->endTime;
$endGevent = str_replace('.000+02:00',"",$endGevent);

//Splitting date and time into two variables
list($startDateEvent, $startTimeEvent) = split('T',$startGevent);
list($endDateEvent, $endTimeEvent) = split('T',$endGevent);

//Fill in the blanks
if($startTimeEvent!=0) {}
else{$startTimeEvent = "00:00:00";}
if($endTimeEvent!=0) {}
else{$endTimeEvent = "00:00:00";}

//Compare dates
if($startdate == $endDateEvent){
if($starttime > $endTimeEvent OR $endtime < $startTimeEvent){}
else {
n++;
}
} if($enddate == $startDateEvent){
if($endtime < $startTimeEvent OR $starttime > $endTimeEvent){}
else {
n++;
}
}

}
}
return $n;
}

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

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

(continuing from topic title)
So if I set a date of July 7 2011 into my script, hard coded in, I would like the current date to be checked against the hard coded date, and return true if the current date is within a week leading up to the hard coded date.

How could I go about doing this easily?

I've been researching dates in php but I can't seem to work out the best way to achieve what I'm after.

Cheers
Denno

I am currently working on a date range script and wondering if anybody think of an easier way to do this, doing up to next 8 weeks?  This one starts on a Sunday. I also need to do one starting on a Monday (will figure that one later)

$thisweek = date("Y-m-d");
$week = date('w', strtotime($thisweek));
$date = new DateTime($thisweek);
$firstWeek = $date->modify("-".$week." day")->format("M d");
$endWeek = $date->modify("+6 day")->format("M d");
echo $firstWeek." - ";
echo $endWeek;

$nextweek = date(("Y-m-d"), strtotime("+7 Days"));
$week1 = date('w', strtotime($nextweek));
$date1 = new DateTime($nextweek);
$firstWeek1 = $date1->modify("-".$week1." day")->format("M d");
$endWeek1 = $date1->modify("+6 day")->format("M d");
echo $firstWeek1." - ";
echo $endWeek1;

 

Why is this not working?
Code: [Select]
$result = mysql_query("SELECT * FROM contacts WHERE type = 'consumer' AND sent BETWEEN '".date("Y-m-d")."' AND '".date("Y-m-d", strtotime("-7 days"))."'")
or die(mysql_error());
$numrows = mysql_num_rows($result);
if($numrows < 0 ){
echo "No records found";
}

The record that is stored in the sent column is like this "2011-11-03 14:42:12", so there is a record in there, but nothing is showing up.

Can anyone see why?

thanks in advance

Hi i have the following code

Quote

$sql= "SELECT * FROM income WHERE month(date) between '04' and '12' and year(date) between 2020 and 2020";
 

This obviously selects all the information from April 2020 to December 2020

 

How do i change this to add a date as well for example if i wanted to display all the information from April 6th 2020 to December 5th 2020 ?

 

Hello,

I'm very disapointed because I don't know how do it this.
I'm explain.
I have a database with one input date_arrival and second date_departure.
Two dates are saved in SQL format : 2014-03-02.

After my SQL request to select all dates in database I'd like to add dates between date_arrival and date_departure and for each line.
For example I have
date_arrival date_departure
line 1 : 2014-02-01 2014-02-05
line 2 : 2014-02-10 2014-02-15

In fact at the end, I have to send the result like this (with JSON) :

["2014-02-01","2014-02-02","2014-02-03","2014-02-04","2014-02-05","2014-02-10","2014-02-11","2014-02-12","2014-02-13","2014-02-14","2014-02-15"] 

Can you give me some help to add intermediates values in an array ?
Thx

how to compare date with current date
let say $date="2010-10-08 2:00 PM"
how can i compare $date with current date and get the result in days, hours, minutes and seconds

thanks