Here is the old calendar code:
Expand|Select|Wrap|Line Numbers
- <?php
- $dbCnx = @mysql_connect("localhost","", "") or die('Could not Connect to the database')
- mysql_select_db("mydb");
- ?>
- <html>
- <script>
- function goLastMonth(month, year){
- if(month == 1){
- --year;
- month = 13;
- }
- document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year;
- }
- function goNextMonth(month, year){
- if(month == 12){
- ++year;
- month = 0;
- }
- document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month+1)+'&year='+year;
- }
- function remChars(txtControl, txtCount, intMaxLength)
- {
- if(txtControl.value.length > intMaxLength)
- txtControl.value = txtControl.value.substring(0, (intMaxLength-1));
- else
- txtCount.value = intMaxLength - txtControl.value.length;
- }
- function checkFilled() {
- var filled = 0
- var x = document.form1.calName.value;
- if (x.length > 0) {filled ++}
- var y = document.form1.calDesc.value;
- if (y.length > 0) {filled ++}
- if (filled == 2) {
- document.getElementById("Submit").disabled = false;
- }
- else {document.getElementById("Submit").disabled = true} // in case a field is filled then erased
- }
- </script>
- <body>
- <?php
- $day = (isset($_GET["day"])) ? $_GET['day'] : "";
- $month = (isset($_GET["month"])) ? $_GET['month'] : "";
- $year = (isset($_GET["year"])) ? $_GET['year'] : "";
- if(empty($day)){ $day = date("j"); }
- if(empty($month)){ $month = date("n"); }
- if(empty($year)){ $year = date("Y"); }
- $currentTimeStamp = strtotime("$year-$month-$day");
- $monthName = date("F", $currentTimeStamp);
- $numDays = date("t", $currentTimeStamp);
- $counter = 0;
- function hiLightEvt($eMonth,$eDay,$eYear){
- $todaysDate = date("n/j/Y");
- $dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear;
- if($todaysDate == $dateToCompare){
- $aClass='class="today"';
- }else{
- $sql="select count(calDate) as eCount from calTbl where calDate = '" . $eMonth . '/' . $eDay . '/' . $eYear . "'";
- $result = mysql_query($sql);
- while($row= mysql_fetch_array($result)){
- if($row['eCount'] >=1){
- $aClass = 'class="event"';
- }elseif($row['eCount'] ==0){
- $aClass ='class="normal"';
- }
- }
- }
- return $aClass;
- }
- ?>
- <div id="Calendar_Event">
- <table width="350" cellpadding="0" cellspacing="0">
- <tr>
- <td width="50" colspan="1">
- <input type="button" value=" < " onClick="goLastMonth(<?php echo $month . ", " . $year; ?>);">
- </td>
- <td width="250" colspan="5">
- <span class="title" style="color:#FFFFFF"><?php echo $monthName . " " . $year; ?></span><br>
- </td>
- <td width="50" colspan="1" align="right">
- <input type="button" value=" > " onClick="goNextMonth(<?php echo $month . ", " . $year; ?>);">
- </td>
- </tr>
- <tr>
- <th>M</td>
- <th>T</td>
- <th>W</td>
- <th>T</td>
- <th>F</td>
- <th>S</td>
- <th>S</td>
- </tr>
- <tr>
- <?php
- for($i = 1; $i < $numDays+1; $i++, $counter++){
- $dateToCompare = $month . '/' . $i . '/' . $year;
- $timeStamp = strtotime("$year-$month-$i");
- if($i == 1){
- $firstDay = date("N", $timeStamp);
- for($j = 1; $j < $firstDay; $j++, $counter++){
- echo "<td> </td>";
- }
- }
- if($counter % 7 == 0 ){
- ?>
- </tr><tr>
- <?php
- }
- ?>
- <!--right here--><td width="50" <?=hiLightEvt($month,$i,$year);?>><a href="<?=$_SERVER['PHP_SELF'] . '?month='. $month . '&day=' . $i . '&year=' . $year;?>&v=1"><?=$i;?></a></td>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="New_Event">
- <?php
- if(isset($_GET['v'])){
- if(isset($_POST['Submit'])){
- $sql="insert into calTbl(calName,calDesc,calDate,calStamp) values('" . $_POST['calName'] ."','" . $_POST['calDesc'] . "','" . $_POST['calDate'] . "',now())";
- mysql_query($sql);
- }
- $sql="select calName,calDesc, DATE_FORMAT(calStamp, '%a %b %e %Y') as calStamp from calTbl where calDate = '" . $month . '/' . $day . '/' . $year . "'";
- $result = mysql_query($sql);
- $numRows = mysql_num_rows($result);
- if ($_SESSION['username']=="user1")
- {
- $check1=mysql_query("SELECT * FROM tbllogin WHERE Username='user1' AND Department='Staff' AND Permission='True'");
- $check2 = mysql_fetch_array($check1);
- $username = $check2['Username'];
- $dep = $check2['Department'];
- $permiss = $check2['Permission'];
- if($username=="user1" && $dep=="Staff" && $permiss=="True"){
- $_SESSION['isallowed'] = $check2['Permission'];
- ?>
- <a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">Add Even</a><a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">t</a>
- <?php
- }
- }
- else
- { echo "You cannot Add New Event"; }
- ?>
- </div>
- <div id="Cal_Event">
- <?php
- if(isset($_GET['f'])){
- include 'calform.php';
- }
- if($numRows == 0 ){
- echo '';
- }else{
- echo '<h3>Event Listed</h3>';
- while($row = mysql_fetch_array($result)){
- ?>
- <h5><?=$row['calName'];?></h5>
- <?=$row['calDesc'];?><br/>
- Listed On: <?=$row['calStamp'];?>
- <?php
- }
- }
- }
- ?>
- </div>
- </body>
- </html>
Honestly, I have no idea why it happened after I change my database. Actually my tbluser was work so I connected in my database on my other webpage.
Any help is highly appreciated. Thank you in advance.