Bruger login system med brugens ejen side

sådan ser mysql tabelen ud
`id` int(11) NOT NULL auto_increment,
  `firma` varchar(100) NOT NULL default '',
  `senr` varchar(10) NOT NULL default '',
  `navn` varchar(100) NOT NULL default '',
  `adresse` text NOT NULL,
  `sted` text NOT NULL,
  `postnr` text NOT NULL,
  `city` text NOT NULL,
  `url` varchar(255) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `tlfnr` varchar(100) NOT NULL default '',
  `apass` varchar(10) NOT NULL default '',
  `bruger` varchar(10) NOT NULL default '',
  `accept` char(1) NOT NULL default '',

Hvis du smider din formular her, så skal jeg hjælpe dig.

<HTML>
<HEAD>
    <TITLE>opret1</TITLE>

<link rel="stylesheet" type="text/css" href="file:///C|/Documents%20and%20Settings/Lynide/Skrivebord/multi/default.css">



<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></HEAD>
<BODY BGCOLOR="#333333" text="FF6600" link="F76B08" alink="#FF6633" vlink="#FF6633" background="http://www.cynide-lynide.dk/images/side_bg2.gif" bgproperties="fixed">

<center>
<table border="0" width=600 cellpadding=0 cellspacing=0>




<tr>
      <td colspan=5 align=left BGCOLOR="#333333" border="2"><div align="center"><img src="http://www.cynide-lynide.dk/images/titles/banner.jpg" width="393" height="63"></div></td></tr>


<tr><td colspan=5><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td></tr>


<tr>
      <td valign=top colspan=5>
        <!--- menu starts here --->
        <div align="center">
          <table border=0 cellpadding=1 cellspacing=1 bgcolor="666666" width=600>
            <tr>
              <td> <table border=0 cellpadding=1 cellspacing=0 bgcolor="333333" width=600>
                  <tr>
                    <td><a href="file:///C|/Documents%20and%20Settings/Lynide/Skrivebord/multi/index.html">Index</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="file:///C|/Documents%20and%20Settings/Lynide/Skrivebord/multi/page.html">Info</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Opret Bruger</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Login</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Vilkår</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Option 6</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Option 7</a></td>
                  </tr>
                </table></td>
            </tr>
          </table>
        </div></td></tr>

<!--- menu ends here --->
<tr><td><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td></tr>

<tr>

<td bgcolor="333333" valign=top colspan=3>


<!--- left column --->

<table border=0 cellpadding=5 cellspacing=0 width=600>
<tr>
            <td><script language="JavaScript">
function formCheck() {
    if (document.post.navn.value == "") {
      alert("Du skal skrive dit navn");
      document.post.navn.focus();
      return false
    }
      if (document.post.adresse.value == "") {
      alert("Du skal skrive din adresse");
      document.post.adresse.focus();
      return false;
    }
      if (document.post.postnr.value == "") {
      alert("Du skal skrive dit postnr.");
      document.post.postnr.focus();
      return false;
    }
              if (document.post.city.value == "") {
      alert("Du skal skrive hvilken by.");
      document.post.city.focus();
      return false;
    }
      if (document.post.tlfnr.value == "") {
      alert("Du skal skrive dit Tlfnr.");
      document.post.tlfnr.focus();
      return false;
    }
    if (document.post.email.value == "") {
      alert("Du skal skrive din email");
      document.post.email.focus();
      return false;
    }
      if (document.post.bruger.value == "") {
      alert("Du skal skrive et brugernavn");
      document.post.bruger.focus();
      return false;
    }
    if (document.post.apass.value == "") {
      alert("Du skal skrive et kodeord");
      document.post.apass.focus();
      return false;
    }
  if (document.post. accept .value == "") {
      alert("Du skal accepter vores kundevilkår");
      document.post. accept .focus();
      return false;
    }
   
       
}
</script> Opret Annoc&oslash;r Bruger:
              <P><form method="post" action="opret1.php" name="post" onsubmit="return formCheck()">Alt der er markeret med * skal udfyldes

<table>
<tr>
                    <td width="200"><font face="arial" size="2"> Firma Navn:</font></font></td>
<td width="300" align="left"><input TYPE="text" size="30" name="firma"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2"> SE-nr.: </font></font></td>
<td width="300" align="left"><input TYPE="text" size="30" name="senr"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2">* Navn:</font></td>
<td width="300" align="left"><input TYPE="text" size="30" name="navn"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2">* Adresse:</font></td>
<td width="300" align="left"><input TYPE="text" size="50" name="adresse"></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Sted:</font></td>
<td width="300" align="left"><input TYPE="text" size="30" name="sted"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2">* Postnr.:</font></td>
<td width="300" align="left"><input TYPE="text" size="5" name="postnr"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2">* By:</font></td>
<td width="300" align="left"><input TYPE="text" size="30"  name="city"></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Hjemmeside:</font></td>
<td width="300" align="left"><input TYPE="text" size="30"  name="url"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">* Telefonnr.:</font></td>
<td width="300" align="left"><input type="text" size="15" name="tlfnr">
                    </td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">* Email:</font></td>
                    <td width="300" align="left"><input type="text" size="30" name="email"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2">*Bruger Navn:</font></td>
<td width="300" align="left"><input TYPE="text" size="15" name="bruger"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2">* Ønsket password:</font></td>
<td width="300" align="left"><input TYPE="password" size="30" name="apass"></td>
</tr>
</table>
              <p>
                <br>
                <input value="accept"  name="accept" accept="yes"type="checkbox" >
                Accepter vores kundevilkår <a href="">Læs vores kundevilkår her</a>
              </p>
              <p>&nbsp;</p>
                <P><font face="arial" size="2"><b> </b></font><br>
               
                <p></p>
               
              <div align="center"><table width="100%" border="0">
  <tr>
    <td><div align="center"> <font face="arial" size="2"><b>Klik p&aring; &quot;Annuller&quot;
                          for at annullere din indtastning.</b></font> <br>
                          <input  type="reset" value="Annuller">
                        </div></td>
    <td><div align="center">
                       
                          <p><font face="arial" size="2"><b>Klik p&aring; &quot;Tilmeld&quot;
                            n&aring;r du har udfyldt formularen.</b></font> <br>
                          <input type="submit" name="send" value="Opret">
                        </div></td>
  </tr>
</table><?
if($send){
include ("./config.php");
mysql_connect($host,$user,$pass);
mysql_select_db($db);
$query = mysql_query("INSERT INTO Annocor (firma, senr, navn, adresse, sted, postnr, city, url, email,tlfnr,apass, bruger,accept)" . "VALUES ('$firma', '$senr', '$navn', '$adresse', '$sted', '$postnr', '$city', '$url', '$email','$tlfnr','$apass', '$bruger','$accept')");
echo "Du er nu oprettet<br><a href=\"./ret.php\">Log ind</a>";
}
?>

               
                </div>
              <hr>

<P></form>
<a href="http://www.e-banner.dk">Opret Banner Bruger:</a>
<BR>




</td>

<td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>



<!--- end left column --->




<td bgcolor="333333" valign=top width=150>

<!--- right column --->


<table border=0 cellpadding=5 cellspacing=0><tr><td>
<P><BR><P><BR>
<table border=0 cellpadding=0 cellspacing=0>
<tr>
                        <td valign=top>&nbsp; </td>
                      </tr>

<tr>
                        <td valign=top bgcolor="">&nbsp;</td>
                      </tr></table>
<p>
<!--- low right column - ads --->


<table border=0 cellpadding=5 cellspacing=0><tr><td>

<img src="http://www.cynide-lynide.dk/images/ad1.gif" width=143><br>
<img src="http://www.cynide-lynide.dk/images/space.gif" height=8><br>
<img src="http://www.cynide-lynide.dk/images/ad2.gif" width=143><br>
<img src="http://www.cynide-lynide.dk/images/space.gif" height=8><br>


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








</td></tr></table>
</td>
<!--- end right column --->

</tr>
</table>



<tr><td><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td></tr>



<tr><td align=center><p>&nbsp;</p></td></tr>



</table>


</center>
</BODY>
</HTML>
----------------------------------------------------------------------------<HTML>
<HEAD>
    <TITLE>opret1</TITLE>

<link rel="stylesheet" type="text/css" href="file:///C|/Documents%20and%20Settings/Lynide/Skrivebord/multi/default.css">



<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></HEAD>
<BODY BGCOLOR="#333333" text="FF6600" link="F76B08" alink="#FF6633" vlink="#FF6633" background="http://www.cynide-lynide.dk/images/side_bg2.gif" bgproperties="fixed">

<center>
<table border="0" width=600 cellpadding=0 cellspacing=0>




<tr>
      <td colspan=5 align=left BGCOLOR="#333333" border="2"><div align="center"><img src="http://www.cynide-lynide.dk/images/titles/banner.jpg" width="393" height="63"></div></td></tr>


<tr><td colspan=5><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td></tr>


<tr>
      <td valign=top colspan=5>
        <!--- menu starts here --->
        <div align="center">
          <table border=0 cellpadding=1 cellspacing=1 bgcolor="666666" width=600>
            <tr>
              <td> <table border=0 cellpadding=1 cellspacing=0 bgcolor="333333" width=600>
                  <tr>
                    <td><a href="file:///C|/Documents%20and%20Settings/Lynide/Skrivebord/multi/index.html">Index</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="file:///C|/Documents%20and%20Settings/Lynide/Skrivebord/multi/page.html">Info</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Opret Bruger</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Login</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Vilkår</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Option 6</a></td>
                    <td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
                    <td><a href="#">Option 7</a></td>
                  </tr>
                </table></td>
            </tr>
          </table>
        </div></td></tr>

<!--- menu ends here --->
<tr><td><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td></tr>

<tr>

<td bgcolor="333333" valign=top colspan=3>


<!--- left column --->

<table border=0 cellpadding=5 cellspacing=0 width=600><?
// Tjek om brugeren er logget ind
if ($s_bruger && $s_apass) {
?>
<?
include ("config.php");
mysql_connect($host,$user,$pass);
mysql_select_db($db);
$query = mysql_query("SELECT * FROM Annocor WHERE bruger='$s_bruger' AND apass='$s_apass'") or print mysql_error();
while($r = mysql_fetch_array($query)) {
$id = $r["id"];
$navn = $r["navn"];
$apass = $r["apass"];
$email = $r["email"];
$firma = $r["firma"];
$url = $r["url"];
$bruger = $r["bruger"];
$senr = $r["senr"];
$adresse = $r["adresse"];
$sted = $r["sted"];
$postnr = $r["postnr"];
$city = $r["city"];
$tlfnr = $r["tlfnr"];
}
?>
<tr>
            <td> Ret Annoc&oslash;r Bruger:
              <P><form method="post" action="opdater.php">
<input type="hidden" name="id" value="$id">
                <table>
<tr>
                    <td width="200"><font face="arial" size="2"> Firma Navn:</font></font></td>
<td width="300" align="left"><input type="text" name="firma" value="<? echo "$firma"; ?>" style="width: 152px"></td>
</tr>
<tr>
                  <td width="200"><font face="arial" size="2"> SE-nr.: </font></font></td>
<td width="300" align="left"><input type="text" name="senr" value="<? echo "$senr"; ?>" style="width: 152px"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2"> Navn:</font></td>
<td width="300" align="left"><input type="text" name="navn" value="<? echo "$navn"; ?>" style="width: 152px"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">Adresse:</font></td>
<td width="300" align="left"><input type="text" name="adresse" value="<? echo "$adresse"; ?>" style="width: 152px"></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Sted:</font></td>
<td width="300" align="left"><input type="text" name="sted" value="<? echo "$sted"; ?>" style="width: 152px"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2"> Postnr.:</font></td>
                    <td width="300" align="left"><input type="text" name="postnr" value="<? echo "$postnr"; ?>" style="width: 152px"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">By:</font></td>
                    <td width="300" align="left">
                    <input type="text" name="city" value="<? echo "$city"; ?>" style="width: 152px"></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Hjemmeside:</font></td>
<td width="300" align="left"><input type="text" name="url" value="<? echo "$url"; ?>" style="width: 152px"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">Email:</font></td>
<td width="300" align="left"><input type="text" name="email" value="<? echo "$email"; ?>" style="width: 152px"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">Telefonnr.:</font></td>
<td width="300" align="left"><input type="text" name="tlfnr" value="<? echo "$tlfnr"; ?>" style="width: 152px"></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">Bruger navn:</font></td>
<td width="300" align="left"><? echo "$bruger" ?></td>
</tr>
<tr>
                    <td width="200"><font face="arial" size="2">password:</font></td>
<td width="300" align="left"><input type="text" name="apass" value="<? echo "$apass"; ?>" style="width: 152px"></td>
</tr>
</table>
             
              <p>&nbsp;</p>
                <P><br>
               
             
               
              <div align="center"><table width="300" border="0">
  <tr>
    <td><div align="center"> <font face="arial" size="2"><b>Klik p&aring; &quot;Annuller&quot;
                          for at annullere din indtastning.<br></b></font>
                          <input  type="reset" value="Annuller">
                        </div></td>
    <td><div align="center">
                         
                          <p><font face="arial" size="2"><b>Klik p&aring; &quot;Rette
                            oplysnigerne &quot; du har udfyldt i formularen. <br>
                            </b></font>
                          <input type="submit" name="update" value="Ret">
                        </div></td>
  </tr>
</table>
                </div>
              <hr>

<P></form><?
// Opdater oplysningerne
if ($update) {
include ("config.php");
mysql_connect($host,$user,$pass);
mysql_select_db($db);
$query = mysql_query("UPDATE Annocor SET navn='$navn', password='$password', email='$email', alder='$alder', hjemmeside='$hjemmeside' WHERE id='$id'") or print mysql_error();
echo "<font color=\"darkgreen\">Dine oplysninger er blevet opdateret";
}
?>
<?
// Hvis brugeren ikke er logget ind
} else {
?>
<center><font color="red">Kun for medlemmer</font></center>
<?
}
?>

<a href="http://www.e-banner.dk">Opret Banner Bruger:</a>
<BR>




</td>

<td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>



<!--- end left column --->




<td bgcolor="333333" valign=top width=150>

<!--- right column --->


<table border=0 cellpadding=5 cellspacing=0><tr><td>
<P><BR><P><BR>
<table border=0 cellpadding=0 cellspacing=0>
<tr>
                        <td valign=top>&nbsp; </td>
                      </tr>

<tr>
                        <td valign=top bgcolor="">&nbsp;</td>
                      </tr></table>
<p>
<!--- low right column - ads --->


<table border=0 cellpadding=5 cellspacing=0><tr><td>

<img src="http://www.cynide-lynide.dk/images/ad1.gif" width=143><br>
<img src="http://www.cynide-lynide.dk/images/space.gif" height=8><br>
<img src="http://www.cynide-lynide.dk/images/ad2.gif" width=143><br>
<img src="http://www.cynide-lynide.dk/images/space.gif" height=8><br>


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








</td></tr></table>
</td>
<!--- end right column --->

</tr>
</table>



<tr><td><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td></tr>



<tr><td align=center><p>&nbsp;</p></td></tr>



</table>


</center>
</BODY>
</HTML>
-----------------------------------------------------------------------------------------<?
include ("file:///C|/Documents%20and%20Settings/Lynide/Skrivebord/mail/commynity/community/config.php");
mysql_connect($host,$user,$pass);
mysql_select_db($db);
$query = mysql_query("SELECT bruger, apass, email, id FROM Annocor WHERE bruger='$bruger' AND apass='$apass'");
if (mysql_num_rows($query) == "0"){
?>
<center>
<font color="red">Forkert Bruger navn og/ell. Kodeord</font><br>
</center>
<?
} else {
while($r = mysql_fetch_array($query)) {
$s_bruger = $r["bruger"];
$s_apass = $r["apass"];
$s_email = $r["email"];
$s_id = $r["dato"];
}
session_start();
session_register ("s_navn");
session_register ("s_apass");
session_register ("s_email");
session_register ("s_id");
header ("location: test.php");
}
?>

her ligger de alle sammen http://www.cynide-lynide.dk/e-banner.dk/her.php

lukker den da der ingen hjælp har været her endnu