Hi mate,
Thanks for replying, yeah I understood what you suggested.
I've managed to get the code for the page:
PHP Code:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SilliFish.co.uk - The Home of The Typhoon Movie Database</title>
<STYLE TYPE="text/css">
<!--
h2{font-family: Verdana, Arial, Helvetica, sans-serif; font-size:12pt;}
p{font-family: Verdana, Arial, Helvetica, sans-serif; font-size:11px;}
td{font-family: Verdana, Arial, Helvetica, sans-serif; font-size:11px; }
th{font-family: Verdana, Arial, Helvetica, sans-serif; font-size:12px; }
--->
</STYLE>
</head>
<body BGCOLOR="#525252" TEXT="#E68313" LINK="#E68313" VLINK="#E68313">
<center>
<h2>Typhoon Calendar Test<br />
Typical User View</h2><br/>
<p><a href="index.php">Calendar Home Page</a></p>
<p>This will not be how the final layout will look like...</p>
<?php
$username="*******";
$password="*******";
$database="*******";
$connection=mysql_connect("localhost", "$username", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());
$userresult = mysql_query("SELECT * FROM typhoon_user ORDER BY user_id") or die(mysql_error());
$getuserid=$_GET[detu];
while($row = mysql_fetch_array($userresult))
{
$listuseradmin=$row['admin'];
$listuserid=$row['user_id'];
if ( $listuserid == $getuserid )
{
if ( $listuseradmin == "1" )
{
echo "<p>Click <a href='calendaradmin.php?detu=";
echo urlencode($getuserid);
echo "'>here</a> to add events to the calendar</p>";
}else{
}
}else{
}
}
$date =time () ;
$day = date('d', $date) ;
$month = date('m', $date) ;
$year = date('Y', $date) ;
$first_day = mktime(0,0,0,$month, 1, $year) ;
$title = date('F', $first_day) ;
$day_of_week = date('D', $first_day) ;
switch($day_of_week){
case "Sun": $blank = 0; break;
case "Mon": $blank = 1; break;
case "Tue": $blank = 2; break;
case "Wed": $blank = 3; break;
case "Thu": $blank = 4; break;
case "Fri": $blank = 5; break;
case "Sat": $blank = 6; break;
}
$days_in_month = cal_days_in_month(0, $month, $year) ;
echo "<table border=1 width=294>";
echo "<tr><th colspan=7>$title $year</th></tr>";
echo "<tr><td width=42 align=center>S</td><td width=42 align=center>M</td><td width=42 align=center>T</td><td width=42 align=center>W</td><td width=42 align=center>T</td><td width=42 align=center>F</td><td width=42 align=center>S</td></tr>";
$day_count = 1;
echo "<tr>";
while ( $blank > 0 )
{
echo "<td align=center> - </td>";
$blank = $blank-1;
$day_count++;
}
$day_num = 1;
while ( $day_num <= $days_in_month )
{
//$eventresult = mysql_query("SELECT * FROM typhoon_event ORDER BY date") or die(mysql_error());
//while($row = mysql_fetch_array($eventresult))
//{
//$dateevent = $row['date'];
//if ( $dateevent == "'$year-$month-$day'" )
//{
//echo "<td align=center bgcolor=#74DF00><a href='viewevent.php?detu=$getuserid&pday=$day_num&pmonth=$month&pyear=$year'><b>$day_num</b></a></td>";
//}else{
if ( $day_num == $day)
{
echo "<td align=center bgcolor=#41383C><a href='viewevent.php?detu=$getuserid&pday=$day_num&pmonth=$month&pyear=$year'><b>$day_num</b></a></td>";
}else{
echo "<td align=center><a href='viewevent.php?detu=$getuserid&pday=$day_num&pmonth=$month&pyear=$year'>$day_num</a></td>";
}
//}
$day_num++;
$day_count++;
if ($day_count > 7)
{
echo "</tr><tr>";
$day_count = 1;
}
//}
}
while ( $day_count >1 && $day_count <=7 )
{
echo "<td> </td>";
$day_count++;
}
echo "</tr></table>";
mysql_close($connection);
?>
</center>
</body>
</html>
As you can see I tried to add
PHP Code:
//$eventresult = mysql_query("SELECT * FROM typhoon_event ORDER BY date") or die(mysql_error());
//while($row = mysql_fetch_array($eventresult))
//{
//$dateevent = $row['date'];
//if ( $dateevent == "'$year-$month-$day'" )
//{
//echo "<td align=center bgcolor=#74DF00><a href='viewevent.php?detu=$getuserid&pday=$day_num&pmonth=$month&pyear=$year'><b>$day_num</b></a></td>";
//}else{
but this failed...
php calendar
Reply With Quote
Bookmarks