calendar.php
[php]
<?php
$host="localhost"; // Host name
$user=""; // Mysql username
$pass=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name
// At line 2 of our calendar.php script, add the MySQL connection information:
$mysql = mysql_connect("$host", "$user", "$pass")or die("cannot connect");
mysql_select_db("$db_name", $mysql) or die(mysql_error());
// Now we need to define "A DAY", which will be used later in the script:
define("ADAY", (60*60*24));
// The rest of the script will stay the same until about line 82
if ((!isset($_POST['month'])) || (!isset($_POST['year']))) {
$nowArray = getdate();
$month = $nowArray['mon'];
$year = $nowArray['year'];
} else {
$month = $_POST['month'];
$year = $_POST['year'];
}
$start = mktime(12,0,0,$month,1,$year);
$firstDayArray = getdate($start);
?>
<?php echo "Calendar: ".$firstDayArray['month']."" . $firstDayArray['year']; ?>
<?php
$months = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
for ($x=1; $x<=count($months); $x++){
echo "<option value=\"$x\"";
if ($x == $month){
echo " selected";
}
echo ">".$months[$x-1]."</option>";
}
?>
</select>
<select name="year">
<?php
for ($x=2011; $x<=2050; $x++){
echo "<option";
if ($x == $year){
echo " selected";
}
echo ">$x</option>";
}
?>
</select>
<?php
$days = Array("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat");
echo "
\n";
foreach ($days as $day) {
echo "|
$day
| \n";
}
for ($count=0; $count < (6*7); $count++) {
$dayArray = getdate($start);
if (($count % 7) == 0) {
if ($dayArray["mon"] != $month) {
break;
} else {
echo "</tr><tr>\n";
}
}
if ($count < $firstDayArray["wday"] || $dayArray["mon"] != $month) {
echo "<td> </td>\n";
} else {
$chkEvent_sql = "SELECT event_title FROM calendar_events WHERE month(event_start) = '".$month."' AND dayofmonth(event_start) = '".$dayArray["mday"]."' AND year(event_start) = '".$year."' ORDER BY event_start";
$chkEvent_res = mysql_query($chkEvent_sql, $mysql) or die(mysql_error($mysql));
if (mysql_num_rows($chkEvent_res) > 0) {
$event_title = "<br/>";
while ($ev = mysql_fetch_array($chkEvent_res)) {
$event_title .= stripslashes($ev["event_title"])."<br/>";
}
mysql_free_result($chkEvent_res);
} else {
$event_title = "";
}
echo "<td ><a href=\"event.php?m=".$month."&d=".$dayArray["mday"]."&y=$year\">".$dayArray["mday"]."</a><br/>".$event_title."</td>\n";
unset($event_title);
$start += ADAY;
}
}
echo "</tr></table>";
mysql_close($mysql);
?>
[/php]
event.php
[php]
<?php
$host="localhost"; // Host name
$user=""; // Mysql username
$pass=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name
$mysql = mysql_connect("$host", "$user", "$pass")or die("cannot connect");
mysql_select_db("$db_name", $mysql) or die(mysql_error());
// Add our new events
if ($_POST){
$m = $_POST['m'];
$d = $_POST['d'];
$y = $_POST['y'];
// Formatting for SQL datetime (if this is edited, it will NOT work.)
$event_date = $y."-".$m."-".$d." ".$_POST["event_time_hh"].":".$_POST["event_time_mm"].":00";
$insEvent_sql = "INSERT INTO calendar_events (event_title,
event_shortdesc, event_start) VALUES('
".$_POST["event_title"]."',
'".$_POST["event_shortdesc"]."', '$event_date')";
$insEvent_res = mysql_query($insEvent_sql, $mysql)
or die(mysql_error($mysql));
} else {
$m = $_GET['m'];
$d = $_GET['d'];
$y = $_GET['y'];
}
// Show the events for this day:
$getEvent_sql = "SELECT event_title, event_shortdesc,
date_format(event_start, '%l:%i %p') as fmt_date FROM
calendar_events WHERE month(event_start) = '".$m."'
AND dayofmonth(event_start) = '".$d."' AND
year(event_start)= '".$y."' ORDER BY event_start";
$getEvent_res = mysql_query($getEvent_sql, $mysql)
or die(mysql_error($mysql));
if (mysql_num_rows($getEvent_res) > 0){
$event_txt = "";
while($ev = @mysql_fetch_array($getEvent_res)){
$event_title = stripslashes($ev["event_title"]);
$event_shortdesc = stripslashes($ev["event_shortdesc"]);
$fmt_date = $ev["fmt_date"];
$event_txt .= "-
".$fmt_date.":
".$event_title."
".$event_shortdesc." ";
}
$event_txt .="
";
mysql_free_result($getEvent_res);
} else {
$event_txt = "";
}
mysql_close($mysql);
if ($event_txt != ""){
echo "Today's Events:
$event_txt
";
}
// Show form for adding the event:
echo "
Add Event:
Complete the form below then press the submit button when you are done.
Event Title:
Event Date:
Event Description:</strong
Event Time (hh:mm):
";
for ($x=00; $x<=23; $x++){
echo "$x";
}
echo " :
00
15
30
45
";
?>
<a href="calendar.php"><input type="button" value="View Calendar" /></a>
[/php]
