webForumDet fria alternativet
Logga in / Bli medlem

variabel som är tom ibland, helt cp! hjälp!

PHP

0 svar · 207 visningar · startad av Simkisen

SimkisenMedlem sedan jan. 200357 inlägg
Frågan#1

problem med koden, jag har testat att skriva echo $id; lite här o var och det funkar...men t.ex på rad 64 så funkar inte $id, den ger inget värde alls! och den verkar inte göra det i något av mysql hämtningarna heller...fattar inte vad som e fel...snälla HJÄLP!

<?php 
session_start(); // Alltid överst på sidan 

include "conn.php"; // Databasanslutningen 

// Kolla om inloggad = sessionen satt 
if (!isset($_SESSION['sess_user'])){ 
  header("Location: index.php"); 
  exit; 
} 

$id = $_GET["id"];

//Vems pool man besöker
if ($id=="" || $id==$_SESSION['sess_id']) {
	$id=$_SESSION['sess_id'];
	$owner=true; //För personliga saker
}

//Hämta ut och spara i en associativ vektor.
$result=mysql_query("SELECT * FROM members WHERE id=".(int)$id);
$user=mysql_fetch_array($result,MYSQL_ASSOC);

?>
<html>
<style type="text/css">
<!--
.textbak { background-color: #AFD1FF}
-->
</style>

<link rel="stylesheet" href="style.css">
<body bgcolor=#AFD1FF>
<form action="<?=$_SERVER[PHP_SELF];?>" method="POST"> 
 
<?php  
if(isset($_POST[savenewevent])){ 
   $timestamp = mktime(1, 1, 1, $_POST[neweventmonth], $_POST[neweventday], $_POST[neweventyear]); 
   @mysql_query("INSERT INTO kalender (id,eventrubr,eventtext,eventtime,user) VALUES (0,'$_POST[neweventrubrik]','$_POST[neweventtext]','$timestamp','{$_SESSION['sess_id']}')"); 
} 
if(isset($_GET[deleteevent])){ 
   @mysql_query("DELETE FROM kalender WHERE id='$_GET[deleteevent]' AND `user`='{$_SESSION['sess_id']}'"); 
} 
 
function getDayName($dayNr){ 
    $dayNames = array ( 
        'Söndag', 'Måndag', 'Tisdag', 'Onsdag', 
        'Torsdag', 'Fredag', 'Lördag'); 
    return $dayNames[$dayNr]; 
} 
 
function getMonthName($monthNr){ 
    $monthNames = array( 
        1 => 'Januari', 'Februari', 'Mars', 'April', 'Maj', 'Juni', 
        'Juli', 'Augusti', 'September', 'Oktober', 'November', 'December'); 
    return $monthNames[$monthNr]; 
} 

function makeDayLink($day,$month,$year){ 
   $timestamp = mktime(1,1,1,$month,$day,$year); 
   $eventQuery = @mysql_query("SELECT eventtime FROM kalender WHERE eventtime='$timestamp' AND `user`='{$id}'"); 
   $antal = mysql_num_rows($eventQuery); 
   if($antal > 0){ 
      $link = "<span class=textbak><a href=".$_SERVER[PHP_SELF]."?id=".$id."&showdayevent=".$timestamp.">".$day."</a></span>"; 
   }else{ 
      $link = "$day"; 
   } 
   return $link; 
} 
 

   $thismonth = getMonthName(date("n")); 
   $thisday = getDayName(date("w")); 
   $thisDate = date("d"); 
   $thisYear = date("Y"); 
?>
<table width=760 cellpadding=0 cellspacing=0>
<tr><td valign=top>

<table width=565 cellpadding=0 cellspacing=0>
<tr><td height=100% width=565 bgcolor=white class="boxh">&nbsp;<b>
<?
echo $user['user']."'s Träningsdagbok";
?>
</td></tr><tr><td class="box">
<?

   echo"<SELECT name='year' onChange='document.forms[0].submit();' class=field2>"; 
    
   $selectedYear = date("Y"); 
   if(!isset($_POST[year])){ 
      $_POST[year] = $selectedYear; 
   }else{ 
      $selectedYear = $_POST[year]; 
   } 
   if(isset($_GET[showdayevent])){ 
      $_POST[year] =  date("Y",$_GET[showdayevent]); 
      $selectedYear = date("Y",$_GET[showdayevent]); 
   } 
   for($i=$selectedYear-2;$i<=$selectedYear+4;$i++){ 
      if($selectedYear == $i){ 
         $sel = "SELECTED"; 
      }else{ 
         $sel = ""; 
      } 
      echo "<option value='$i' $sel>$i</option>"; 
   } 
   echo"</SELECT>&nbsp;&nbsp;"; 
   echo"<SELECT name='month' onChange='document.forms[0].submit();' class=field2>"; 
   $selectedMonth = date("n"); 
   if(!isset($_POST[month])){ 
      $_POST[month] = $selectedMonth; 
   }else{ 
      $selectedMonth = $_POST[month]; 
   } 
   if(isset($_GET[showdayevent])){ 
      $_POST[month] =  date("m",$_GET[showdayevent]); 
      $selectedMonth = date("m",$_GET[showdayevent]); 
   } 
   for($i=1;$i<=12;$i++){ 
      if($selectedMonth == $i){ 
         $sel = "SELECTED"; 
      }else{ 
         $sel = ""; 
      } 
      $selMonth = getMonthName($i); 
      echo "<option value='$i' $sel>$selMonth</option>"; 
   } 
   echo"</SELECT>"; 

   if(!isset($_GET[showdayevent])){ 
      $geteventtimestamp = mktime(1,1,1,date("m"),date("d"),date("Y")); 
   }else{ 
      $geteventtimestamp = $_GET[showdayevent]; 
   } 
    

   $daysInMonth = date("t",mktime(1,1,1,$_POST[month],1,$_POST[year])); 
   $firstDayNr = date("w",mktime(1,1,1,$_POST[month],1,$_POST[year])); 
   if($firstDayNr == 0){ 
      $firstDayNr = 7; 
   } 
   $firstDayNr-=2; 
   $dayNumberArray = array(); 
   for($i=0;$i<=$firstDayNr;$i++){ 
      $dayNumberArray[] = ""; 
   } 
   for($i=1;$i<=$daysInMonth;$i++){ 
      if($i <= 9){ 
         $dNr = "0$i"; 
      }else{ 
         $dNr = $i; 
      } 
      $dayNumberArray[] = $dNr; 
   } 

    
   echo"<center><table>"; 
   echo"<tr><td><b>Mån</b></td><td><b>Tis</b></td><td><b>Ons</b></td><td><b>Tor</b></td><td><b>Fre</b></td><td><b>Lör</b></td><td><b>Sön</b></td></tr>"; 
   for($i=0;$i<=sizeof($dayNumberArray);$i++){ 
      $a=$i;$b=$i+1;$c=$i+2;$d=$i+3;$e=$i+4;$f=$i+5;$g=$i+6; 
      $dayA = makeDayLink($dayNumberArray[$a],$_POST[month],$_POST[year]); 
      $dayB = makeDayLink($dayNumberArray[$b],$_POST[month],$_POST[year]); 
      $dayC = makeDayLink($dayNumberArray[$c],$_POST[month],$_POST[year]); 
      $dayD = makeDayLink($dayNumberArray[$d],$_POST[month],$_POST[year]); 
      $dayE = makeDayLink($dayNumberArray[$e],$_POST[month],$_POST[year]); 
      $dayF = makeDayLink($dayNumberArray[$f],$_POST[month],$_POST[year]); 
      $dayG = makeDayLink($dayNumberArray[$g],$_POST[month],$_POST[year]); 
      echo"<tr><td>$dayA</td><td>$dayB</td><td>$dayC</td><td>$dayD</td><td>$dayE</td><td>$dayF</td><td>$dayG</td></tr>"; 
      $i=$i+6; 
   } 
   echo"</table></center>"; 
   echo "</td></tr></table>";

?>
</td><td width=5></td><td valign=top>

<table width=190 cellpadding=0 cellspacing=0>
<tr><td height=100% width=190 class="boxh">&nbsp;<b>
<?
echo $thisday." ".$thisDate." ".$thismonth." ".$thisYear;
?>
</td></tr><tr><td class="box">
<?
if($owner)
echo "<a href=".$_SERVER[PHP_SELF]."?newevent=1&id=".$id.">Skriv i träningsdagboken</a>"; 
?>
</td></tr></table>

</td></tr></table>
<?

   $eventQuery = @mysql_query("SELECT id,eventrubr FROM kalender WHERE eventtime='$geteventtimestamp' AND `user`='{$id}'"); 
   $antal = mysql_num_rows($eventQuery); 
   if($antal < 1){ 
   }else{ 
      while($eventArray = mysql_fetch_array($eventQuery)){ 

$showevent=$eventArray[id];

if(isset($showevent)){ 
      $savedEventQuery = @mysql_query("SELECT * FROM kalender WHERE id='$showevent'"); 
      $savedEventArray = mysql_fetch_row($savedEventQuery); 
      $savedEventYear = date("Y",$savedEventArray[3]); 
      $savedEventMonth = getMonthName(date("n",$savedEventArray[3])); 
      $savedEventDay = getDayName(date("w",$savedEventArray[3])); 
      $savedEventDate = date("d",$savedEventArray[3]); 
      $savedEventText = nl2br($savedEventArray[2]); 
?>
<br>
<table width=760 cellpadding=0 cellspacing=0>
<tr><td valign=top>

<table width=565 cellpadding=0 cellspacing=0>
<tr><td height=100% width=565 bgcolor=white class="boxh">&nbsp;<b>
<?
echo $savedEventArray[1];
?>
</td></tr><tr><td class="box">
<?
      echo"$savedEventText<br><br>"; 
if($owner)
echo "<a href=$_SERVER[PHP_SELF]?deleteevent=".$savedEventArray[0].">&#187 Radera</a>"; 

      echo "</td></tr></table>";
   } 
      } 
   } //while eventarray

   if(isset($_GET[newevent])){ 
?>
<br>
<table width=760 cellpadding=0 cellspacing=0>
<tr><td valign=top>

<table width=565 cellpadding=0 cellspacing=0>
<tr><td height=100% width=565 bgcolor=white class="boxh">&nbsp;<b>
Lägg till ny händelse
</td></tr><tr><td class="box">
<?
      echo"<SELECT name='neweventyear' class='select1'>"; 
      $selectedYear = date("Y"); 
      for($i=$selectedYear-2;$i<=$selectedYear+4;$i++){ 
         if($selectedYear == $i){ 
            $sel = "SELECTED"; 
         }else{ 
            $sel = ""; 
         } 
         echo "<option value='$i' $sel>$i</option>"; 
      } 
      echo"</SELECT>&nbsp;&nbsp;"; 
      echo"<SELECT name='neweventmonth' class='select1'>"; 
      $selectedMonth = date("n"); 
      for($i=1;$i<=12;$i++){ 
         if($selectedMonth == $i){ 
            $sel = "SELECTED"; 
         }else{ 
            $sel = ""; 
         } 
         $selMonth = getMonthName($i); 
         echo "<option value='$i' $sel>$selMonth</option>"; 
      } 
      echo"</SELECT>&nbsp;&nbsp;"; 
      echo"<SELECT name='neweventday' class='select1'>"; 
      $selectedDay = date("j"); 
      for($i=1;$i<=31;$i++){ 
         if($selectedDay == $i){ 
            $sel = "SELECTED"; 
         }else{ 
            $sel = ""; 
         } 
         echo "<option value='$i' $sel>$i</option>"; 
      } 
      echo"</SELECT><br><br>"; 
      echo"Rubrik: <input type='text' name='neweventrubrik' size='30' class='field2'><br>"; 
      echo"Text: <textarea name='neweventtext' cols='25' rows='3' class='field2'></textarea><br><br>"; 
      echo"<input type='submit' name='savenewevent' value='Spara' class='field2'>"; 
      echo "</td></tr></table>";
   } //newevent
?> 
</form>
</body> 
</html>
265 ms totalt · 4 externa anrop · v20260731065814-full.a51de22e
122 ms — deklarationer (db)
0 ms — hämta statistik (cache)
138 ms — hämta tråd, inlägg och bilagor (db)
125 ms — ändringar (db)