Session i Dreamweaver i PHP fra MySQL-database
Hej..Jeg har en php side, som jeg har lavet ud fra en "Lav dit eget CMS-system"-bog. Jeg har lært at connecte til min MySql database samt lave log in. Men den log in jeg har lavet er til administratorsystemet. Nu vil jeg lave log-in til brugerne eller de besøgende på sitet.
Hvordan beholder jeg en brugers id, fra når de har logget ind på loginsiden? Det gør den ikke nu, og når man så vil se sin profil el. rette i sin egen profil - så kommer men kun til "ID0001" - altså den første, og det går ikke.
Min loginside ser sådan ud i koderne:
<?php require_once('../Connections/tvduno.php'); ?>
<?php
// *** Validate request to login to this site.
session_start();
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($accesscheck)) {
$GLOBALS['PrevUrl'] = $accesscheck;
session_register('PrevUrl');
}
if (isset($_POST['brugernavn'])) {
$loginUsername=$_POST['brugernavn'];
$password=$_POST['password'];
$MM_fldUserAuthorization = "status";
$MM_redirectLoginSuccess = "index.php?brugerid=";
$MM_redirectLoginFailed = "login_fejl.php";
$MM_redirecttoReferrer = false;
mysql_select_db($database_tvduno, $tvduno);
$LoginRS__query=sprintf("SELECT brugernavn, password, status, brugerid FROM fan_brugere WHERE brugernavn='%s' AND password='%s'",
get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password));
$LoginRS = mysql_query($LoginRS__query, $tvduno) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {
$loginStrGroup = mysql_result($LoginRS,0,'status');
//declare two session variables and assign them
$GLOBALS['MM_Username'] = $loginUsername;
$GLOBALS['MM_UserGroup'] = $loginStrGroup;
//register the session variables
session_register("MM_Username");
session_register("MM_UserGroup");
if (isset($_SESSION['PrevUrl']) && false) {
$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
}
header("Location: " . $MM_redirectLoginSuccess )+session_register("MM_Username");
}
else {
header("Location: ". $MM_redirectLoginFailed );
}
}
?>
<?php require_once('../Connections/tvduno.php'); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>DUNO.dk | Vi er på, når du er på...</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">
<!--
.style3 {color: #CCCCCC}
.soegeform {PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 12px; PADDING-BOTTOM: 0px; VERTICAL-ALIGN: baseline; COLOR: #333; PADDING-TOP: 0px; FONT-FAMILY: Arial, Helvetica, sans-serif; HEIGHT: 17px
}
.style11 {color: #FFFFFF}
.style12 {font-family: Verdana;
color: #FF6633;
font-weight: bold;
}
.style13 {color: #FFCC66}
.style15 { color: #FFCC66;
font-family: Verdana;
font-weight: bold;
}
.style16 {
font-family: Verdana;
font-weight: bold;
font-size: 11px;
}
.style5 {color: #FFCC66; font-weight: bold; }
.style6 {font-size: 10px}
.style17 {font-family: Verdana}
.style18 {font-family: Verdana; font-size: 11px; }
.style19 {font-size: 11px}
-->
</style>
</head>
<body bgproperties="fixed">
<TABLE cellSpacing=0 cellPadding=0 width=796 align=center border=0 vspace="0"
hspace="0">
<TBODY>
<TR>
<TD width="796" height="70" align=right vAlign=center>
<div align="center">
<table width="100%" height="70" border="0" cellpadding="0" cellspacing="2">
<tr>
<td background="../grafik/site_top.gif"><div align="right">
<table width="790" height="60" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="379"><a href="http://www.duno.dk/"><img src="../grafik/usynlig.gif" width="380" height="60" border="0"></a></td>
<td width="411"><div align="right"></div></td>
</tr>
</table>
</div>
<div align="left"></div></td>
</tr>
</table>
</div></TD>
</TR>
<TR height=35>
<TD><table width="200" border="0" align="center" cellpadding="0" cellspacing="2" class="menu">
<tr align="center" valign="middle">
<td width="20%" class="menu1"><div align="center"><strong><a href="../nyheder/index.php?mainid=1">NYHEDER</a></strong></div></td>
<td width="20%" class="menu2"><div align="center"><strong><a href="../video/index.php">INTERNET-TV</a></strong></div></td>
<td width="20%" class="menu3"><div align="center"><strong><a href="../mobil/index.php">MOBIL</a></strong></div></td>
<td width="20%" class="menu4"><div align="center"><strong><a href="../services/index.php">SERVICES</a></strong></div></td>
<td width="20%" class="menu5"><div align="center"><strong><a href="../duno/index.php">DUNO</a> </strong></div></td>
</tr>
</table></TD>
</TR>
<TR>
<TD>
<TABLE width=100% border=0 align="center" cellPadding=0 cellSpacing=2 class=soegeform>
<TR>
<TD width=163 valign="top"> <br>
<TABLE cellSpacing=0 cellPadding=0 width=130 border=0>
<TBODY>
<TR>
<TD width="130"
height=24
background="../grafik/left_menu_top_red.gif" class=menu_venstre_overskrift><div align="center" class="style13"><strong>MOBIL</strong></div></TD>
</TR>
<TR>
<TD
height=24 bgcolor="#e5e5e5" class=menu_venstre_overskrift><table border="0" cellpadding="2" cellspacing="2">
<tr>
<td><IMG
src="../grafik/prik_red.gif" name=n11 width="10" height="11" border=0
align=absMiddle id=n1><IMG height=1
src="../grafik/usynlig.gif"
width=1 align=absMiddle></td>
<td><a href="../mobil/billeder.php">Billeder</a></td>
</tr>
<tr>
<td><IMG
src="../grafik/prik_red.gif" name=n11 width="10" height="11" border=0
align=absMiddle id=n1></td>
<td><a href="../mobil/konkurrence.php">Konkurrence</a></td>
</tr>
<tr>
<td><IMG
src="../grafik/prik_red.gif" name=n11 width="10" height="11" border=0
align=absMiddle id=n1></td>
<td><a href="../mobil/smsnews.php">Nyheds-SMS</a></td>
</tr>
</table></TD>
</TR>
<TR>
<TD class=menu_venstre_overskrift
height=7><IMG height=7
src="../grafik/left_bund.gif"
width=100%></TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=135 border=0>
<TBODY>
<TR>
<TD class=menu_venstre_menupunkt vAlign=top align=middle> <BR>
<DIV></DIV></TD>
</TR>
<TR>
<TD>
<DIV align=center></DIV></TD>
</TR>
</TBODY>
</TABLE></TD>
<TD width="492" valign="top"><div align="right"> </div>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../grafik/midten_ramme_top.gif" width="100%" height="10"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><TABLE cellSpacing=0 cellPadding=0 width=100% align=center
border=0>
<TBODY>
<TR>
<TD vAlign=center align=right width=15><IMG height=24
src="../grafik/ende_blue_left.gif"
width=10></TD>
<TD bgColor=#666699 class=midten_sektion_overskrift><span class="style15">DUNO FAN </span></TD>
<TD vAlign=center align=left width=15><IMG height=24
src="../grafik/ende_blue_right.gif"
width=10></TD>
</TR>
</TBODY>
</TABLE>
<table width="100%" border="0" cellspacing="4" cellpadding="0">
<tr>
<td><br>
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td><h1>Log In: </h1></td>
</tr>
<tr>
<td><form ACTION="<?php echo $loginFormAction; ?>" method="POST" name="login" id="login">
<table width="400" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td colspan="2"><div align="center"><strong>Indtast brugernavn og adgangskode </strong></div></td>
</tr>
<tr>
<td width="50%">Brugernavn:</td>
<td width="50%"><input name="brugernavn" type="text" id="brugernavn" size="40"></td>
</tr>
<tr>
<td width="50%">Adgangskode:</td>
<td width="50%"><input name="password" type="password" id="password" size="40"></td>
</tr>
<tr>
<td width="50%"> </td>
<td width="50%"><input type="submit" name="Submit" value="Log på"></td>
</tr>
</table>
</form></td>
</tr>
</table>
<div align="center"><br>
</div></td>
</tr>
</table> <br>
<div align="center"></div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><img height=1
src="../grafik/usynlig.gif"
width=1> </td>
</tr>
<tr>
<td><img src="../grafik/midten_ramme_bund.gif" height="30"></td>
</tr>
</table>
<div align="center"> <IMG height=1
src="../grafik/usynlig.gif"
width=1> </div></TD>
<TD width="144" valign="top">
<div align="center" class="style5"> </div>
<br>
<table width="130" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td><TABLE width=130 border=0 align="right" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width=118 height="24" background="../grafik/left_menu_top_red.gif" class="style5">
<div align="center">DAGEN I DAG </div></TD>
</TR>
<TR>
<TD bgcolor="#e5e5e5"><div align="center" class="style12">
<script language="JavaScript">
<!-- start
Stamp = new Date();
var months=new Array(13);
months[1]="januar";
months[2]="februar";
months[3]="marts";
months[4]="april";
months[5]="maj";
months[6]="juni";
months[7]="juli";
months[8]="august";
months[9]="september";
months[10]="oktober";
months[11]="november";
months[12]="december";
var time=new Date();
var lmonth=months[time.getMonth() + 1];
var date=time.getDate();
var year=time.getFullYear();
document.write(date + ". " + lmonth + " " + year + '<br>');
var Hours;
var Mins;
var Time;
Hours = Stamp.getHours();
if (Hours >= 24) {
Time = "";
}
else {
Time = "";
}
if (Hours > 24) {
Hours -= 24;
}
if (Hours == 0) {
Hours = 24;
}
Mins = Stamp.getMinutes();
if (Mins < 10) {
Mins = "0" + Mins;
}
document.write(Hours + ":" + Mins + Time);
// End -->
</script>
</div>
</TR>
<TR>
<TD align=middle vAlign=top><span class="style11"><IMG height=7
src="../grafik/left_bund.gif"
width=100%></span></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><TABLE width=130 border=0 align="right" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width=118 height="24" background="../grafik/left_menu_top_red.gif" class="style5">
<div align="center">DUNO SpeakeR </div></TD>
</TR>
<TR>
<TD bgcolor="#e5e5e5"><div align="center"><span class="style5"><a href="../services/speaker/index.php"><img src="../grafik/speaker_spot.gif" width="130" height="36" border="0"></a> </span> </div>
</TR>
<TR>
<TD align=middle vAlign=top><span class="style11"><IMG height=7
src="../grafik/left_bund.gif"
width=100%></span></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
</table>
<P> </P></TD>
</TR>
</TABLE></TD>
</TR>
<TR height=31 >
<TD height=13 >
<DIV class=bottom_disclaimer align=center><SPAN class=bottom_adress style13>2001-2007 © DUNO.dk - All Rights Reserved</SPAN></DIV></TD>
</TR>
</TBODY>
</TABLE>
</body>
</html>
<?php
mysql_free_result($rsSideindhold);
?>