Ive begun to build a simple forum, nothing huge but I do have a question. When Im doing the login im going to use a session. to tell who the user is would I just set a session variable to username like this for my login page after they type in username and pass
[code=php]
$query=”SELECT * FROM `reforum_users` WHERE username=’$_POST[‘username’] LIMIT 1;
$result=mysql_query($query);
$row=mysql_fetch_assoc($result);
if($row[‘password’]==$_POST[‘passsword’])
{
$_SESSION[‘loggedin’]=”1″;
$_SESSION[‘username’]=$row[‘username’];
echo”Thank you for logging in”;
}
else
{
$_SESSION[‘loggedin’]=”0″;
$_SESSION[‘username’]=NULL;
echo”Incorrect Password for corresponding username please try again”;
}
With this could I reference username throughout the rest of the forum.
Heres my progess so far to anyone interested [url]http://www.complexfellow.com/forum/
[code=php]
<?include("functions.php");?>
<div class="container">
<?
if($action=="")
{
?>
<div>
<form action="/forum/login.php?action=login" method="post">
<div>Username<input type="text" name="username" /></div>
<div>Password<input type="password" name="pass" /></div>
<div><input type="submit" value="Login!" /></div>
</form>
</div>
</div>
<?
}
if($action=="login")
{
$username=$_POST['username'];
$query="SELECT * FROM reforum_users
WHERE username=$username";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
if($row['password']==$_POST['passsword'])
{
$_SESSION['loggedin']="1";
$_SESSION['username']=$row['username'];
echo"Thank you for logging in".$_SESSION['username']."<br>";
}
else
{
$_SESSION['loggedin']="0";
$_SESSION['username']=NULL;
echo"Incorrect Password for corresponding username please try again";
}
}
?>
</div>
<?
include("footer.php");
?>
[/code]
[code=php]
while($row=mysql_fetch_array($result))
[/code]
[code=php]
<?require("functions.php");?>
<div class="container">
<?
if($action=="")
{
?>
<div>
<form action="/forum/login.php?action=login" method="post">
<div>Username<input type="text" name="username" /></div>
<div>Password<input type="password" name="pass" /></div>
<div><input type="submit" value="Login!" /></div>
</form>
</div>
</div>
<?
}
if($action=="login")
{
$username=$_POST['username'];
$query="SELECT * FROM reforum_users
WHERE username='$username'";
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_assoc($result))
{
if($row['password']==$_POST['pass'])
{
$_SESSION['loggedin']="1";
$_SESSION['username']=$row['username'];
echo"Thank you for logging in ".$_SESSION['username']."<br /><a href='/forum' title='index'>Return to Index</a>";
}
}
}
else
{
echo"Incorrect Username Or poassword";
}
?>
</div>
<?
include("footer.php");
?>
[/code]
[code=php]
<?
include("functions.php");
echo"<div class='container'><h3>$user 's Profile</h3><table width='100%' cellspacing='0' border='1'>";
$user=$_GET['user'];
$query="SELECT * FROM reforum_users
WHERE username='$user'";
$result = mysql_query($query);
while($row=mysql_fetch_assoc($result))
{
$id=$row['ID'];
$username = $row['user'];
$name = $row['name'];
$email = $row['email'];
$postcount = $row['postcount'];
$reg= $row['registered'];
echo "<tr class='odd'><td class='left'>Username</td><td class='post'>$username</td></tr>"
."<tr class='even'><td class='left'>Name</td><td class='post'>$name</td></tr>"
."<tr class='odd'><td class='left'>Email</td><td class='post'>$email</td></tr>"
."<tr class='even'><td class='left'>Post Count</td><td class='post'>$postcount</td></tr>"
."<tr class='odd'><td class='left'>Reg Date</td><td class='post'>$reg</td></tr>";
}
echo"</table></div>";
include("footer.php");
?>
[/code]
[code=php]
<?
$pageTitle="ReForum::Log In";
require("functions.php");?>
<div class="container">
<?
if($action=="")
{
?>
<div>
<form action="/forum/login.php?action=login" method="post">
<div>Username<input type="text" name="username" /></div>
<div>Password<input type="password" name="pass" /></div>
<div><input type="submit" value="Login!" /></div>
</form>
</div>
</div>
<?
}
if($action=="login")
{
$passw=$_POST['pass'];
$passw=md5($passw);
$username=$_POST['username'];
$query="SELECT * FROM reforum_users
WHERE username='$username'";
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_assoc($result))
{
if($row['password']==$passw)
{
$_SESSION['loggedin']="1";
$_SESSION['username']=$row['username'];
echo"Thank you for logging in ".$_SESSION['username']."<br /><a href='/forum' title='index'>Return to Index</a>";
}
else
{
echo"Incorrect Username Or password";
}
}
}
?>
</div>
<?
include("footer.php");
?>
[/code]
[code=php]
$user=$_GET['user'];
echo "<div class='container'><h3>$user's Profile</h3><table width='100%' cellspacing='0' border='1'>";
[/code]
[i]Originally posted by RefreshF5 [/i]
[B]yeah but why would that affect if in login.php and profile.php arent connected in anyway
I dont know why that worked but it did thanks [/B][/QUOTE]
[I]Originally posted by RefreshF5[/I]
[b]ok When I echo out the posts I use a while loop to echo out everything from the table reforum_posts, how would I echo out the corresponding post count for the user from reforum_users?[/b][/QUOTE]
[i]Originally posted by RefreshF5 [/i]
[B]so can i run one while in another like I mentioned in the first post on this page. [/B][/QUOTE]
0.1.9 — BETA 6.17