Rediger Bruger script virker Ikke
Der er ikke så meget at sige.. :)jeg har ledt begge filer igennem en milliard gange for at finde grunden, eller fejlen til at det ikke virker
Men fejlen er at den ikke lægger de ting den skal op i mysql databasen... :/
########
FIL ET , den fil hvor man udfylder formularene
########
<?php
include('mysql.php');
include('beskyt.php');
if ($_SESSION['rediger'] == ""){/*Gør intet*/}
else {
echo $_SESSION['rediger'];
$_SESSION['rediger'] = "";
}
$query = "SELECT * FROM users WHERE id = '".$_SESSION['id']."'";
$result = mysql_query($query)or die("MySQL fejl: " . mysql_error());
$log = mysql_fetch_array($result);
echo "<h3>Rediger Profil</h3><table><form action=\"redigerp.php\" method=\"post\" name=\"post\" >";
echo "<tr><td>Brugernavn:</td><td><input name=\"navn\" type=\"text\" size=\"25\" maxlength=\"35\" value=\"".$log['user']."\"></td></tr>";
echo "<tr><td>Password:</td><td><input name=\"password\" type=\"password\" size=\"25\" maxlength=\"30\" value=\"".$log['pass']."\"></td></tr>";
echo "<tr><td>Gentag password:</td><td><input name=\"password2\" type=\"password\" size=\"25\" maxlength=\"30\" value=\"".$log['pass']."\"></td></tr>";
echo "<tr><td>Alder:</td><td><input name=\"alder\" type=\"text\" size=\"25\" maxlength=\"20\" value=\"".$log['alder']."\"></td></tr>";
echo "<tr><td>ID:</td><td><input name=\"id\" type=\"text\" size=\"25\" maxlength=\"6\" value=\"".$log['heroesid']."\"></td></tr>";
echo "<tr><td>Køn:</td><td><input name=\"sex\" type=\"text\" size=\"25\" maxlength=\"50\" value=\"".$log['køn']."\"></td></tr>";
echo "<tr><td>Signatur:</td><td><input name=\"signatur\" type=\"text\" size=\"25\" maxlength=\"100\" value=\"".$log['signatur']."\"></td></tr>";
echo "<tr><td>Msn:</td><td><input name=\"msn\" type=\"text\" size=\"25\" maxlength=\"50\" value=\"".$log['msn']."\"></td></tr>";
echo "<tr><td>Icq:</td><td><input name=\"icq\" type=\"text\" size=\"25\" maxlength=\"50\" value=\"".$log['icq']."\"></td></tr>";
echo "<tr><td>Skype:</td><td><input name=\"skype\" type=\"text\" size=\"25\" maxlength=\"50\" value=\"".$log['skype']."\"></td></tr>";
echo "<tr><td>Hjemmeside:</td><td><input name=\"site\" type=\"text\" size=\"25\" maxlength=\"50\" value=\"".$log['website']."\";></td></tr>";
echo "<tr><td>Email:</td><td><input name=\"email\" type=\"text\" size=\"25\" maxlength=\"35\" value=\"".$log['email']."\"></td></tr>";
echo "<tr><td>ProfilTekst:</td><td><textarea name=\"om\" cols=\"25\" rows=\"15\" value=\"".$log['about']."\"></textarea><br> Html koder tilladt</td></tr>";
echo "<tr><td><input name=\"submit\" type=\"submit\" value=\"opdater\"></td></tr>";
echo "</form><table>";
?>
#######
FIL TO, Filen hvor den tjekker formularene og lægger det i Databasen
#######
<?php
include('mysql.php');
include('beskyt.php');
if ($_POST['navn'] == "" & $_POST['pass'] = ""){
$_SESSION['rediger'] = "Feltet BrugerNavn og Password er Tomt";
print(" <script language='javascript'>
location.href='rediger.php';
</script>");
}
elseif ($_POST['navn'] == ""){
$_SESSION['rediger'] = "Feltet BrugerNavn er Tomt";
print(" <script language='javascript'>
location.href='rediger.php';
</script>");
}
elseif ($_POST['password'] == ""){
$_SESSION['rediger'] = "Feltet Password er Tomt";
print(" <script language='javascript'>
location.href='rediger.php';
</script>");
}
else {
if ($_POST['password'] == $_POST['password2']){
$result = mysql_query("UPDATE users
SET user='".$_POST['navn']."'
AND pass = '".$_POST['pass']."'
AND alder = '".$_POST['alder']."'
AND pass = '".$_POST['pass']."'
AND heroesid = '".$_POST['id']."'
AND pass = '".$_POST['pass']."'
AND køn = '".$_POST['sex']."'
AND msn = '".$_POST['msn']."'
AND icq = '".$_POST['icq']."'
AND about = '".$_POST['om']."'
AND website = '".$_POST['site']."'
AND signatur = '".$_POST['signatur']."'
AND skype = '".$_POST['skype']."'
WHERE id='$id'")or die("MySQL fejl: " . mysql_error());
$_SESSION['rediger'] = "Dine indstilninger er opdateret";
print(" <script language='javascript'>
location.href='rediger.php';
</script>");
}
}
?>
Håber i kan hjælpe ;)
Mvh
Hyanen
