URGENT: Session problem not carrying UserName over
| From: | Mike Yuen | Date: | Fri, 13 Apr 2001 18:27:56 +0000 |
| Subject: | URGENT: Session problem not carrying UserName over | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-48474@lists.php.net to get a copy of this message | ||
I have this calendar and it's supposed to print out the word "Activity" if there is an event booked on that day.
Everything works great except the query isn't finding the username. I did a print "$CUserName is CUserName" and it works great - so I know I started my session and it's accessible but when I put inside the query, it doesn't show up. I tried passing it through the browser and passing the entire session through the browser and still no dice. I also checked my php.ini file and ALL of my globals are on.
Here's my coding, I really hope someone can help me figure this thing out.
Thanks,
Mike
<?PHP
session_start();
include ("dblib.inc");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>LDSAlberta.com: Personal Calendar</title>
<Link href="arial.css" rel="stylesheet" title="arial" type="text/css">
</head>
<body>
<img src="pics/logo.gif">
<BR>
<div align="center"><font size="4">Calendar of Events</font> <BR>
<hr>
<BR>
<?PHP
mk_drawCalendar($m,$y);
?></div>
<div align="center">
<?PHP
// Draw the Calendar
global $CUserName;
function mk_drawCalendar($m,$y)
{
if ((!$m) || (!$y))
{
$m = date("m",mktime());
$y = date("Y",mktime());
if ($m==1)
$themonth="jan";
else if ($m==2)
$themonth="feb";
else if ($m==3)
$themonth="mar";
else if ($m==4)
$themonth="apr";
else if ($m==5)
$themonth="may";
else if ($m==6)
$themonth="jun";
else if ($m==7)
$themonth="jul";
else if ($m==8)
$themonth="aug";
else if ($m==9)
$themonth="sept";
else if ($m==10)
$themonth="oct";
else if ($m==11)
$themonth="nov";
else if ($m==12)
$themonth="dec";
}
// get what weekday the first is on /
$tmpd = getdate(mktime(0,0,0,$m,1,$y));
$month = $tmpd["month"];
$firstwday= $tmpd["wday"];
$lastday = mk_getLastDayofMonth($m,$y);
?>
<font size=1>Click on date to see details</font>
<table cellpadding=2 cellspacing=0 border=1>
<tr>
<td colspan=7 bgcolor="#cccc99">
<table cellpadding=0 cellspacing=0 border=0 width="100%">
<tr>
<th width="100">
<a href="<?=$SCRIPT_NAME?>?m=<?=(($m-1)<1) ? 12 : $m-1 ?>&y=<?=(($m-1)<1) ? $y-1 : $y ?>"><<</a>
</th>
<th><font size=2><?="$month $y"?></font></th>
<th width="100">
<a href="<?=$SCRIPT_NAME?>?m=<?=(($m+1)>12) ? 1 : $m+1 ?>&y=<?=(($m+1)>12) ? $y+1 : $y ?>">>></a>
</th>
</tr>
</table>
</td>
</tr>
<tr>
<th width=100 class="tcell">Sunday</th>
<th width=100 class="tcell">Monday</th>
<th width=100 class="tcell">Tuesday </th>
<th width=100 class="tcell">Wednesday</th>
<th width=100 class="tcell">Thursday</th>
<th width=100 class="tcell">Friday</th>
<th width=100 class="tcell">Saturday</th>
</tr>
<?PHP
$d = 1;
$wday = $firstwday;
$firstweek = true;
//Loop Through to last day
while ( $d <= $lastday)
{
//blanks for first week
if ($firstweek) {
print "<tr>";
for ($i=1; $i<=$firstwday; $i++)
{ print "<th height=100 bgcolor=#CCCCCC><font size=2> </font>
</th>"; }
$firstweek = false;
}
//checks for event
if($numrows>=1)
{
//Event exists
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\"> <a href=calendardetails.php?ADay=$d&AMonth=$themonth&AYear=$y target=\"new_window\"><B>$d</b></a></td>"; } else {
//Event doesn't exist
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">
<a href=calendardetails.php?ADay=$d&AMonth=$themonth&AYear=$y target=\"new_window\"><B>$d</b></a>";
///////////////////////////////////////////////////////
// PROBLEM IS HERE!!!! CUserName doesn't show up
$eventrows = 0;
$query = "SELECT * FROM activities WHERE CUserName='$CUserName' AND ADay='$d' AND AMonth='$themonth' AND AYear='$y'";
print "<font size=-1>$query</font>";
//
///////////////////////////////////////////////////////
$result = mysql_query($query);
$eventrows = mysql_num_rows($result);
if($eventrows>=1)
print "Activity";
print "</td>";
}
$wday++;
$wday = $wday % 7;
$d++;
// Sunday start week with <tr>
if ($wday==0) { print "<th height=100 bgcolor=#ffffff><tr></th>"; }
//blanks for last week
if ($lastweek) {
print "<tr>";
for ($lastday=28; $tlastday<=31; $lastday++)
{
print "<th height=100 bgcolor=#AAAAAA>
</th><font size=2> </font>"; }
$lastweek = false;
}
}
?>
</tr></table>
<font size=1>Click on date to see details</font>
<br>
<?PHP
//end calendar Draw Function
}
//Show the last day of the month
function mk_getLastDayofMonth($mon,$year)
{
for ($tday=28; $tday <= 31; $tday++)
{
$tdate = getdate(mktime(0,0,0,$mon,$tday,$year));
if ($tdate["mon"] != $mon)
{ break; }
}
$tday--;
return $tday;
}
?>
</div>
</body>
</html>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.