Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8
  1. #1
    Regular Coder
    Join Date
    May 2007
    Location
    Indonesia
    Posts
    164
    Thanks
    10
    Thanked 0 Times in 0 Posts

    in need of calendar help

    Need help on getting this calendar to work. The problem is it doesnt link to the include file of calForm.php and nothing shows on the calendar I have created the db already and i shows a calendar a calendar but no days. Here is the file cal.php not sure what is wrong.

    PHP Code:
    <?php
    //db conn hardcode or include whichever you like 
    mysql_connect("""""") or die(mysql_error());
    mysql_select_db("cal") or die(mysql_error());

    ?>
    <!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(
    $rowmysql_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 == 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 == ){
    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>

  • #2
    Regular Coder poyzn's Avatar
    Join Date
    Nov 2010
    Posts
    266
    Thanks
    2
    Thanked 61 Times in 61 Posts
    try to define full path to the file from the site root directory. If calForm.php is in the root, it should be
    PHP Code:
    include $_SERVER['DOCUMENT_ROOT'].'/calForm.php'

  • #3
    Regular Coder
    Join Date
    May 2007
    Location
    Indonesia
    Posts
    164
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Hi could you highlight where I need to put the code within the php file that I posted?

  • #4
    Regular Coder
    Join Date
    May 2007
    Location
    Indonesia
    Posts
    164
    Thanks
    10
    Thanked 0 Times in 0 Posts
    poyzn I copied the code you gave and commented out mine and its still the same result with the calendar showing no day numbers or anything just current month and left and right buttons thats about it. The calendar is virtually blank with M T W T F S S at the top bit.

  • #5
    Regular Coder poyzn's Avatar
    Join Date
    Nov 2010
    Posts
    266
    Thanks
    2
    Thanked 61 Times in 61 Posts
    show your full path to calForm.php

  • #6
    Regular Coder
    Join Date
    May 2007
    Location
    Indonesia
    Posts
    164
    Thanks
    10
    Thanked 0 Times in 0 Posts
    poyzn not sure what you mean by showing the full path because its in the same directory as all other files including cal.php. This is where I got the code http://hubpages.com/hub/Simple-Event...dar-PHP--MySQL not sure why its not doing what its supposed to.
    Last edited by rjkdonaldson; 11-12-2010 at 08:08 AM. Reason: additional info

  • #7
    Regular Coder poyzn's Avatar
    Join Date
    Nov 2010
    Posts
    266
    Thanks
    2
    Thanked 61 Times in 61 Posts
    Quote Originally Posted by rjkdonaldson View Post
    poyzn not sure what you mean by showing the full path because its in the same directory as all other files including cal.php
    just give me full path to that file, I'll create an absolute path to include calForm.php and you'll test it if script works with right include

  • #8
    Regular Coder
    Join Date
    May 2007
    Location
    Indonesia
    Posts
    164
    Thanks
    10
    Thanked 0 Times in 0 Posts
    poyzn code is in the website I gave just copy it then can you provide me with a working version. by the way the full path is http://localhost/cal.php not sure if its what you mean sorry.


  •  

    Posting Permissions

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