Hi,
i am a beginner and can not finde the error, why it is not possible after a user login to change the user profile data.
Can You have a look on my script - maybe you see that error?
Thanks for any help!!
Regards from Cologne/Deutschland
Arthur
Here my script:
<?require("login_check.php3");?>
<body>
<?php
require("inc/mydb.inc");
mysql_connect(localhost,"$db_user","$db_password");
@mysql_select_db($db);
if($USER) {
if ($update)
{
/ update db
$sql = "UPDATE user SET pwd='$pwd',email='$email',plz='$plz',city='$city',age='$age',size='$size',wight='$wight',eyes='$eyes',hair='$hair' WHERE usr='$usr'/
$result = mysql_query($sql);
echo "Hey, <?php echo $USER; ?> Deine Daten wurden erfolgreich in der Datenbank geändert.\n";
mysql_close();
}
else
{
$sql = "SELECT * FROM user WHERE usr = '$USER'";
$result = mysql_query($sql);
$data = mysql_fetch_array($result);
$usr=$data["usr"];
$pwd=$data["pwd"];
$email=$data["email"];
$plz=$data["plz"];
$city=$data["city"];
$age=$data["age"];
$size=$data["size"];
$wight=$data["wight"];
$eyes=$data["eyes"];
$hair=$data["hair"];
// display form
}
}
?>
<P align="center"><font size="2"><b><font face="Arial, Helvetica, sans-serif" color="#666666"><?php echo $USER; ?>, hier kannst Du
Deine Daten ändern:</font></b></font>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type=hidden name ="usr" value="<?php echo $usr ?>">
<table width="24%" border="0" align="center" bgcolor="#FFFFFF" bordercolor="#FFFFFF">
<tr bgcolor="#99CCFF" bordercolor="#FFFFFF">
<td colspan="2">
<div align="center"><font size="2" face="Arial, Helvetica, sans-serif" color="#FFFFFF"><b>Deine
Profildaten</b></font></div>
<tr bgcolor="#FFCC99" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Passwort:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="pwd" maxlength=8 size=10 value="<?php echo $pwd ?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">eMail:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="email" maxlength=15 size=10 value="<?php echo $email ?>">
</font></td>
</tr>
<tr bgcolor="#FFCC99" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Plz.:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="plz" maxlength=5 size=10 value="<?php echo $plz ?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Stadt:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="city" maxlength=15 size=10 value="<?php echo $city ?>">
</font></td>
</tr>
<tr bgcolor="#FFCC99" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Alter:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="age" maxlength=2 size=10 value="<?php echo $age ?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Größe:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="size" maxlength=4 size=10 value="<?php echo $size ?>">
</font></td>
</tr>
<tr bgcolor="#FFCC99" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Gewicht:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="wight" maxlength=2 size=10 value="<?php echo $wight ?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Augenfarbe:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="eyes" maxlength=10 size=10 value="<?php echo $eyes ?>">
</font></td>
</tr>
<tr bgcolor="#FFCC99" bordercolor="#FFFFFF">
<td><font size="1" face="Arial, Helvetica, sans-serif" color="#666666">Haarfarbe:</font></td>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="Text" name="hair" maxlength=10 size=10 value="<?php echo $hair ?>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF" bordercolor="#FFFFFF">
<td><font face="Arial, Helvetica, sans-serif"></font></td>
<td>
<p> </p>
<p><font size="2" face="Arial, Helvetica, sans-serif">
<input type="Submit" name="update" maxlength=10 size=10 value="Und ab die Post...">
</font></p>
</td>
</tr>
</table>
</form>
</body>
