CSS Codes
CSS Layouts
Results 1 to 2 of 2

Thread: Restriction in Posting Events

  1. 08-18-2010, 03:51 AM #1
    rhodarose
    rhodarose is offline Regular Coders
    Join Date
    Jul 2010
    Posts
    228
    Thanks
    18
    Thanked 0 Times in 0 Posts

    Default Restriction in Posting Events

    Good day!

    I have a database and it has a 2 tables the first table is tbllogin its consist of Username and Department and the second table is caltbl i use it for the calendar.

    I download a calendar and the calendar i download you can add events once you click the date. I want that theirs a restriction like if the username is xxx and the department is yyy she can add events or the calForm would be active and else she could not add events or the calform would be deactive...

    here is the code for thew cal.php:

    Code:
    <?php

	$host = "localhost";

	$username = "";

	$password = "";

	$dbCnx = @mysql_connect($host, $username, $password) or die('Could not Connect to the database');

	$dbName = 'dspi';

	mysql_select_db($dbName);	

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Untitled Document</title>

<script>

function goLastMonth(month, year){

	// If the month is January, decrement the year

	if(month == 1){

		--year;

		month = 13;

	}

	document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year;

}

//next function

function goNextMonth(month, year){

	// If the month is December, increment the 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;

//x = x.replace(/^\s+/,"");  // strip leading spaces

if (x.length > 0) {filled ++}



var y = document.form1.calDesc.value;

//y = y.replace(/^s+/,"");  // strip leading spaces

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>

<style>

body{

	font-family:Georgia, "Times New Roman", Times, serif;

	font-size:12px;

}

.today{

	/*background-color:#00CCCC;*/

	font-weight:bold;

	background-image:url(calBg.jpg);

	background-repeat:no-repeat;

	background-position:center;

	position:relative;

}

.today span{

	position:absolute;

	left:0;

	top:0;	

}



.today a{

	color:#000000;

	padding-top:10px;

}

.selected {

color: #FFFFFF;

background-color: #C00000;

}

.event {

	background-color: #C6D1DC;

	border:1px solid #ffffff;

} 

.normal {



} 

table{

	border:1px solid #cccccc;

	padding:3px;

}

th{

	width:36px;

	background-color:#cccccc;

	text-align:center;

	color:#ffffff;

	border-left:1px solid #ffffff;

}

td{

	text-align:center;

	padding:10px;

	margin:0;

}

table.tableClass{

	width:350px;

	border:none;

	border-collapse: collapse;

	font-size:85%;

	border:1px dotted #cccccc;

}

table.tableClass input,textarea{

	font-size:90%;

}

#form1{

	margin:5px 0 0 0;

}

#greyBox{

	height:10px;

	width:10px;

	background-color:#C6D1DC;

	border:1px solid #666666;

	margin:5px;

}

#legend{

	margin:5 0 10px 50px;

	width:200px;

}

#hr{border-bottom:1px solid #cccccc;width:300px;}

.output{width:300px;border-bottom:1px dotted #ccc;margin-bottom:5px;padding:6px;}

h5{margin:0;}

</style>

</head>



<body>

<div id="legend"> 

<img src="sq.jpg" /> Scheduled Events<br/><img src="calBg.jpg" height="10"/> Todays Date</div>

<?php

	//$todaysDate = date("n/j/Y");

	//echo $todaysDate;

	// Get values from query string

	$day = (isset($_GET["day"])) ? $_GET['day'] : "";

	$month = (isset($_GET["month"])) ? $_GET['month'] : "";

	$year = (isset($_GET["year"])) ? $_GET['year'] : "";

	//comparaters for today's date

	//$todaysDate = date("n/j/Y");

	//$sel = (isset($_GET["sel"])) ? $_GET['sel'] : "";

	//$what = (isset($_GET["what"])) ? $_GET['what'] : "";

	

	//$day = (!isset($day)) ? $day = date("j") : $day = "";

	if(empty($day)){ $day = date("j"); }

	

	if(empty($month)){ $month = date("n"); }

	

	if(empty($year)){ $year = date("Y"); } 

	//set up vars for calendar etc

	$currentTimeStamp = strtotime("$year-$month-$day");

	$monthName = date("F", $currentTimeStamp);

	$numDays = date("t", $currentTimeStamp);

	$counter = 0;

	//$numEventsThisMonth = 0;

	//$hasEvent = false;

	//$todaysEvents = ""; 

	//run a selec statement to hi-light the days

	function hiLightEvt($eMonth,$eDay,$eYear){

		//$tDayName = date("l");

		$todaysDate = date("n/j/Y");

		$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear;

		if($todaysDate == $dateToCompare){

			//$aClass = '<span>' . $tDayName . '</span>';

			$aClass='class="today"';

		}else{

			//$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear;

			//echo $todaysDate;

			//return;

			$sql="select count(calDate) as eCount from calTbl where calDate = '" . $eMonth . '/' . $eDay . '/' . $eYear . "'";

			//echo $sql;

			//return;

			$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;

	}

?>

<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"><?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>S</td>

    <th>M</td>

    <th>T</td>

    <th>W</td>

    <th>T</td>

    <th>F</td>

    <th>S</td>

</tr>

<tr>

<?php

	for($i = 1; $i < $numDays+1; $i++, $counter++){

		$dateToCompare = $month . '/' . $i . '/' . $year;

		$timeStamp = strtotime("$year-$month-$i");

		//echo $timeStamp . '<br/>';

		if($i == 1){

			// Workout when the first day of the month is

			$firstDay = date("w", $timeStamp);

			for($j = 0; $j < $firstDay; $j++, $counter++){

				echo "<td>&nbsp;</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>

<?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 . "'";

//echo $sql;

//return;

$result = mysql_query($sql);

$numRows = mysql_num_rows($result);

?>

<a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">New Event</a><br/>

<?php

if(isset($_GET['f'])){

		include 'calForm.php';

}

if($numRows == 0 ){

	echo '<h3>No Events</h3>';

}else{

//echo '<ul>';

echo '<h3>Events Listed</h3>';

	while($row = mysql_fetch_array($result)){

?>

	<div class="output">

		<h5><?=$row['calName'];?></h5>

    	<?=$row['calDesc'];?><br/>

    	Listed On: <?=$row['calStamp'];?>

    </div>

<?php

	}

  }

}

?>

</body>

</body>

</html>

    and here is the code for the calForm.php

    Code:
    <form id="form1" name="form1" method="post" action="<?=$_SERVER['PHP_SELF'].'?month=' .$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1">

  <table cellpadding="0" cellspacing="0" class="tableClass">

    <tr>

      <td width="142">Event Name</td>

      <td width="146"><div align="left">

        <input type="text" name="calName" id="calName" onKeyup="checkFilled();">

      </div></td>

    </tr>

    <tr>

      <td rowspan="2">Event Desc</td>

      <td><div align="left">

        <textarea name="calDesc" id="calDesc" cols="15" rows="5" onKeyDown="remChars(this, document.form1.txtCount, 200);"

							onKeyUp="remChars(this, document.form1.txtCount, 200);checkFilled();"></textarea>

        <br/>

      </div></td>

    </tr>

    <tr>

      <td>You have

        <input readonly name="txtCount" type="text" id="txtCount" value="200" size="2" maxlength="3">

characters left!</td>

    </tr>

    <tr>

      <td>Event Date</td>

      <td><div align="left">

        <input type="text" name="calDate" id="calDate" value="<?=$_GET['month'] . '/' . $_GET['day'] . '/' . $_GET['year'];?>" readonly>

      </div></td>

    </tr>

    <tr>

      <td colspan="2"><input type="submit" name="Submit" id="Submit" value="Submit" disabled></td>

    </tr>

  </table>

</form>
    Reply With Quote Reply With Quote
  2. 08-19-2010, 11:23 AM #2
    ceriamultimedia
    ceriamultimedia is offline New Comer (less than 5 posts)
    Join Date
    Aug 2010
    Location
    Yogyakarta, Indonesia
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thank you for the information, I will use ini my website http://www.ceriamultimedia.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules