Creating Calendars in PHP – Part 4

In this last part of the series on creating a calendar application in PHP, we create an include file to hold the parameters required to connect to the MySQL database. Next, we create a page that displays all calendar events on a particular day, using the date which is passed as a URL parameter to find the correct records from the database.

Then, we create a page which allows a user to easily add events to the database through a simple web interface. Finally, we create a multi purpose page that allows a user to edit existing records in the database, or delete a calendar event from the database.

All the code is provided for download, so if you haven't followed the previous tutorials, it's all available for you to build this sophisticated calendar application for your users.

Please note that this article forms part of a chapter in the DMXzone e-book PHP Web Applications for Dreamweaver: Juicy Solutions for the Busy Developer.

 

$2.89
- OR -

Overview

Table of Content:

  • Creating a PHP Include File for the Database Connection
  • Creating the Details page to display Events
  • Creating the HTML
  • Creating the PHP Code
  • Making the Data Dynamic
  • Building the Add Record Page
  • Creating the HTML
  • Adding the PHP
  • Building a page to Edit and Delete Calendar Entries
  • Creating the HTML
  • Creating the PHP Code
  • Making the Page Dynamic
  • Adding the Database Operations
  • The Update Record Operation
  • The Delete Record Operation
  • Viewing the Page in a Browser
  • Summary

Gareth Downes-Powell

Gareth Downes-PowellGareth has a range of skills, covering many computer and internet related subjects. He is proficient in many different languages including ASP and PHP, and is responsible for the setup and maintenance of both Windows and Linux servers on a daily basis.


In his daily web development work he uses the complete range of Macromedia software, including Dreamweaver MX, Flash MX, Fireworks MX and Director to build a number of websites and applications. Gareth has a close relationship with Macromedia, and as a member of Team Macromedia Dreamweaver, he has worked closely in the development of Dreamweaver, and was a beta tester for Dreamweaver MX.


On a daily basis he provides support for users in the Macromedia forums, answering questions and providing help on a range of different web related subjects. He has also written a number of free and commercial extensions for Dreamweaver MX, to further extend its capabilities using its native JavaScript API’s or C++.


As a web host, Gareth has worked with a range of different servers and operating systems, with the Linux OS as his personal favourite. Most of his development work is done using a combination of Linux, Apache and MySQL and he has written extensively about setting up this type of system, and also running Apache and MySQL under Windows.

See All Postings From Gareth Downes-Powell >>

Reviews

Silly Bug

April 20, 2009 by Sriram Venkatesh

Am new to PHP and hence i wanted to create a Calendar for my website.

And so i purchased it and after purchasing and working on it for a day, i realised that the calendar generates 31 days for all the months, whether it is Feb, Mar or April which is silly bug which any coder would have taken into consideration before starting to code.

Any suggestions or corrections would be very helpul. 

Contd...

April 20, 2009 by Sriram Venkatesh

I Figures out the problem.

Just interchange the lines 7 & 8 in basic.php 

You must me logged in to write a review.