Hjælp til udskiftning af emailadresse til en anden adresse
Jeg er gået i stå vedr. opsætning til at hvordan man kan udskifte ekst. emailadresse til en anden i admin.På forsiden som vises på nettet ser koden således ud.
<?php require_once('Connections/cms.php'); ?>
<?php
$colname_rsSideindhold = "1";
if (isset($_GET['id'])) {
$colname_rsSideindhold = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsSideindhold = sprintf("SELECT * FROM sideindhold WHERE id = %s ORDER BY id DESC", $colname_rsSideindhold);
$rsSideindhold = mysql_query($query_rsSideindhold, $cms) or die(mysql_error());
$row_rsSideindhold = mysql_fetch_assoc($rsSideindhold);
$totalRows_rsSideindhold = mysql_num_rows($rsSideindhold);
$colname_rsSubmenu = "1";
if (isset($_GET['mainid'])) {
$colname_rsSubmenu = (get_magic_quotes_gpc()) ? $_GET['mainid'] : addslashes($_GET['mainid']);
}
mysql_select_db($database_cms, $cms);
$query_rsSubmenu = sprintf("SELECT * FROM sideindhold WHERE mainid = %s", $colname_rsSubmenu);
$rsSubmenu = mysql_query($query_rsSubmenu, $cms) or die(mysql_error());
$row_rsSubmenu = mysql_fetch_assoc($rsSubmenu);
$totalRows_rsSubmenu = mysql_num_rows($rsSubmenu);
$colname_rsEmail = "1";
if (isset($_GET['id'])) {
$colname_rsEmail = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsEmail = sprintf("SELECT * FROM email WHERE id = %s", $colname_rsEmail);
$rsEmail = mysql_query($query_rsEmail, $cms) or die(mysql_error());
$row_rsEmail = mysql_fetch_assoc($rsEmail);
$totalRows_rsEmail = mysql_num_rows($rsEmail);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>CMS siden</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="layout">
<tr>
<td class="top"> </td>
<td class="top"> </td>
</tr>
<tr>
<td class="top1"> </td>
<td class="top1">| <a href="index.php?id=1&mainid=1">Topmenu 1</a> | <a href="index.php?id=2&mainid=2">Topmenu 2</a> | <a href="index.php?id=3&mainid=3">Topmenu 3</a> | <a href="index.php?id=4&mainid=4">Topmenu 4</a> | <a href="index.php?id=5&mainid=5">Topmenu 5</a> | </td>
</tr>
<tr>
<td class="left"><p> </p>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td><div align="center"><a href="index.php?id=<?php echo $row_rsSubmenu['id']; ?>&mainid=<?php echo $row_rsSubmenu['mainid']; ?>"><?php echo $row_rsSubmenu['navn']; ?></a></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu = mysql_fetch_assoc($rsSubmenu)); ?>
<p> </p></td>
<td class="middle"><form name="form1" method="get" action="resultat.php">
<table width="200" border="0" align="right" cellpadding="2" cellspacing="0">
<tr>
<td><input name="search" type="text" id="search"></td>
<td><input name="søg" type="submit" id="søg" value="Søg"></td>
</tr>
</table>
</form> <p> </p>
<table width="90%" border="0" cellpadding="5">
<tr>
<td><h1><?php echo $row_rsSideindhold['overskrift']; ?></h1></td>
</tr>
<tr>
<td><?php echo $row_rsSideindhold['tekst1']; ?></td>
</tr>
<tr>
<td><?php
if ($row_rsSideindhold['billede']) {
echo '<img src="billeder/'.$row_rsSideindhold['billede'].'">';}?></td>
</tr>
<tr>
<td><?php echo $row_rsSideindhold['tekst2']; ?></td>
</tr>
</table> <p>
</p>
<form action="" method="post" name="email" id="email">
<table width="200" border="0" cellpadding="3">
<tr>
<td><td><a href="mailto:<?php echo $row_rsEmail['email']; ?>"><?php echo $row_rsEmail['email']; ?></a></td>
</tr>
</table>
</form>
<p> </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsSideindhold);
mysql_free_result($rsSubmenu);
mysql_free_result($rsEmail);
?>
=================================================================
I admin har jeg oprettet en fil med navn email.php
Koden for denne side ser således ud.
<?php require_once('../Connections/cms.php'); ?>
<?php
$colname_rsEmail = "1";
if (isset($_GET['id'])) {
$colname_rsEmail = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsEmail = sprintf("SELECT * FROM email WHERE id = %s", $colname_rsEmail);
$rsEmail = mysql_query($query_rsEmail, $cms) or die(mysql_error());
$row_rsEmail = mysql_fetch_assoc($rsEmail);
$totalRows_rsEmail = mysql_num_rows($rsEmail);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>email</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"> </td>
</tr>
<tr>
<td class="left"> </td>
<td class="middle"><p> </p>
<form action="" method="post" name="email" id="email">
<table width="350" border="0" cellpadding="3">
<tr>
<td width="156"><div align="right">Gammel email: </div></td>
<td width="176"><input name="gammel email" type="text" id="gammel email" size="30"></td>
</tr>
<tr>
<td><div align="right">Ny email: </div></td>
<td><input name="ny email" type="text" id="ny email" size="30"></td>
</tr>
<tr>
<td><div align="right">Gentag email: </div></td>
<td><input name="gentag email" type="text" id="gentag email" size="30"></td>
</tr>
<tr>
<td> </td>
<td><input name="udfør" type="submit" id="udfør" value="Udfør"></td>
</tr>
<tr>
<td><input type="hidden" name="id" value="<?php echo $colname_rs_update ?>"></td>
<td> </td>
</tr>
</table>
</form> <p> </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsEmail);
?>
=================================================================
Så er herfra jeg gerne vil kunne videre med at få det til at virke.