Hi, i've made a function that enables the visitor to change his image on his profil, but it doesn't work. The images doesn't save in my tabel.
I'm sorry but my english sucks đ
Here is some code :
//Ăndra profilbild
if (isset($_GET['profilbild']))
{
?>
<form method='post' action='redigera.php' name='andra'>
<input type="file" name="profilbild"> <br>
<input type='submit' value='Ladda upp'>
</form>
<?php
if ( $_POST['profilbild'] )
{
$bilden = "UPDATE members SET bild='$_POST[info]' WHERE id='$_SESSION[sess_id]'";
mysql_query($bilden);
header("Location: redigera.php?klart");
} else if (empty($_POST['profilbild']))
{
$bilden2 = "UPDATE members SET bild='images/inget-foto.jpg' WHERE id='$_SESSION[sess_id]'";
mysql_query($bilden2);
}
}
Here is the whole page:
<?php
header('P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"');
session_start(); // Alltid överst pÄ sidan
ob_start();
include("conn.php");
include("images2/design.php");
include "new.php";
// Kolla om inloggad = sessionen satt
if (!isset($_SESSION['sess_user']))
{
header("Location: index.php");
exit;
}
?>
<html><h1>
<?php
//Uppdaterar presentationen
if ( $_POST['presentation'] )
{
$result = mysql_query("UPDATE members SET egeninfo='$_POST[info]' WHERE user='$_SESSION[sess_user]'")
or die(mysql_error());
header("Location: redigera.php?klart");
}
//Uppdaterar uppgifter
if ( $_POST['uppgifter'] )
{
$result = mysql_query("UPDATE members SET name='$_POST[namn]', age='$_POST[age]', MF='$_POST[MF]' WHERE user='$_SESSION[sess_user]'")
or die(mysql_error());
header("Location: redigera.php?klart");
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<title>Välkommen</title>
</head>
<body>
<br>
<a href="?presentation">Ăndra presentation</a> - <a href="?uppgifter">Ăndra anvĂ€ndaruppgifter</a> - <a href="?losen">Ăndra lösenord</a> - <a href="?profilbild">Ăndra profilbild</a> - <a href="?radera">Radera anvĂ€ndare</a>
<br><br>
<?php
//FormulÀret för anvÀndaruppgifter Àndring
if (isset($_GET['uppgifter']))
{
$result = mysql_query("SELECT * FROM members WHERE user='$_SESSION[sess_user]'");
while ( $rad = mysql_fetch_array($result) )
{
echo "<h2>Redigera dina uppgifter</h2><br><br>
<form method=\"post\" action=\"redigera.php\" name=\"andra\">
<table border=0>
<tr>
<td>
Namn:
</td>
<td>
<input type=\"text\" name=\"namn\" size=\"25\" value=\"" . $rad['name'] . "\">
</td>
</tr>
<tr>
<td>
Ă
lder:
</td>
<td>
<input type=\"text\" name=\"age\" value=\"" . $rad['age'] . "\"> T.ex. 0000-00-00
</td>
</tr>
<tr>
<td>
Kön:
</td>
<td>
<INPUT TYPE=\"radio\" NAME=\"MF\" VALUE=\"M\" CHECKED>Man
<INPUT TYPE=\"radio\" NAME=\"MF\" VALUE=\"F\">Kvinna
</td>
</tr>
<tr>
<td>
<input type=\"submit\" value=\"Ăndra presentation\" name=\"uppgifter\">
</td>
</tr>
</table>
</form>";
}
}
if (isset($_GET['presentation']))
{
//FormulÀr för att Àndra presentationen
$result = mysql_query("SELECT * FROM members WHERE user='$_SESSION[sess_user]'");
while ( $rad = mysql_fetch_array($result) )
{
echo "<h2>Redigera din presentation</h2><br><br>
<form method='post' action='redigera.php' name='andra'>
<table>
<tr>
<td>
Presentation: <br>
</td>
<td>
<textarea cols='50' rows='6' name='info'>" . $rad['egeninfo'] . "</textarea>
</td>
</tr>
<tr>
<td>
<input type='submit' value='Ăndra presentation' name='presentation'>
</td>
</tr>
</table>
</form>";
}
}
//Tar bort anvÀndare
if (isset($_GET['radera']))
{
$_SESSION['raderad'] = 1;
$sql = "DELETE FROM members WHERE id = ".$_SESSION['sess_id'];
mysql_query($sql);
header("Location: index.php?logout=");
}
//Ăndra profilbild
if (isset($_GET['profilbild']))
{
?>
<form method='post' action='redigera.php' name='andra'>
<input type="file" name="profilbild"> <br>
<input type='submit' value='Ladda upp'>
</form>
<?php
if ( $_POST['profilbild'] )
{
$bilden = "UPDATE members SET bild='$_POST[info]' WHERE id='$_SESSION[sess_id]'";
mysql_query($bilden);
header("Location: redigera.php?klart");
} else if (empty($_POST['profilbild']))
{
$bilden2 = "UPDATE members SET bild='images/inget-foto.jpg' WHERE id='$_SESSION[sess_id]'";
mysql_query($bilden2);
}
}
//Uppdaterar lösenordet
if ($_POST['losenord'])
{
$user = $_SESSION['sess_user'];
//Plockar ut det aktuella lösenordet ifrÄn anvÀndaren
$result1 = mysql_query("Select * from members WHERE user='$user'")
or die(mysql_error());
while ($rad = mysql_fetch_array($result1))
{
//Kollar om du skrev in rÀtt gammalt lösenord
$gpass = $_POST['gammaltpass'];
$npass = $_POST['nyttpass1'];
$npass1 = $_POST['nyttpass1'];
$npass2 = $_POST['nyttpass2'];
$pass = $rad['pass'];
if ( $gpass == "" )
{
echo "Du mÄste fylla i det aktuella lösenordet";
}
else
{
if ( $gpass == $pass )
{
if ( $npass1 == "" || $npass2 == "" )
{
echo "Du mÄste fylla i alla textboxar";
}
else
{
if ( $npass1 != $npass2 )
{
echo "Dina lösenord matchar inte varandra";
}
else
{
$result = mysql_query("UPDATE members SET pass='$npass' WHERE user='$_SESSION[sess_user]'")
or die(mysql_error());
header("Location: redigera.php?klart");
}
}
}
else
{
echo "Du angav fel lösenord, testa igen";
}
}
}
}
if (isset($_GET['losen']))
{
//FormulÀr för att Àndra ditt lösenord
?>
<h2>Redigera ditt lösenord</h2><br><br>
<form method="post" action="redigera.php" name="andra">
<table>
<tr>
<td>
Gammalt lösenord:
</td>
<td>
<input type="password" name="gammaltpass">
</td>
</tr>
<tr>
<td>
Nytt lösenord:
</td>
<td>
<input type="password" name="nyttpass1">
</td>
</tr>
<tr>
<td>
Nytt lösenord (igen):
</td>
<td>
<input type="password" name="nyttpass2">
</td>
</tr>
<tr>
<td>
<input type="submit" value="Ăndra presentation" name="losenord">
</td>
</tr>
</table>
</form>
<?php
}
?>
<br>
<?php
//Om uppgifterna Àr sparade
if (isset($_GET['klart']))
{
echo "Dina uppgifter sparade";
}
?>
<br><br>
<a href="profile.php?show=<?php echo $_SESSION['sess_user']; ?>">GĂ„ till din profil</a>
</h1></html>
Best regards Fredda!
