[RESOLVED] Revamp of Calendar Program

[KingWylim]

I downloaded one of the calendar programs from this site and I revamped it so that it no longer requires register_globals = on. But now I am having a small problem. I doesn't seem to be working with the database any longer and I can't figure out why. Any help on this would be greatly appreciated. If I knew close to where the error was I would just post that code but I am unsure so here is the whole file:

calendar.php

<?php
/*
	Written by Aline Bernstein, [e-mail], June 2002
	Adapted from the work of Joseph Cunningham, [e-mail]
	Copyright: None

Version 3.0 Security Risks fixed by Alex Autrey, [e-mail]
* Changed to short php tags
* Now uses sessions without globals
* Which helps elivate all of the glorious hacks we recieve.

Displays a one-month calendar and a list of events for the month,
retrieved from a database. Prev and Next links let you navigate
to the next month. The mktime() function is used to roll through
the months continuously and cross into the next year. Called with
no parameters, it starts with the current month.

*/


// Edit the following variables for your environment

$hostname = "localhost";
$mysql_user = "root";
$mysql_paswd = "";
$dbname = "test";

$db = mysql_connect($hostname,$mysql_user,$mysql_paswd);
mysql_select_db($dbname,$db);

$db_table_name =  'mts';
$db_column_name =  'EntryDate';
$pgm = $_SERVER['PHP_SELF'];

$cal_table_tag =  "\n<table width=140 border=0 bgcolor=#DDDDDD>";
$cal_mon_tr_tag =  "\n<tr bgcolor=#D3DCE3>";
$cal_dayname_tr_tag =  "\n<tr bgcolor=#CCCCCC>";
$cal_day_tr_tag =  "\n<tr>";
$cal_day_opentd = "<td align=center>";
$cal_day_closetd = "</td>";
$cal_event_opentd = "<td align=center bgcolor=#c0c0ff><b>";
$cal_event_closetd = "</b></td>";
$event_table_opentag =  "<table cellspacing=0 cellpadding=4 border=0>\n";
$event_table_closetag =  "</table>\n";
$event_tr_opentag =  "\t<tr>\n";
$event_tr_closetag =  "\t</tr>\n";
$event_th_opentag =  "\t\t<th bgcolor=#D3DCE3>\n";
$event_th_closetag =  "\t\t</th>\n";
$event_td_opentag =  "\t\t<td bgcolor=#CCCCCC>\n";
$event_td_closetag =  "\t\t</td>\n";

//Added for version 3.0 which gives better security.
//So you no longer have to have globals on.
session_start();
$_SESSION["db_table_name"] = $db_table_name;
$_SESSION["db_column_name"] = $db_column_name;
$_SESSION["pgm"] = $pgm;
$_SESSION["cal_table_tag"] = $cal_table_tag;
$_SESSION["cal_mon_tr_tag"] = $cal_mon_tr_tag;
$_SESSION["cal_dayname_tr_tag"] = $cal_dayname_tr_tag;
$_SESSION["cal_day_tr_tag"] = $cal_day_tr_tag;
$_SESSION["cal_day_opentd"] = $cal_day_opentd;
$_SESSION["cal_day_closetd"] = $cal_day_closetd;
$_SESSION["cal_event_opentd"] = $cal_event_opentd;
$_SESSION["cal_event_closetd"] = $cal_event_closetd;
$_SESSION["event_table_opentag"] = $event_table_opentag;
$_SESSION["event_table_closetag"] = $event_table_closetag;
$_SESSION["event_tr_opentag"] = $event_tr_opentag;
$_SESSION["event_tr_closetag"] = $event_tr_closetag;
$_SESSION["event_th_opentag"] = $event_th_opentag;
$_SESSION["event_th_closetag"] = $event_th_closetag;
$_SESSION["event_td_opentag"] = $event_td_opentag;
$_SESSION["event_td_closetag"] = $event_td_closetag;


function fixlen($fixit) {
        if (strlen($fixit)<2) {
                return  "0$fixit";
        } else {
                return $fixit;
        }
}

function gen_month($year,$month) {
//Globals were removed from this section and replaced by Sessions.
session_start();
$pgm = $_SESSION["pgm"];
$cal_table_tag = $_SESSION["cal_table_tag"];
$cal_mon_tr_tag = $_SESSION["cal_mon_tr_tag"];
$cal_dayname_tr_tag = $_SESSION["cal_dayname_tr_tag"];
$cal_day_tr_tag = $_SESSION["cal_day_tr_tag"];
$cal_day_opentd = $_SESSION["cal_day_opentd"];
$cal_day_closetd = $_SESSION["cal_day_closetd"];
$cal_event_opentd = $_SESSION["cal_event_opentd"];
$cal_event_closetd = $_SESSION["cal_event_closetd"];
$event_table_opentag = $_SESSION["event_table_opentag"];
$event_table_closetag = $_SESSION["event_table_closetag"];
$event_tr_opentag = $_SESSION["event_tr_opentag"];
$event_tr_closetag = $_SESSION["event_tr_closetag"];
$event_th_opentag = $_SESSION["event_th_opentag"];
$event_th_closetag = $_SESSION["event_th_closetag"];
$event_td_opentag = $_SESSION["event_td_opentag"];
$event_td_closetag = $_SESSION["event_td_closetag"];


$mon_date = getdate(mktime(0,0,0,$month,1,$year));
$mon_name = $mon_date['month'];
$mon_total_days = strftime( "%d",mktime(0,0,0,$month+1,0,$year));
echo "<a name=\"top\"></a>";
echo $cal_table_tag;
$prev_date = getdate(mktime(0,0,0,$month-1,1,$year));
$prev = $prev_date['year'] . fixlen($prev_date['mon']);
$next_date = getdate(mktime(0,0,0,$month+1,1,$year));
$next = $next_date['year'] . fixlen($next_date['mon']);
echo $cal_mon_tr_tag . "<td align=left><a href=$pgm?yyyymm=$prev>Prev</a></td>";
echo "<td colspan=5 align=center><b>$mon_name $year</b></td>";
echo "<td align=right><a href=$pgm?yyyymm=$next>Next</a></td></tr>";
echo $cal_dayname_tr_tag .  "<td>Sun</td><td>Mon</td><td>Tue</td><td>Wed</td><td>Thu</td><td>Fri</td><td>Sat</td></tr>";
$day_count = 1;
while ($day_count<=($mon_total_days-7)) {
    $fweek = getdate(mktime(0,0,0,$month,$day_count,$year));
    if ($day_count<=7) {
        $sb_cnt_td = $fweek['wday'];
        $sb_cnt = $fweek['wday'];
        $sb_max = 7;
        $p_line = $cal_day_tr_tag;
        while ($sb_cnt_td>=1) {
            $p_line .=  "\n<td>&nbsp;</td>";
            $sb_cnt_td--;
        }
        while ($sb_cnt<$sb_max) {
            $find_data = $fweek['year'] ."-". fixlen($fweek['mon']) ."-". fixlen($day_count);
            $urldisp = gen_day_url($find_data,$day_count);
            if (strlen($urldisp) > 2)
                $p_line .=  $cal_event_opentd . $urldisp . $cal_event_closetd;
            else
                $p_line .=  $cal_day_opentd . $urldisp . $cal_day_closetd;
            $sb_cnt++;
            $day_count++;
        }
        echo  "$p_line</tr>";
    } else {
        $weekday_count = 1;
        $p_line = $cal_day_tr_tag;
        while ($weekday_count<=7) {
            $find_data = $fweek['year'] ."-". fixlen($fweek['mon']) ."-". fixlen($day_count);
            $urldisp = gen_day_url($find_data,$day_count);
            if (strlen($urldisp) > 2)
                $p_line .=  $cal_event_opentd . $urldisp . $cal_event_closetd;
            else
                $p_line .=  $cal_day_opentd . $urldisp . $cal_day_closetd;
            $weekday_count++;
            $day_count++;
        }
        $p_line .= "</tr>";
        echo $p_line;
    }
}
$sb_cnt_td = 7-($mon_total_days - $day_count);
$p_line = $cal_day_tr_tag;
while ($day_count<=$mon_total_days) {
    $find_data = $fweek['year'] ."-". fixlen($fweek['mon']) ."-". fixlen($day_count);
    $urldisp = gen_day_url($find_data,$day_count);
    if (strlen($urldisp) > 2)
        $p_line .=  $cal_event_opentd . $urldisp . $cal_event_closetd;
    else
        $p_line .=  $cal_day_opentd . $urldisp . $cal_day_closetd;
    $day_count++;
}
while ($sb_cnt_td>1) {
    $p_line .=  "\n<td>&nbsp;</td>";
    $sb_cnt_td--;
}
echo  "$p_line</tr>";
echo  "</table>";
}

function gen_day_url($data,$day) {
	session_start();
	$db_table_name = $_SESSION["db_table_name"];
	$db_column_name = $_SESSION["db_column_name"];
	$db = $_SESSION["db"];

$qrsql =  "SELECT * FROM $db_table_name WHERE ($db_column_name='$data')";
$qr_ret = mysql_query($qrsql, $db);
    $qr_num=mysql_num_rows($qr_ret);
    if ($qr_num>0) {
		$row=mysql_fetch_array($qr_ret);
		return  "<a href=\"#$day\">$day</a>";
    } else {
        return $day;
    }
}

function show_events($year,$month) {
session_start();
$db_table_name = $_SESSION["db_table_name"];
$db_column_name = $_SESSION["db_column_name"];
$db = $_SESSION["db"];
$pgm = $_SESSION["pgm"];

  $date1 = date("Y-m-d", mktime(0,0,0,$month,1,$year));
  $date2 = date("Y-m-d", mktime(0,0,0,$month+1,1,$year));

  $qrsql =  "SELECT * FROM $db_table_name WHERE ($db_column_name>='$date1' " .
	"and $db_column_name<'$date2') ORDER BY $db_column_name";
  $qr_ret = mysql_query($qrsql, $db);
  $qr_num=mysql_num_rows($qr_ret);
$lastday = 0;
while($row=mysql_fetch_array($qr_ret)) {           		
	$event_date = $row[$db_column_name];
	$event_year = substr($event_date,0,4);
	$event_month = substr($event_date,5,2);
	$event_day = substr($event_date,8,2);
	$event_getdate = getdate(mktime(0,0,0,$event_month,$event_day,$event_year));
	$day_of_week = $event_getdate['weekday'];
	if ($lastday != $event_day) {
		if ($lastday <> 0) {
			echo "<br><a href=\"#top\">Top</a>";
		}
		echo "<p><hr width=200 align=\"left\"><a name=\"$event_day\"><b>" .
		$event_getdate['weekday'] . ", " . $event_getdate['month'] . " " .
		$event_getdate['mday'] . "</b></a>";
	}
	$lastday = $event_day;
	echo "<br>" . $row['description'];
}
if ($lastday <> 0) {
	echo "<br><a href=\"#top\">Top</a>";
}
}


?>

<?php
  // Main
  $yyyymm = $_GET["yyyymm"];

  if (isset($yyyymm)) {
	if(strlen($yyyymm) == 6) {
     	$yyyy = substr($yyyymm, 0, 4);
     	$mm = substr($yyyymm, 4, 2);
  	}
  } else {
    $today = getdate();
    $yyyy = $today['year'];
    $mm = $today['mon'];
  }

  gen_month($yyyy, $mm);
?>

[KingWylim]

I still have not been able to locate the error in this code if anyone could help me out in this respect even if they don't have a solution but maybe an idea that would be greatly appreciated. I realize that looking a, a whole document isn't really what any of you had in mind to do in this forum but I would really appreciate it.

Thank you,
Alex Autrey

[TheDefender]

Have you done any kind of debugging on this? Take a look into [man]mysql_error[/man] Add that to the code where applicable, and see what gets returned. Need more details than just "It doesn't seem to be working with the database any longer" Wat indications do you have that this is failing?

[KingWylim]

I greatly appreciate the advice I will look into this further when I get back to work and the test server. I have already setup a db there and have test data.

Trying to work on this problem at home would work best if I could ghost the test server to hear rather then have any variences in the computers and there respective software setup's.

If I am able to fix and resolve this problem or at least narrow it down I will continue or resolve this thread respective of my result.

Thanks again