OffTopic:
Endgültig der Zeitpunkt zum Verschieben nach Projekthilfe erreicht ...
Tweet
<?
session_start();
include 'sessionhelpers.inc.php';
echo 'You are ';
if (!logged_in())
echo 'not ';
echo 'logged-in.<p />';
echo 'Hallo';
echo " <a href=\"user.php".SID."\" target=\"Site".SID."\"
>\n";
function user_data($userid)
{
$sql="SELECT UserName
FROM users
WHERE UserID='".$userid."'
LIMIT 1";
$result= mysql_query($sql) or die(mysql_error());
if ( mysql_num_rows($result)==1)
{
$uname=mysql_fetch_assoc($result);
return $uname['UserName'];
}
else
return false;
}
echo " " .$uname['UserName'] ;
echo " </a>\n";
echo ' (<font size="-1"><a href="logout.php"
target="_parent">Log out</a></font>)';
?>
echo 'Benutzername:'.$name.'<br>';
$_SESSION['username']=$name;
print_r($SESSION);
echo 'Benutzername:'.$name.'<br>';
$_SESSION['username']=$name;
print_r($SESSION);
return $user['UserID'];
}
echo 'Hallo'.$_SESSION['username'].'<br>';
. Warum ich ihn allerdings per SELECT hohlen wollte, war, weil ich nun noch eine Seite möchte, wo der User seine Dateien ansehen kann und auch überarbeiten kann. Dazu sollte ich ja alle Daten aus der SQL Tabelle haben. Mein Problem ist jetzt nun:
$sql = "SELECT UserMail
FROM users
WHERE UserName = ".$_SESSION['username']." ";
$result = mysql_query($sql)
or die(mysql_error());
$row = mysql_fetch_assoc($result);
WHERE UserName = '".$_SESSION['username']."' ";
SELECT * FROM users
if(isset($_POST['submit']) AND "Save" == $_POST['submit']) {
if(!preg_match('/^\w+$/', trim($_POST['UserName']))) {
echo '<p class="error">';
echo 'Please use only signs that the database can handle';
echo '</p>';
} else {
$sql = "UPDATE
users
SET
UserName = '".trim($_POST['UserName'])."',
UserMail = '".addslashes(trim($_POST['UserMail']))."'
WHERE
UserID = '$ID' ";
// Die $ID steht mal provisorisch hier für den Wert der $row['UserID']
mysql_query($sql) OR die(mysql_error());
echo '<p>';
echo 'Your changes have been saved';
echo '</p>';
} }
session_start();
include 'sessionhelpers.inc.php';
if(isset($_POST['submit']) AND "Save" == $_POST['submit']) {
if(!preg_match('/^\w+$/', trim($_POST['UserName']))) {
echo '<p class="error">';
echo 'Please use only signs that the database can handle';
echo '</p>';
} else {
$sql = "UPDATE
users
SET
UserName = '".trim($_POST['UserName'])."',
UserMail = '".addslashes(trim($_POST['UserMail']))."'
WHERE
UserID = ".$row['UserID']." ";
mysql_query($sql) OR die(mysql_error());
echo '<p>';
echo 'Your changes have been saved';
echo '</p>';
} }
mysql_query($sql) OR die(mysql_error());
mysql_query($sql) OR die($sql."\n".mysql_error());
WHERE UserID =
<?php
session_start();
include 'sessionhelpers.inc.php';
if(isset($_POST['submit']) AND "Save" == $_POST['submit']) {
if(!preg_match('/^\w+$/', trim($_POST['UserName']))) {
echo '<p class="error">';
echo 'Please use only signs that the database can handle';
echo '</p>';
} else {
$sql = "UPDATE
users
SET
UserName = '".trim($_POST['UserName'])."',
UserMail = '".addslashes(trim($_POST['UserMail']))."'
WHERE
UserID = ".$row['UserID']." ";
mysql_query($sql) OR die($sql."\n".mysql_error());
echo '<p>';
echo 'Your changes have been saved';
echo '</p>';
} }
echo '<body bgcolor="#ffff00" text="#000066">';
echo '<font face="Arial">';
echo " <h2>\n";
echo "Change your profile here";
echo " </h2>\n";
echo '<table border="0" cellpadding="0" cellspacing="3" summary="Your profile" font face="Arial">';
$result = mysql_query("SELECT * FROM users WHERE UserName = '".$_SESSION['username']."' ") OR die(mysql_error());
$row = mysql_fetch_array($result) ;
echo '<h3>Your current settings</h3>';
echo '<tr>';
echo '<td width="250">';
echo "Your registered username: " ;
echo '</td>';
echo '<td width="350">';
echo " " .$row['UserName'] ;
echo '</td>';
echo '<tr>';
echo '<td>';
echo "<p>Your registered e-Mail adress: " ;
echo '</td>';
echo '<td>';
echo " " .$row['UserMail'] ;
echo '</td>';
echo '</tr>';
echo '</table><br>';
echo '<hr>';
echo '<h3>Change your settings</h3><p>';
echo ' <form action="user.php" method="post" class="formular"> ';
echo "<ol>\n";
echo '<label for="name">Name</label> ';
echo "<input type=\"text\" name=\"UserName\" id=\"UserName\" value=\"".$row['UserName']."\"/><p>\n";
echo "<label for=\"email\">e-Mail adress</label> \n";
echo "<input type=\"text\" name=\"UserMail\" id=\"UserMail\" value=\"".$row['UserMail']."\"/><p>\n";
echo "<input type=\"submit\" name=\"submit\" value=\"Save\" />\n";
echo "<input type=\"reset\" name=\"submit\" value=\"Clear\" />\n";
echo "<input type=\"hidden\" name=\"".session_id()."\" value=\"".session_id()."\" />\n"; // was das hier ist, weiss ich absolut nicht.
// brauch ich dass überhaupt?
echo "</ol>\n";
echo "</form>\n";
echo '<hr>';
echo '<p><form action="index1.php"><input type="submit" value="Back"></form>';
echo '</font>';
echo '</body>';
?>
WHERE UserID =
Kommentar