PHP :: Auto Delete Date Based Calendar Events

Displaying Events In A Calendar
I have a calendar that I would like to display some events on. The events are stored in a database but I do not think I am getting the information in the right place and displaying like it should be. I cannot seem to get an event to display on the exact date that it should be displayed on. I can get one event for a whole week but that, of course, is not right. Code:

Events Calendar Using MySQL Database
I have a mySQL table listing all the regular events that happen each month for a group according to schedules like, every Sunday or every other Saturday*. How can I make a visual monthly calendar out of this? Basically, I need to produce a list of dates for each of the events happening in a given month. That's where I'm stumped.

Web Calendar Group/individual View Events?
There seem to be a lot of web calendars out there and I am having a tough time sorting out which ones to even try - a lot of the more popular ones were created 2 or 3 years ago.
Can anyone recommend a good one that uses php and mysql preferably?

One of the main uses would be for family to indicate their holidays so all in the family can see. Thus, it would require a group/public feature that allows users to see all "public" holidays or just their own holidays.

Sample Month At A Time Code For Events Calendar
I am in the process of rewriting one of my first PHP scripts, an event
calendar, and wanted to share the code that is the core of the new
calendar. My current/previous calendar processed data dates only, this
code is intended to use more thrifty event descriptions (3rd saturday,
last tuesday, etc.) as well as traditional one-of dates.

The core here here is quite spartan, no table logic or or db cruft
included

<?php
//sample code to generate american calendar format for a given month
// i,e. start of sunday on or before the 1st end on te saturday on or
after the last day.
// makes use of mktime's cool liberal calculation of dates.

// Set sample month and year values:
$mn = date("m");
$yr = date("Y");

// Start calendar logic:

$firstday = date("w",mktime(0,0,0,$mn,1,$yr));// Get first day of
target month (0=sum 6=set)

$numdays = date("t",mktime(0,0,0,$mn,1,$yr));// Number of days in
target month

$daystop = $numdays+(6-date("w",mktime(0,0,0,$mn+1,0,$yr)));//
Adjusted last saturday of calendar page (on or after last day of month

//start with american first sunday on or before start of month of
calendar page and end on daystop (saturday)
for($daynum = 1 - $firstday; $daynum <= $daystop; $daynum++) {

//need working date timestamp to work out details of the calendar
$wkdate = mktime(0,0,0,$mn,$daynum,$yr);//the first of the month -
unix value

$wdy = date("w",$wkdate);//day of the week (0 sun - 6 sat)
$wmn = date("m",$wkdate);//month
$wdt = date("d",$wkdate);//date

$wdte = date("D, m/d/Y",$wkdate);//date string of current date "Day,
mm/dd/yyyy"

Intranet-based Calendar?
I'm interested in creating an Intranet-based calendar which will contain company information such as holidays, special events, etc. I was wondering how this could be done. I was originally thinking of using an ActiveX control of some sort but would rather use DHTML w/ Perl/PHP instead.

Events Calander And Date Conversion
I have been working on an events calander program that needs to be in chronological order by date. The fields I have are id, date, event and event discription. The problem I have is that the event date needs to be displayed in this format 09/21/03. However, when I simply sort by date 02/21/04 would display before 03/21/01. How could I sort by date and display the date in the 00/00/00 format.

Auto Delete
This script was meant to delete a file after X days...in this case I wanted it to delete files that were older than 1 day except .htaccess. what the script is doing is deleting everything in the specified folders except htaccess even though the files are less than a day old. any suggestions? Code:

How To Auto Delete Table Row?
I Have A Page On My Site That The Database Outputs To. There Is A User That I Dont Want To Ban Yet , But I Do Want To Block Or auto Delete His Data. Now When Everyone Post New Data The Only Table That Would identify Them Is The Username Table, There Is No Member ID Table.

Now I Would Like To querry The Database And Auto Delete Table (Username) BOBBY And The Row BOBBY Posted , So There Is No Data Output To My Site Page For BOBBY. Can Someone Give Me A Couple Codes To Try, And I Would Think The Code Would Need To Be On A New Page That I Need To Make Up Right?

Database Auto Count What About Delete?
I have a table that give a unique ID to certain Articles.
To give the ID i simply use the Auto count of the DB.

But what happens when i delete a record? i am now missing an ID.
How can i insert a row and give it the first available number?

For example ID 1, 2, 4, 5, 6

i would Insert and set the ID number to 3.

Calendar/Date Picker
I have searched for hours on end trying to find the perfect calendar. I would like one that:

1. Displays the selected date into drop-down boxes e.g 1 for day, 1 for month and 1 for year.

2. These drop down boxes can then be saved to database

3. Anything else goes really, as long as it looks good.

Stoping Auto Updates Of The Date Field
I have a table with a field using the "timestamp" type. When I update another field, the "timestamp" field also updates to the time the other field was updated. I don't want this.
I'm using this to update the table. PHP Code:

Auto Changing Link Depending On Date
I want to have a special link on my site.
The link is to a text file located on a distributor's website and is named with a specific filename in the same format every week. In other words it's guaranteed predictable.

Here is what the file would look like,
shipping_032107.txt
which means,
shipping_(month)(day)(year).txt

How could I use something to make the link the right name without modifying my page weekly? The one tricky part is that it's updated once a week and it would be Wednesdays date each time. So it actually has to predict the next date. Perhaps if the script couldn't do that it could figure out todays date, check it to the days of the week and add a number to equal the proper day, I have no idea what to start with for this.

Get Date Based On Weekday?
I have this:

Mon, Tue, Wed, Thu, Fri, Sat, Sun created as links. What I would like to
do is to associate days with its current week dates, for example:

Mon (05.01.2004); Tue (06.01.2004); and so on.

Delete MySql Row By Date
Can someone help me with the following problem:

I have a table that includes a column for "last application date", let's simply call it "date".

Now the problem is how to automatically delete rows where the information in the "date" column has gone old, let's say by -86400 (1 day).

Example: today's date is April 11th, which means that all rows with the info April 10th in the date column would get deleted.

Deleting A Field Value Based On Date?
How would I delete a field value in a mysql database every 24 hours? Anyone know?

Add To Date Based On User Selection
I have a form with Radio buttons that when selected should add "$howMuch" amount of hours to the current date and time and put the output into a field called "ExpireTime". The code I'm using for the hour adding: PHP Code:

Calculate Age Based On Date Of Birth
I am trying to validate whether or not a date of birth entered in dd/mm/yyyy format is between 16 and 69 years old. Suppose we have todaysdate = 18/04/2007

The minimum allowed date of birth would be 18/04/1991 and the maximum allowed date of birth would be 18/04/1938. I have looked at using strtotime but this only does dates from 1970 (I think)

Clause Based On Date/time
I have a database that returns a field with a date and time that looks like this:
12/04/2007 07:45:03

I need a simple clause that says if the time is before noon then A else if the time is after noon then B I could split the date from the time in a string then split the time by the : but there is a much easier way, right?

Displaying 'new' Icon Based On Date?
I'd like to display a little "new" icon next to all products in a directory which are, funnily enough, new! I've got a date (timestamp) for each product which is inserted on adding a new product and updating a product.

I'd like to do a conditional region using the timestamo but I'm not sure what to use - I could do === [current date] but that would only show the icon for that day and I'd like it to be there for about a week or so.

Delete File (timestamp & Date Problem)
I want to delete a file which is modified at least 60 minutes ago. i failed to do it.i fetched the last modified timestamp using filectime() or filemtime. but how can compare if it is last modified at 60 mins ago?

Generating Reports Based On Date/time Conditions
I need to generate reports in three ways:

I have a Date field in my database...

today
$query = 'SELECT * FROM 'table' WHERE Date = today';

Past seven days
$query = 'SELECT * FROM 'table' WHERE Date - 7';

Choose month( drop down preferably)

$query = 'SELECT * FROM 'table' WHERE Date = "'.$_POST['monthselected'].'"';

Get Most Recent Row On An Inner Join Mysql Query Based On Date
Here is my current query:

SELECT tbl1.id, tbl1.username, tbl1.status, tbl1.joined, tbl2.timeDate, tbl1.directory FROM tbl1, tbl2 WHERE tbl1.id = tbl2.users_id GROUP BY tbl1.id

This returns their oldest ie first login. I use this for analytics on the backend to determine user activity. So I would like a query that instead that returns the most recent tbl2.timeDate.

Php Events Box
Is there a way to get the PHP code to read a line from the table and write it in a box? What I have is an events table with two columns, Date of Event & Name of Event. This is saved on a page called events.html (can be changed to .php) What I wan is on index.php I want a next event box.

So what I want for it is to read from the events page, and find when the next event is, using information on dates. I have no idea on how to start this at all.

Scheduled Events
possible to get php to execute a script at certain times a day ? or is the only way to have a list of set times in a db, and when each user comes to my site see if it has been done or not ? and do, or dont do accordingly?

Timing Events
I would like to be deleteing certain records from my database automatically after every 72hrs. I have never tried this before but is it possible to perform actions after a certain duration of time in php ?

How To Catch System Events
I have a site from which people can download files. If they cancel the downloading in-between then my page hangs. Does anyone know how to catch system events like "Cancel" in PHP ?

Events Application In PHP Or Perl
I am looking for an events registration/calendar application (open source or otherwise) written in PHP or Perl.

It would need some (or all) of the following capabilities:
1-Allow admins to create/edit/delete events including:

a) Max number of attendess
b) Event registration fees

2-Allow admins to run reports per event on the number of attendees, who has paid ,etc

3-Allow event attendees to register and pay for the event(s) via the web (Paypal).

I would prefer there be different levels of administration privileges, like full admin, reporting only, and per-event administrators.

The most important features are the ability to pay via the website via PayPal and the admin capabilities.

Export Events To Outlook
Do anybody know how to export events to Outlook from a php script? I'm
making a list of events, and my idea is that when the user clicks on
the event it will be exported to his or hers Outlook-calendar. I don't
want to force the users to install any software (like a RSS-reader).

Automatic Display Of Events Each Week
I know how to display a list of upcoming events from a SQL database, but am wanting to display the events based on the date, eg. events happening this week only. Could someone tell me how to do this or point me in the right direction please?

Multiple Dates For Recurring Events
how I could add multiple dates for the same activity that recurs many times in an events calendar? Now I am creating an entirely separate entry for each event; it all works fine, but it's mighty tedious! Code:

Code Relating To Button Events....
I have one screen that has multiple buttons/images for varying actions. How do I trap which button/image was clicked in order to carry out the related code events?

Do I utilise the value of each button, or the name of each button to identify, and then 'select' the result? Should they all be type=submit?

OnUnload (check If Variable Is Set) Events To Detect Browser
I'm building a website using PHP/JavaScript/HTML. I am using sessions. I need to find out how to do two tasks.

1. Log the time when the user is done using the website. I am using the onLoad (set a variable) and onUnload (check if variable is set) events to detect browser close. But this doesnt let the page to be refreshed or the 'Back' button to be used. (I am ensuring that the time is not logged when the user clicks a hyperlink by resetting the variable.) Is there a way to let the user use the back button and refresh without logging him out?

2. I need to make sure that only one user logs into the site using a username. What is the best way to do this? I have the usernames stored in a database. DO I set and reset a flag when a user logs in or out?

EyeOS : Opensource Web Based Operating System Based On "php"
EyeOS is a Opensource web based operating system based on "php".

try demo here

http://eyeos.info/eyeOS/

Pop-up Calendar
Where can I find a script for a pop-up calendar for a user to select a date to enter in a field.

Calendar
I have a simple calendar script which displays a calendar on my website and at present, you enter dates using a seperate xml file.

If you enter an event for a certain date, the event is displayed next to the date. This is fine, all works great, but what I would like to do is actually display the event in a pop-up window.

So you would click on the date , a pop-up window would appear with the event displayed.
PHP Code:

Php Calendar
I'm looking to develop a simple php calendar/schedule - similar to outlook calendar - that does not rely on a database but rather writes to a file. I need to be able to add to/delete from the schedule. As I am only starting out with php I am a little confused by the codes which links to databases and how to adapt them to only write to a flat file.

Calendar
It's two calendars, side by side and in reverse order (May/April). First you enter your Zip Code (have DB set up ewth UPS codes, zones, and shipping dates), then you click on the date you'd like to have your borchures delivered by.

A red sphere will appear on the delivery date, preceded two or more days (depending upon the DB results) with a yellow sphere designatng the shipping date. 5 days before that, a purple sphere, represnting the date the press is run. Two days before this, a green sphere represnenting when you'll receive (and hopefully approve same day) your proof. Back up two more days and a blue sphere represents the latest date you must upload your files to the printer.

PROBLEM: ANy sphere falling on a weekend miust be backed up to the prvious Friday. Sounds simple, but it's proving otherwise. Maybe I need to start all over and re-evaluate my approach. First problem, because of the way I've designed the script, is getting
balls to fall into the previous month if necessary, but I won't worry about that now.

The BIG problem is getting Saturdays and Sundays ($wday ==0 && $wday==6) to back up.
Here's a simplifed excerpt of what I've tried so far. Code:

Calendar
how can i make a calendar on my php page?

PHP 5 Calendar
Is there PHP5 calendaring software that will allow you to import events
from other calendars? For example, I have a Master project calendar
that my satellite sites want to import. They import the calendar and
now they have all my dates and theirs as well.

Calendar
Can anyone direct me or supply a simple free calendar for use with one of my pages please?

Calendar
I am wondering someone could please tell me how I can create a calendar? The way this one looks. I am wanting to highlight dates that are in a database. Using php, mysql and Javascript to build it. I don't want someone to build the calendar for me. I want someone to either guide me or show me one that already built.

Calendar
I have a simple calendar below. How would i go about attaching it to a database and saying If theres an event change the day colour and add a link. I followed a tutorial for this and i am a little unsure. Code:

Calendar
I'm looking for a calendar where I can simply browse the next | Previous months, and then when I click on a date in the calendar it simply passes the date clicked on to the address bar so if I clicked on today's date it would pass something like:- Code:

Calendar
I was messing around with this calendar and for some reason it likes to skip january when you moved back in the calendar and when you move from december forward it skips january and february and goes right to march.. there must be something wrong with my logic but I cant figure it out. Code:

Calendar
Ive found a simple calendar that displays all the days of the month as a link. I have saved the code below as eventcalendar.php and what I would like is when the user selects a certain day, that will take them to a page saved as eventinfo.php with the events for that day. I have managed to point each link to eventinfo.php, I'm just struggling to pass the actual date to that page, any ideas? Code:

Making A Calendar
What is the principle behind a calendar? I have some ideas but not 100% sure.

or is it that simple make 12 tables in the database? i don't think that's true tho. i'm hoping to use the least of the database, don't know why. say it was a daily calendar that would be 365 tables. also it's not for one year.

then again i've no idea what i'm talking about.

any help, links would be appreciated.

Another Calendar Dilemma
I coded a calendar a while back with sample code from here. Then the user wanted the calendar to span into the next month and I did this. Now the calendar needs to span into the previous and possibly next month...it called a bidmonth. I get the actual dates from a table. So for example bidmonth December 06 spans from November 27, 2006 to December 31, 2006. The table stores the bidmonthbegindate, bidmonthenddate, and the actual bidmonth, in this case 12, as a number.

I am not sure if it could span 3 months but I would like to code for it just in case. Below is the code I had that allows for a bid month to span into the NEXT month. I need to change it and I am in way over my head. Can someone help? PHP Code:

PHP Event Calendar
im looking for a PHP Event Calendar that is small in size and when a event is placed on a day will color code that day, then when you mouse over that date / click on the date it opens a new small window that will show the current events for that day.. (showing time the event will take place ect)

i may have to write this my self.. iv done some searches for some and found some good looking ones but they require me to buy them.. i was woundering if any one knows of some that do this and can be easily modded that are free?