opret bruger med php oh mysql
Jeg er igang med at lave mit første log indsystemmen der er sikkert en helt del fejl i mine scripts, da når jeg prøver at oprette en ny bruger så kommer denne error
Parse error: parse error in /home/web/web3731/Annocor_process.php on line 71
Desuden har jeg ikke fået løst et andet problem jeg har når man logger ind skal man kunne se de oplysninger man har skrevet ind, de skal kun havde adgang til deres "egenside" på min side men jeg ved ikke helt hvordan det skal løses.
Her er 3 af de script den er gal med:
<HTML>
<HEAD>
<TITLE>opret1</TITLE>
<link rel="stylesheet" type="text/css" href="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="index.html">Index</a></td>
<td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
<td><a href="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> Opret Annocør Bruger:
<P><form action="http://www.cynide-lynide.dk/Annocor_process.php" method="post">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">* 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">* 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">* Ønsket password:</font></td>
<td width="300" align="left"><input TYPE="password" size="30" name="Apass"></td>
</tr>
</table>
<p>
<br>
<input value="accept" type="checkbox" >
Accepter vores kundevilkår <a href="">Læs vores kundevilkår her</a>
</p>
<p> </p>
<P>
<p><font face="arial" size="2"><b>Klik på "Tilmeld"
når du har udfyldt formularen. Klik på "Annuller"
for at annullere din indtastning.</b></font>
<br><p></p>
<div align="center"><table width="300" border="0">
<tr>
<td><div align="center">
<input type="reset" value="Annuller">
</div></td>
<td><div align="center">
<input type="submit" value="Tilmeld">
</div></td>
</tr>
</table>
</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> </td>
</tr>
<tr>
<td valign=top bgcolor=""> </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> </p></td></tr>
</table>
</center>
</BODY>
</HTML>
______________________________________________________________________________________________________________________<HTML>
<HEAD>
<TITLE>opret1</TITLE>
<link rel="stylesheet" type="text/css" href="default.css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</HEAD>
<?php
if(is_array($HTTP_GET_VARS)) {
$start_nr = $HTTP_GET_VARS['start_nr'];
} elseif (is_array($_GET)) {
$start_nr = $_GET['start_nr'];
}
if(!$start_nr || $start_nr < 0) {
$start_nr = 0;
}
aabn_forbindelse_og_vaelgdb();
$resultat = sql_spoerg_og_faa_svar($sql);
$optaelling = sql_spoerg_og_faa_svar($taeller_sql);
luk_forbindelse();
if(count($resultat) < 1) {
echo "Der er ingen Bruger med de oplysninger";
} else {
for($i=0;$i<count($resultat);$i++) {
extract($resultat[$i]);
$navn = stripslashes($navn);
$firma = stripslashes($firma);
$senr = stripslashes($senr);
$adresse= stripslashes($adresse);
$sted = stripslashes($sted);
$postnr =stripslashes($postnr);
$city = stripslashes($city);
$url =stripslashes($url);
$email = stripslashes($email);
$tlfnr = stripslashes($tlfnr);
$apass = stripslashes( $apass);
if($html_p != "t") {
$navn = htmlentities($navn);
$firma = htmlentities($firma);
$senr = htmlentities($senr);
$adresse= htmlentities($adresse);
$sted = htmlentities($sted);
$postnr =htmlentities($postnr);
$city = htmlentities($city);
$url =htmlentities($url);
$email = htmlentities($email);
$tlfnr = htmlentities($tlfnr);
$apass = htmlentities( $apass);
}
?>
<BODY BGCOLOR="#FFFFFF" 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> <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="index.html">Index</a></td>
<td><img src="http://www.cynide-lynide.dk/images/space.gif" width=8></td>
<td><a href="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>
<tr>
<td><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td>
</tr>
<tr>
<td bgcolor="333333" valign=top colspan=3> <table border=0 cellpadding=5 cellspacing=0 width=600>
<tr>
<td> DIne/Jeres Annocør Bruger oplysninger:
<table>
<tr>
<td width="200"><font face="arial" size="2"> Firma Navn:</font></font></td>
<td width="300" align="left"><?php echo $firma; ?>;</td>
</tr>
<tr>
<td width="200"><font face="arial" size="2"> SE-nr.: </font></font></td>
<td width="300" align="left"><?php echo $senr; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2"> Navn:</font></td>
<td width="300" align="left"><?php echo $navn; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2"> Adresse:</font></td>
<td width="300" align="left"><?php echo $adresse; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Sted:</font></td>
<td width="300" align="left"><?php echo $sted; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2"> Postnr.:</font></td>
<td width="300" align="left"><?php echo $postnr; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2"> By:</font></td>
<td width="300" align="left"><?php echo $city; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Hjemmeside:</font></td>
<td width="300" align="left"><?php echo $url; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2"> Email:</font></td>
<td width="300" align="left"><?php echo $email; ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Telefonnr.:</font></td>
<td width="300" align="left"><?php echo $tlfnr ?></td>
</tr>
<tr>
<td width="200"><font face="arial" size="2">Password:</font></td>
<td width="300" align="left"><?php echo $apass; ?></td>
</tr>
</table>
<form name="form1" method="post" action="">
<div align="center">
<input type="submit" name="Ret" value="Retoplysninger">
</div>
</form>
<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>
<?php
}
echo $nav;
}
echo bund();
?>
<td bgcolor="333333" valign=top width=150> <table border=0 cellpadding=5 cellspacing=0>
<tr>
<td> <table border=0 cellpadding=0 cellspacing=0>
<tr>
<td valign=top> <img src="http://www.cynide-lynide.dk/http://www.cynide-lynide.dk/images/rightphoto.jpg"></td>
</tr>
<tr>
<td valign=top bgcolor="222222">Your pic here</td>
</tr>
</table>
<table border=0 cellpadding=5 cellspacing=0>
<tr>
<td> <img src="http://www.cynide-lynide.dk/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>
</tr>
</table>
<tr>
<td><img src="http://www.cynide-lynide.dk/images/space.gif" height=8></td>
</tr>
<tr>
<td align=center> </td>
</tr>
</table>
</center>
</BODY>
</HTML>
_____________________________________________________________________________________________________________________________
<?php
if(is_array($HTTP_POST_VARS)) {
$navn = $HTTP_POST_VARS['navn'];
$firma = $HTTP_POST_VARS['firma'];
$senr = $HTTP_POST_VARS['senr'];
$adresse= $HTTP_POST_VARS['adresse'];
$sted = $HTTP_POST_VARS['sted'];
$postnr = $HTTP_POST_VARS['postnr'];
$city = $HTTP_POST_VARS['city'];
$url = $HTTP_POST_VARS['url'];
$email = $HTTP_POST_VARS['email'];
$tlfnr = $HTTP_POST_VARS['tlfnr'];
$apass = $HTTP_POST_VARS['apass'];
$Accept = $HTTP_POST_VARS['Accept'];
} elseif (is_array($_POST)) {
$navn = $_POST['navn'];
$firma = $_POST['firma'];
$senr = $_POST['senr'];
$adresse= $_POST['adresse'];
$email= $_POST['email'];
$postnr = $_POST['postnr'];
$city = $_POST['city'];
$tlfnr = $_POST['tlfnr'];
$apass = $_POST['apass'];
$Accept = $_POST['Accept'];
}
function gbog_fejl($fejl) {
$generel_tekst = "<p>Vær venlig at gå tilbage og ret til.</p>";
$fejlmelding = "<ul>";
for($i=0;$i<count($fejl);$i++) {
$fejlmelding .= "<li>". $fejl[$i];
}
$fejlmelding .= "</ul>";
echo top("Fejl") . "opret1 brokkede sig lidt over dit input:" . $fejlmelding . $generel_tekst . bund();
exit;
}
function Annocor($navn,$firma,$senr,$adresse,$sted, $postnr, $city,
$url,
$email) {
$ip = getenv('REMOTE_ADDR');
$sql = "Annocor_process(navn,email,
,ip,firma,senr,adresse,sted,postnr,city,url,tid)
values('$navn','$email','$ip',
'$firma','$senr','$adresse','$sted', '$postnr','$city,'
'$url',now())";
aabn_forbindelse_og_vaelgdb();
sql_spoerg($sql);
luk_forbindelse();
}
if(!ereg("[A-z0-9]+", $navn)) {
$fejl[] = "Du har ikke skrevet dit navn";
}
if(!ereg("[A-z0-9]+", $firma)) {
$fejl[] = "Du har ikke skrevet firmanavn";
}
if(!ereg("[A-z0-9]+", $senr)) {
$fejl[] = "Du har ikke skrevet Dit/Jeres Se-nr.";
}
if(!ereg("[A-z0-9]+", $adresse)) {
$fejl[] = "Du har ikke skrevet Din/Jeres adresse";
}
if(!ereg("[A-z0-9]+", $postnr)) {
$fejl[] = "Du har ikke skrevet Din/Jeres Postnummer";
}
if(!ereg("[A-z0-9]+", $postnr)) {
$fejl[] = "Du har ikke skrevet Din/Jeres By";
}
if(!ereg("[A-z0-9]+", $email)) {
$fejl[] = "Du har ikke skrevet Din/Jeres E-mail adresse";
}
if(count($fejl) > 0) {
gbog_fejl($fejl);
}
Annocor(addslashes($navn),addslashes($firma),addslashes($senr),addslashes($adresse),addslashes($sted),addslashes ($postnr), addslashes ($city),
addslashes($url),addslashes($email));
header("Location: Annocor.php");
?>
