Jump to content

page continues to load without showing any data

runnerjp

By runnerjp
in PHP Coding Help

Recommended Posts

runnerjp Advanced Member

runnerjp

Posted
Posted

I have a calander in which when you click on a date which has entry on it it opens up a popup window and shows the data. This works fine untill i include it onto my profiles page via include

<?php  include "diary/cal_show.php";?>

and the box opens but continues to load and never shows the results as shown below error66.jpg the thing is when i open the calander of the url diary/cal_show.php it works.

 

below i have included the relevant php pages.

 

here is the calander itself

 

<script src="http://www.runningprofiles.com/jquery.js" type="text/javascript"></script>
<link href="http://www.runningprofiles.com/members/diary/facebox/facebox.css" media="screen" rel="stylesheet" type="text/css">
<script src="http://www.runningprofiles.com/members/diary/facebox/facebox.js" type="text/javascript"></script>    
<script>
jQuery(document).ready(function($) {
  $('a[rel*=facebox]').facebox()
}) </script>




<?php


// there is NO NEED to edit ANY of this code

$ev_dat = array();
for ($i=0;$i<32;$i++) {
    $ev_dat[$i]=0;
}

$now = date("Y-m-d", time());
list($ty, $tm, $td) = explode('-',$now); // ty=thisyear, etc. used for highlighting 'today'

include("cal_parms.php"); // assorted configuration variables
include($dat_names); // retrieved from cal_parms.php as a 'language' file

if (!isset($_GET['m'])) { 
    $m = date("m",mktime()); 
} else {
    $m = $_GET['m'];
}
if (!isset($_GET['y'])) {
    $y = date("Y",mktime());
} else {
    $y = $_GET['y'];
}
   
/*== get what weekday the first is on ==*/ 
$tmpd = getdate(mktime(0,0,0,$m,1,$y)); 
$month = $tmpd["month"]; 
$firstwday= $tmpd["wday"]; 
if ($firstDayIsMonday == 1) {
    if ($firstwday == 0) {
        $firstwday = 6;
    } else {
        $firstwday--;
    }
}
$lastday = mk_getLastDayofMonth($m,$y); 

/*== get 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; 
}
  
// compute range of dates for this month to match dates in database in the format yyyy-mm-dd
if (strlen($m)<2) {
    $q="0";
    $q.=$m;
}
else {
    $q = $m;
}    
$dats_beg = $y. "-". $q. "-01";
$dats_en = $y. "-". $q. "-". $lastday;
  
// open db conn and select all records where date is between $dats_beg and $dats_en
include("cal_db_conn.php");
mysql_connect($db_host, $db_login, $db_pass) or die ("Can't connect!"); 
mysql_select_db($db_name) or die ("Can't open database!"); 
$query = "SELECT * FROM $db_table WHERE (ev_dat>='$dats_beg') AND (ev_dat<='$dats_en') "; 
  
$result = mysql_db_query($db_name, $query); 
// any matches?
if ($result)
{
    // handle the matches and pass relevant info to arrays
    while ($myrow = mysql_fetch_array($result)) 
    { 
        $found = $myrow['ev_dat'];
        $pieces = explode("-", $found);
        $dd = intval($pieces[2]);
        $ev_dat[$dd] = $myrow['id'];
    }
}
?> 
<table cellpadding="1" cellspacing="1" border="0" bgcolor="#<? echo $bg_edge; ?>"> 
<tr><td colspan="7" bgcolor="#<? echo $bg_top; ?>"> 
<table cellpadding="1" cellspacing="1" border="0" width="100%"> 
<tr bgcolor="#<? echo $bg_top; ?>"><th width="20" style="<?php echo $hcell; ?>"><a href="<? echo  $username; ?>&m=<?=(($m-1)<1) ? 12 : $m-1 ?>&y=<?=(($m-1)<1) ? $y-1 : $y ?>"><img src='http://www.runningprofiles.com/calendar/images/prev.gif' height='18' width='18' alt='' border='0' /></a></th> 
<th style="<?php echo $hcell; ?>">
<?php
echo  "<a href='../diary/show-month.php?mon=". $m. "&yr=". $y. "'rel=\"facebox\">";
echo "<span style='text-decoration:none'>". $mo[intval($m)]. " ". $y. "</span></a>";
?>
</th> 
<th width="20" style="<? echo $hcell; ?>"><a href="<? echo  $username; ?>&m=<?=(($m+1)>12) ? 1 : $m+1 ?>&y=<?=(($m+1)>12) ? $y+1 : $y ?>"><img src='http://www.runningprofiles.com/calendar/images/next.gif' height='18' width='18' border='0' alt='' /></a></th> 
</tr>
</table> 
</td></tr> 
<tr bgcolor="#<? echo $bg_top; ?>">
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[1]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[2]; ?></th> 
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[3]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[4]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[5]; ?></th>
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[6]; ?></th> 
<th width="20" style="<?php echo $hcell; ?>"><? echo $da[7]; ?></th>
</tr> 
    
<?  
$d = 1; 
$wday = $firstwday; 
$firstweek = true; 
/*== loop through all the days of the month ==*/ 
while ( $d <= $lastday) 
{ 
    /*== set up blank days for first week ==*/ 
    if ($firstweek) 
    {
        if ($wday!=0) {     
            echo "<tr bgcolor='#". $bg_tabl. "'>\n";
            for ($i=1; $i<=$firstwday; $i++) { 
                 echo "<td style='". $tcell. "' bgcolor='#". $bg_fill. "'> </td>\n"; 
            }
        }
        /*== Sunday start week with <tr> ==*/ 
        else { 
            echo "<tr bgcolor='#". $bg_tabl. "'>\n";
        } 
        $firstweek = false;
    }
    /*== check for event ==*/   
    echo "<td style='". $tcell. "' ";
    // is this day 'today' AND there's no event today
    if (($ty==$y) && ($tm==$m) && ($td == $d) && (!$ev_dat[$d])) { 
        echo "bgcolor='#". $bg_now. "'>". $d;
    }
    elseif ($ev_dat[$d]) {
        // get what's happening that day and use as 'mouseOver' for the link
        $query = "SELECT * FROM $db_table WHERE id=$ev_dat[$d] ";
        $result = mysql_query($query); 
        $ev = mysql_fetch_array($result);
        $titl = $ev['ev_title'];
        echo "bgcolor='#". $bg_act. "'>";
        $url = "../diary/show.php?event=". $ev_dat[$d]. "&sho=". $win_sho;
      
             echo "<a href=' $url' rel=\"facebox\" title=\"". $titl. "\">". $d. "</a>";
       
    }
    else {
        echo "bgcolor='#". $bg_days. "'>". $d; 
    }
    echo "</td>\n"; 

    /*== Saturday end week with </tr> ==*/ 
    if ($wday==6) {
        echo "</tr>\n"; 
    }
    $wday++; 
    $wday = $wday % 7; 
    if (($wday==0) AND ($d!=$lastday)){ echo "<tr bgcolor='#". $bg_tabl. "'>\n"; }
        $d++; 
    }
    // and close off the table
    if (($wday!=7) AND ($wday!=0)) {
        for ($i=$wday; $i<=6; $i++) {
            echo "<td style='". $tcell. "' bgcolor='#". $bg_fill. "'> </td>\n";
        }
        echo "</tr>";
    } 
echo "\n</table>"; 
include("win_open.php");


?>

 

row 104 = echo  "<a href='../diary/show-month.php?mon=". $m. "&yr=". $y. "'rel=\"facebox\">"; is one of the areas im talking about.

 

now like i said this all works fine on its own but as soon as i add it to this page it dosent work

 

profiles.php

 

	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
  "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
<link rel="stylesheet" type="text/css" href="http://www.runningprofiles.com/css/login.css">
<link rel="stylesheet" type="text/css" href="include/profiletab/ajaxtabs/ajaxtabs.css">
<script type="text/javascript" src="include/profiletab/ajaxtabs/ajaxtabs.js"></script>
<script type="text/javascript" src="http://www.runningprofiles.com/popup.js"></script>
<script src="http://www.runningprofiles.com/jquery.js" type="text/javascript"></script>
<link href="http://www.runningprofiles.com/members/diary/facebox/facebox.css" media="screen" rel="stylesheet" type="text/css">
<script src="http://www.runningprofiles.com/members/diary/facebox/facebox.js" type="text/javascript"></script> 

<script>
jQuery(document).ready(function($) {
  $('a[rel*=facebox]').facebox()
}) </script>
<?php
require_once '../settings.php';
checkLogin('1 2'); 

include "../info.php"; // sets username/id ect
include "../getuser.php"; // records user view on page
ini_set('error_reporting', E_ALL);

$getuser = mysql_fetch_assoc(mysql_query("SELECT * from users where Username='$profilename'"));
$getuserprofile = mysql_fetch_assoc(mysql_query("SELECT * from profile where ID='".$getuser['ID']."'"));

$sql1 = "Select * FROM diary where author = '$profilename' ORDER BY `ev_dat` DESC LIMIT 0, 5";
$postsresult1 = mysql_query($sql1) or die("Could not get diary");
$num1 = mysql_num_rows($postsresult1);

$sql = "Select DISTINCT title FROM forumtutorial_posts where author = '$profilename' ORDER BY `showtime` DESC LIMIT 0, 5";
$postsresult = mysql_query($sql) or die("Could not get threads");
$num = mysql_num_rows($postsresult);

?><table width="99%" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="2"></td>
    <td width="21%"> </td>
  </tr>
  <tr>
    <td width="22%" height="381" align="center" valign="top"><div align="center">
      <table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
        <tr>
          <td><div align="center"><br />
                <img src='http://www.runningprofiles.com/members/images/thumbs/<?php echo $getuser['image'];?>' border="1" align="middle" /> </div>
            <p align="center">Name : <?php echo $getuserprofile['first_name'];echo ' ';echo $getuserprofile['last_name'];?><br />
              Status:
              <?php $result =mysql_query("SELECT * FROM useronline WHERE(user='". $getuser['Username'] ."')");
			while ($row = mysql_fetch_array($result))
			{

							$last_active = time() - $row['timestamp'];
			}
echo ($last_active < 300)  ? 'Online <img src="/images/useron.gif" width="12" height="11" />' : 'Offline <img src="/images/useroff.gif" width="12" height="11" />';

?>
    <br />
              Age :<?php $dob = $getuserprofile['dob'];

// GET TIMESTAMPS
$ts_dob = strtotime($dob);
$ts_now = time();

// DIFFERENCE IN YEARS
$years = date('Y', $ts_now) - date('Y', $ts_dob);

// IF BEFORE THE BIRTHDAY
$mdnow = date('m-d', $ts_now);
$mddob = date('m-d', $ts_dob);
if ($mdnow < $mddob) $years--;

// SHOW THE ANSWER
echo $years;  ?> <br />
              Gender : <?php echo $getuserprofile['gender']?><br />
            Club : <?php echo $getuserprofile['club']?></p></td>
        </tr>
      </table>
      <table width="90%" cellspacing="0" cellpadding="0">
        <tr>
          <td> </td>
        </tr>
      </table>
      <table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
        <tr>
          <td height="174"><p align="center"><strong>Contact </strong></p>
            <div align="center">
              <table cellspacing="0" cellpadding="0">
                <tr>
                  <td height="30" align="center" valign="middle"><div align="center"><a href="index.php?page=sendmessage&usr=<?php echo $profilename;?>">Send message</a></div></td>
                </tr>
                <tr>
                  <td align="center" valign="middle"><div align="center"><img src="http://x.myspacecdn.com/modules/common/static/img/clear.gif" border="0" width="1" height="2" /></div></td>
                </tr>
                <tr>
                  <td height="30" align="center" valign="middle"><?php $result = mysql_query("SELECT * FROM `friends` WHERE `username` =  '$profilename' AND `friendname` = '$username'") or die(mysql_error());
if ($username !== $profilename && mysql_num_rows($result) == 0)  { ?><div align="center"><a href="http://www.runningprofiles.com/members/include/friendrequest.php?username=<?php echo $profilename ?>"
onclick="popUp(this.href,'console',200,500);return false;"
target="_blank">Add to frinds list</a></div><?php }?></td>
                </tr>
                <tr>
                  <td align="center" valign="middle"><div align="center"><img src="http://x.myspacecdn.com/modules/common/static/img/clear.gif" border="0" width="1" height="2" /></div></td>
                </tr>
                <tr>
                  <td height="30" align="center" valign="middle"><div align="center"></div></td>
                </tr>
                <tr>
                  <td><img src="http://x.myspacecdn.com/modules/common/static/img/clear.gif" border="0" width="1" height="2" /></td>
                </tr>
                <tr>
                  <td height="5" align="center" valign="top" nowrap="nowrap"> </td>
                </tr>
              </table>
          </div></td>
        </tr>
      </table> 
      <table width="90%" cellspacing="0" cellpadding="0">
        <tr>
          <td> </td>
        </tr>
      </table>
         <table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
        <tr>
          <td><div align="center">Friends</div><br/>
          <?php include'include/myfriends.php';?></td>
        </tr>
      </table> 
      <table width="90%" cellspacing="0" cellpadding="0">
        <tr>
          <td> </td>
        </tr>
      </table>
         <table width="100%" cellspacing="0" cellpadding="0" class="loggedin">
        <tr>
          <td align="center" valign="top"><div align="center">My Training Diary</div>
           
          <?php  include "diary/cal_show.php";?></td>
        </tr>
      </table>  </td>
    <td colspan="2" rowspan="2" align="center" valign="top"><table width="90%" height="108" cellpadding="3" cellspacing="5" >
        <tr>
          <td valign="top" bgcolor="#FFFFFF"><div align="center" class="style5">
            <p class="style9"><u>Welcome to Admins profile</u></p>
            <p class="style9"> </p>
          </div>
            <ul id="countrytabs" class="shadetabs">
<li><a href="#" rel="#default" class="selected">About me</a></li>
<li><a href="include/profiletab/showgoals.php?username=<?php echo $profilename;?>" rel="countrycontainer">Goals</a></li>
<li><a href="include/profiletab/showidols.php?username=<?php echo $profilename;?>" rel="countrycontainer">Idols</a></li>
<li><a href="include/profiletab/showthanks.php?username=<?php echo $profilename;?>" rel="countrycontainer">Thanks to</a> </li>
</ul>

<div id="countrydivcontainer" style="border:1px solid gray; width:800px; margin-bottom: 1em; padding: 10px">
<?php echo $getuserprofile['about_me']?></div>
<script type="text/javascript">

var countries=new ddajaxtabs("countrytabs", "countrydivcontainer")
countries.setpersist(true)
countries.setselectedClassTarget("link") //"link" or "linkparent"
countries.init()

</script></td>
        </tr>
      </table>
      <table width="90%" cellspacing="0" cellpadding="0">
        <tr>
          <td> </td>
        </tr>
      </table>
      <table width="90%" height="568" cellpadding="0" cellspacing="0">
        <tr>
          <td height="566" align="center" valign="top"><table width="100%" cellspacing="0" cellpadding="0">
            <tr>
              <td width="44%" height="481" align="left" valign="top"><div align="center">
                <?php
$result = mysql_query("SELECT * FROM pb where uid='".$getuser['ID']."' Order by distance ASC") or die(mysql_error());
$num2 = mysql_num_rows($result);

echo "<table class=\"profilepbs\" width=195 align=\"center\" cellpadding=\"0\" cellspacing=\"0\">
   <tr><td width=105 ><div align=\"center\">Distance</div></td><td width=125><div align=\"center\">Pb</div></td></tr>
   <tr>
     <td height=\"1\" colspan=\"2\" bgcolor=\"#000000\"></td>
     <td height=\"1\" colspan=\"2\" bgcolor=\"#000000\"></td>
   </tr>
   ";
while ( $row = mysql_fetch_array($result) ) {
$text = $row["distance"];
$text2 = substr($text, 2,30);

echo "<tr><td bgcolor=\"#FFFFFF\"><center>" . $text2 . "</center></td><td bgcolor=\"#FFFFFF\"><center>" . $row["pb"] . "</center></td></tr>";
  }
  if($num2 < 1)
    {echo "<tr><td bgcolor=\"#FFFFFF\" ><center> N/A 
    </center></td><td bgcolor=\"#FFFFFF\"><center> N/A 
    </center></td></tr>";}
echo "</table>
<p>";
?>

                <br />
              </div>
                <table class="profilepbs" width="80%" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td height="1"  align="center" valign="top">My Forum Posts </td>
                  </tr>
                  <tr>
                    <td height="1" colspan="2" bgcolor="#000000"></td>
                  </tr>
                  <tr>
                    <td height="49"  align="center" valign="top" bgcolor="#FFFFFF" ><?php if($num < 1)
    {echo 'User has yet to make a post.';}else{
while($row = mysql_fetch_assoc($postsresult)) {  echo ' <a id="posts" href="http://www.runningprofiles.com/members/index.php?page=message&forum='.$row['forum'].'&id='.$row['postid'].'&pagenum=last">'.$row['title'].'</a> <br />' ;}
     }?></td>
                  </tr>
                </table>
                <p> </p>
                <table class="profilepbs" width="80%" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td height="97"  align="center" valign="top" h="h">My Recent Training Log's
                      <table width="99%" cellspacing="0" cellpadding="0">
                          <tr>
                            <td height="1" bgcolor="#000000">                              </td>
                          </tr>
                          <tr>
                            <td height="75" align="center" valign="top" bgcolor="#FFFFFF"><?php if($num1 < 1)
    {echo 'User has yet post their training diary.';}else{
while($row1 = mysql_fetch_assoc($postsresult1)) { 
$date = $row1['ev_dat'];
list($year, $month, $day) = split('[-.-]', $date);
?>
<?
echo ' <a id="posts"  href="http://www.runningprofiles.com/members/diary/cal_show.php?m='.$month.'&y='.$year.'">'.$row1['ev_title'].'</a> <br />' ;

}
}


?>
</td>
                          </tr>
                      </table></td>
                  </tr>
                </table>
               
                <p> </p></td>
              <td width="56%" valign="top" >
                <?php include "shoutbox/index.php";

?></td>
            </tr>
            
          </table>          </td>
        </tr>
      </table>
      
      <p> </p>
    <p> </p></td>
  </tr>
  <tr>
    <td align="center" valign="top">      </td>
  </tr>
  
  
</table>

 

why?

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.