PHP kode fungere ikke korrekt
<?// includes
include("../conf.php");
?><head>
<meta http-equiv="Content-Language" content="da" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
a:link {
color: white;
text-decoration:none;
}
a:visited {
color: white;
text-decoration:none;
}
.style1 {
border-width: 2px;
text-align: center;
background-color: #aef5ac;
}
.style2 {
border-width: 2px;
text-align: center;
}
.style4 {
border: 2px solid #0099FF;
}
.style8 {
text-align: center;
}
.style9 {
border: 2px solid #33CCFF;
background-color: #FF99CC;
}
.style10 {
border: 2px solid #33CCFF;
background-color: #66FF99;
}
.submenu{
margin-bottom: 0.5em;
}
.style13 {
border-width: 0;
}
.style14 {
border: 2px solid #000000;
}
</style>
<script type="text/javascript">
/***********************************************
* Switch Menu script- by Martial B of http://getElementById.com/
* Modified by Dynamic Drive for format & NS4/IE4 compatibility
* Visit http://www.dynamicdrive.com/ for full source code
***********************************************/
var persistmenu="yes" //"yes" or "no". Make sure each SPAN content contains an incrementing ID starting at 1 (id="sub1", id="sub2", etc)
var persisttype="sitewide" //enter "sitewide" for menu to persist across site, "local" for this page only
if (document.getElementById){ //DynamicDrive.com change
document.write('<style type="text/css">\n')
document.write('.submenu{display: none;}\n')
document.write('</style>\n')
}
function SwitchMenu(obj){
if(document.getElementById){
var el = document.getElementById(obj);
var ar = document.getElementById("masterdiv").getElementsByTagName("span"); //DynamicDrive.com change
if(el.style.display != "block"){ //DynamicDrive.com change
for (var i=0; i<ar.length; i++){
if (ar[i].className=="submenu") //DynamicDrive.com change
ar[i].style.display = "none";
}
el.style.display = "block";
}else{
el.style.display = "none";
}
}
}
function get_cookie(Name) {
var search = Name + "="
var returnvalue = "";
if (document.cookie.length > 0) {
offset = document.cookie.indexOf(search)
if (offset != -1) {
offset += search.length
end = document.cookie.indexOf(";", offset);
if (end == -1) end = document.cookie.length;
returnvalue=unescape(document.cookie.substring(offset, end))
}
}
return returnvalue;
}
function onloadfunction(){
if (persistmenu=="yes"){
var cookiename=(persisttype=="sitewide")? "switchmenu" : window.location.pathname
var cookievalue=get_cookie(cookiename)
if (cookievalue!="")
document.getElementById(cookievalue).style.display="block"
}
}
function savemenustate(){
var inc=1, blockid=""
while (document.getElementById("sub"+inc)){
if (document.getElementById("sub"+inc).style.display=="block"){
blockid="sub"+inc
break
}
inc++
}
var cookiename=(persisttype=="sitewide")? "switchmenu" : window.location.pathname
var cookievalue=(persisttype=="sitewide")? blockid+";path=/" : blockid
document.cookie=cookiename+"="+cookievalue
}
if (window.addEventListener)
window.addEventListener("load", onloadfunction, false)
else if (window.attachEvent)
window.attachEvent("onload", onloadfunction)
else if (document.getElementById)
window.onload=onloadfunction
if (persistmenu=="yes" && document.getElementById)
window.onunload=savemenustate
</script>
<!--
This file retrieved from the JS-Examples archives
http://www.js-examples.com
1000s of free ready to use scripts, tutorials, forums.
Author: JS-Examples - http://www.js-examples.com/
-->
<script type=text/javascript src="http://www.js-examples.com/bin/div_construct2.js"></script>
<script type=text/javascript>
var _banners = new Array();
function addBanner(_bannerHTML){
_banners[_banners.length?_banners.length:0]=_bannerHTML;
}
addBanner("<a href='http://www.js-examples.com/'><img border=0 alt='image 1' src='../../billeder/graa.jpg'></a>");
addBanner("<a href='http://www.js-examples.com/'><img border=0 alt='image 2' src='../../billeder/blaa.jpg'></a>");
addBanner("<a href='http://www.js-examples.com/'><img border=0 alt='image 3' src='../../billeder/gul.jpg'></a>");
addBanner("<a href='http://www.js-examples.com/'><img border=0 alt='image 4' src='../../billeder/groen.jpg'></a>");
addBanner("<a href='http://www.js-examples.com/'><img border=0 alt='image 5' src='../../billeder/roed.jpg'></a>");
addBanner("<a href='http://www.js-examples.com/'><img border=0 alt='image 6' src='../../billeder/sort.jpg'></a>");
var div2 = new NewDiv2(window, "banner", _banners[0],0,0,50,50,500,"ABSOLUTE");
var count=0; /* which one to start with */
function doIt() {
count++;
count%=_banners.length;
div2.setBody(_banners[count]);
}
setInterval('doIt()',1500);
</script>
</head>
<table style="width: 56%; height: 911px;" class="style14">
<tr>
<td rowspan="2" style="width: 215px" valign="top" class="style14">
<p><img src="../../billeder/logo.jpg" width="160" height="160"></p>
<!-- Keep all menus within masterdiv-->
<div id="masterdiv" align="center">
<a href="../../index.php">
<img src="../../billeder/forside.jpg" class="style13"></a><br>
<a href="../../bestyrelsen.php">
<img src="../../billeder/bestyrelsen.jpg" class="style13"></a><br>
<a href="../../historie.php">
<img src="../../billeder/historie.jpg" class="style13"></a><br>
<img src="../../billeder/blivmedlem.jpg" onClick="SwitchMenu('sub1')"><br>
<span class="submenu" id="sub1">
<a href="../../blivmedlemgymnastik.php"><img src="../../billeder/gymnastik.jpg" class="style13"></a><br>
<a href="../../blivmedlemhaandbold.php"><img src="../../billeder/haandbold.jpg" class="style13"></a><br>
</span>
<img src="../../billeder/hold.jpg" onClick="SwitchMenu('sub2')"><br>
<span class="submenu" id="sub2">
<a href="../../gymnastikhold.php"><img src="../../billeder/gymnastik.jpg" class="style13"></a><br>
<a href="../../haandboldhold.php"><img src="../../billeder/haandbold.jpg" class="style13"></a><br>
</span>
<img src="../../billeder/traenere.jpg" onClick="SwitchMenu('sub3')"><br>
<span class="submenu" id="sub3">
<a href="../../index.php"><img src="../../billeder/tomknap.jpg" class="style13"></a><br>
<a href="../../index.php"><img src="../../billeder/tomknap.jpg" class="style13"></a><br>
<a href="../../index.php"><img src="../../billeder/tomknap.jpg" class="style13"></a><br>
</span>
<span>
<a href="../../kampprogram.php">
<img src="../../billeder/kampprogram.jpg" class="style13"></a><br>
<a href="../../hjaelpos.php">
<img src="../../billeder/hjaelpos.jpg" class="style13"></a><br>
<a href="../../links.php">
<img src="../../billeder/links.jpg" class="style13"></a><br>
<a href="mailto:nicer@post.cybercity.dk">
<img src="../../billeder/mail.jpg" class="style13"></a><br>
<img src="../../billeder/billedalbum.jpg" class="style13"><br>
<img src="../../billeder/debatforum.jpg" class="style13"><br></span>
<br><br>
<span> <a href="../../admin/main.php">
<img src="../../billeder/admin.jpg" class="style13"></a><br>
</span>
</div></td>
<td style="height: 60px" valign="top" class="style14">
<script type=text/javascript>
div2.output();
</script>
</td>
</tr>
<tr>
<td style="height: 633px" valign="top" class="style14">
<p><font size="30"><img src="../../billeder/banner.jpg" width="600" height="100" /></font></p>
<table style="width: 100%; height: 777px;" class="style4">
<tr>
<td class="style1" style="height: 4%; width: 100%;"><font size="5">
<strong>
Rediger Kamp:</strong></font></td>
</tr>
<tr>
<td valign="top" class="style2" style="width: 146%">
<center style="width: 100%">
<?
$id = $_GET['id'];
if (!$submit)
{
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
$query = "SELECT hold, modstander, tunering, dato, tid, sted FROM kampprogram WHERE id = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if (mysql_num_rows($result) > 0)
{
$row = mysql_fetch_object($result);
?>
<table cellspacing="5" cellpadding="5" border="1">
<form action="<? echo $PHP_SELF; ?>" method="POST">
<input type="hidden" name="id" value="<? echo $id; ?>">
<tr>
<td valign="top"><font size="4" color="#000000">Hold:</font></td>
<td><input size="50" maxlength="250" type="text" name="hold" value="<? echo $row->hold; ?>"></td>
</tr>
<tr>
<td valign="top"><font size="4" color="#000000">Modstander:</font></td>
<td><input size="50" maxlength="250" type="text" name="modstander" value="<? echo $row->modstander; ?>"></td>
</tr>
<tr>
<td valign="top"><font size="4" color="#000000">Tunering:</font></td>
<td><input size="50" maxlength="250" type="text" name="tunering" value="<? echo $row->tunering; ?>"></td>
</tr>
<tr>
<td valign="top"><font size="4" color="#000000">Dato:</font></td>
<td><input size="50" maxlength="250" type="text" name="dato" value="<? echo $row->dato; ?>"></td>
</tr>
<tr>
<td valign="top"><font size="4" color="#000000">Tid:</font></td>
<td><input size="50" maxlength="250" type="text" name="tid" value="<? echo $row->tid; ?>"></td>
</tr>
<tr>
<td valign="top"><font size="4" color="#000000">Sted:</font></td>
<td><input size="50" maxlength="250" type="text" name="sted" value="<? echo $row->sted; ?>"></td>
</tr>
<tr>
<td colspan=2 align="center"><input type="Submit" name="submit" value="Opdater"></td>
</tr>
</form>
</table>
<?
}
else
{
$errorList = array();
$count = 0;
if (sizeof($errorList) == 0)
{
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
$query = "UPDATE kampprogram SET hold = '$hold', modstander = '$modstander', tunering = '$tunering', dato = '$dato', tid = '$tid', sted = '$sted' WHERE id = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
echo "<font size='4' color='#000000'>Linket er opdateret.</font> <br><br><a href=list.php><font size='4' color='#000000'>Tryk her for at komme tilbage til listen over links</font></a>.";
}
else
{
echo "<font size=-1>Følgende fejl opstod under behandlingen: <br>";
echo "<ul>";
for ($x=0; $x<sizeof($errorList); $x++)
{
echo "<li>$errorList[$x]";
}
echo "</ul></font>";
}
}
}
?>
</center>
</td>
</tr>
</table>
<table style="width: 100%" class="style9">
<tr>
<td class="style8"><font face="Arial" color="#000000" size="2">Se alle
seneste resultater samt tid og sted for kommende kampe under <a href="../../kampprogram.php">kampprogram</a></font></td>
</tr>
</table>
<table style="width: 100%" class="style10">
<tr>
<td class="style8"><font face="Arial" size="2">Yderligere oplysninger om
indmeldelse, træningstider, kontingent m.m.: <br />
<navn>, tlf.?? ?? ?? ?? - e-mail: ???@???.dk.</font></td>
</tr>
</table>
</td>
</tr>
</table>
Koden vil fint hente oplysingerne til felterne så jeg kan redigere, men når jeg trykker på opdater sletter den bare info som allerede ligger i MySQL databasen :/ Hvorfor er det lige den ikke får ændringerne med?? Jeg har lige rykket siden fra et webhotel hvor det virkede perfekt, men nu virker det her "admin" script ikke længere :/ hvorfor??
