PHP - Keeping Track Of Dates Set On A Php Calendar

Hello, I found this great free php calandar script here "" by Xu and Alessandro, and I'm trying to modify the code to mark several dates(birthdays YYYY-mm-dd) from a date column in a sql database.

I've played around with the _showDay() method but I can't seem to get it working.. I've also tried to create a _showBirthday() method to modify the css as well but with no luck. What I'm trying to do is loop through the database to mark the respective dates on the calendar, and have a href to display a new page with the person's name when I click the specific date.

Can anyone help with this. Thanks in advance!

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

Hi All,

I need to subtract dates and display the number of days left.  I have a 'Start' date and an 'End' date in DATETIME format in the DB.  Not quite sure where to start.  A simply start - end doesn't work  .

Start = 2011-11-01-00:00:00
End = 2011-11-30-23:59:59

Since it is now 2011-11-27, my output should equal 3.  Any help is appreciated.

Hi guys,

I am trying to do a multidates events availability calender. The script below indicates todays date by highlighting an orange colour and also indicates the start and end date of the event highlighting grey colour on the two dates (The colour are link via css classes as shown).
Code: [Select]
//Today's date
$todaysDate = date("d/m/Y");
            $dateToCompare = $daystring . '/' . $monthstring . '/' . $year;
echo "<td align='center' ";
if($todaysDate == $dateToCompare){
echo "class='today'";
}else{
//Compare's the event dates
$sqlcount = "select event_start,event_end from b_calender where event_start ='".$dateToCompare."' AND event_end='".$dateToCompare."'";
$noOfEvent = mysql_num_rows(mysql_query($sqlcount));
if($noOfEvent >= 1){
echo "class='event'";
}
}
It works ok i.e. if start date = 01/01/2012 and end date = 04/01/2012 both date will be highlighted with grey colour. However I want it to also highlight grey on the dates between the 1st and 4th to show that then anydates between the 1st and 4th are not available and this is when I'm stuck.

Please guys I need help.

Thanks

Hi,   i am a student for a school.   we have in each class a book that lists the shool year. Teachers use it to make notes in it and mark people that are not present.   i want to bring that whole process online making a website out of it.   Teachers can log in and see the yearbook. Days view, Week view, Month view. Mark people that have been missing on a specific day. List all the people that have been missing during a school week.   How would i present the Calender? Tables?   I have the some knowledge in mysql, php and joomla.   How would i go about getting startet? Do i need to have a Framework?   All ideas would be greatly appreciated.   Thank you    

I have a site where people vote, currently if two computers that are on the same network vote, my site will see them as one computer because I only track people by IP address.

What would be a good way to track 2+ computers with the same IP address?

I've searched the forum, and haven't yet found what I need.

I have a long list of PDF files:  http://www.iampeth.com/vintage_magazines.php

How can I track the number of downloads for each file?

Hello!

I want to build a script to basically keep track of the number of hosting accounts that are currently on each server. I have roughly 30 servers (root access,  WHM, cPanel) that I would like to be able to track all of from a single page. Could someone help/point me in the right direction/offer any input?


thanks! much appreciated!

How can I track session requests, so I can, after a certain number of requests (let's say ten because it's physcologically pleasing), have the id regenerated?

Hello,   I have been looking for a way to track the play stats on audio mp3's in the admin of my custom post-type. Whatever I google seems to come up with nothing. I not very versed in audio player code - could someone please point me in the right direction.    Again:  I have a custom post-type which uses the wordpress default audio.  I would like to get the number of plays for each audio file and display that in the admin column for my custom post-type   Thanks, Drew

So i have a bunch of random videos playig one after the other what i want is to track if the user viewed the videos by inserting a view lets say in to the database, so if they view the first video the database will increment by 1 then after the page refreshes and the next video loads it will increment again, the only part i dont know what im doing is how would i know if my user viewed the video, any help please thank you?

Hello friends,

I am new to PHP and have developed a website... i am stuck at one place. I want to know if the user changes the url in the adress bar and goes to another webpage.. Can we detect that?

This is very important for my website because I calsulate the duration of login based on whether user goes to another page or logs out.

Hi everybody,   I want to cloak my affiliate links or mask it so it looks like a pretty url. Also if possible, I want to track the clicked link with Google Analytics so I think I need a page where I can log the click.   I found lots of information but not for the situation I have. I get my links from my database like this:

echo '<a href="'.$info['url'].'">the link</a>';

How can I accomplish this? So I need a url like www.mydomain.com/click and when a user click on the link the get a new page with a tracking code and a redirect script to the right url.   Thanks so much for the help!   Kind regards, Mark

I'm interested to know how other people keep track of time and also how they display time correctly back to the users. I'm using a third party API that I can tie into that actually gives me the userID of a user, their full name and the timezone for that user. After checking a few users data, this is an example data of what I'm working with.

userID: 234213412
first_name: foo
last_name: bar
timezone: -6

Basically when a user visits my web app, I create a new account for them and store the above data. Currently, I'm just fetching the result from time() and converting it into MySQL DateTime format and storing that into my database.

Code: [Select]
//get the current time as an integer
$php_timestamp = time();
//formats the time according to MySQL DateTime type
$this->mysql_formatted_time = date('Y-m-d H:i:s', $php_timestamp);

I would think the current way that I'm doing this is not very good because there is a possibility that I could introduce load balancing servers into the mix and they might not be located in the same region. Also, I would have no idea how to factor the time and modify it according to the timezone value.(in my above example, -6)

Can anyone help me decide what method I should use to keep all of my servers timestamps in sync and how to display the time to the end user so that it looks correct to them?

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=316351.0