Location: PHPKode > scripts > PHPalm Calendar > phpalm-calendar/example.4.php
<?php

/* PHPalm - Calendar
 * Example 4 : Display an advanced calendar with the current year and month, a specific language, with monday as
 * the first day,links on days when something have been saved in a database and with specific strings to change the month.
 * Here's the scheme of the mysql database called 'save' :
 * 		
 * +-------+-------+-------+-------+--------+
 * |  id   | month |  year |  day  |  text  |
 * |-------|-------|-------|-------|--------|
 * |  int  |  int  |  int  |  int  |  text  |
 * +-------+-------+-------+-------+--------+
 * 
 * 03/06/2005
 * Author : Rémy Salettes
 *   
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation.	
*/ 

// We include the class
require_once ("calendar.class.php");

// What is the expected date ?
if($_GET['calmonth'] == '')
$month = date("m");
else
$month = $_GET['calmonth'];
if($_GET['calyear'] == '')
$year = date("Y");
else
$year = $_GET['calyear'];

// We create an instance of the class
$MyCal = new calendar('auto', 'auto', 'fr');
// We indicate to the class we want monday as the first day
$MyCal->monday_1st = '1';

// We change the strings to change the month.
$MyCal->prev = '-';
$MyCal->next = '+';

// Mysql stuffs
mysql_connect('server','user','pass');
mysql_select_db('db');
$query = mysql_query("SELECT * FROM save WHERE month = $month AND year = $year");
// Thanks to this loop, we get a string ($DAYS) in which are the days when something have been added to the sql table
// Please note the numbers in the string must be separated by a ':' (ex: '02:09:15:29')
while ($fetch = mysql_fetch_array($query)) {
    $day = $fetch['day'];
    $DAYS .= $day . ':';
} 
// Deletes the final ':'
$DAYS = substr($DAYS, 0, -1);
// We call the links() function : we give first the string in which are the days and then the pattern of the link
// {D} = the linked day
// {M} = the month of the calendar
// {Y} = the year of the calendar
$MyCal->links($DAYS, "?op=inc/calnk.inc.php&amp;jour={D}&amp;mois={M}&amp;an={Y}");
// We call the generate() function, all is in its name
$MyCal->generate();
// We call the draw() function which allow you to display the calendar generated before
$MyCal->draw();

?>
Return current item: PHPalm Calendar