PHP - Find Next Session Between Two Dates/times

Hi There,

I am trying to use PHP to create a calendar that only show's working days - which are monday to friday.

Is there any way that PHP can return a list of the next 5 working day's dates? For example, if today is Thursday 15th Sept - could it return the numbers 15,16,19,20 and 21?

Thanks
Matt

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

I need to find the earliest and latest times, but there must be at least 3 to count it.

$array[] = "09:00 - 15:00"
$array[] = "09:00 - 15:00"
$array[] = "09:00 - 15:00"
$array[] = "09:00 - 17:00"
$array[] = "09:00 - 15:30"
$array[] = "07:30 - 15:00"
$array[] = "07:00 - 12:00"

So the above would return 09:00 - 15:00

I thin would need to ensure that a maximum 4 hours inbetween, so I then get something like 10:00 - 14:00 returned

Hello,

I have a few strings that contain dates along with some other text.
The string looks like this:

Code: [Select]
Hi, could you please add these dates to the database?<br />
 <br />
<br />
2-September-2011<br />
6-September-2011<br />
7-September-2011<br />
8-September-2011<br />
9-September-2011<br />
 <br />
Thank you.

Dates are always the same format. Sometimes there's a single date, most times there are multiple.
Does anyone know how can I get the dates from this string to add them to my sql database?

Thank you!

I've simply set some sessions....

$_SESSION['LoggedIn'] = 1;
$_SESSION['UserID'] = $row["UserID"];

They don't seem to last very long, usually when I close my browser and go back on later, they'll expire. I want them to last permanently unless the user logs out.

How do I do this?

Thanks in advance.