Nogen her som kan se fejlen i linje 13 er fremhævet, hvor jeg får en fejlkode.
<?php require_once('../Connections/cms.php'); ?>
<?php
//finder brugeren
$colname_rs_update = "-1";
if (isset($_GET['id'])) {
$colname_rs_update = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rs_update = sprintf("SELECT * FROM brugere WHERE id = '%s'", $colname_rs_update);
$rs_update = mysql_query($query_rs_update, $cms) or die(mysql_error());
$row_rs_update = mysql_fetch_assoc($rs_update);
$totalRows_rs_update = mysql_num_rows($rs_update);
}
//her ckekkes det gamle pw mod db, desuden sammenlignes de to indtastninger af det nye
if (isset($_POST['id']) { if($_POST['gammel_password']==$row_rs_update['adgangskode'] && $_POST['nyt_password']==$_POST['gentag_password']) {
$updateSQL = sprintf("UPDATE brugere SET ´adgangskode´=%s WHERE id=%s", $_POST['nyt_password'], $_POST['id']);
mysql_select_db($database_conn_cms, $conn_cms);
$Result1 = mysql_query($updateSQL, $conn_cms) or die(mysql_error());
$result="Koden er ændret";
}
else $result="Der er en fejl i dine indtasninger, prøv igen";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Ændring af password</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../css/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {
color: #666666;
font-weight: bold;
font-size: 12px;
}
-->
</style>
</head>
<body>
<table width="100%" border="0" class="layout">
<tr>
<td colspan="2" class="top style1">Administrationsområde</td>
</tr>
<tr>
<td class="top1"> </td>
<td class="top1"><?php echo $result; ?></td>
</tr>
<tr>
<td class="left"> </td>
<td class="middle"><p> </p> <form action="" method="post" name="code" id="code">
<table width="550" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="115">Brugernavn:</td>
<td width="147"><input name="brugernavn" type="text" id="brugernavn" size="25" value="<?php echo $row_rs_update['brugernavn'] ?>"></td>
<td width="131">Gammel password: </td>
<td width="133"><input name="gammel_password" type="password" id="gammel password" size="25"></td>
</tr>
<tr>
<td>Nyt password: </td>
<td><input name="nyt_password" type="password" id="nyt password" size="25"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Gentag password: </td>
<td><input name="gentag_password" type="password" id="gentag password" size="25"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input name="udfør" type="submit" id="udfør" value="Udfør"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="hidden" name="id" value="<?php echo $_GET['id'] ?>"> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form> <p> </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rs_update);
?>