Okay, so what I want to do is have the user login, and then when it redirects to the members page I want it to echo out the username who has logged in.
Here is the login code:
<?php
session_start();
include 'dbconnect.php';
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = addslashes($myusername);
$mypassword = addslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
session_start();
$_SESSION['username']=$myusername;
header( 'Location: test.php' ) ;
}
else {
echo "Wrong Username or Password";
}
?>
Here is the page where they login:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>home</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<div class="size">
<div class="header">
<div class="header01">
<div class="logo">Logo goes here</div>
<div class="hright">
<div class="hr01">
<div class="hr0101"><span class="style1">Login</span></div>
<div class="hr0102"></div>
<div class="hr0102"><span class="style1"><a href="register.html">Register</a></span></div>
<div class="hr0102"></div>
</div>
<div class="hr02"></div>
</div>
</div>
<div class="mnav">
<img class="mnimgl" src="image/img_37.jpg" alt="" />
<img class="mnimgr" src="image/img_50.jpg" alt="" />
<div class="mnm">
<ul>
<li><a href="test.html">HOME</a></li>
<li><a href="#">ABOUT US</a></li>
<li><a href="#">Order Status</a></li>
<li><a href="#">FAQ</a></li>
<li><a href="#">SERVICES</a></li>
<li><a href="#">CONTACT</a></li>
</ul>
</div>
</div>
</div>
<div class="content">
<div class="cmainimg">
<p>BANNER GOES HERE</p>
<p> </p>
</div>
<div class="submenu" style="left: 0px; top: 0px">
<img class="snimgl" src="image/img_96.jpg" alt="" />
<img class="snimgr" src="image/img_107.jpg" alt="" />
<div class="subtext">
You are here:Home
</div>
<div class="subimag" style="width: 41px; height: 51px">
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="mcontent">
<div class="mcleft">
<div class="mcbox01">
<div class="mc01t2">
Login</div>
<div class="mc01cc">
<form id="form1" name="form1" method="post" action="login.php">
<p>
Username :
<input type="text" name="myusername" id="myusername" />
<BR />
Password:
<input type="password" name="mypassword" id="mypassword" />
</p>
<p>
<input type="submit" name="submit" value="Login" />
</p>
<p> </p>
</form>
</div>
<div class="mc01b">
<img src="image/img_272.jpg" alt="" />
</div>
</div>
</div>
<div class="mcright">
<div class="mc01">
<div class="mc0101" style="left: 0px; top: 0px">
<img class="r0101" src="image/img_150.jpg" alt="" />
<img class="r0102" src="image/img_153.jpg" alt="" />
<img class="r0103" src="image/img_202.jpg" alt="" />
<img class="r0104" src="image/img_205.jpg" alt="" />
<div class="mcr">
<div class="mcr01">Weekly Promo goes here</div>
<div class="mcr02"></div>
</div>
</div>
<div class="mc0102">
<img class="r0101" src="image/img_155.jpg" alt="" />
<img class="r0102" src="image/img_157.jpg" alt="" />
<img class="r0103" src="image/img_207.jpg" alt="" />
<img class="r0104" src="image/img_209.jpg" alt="" />
<div class="mcl">
<div class="mcl01">
google ad goes here</div>
<div class="mcl02"></div>
</div>
</div>
</div>
<div class="mc02">
<div class="mc0201">
Welcome to our site
</div>
<div class="mc0202" style="width: 18px; height: 15px">
</div>
<div class="mc0203">
<div class="mc020301">
<p> </p>
<p>Who we are and what we do will go here w/ ads down the left side</p>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="footer">
<img class="mnimgl" src="image/img_275.jpg" alt="" />
<img class="mnimgr" src="image/img_291.jpg" alt="" />
<a href="#">HOME</a> | <a href="#">ABOUT US</a> | Order Status | <a href="#">FAQ</a> | <a
href="#">SERVICES</a> | <a href="#">CONTACT</a>
<br/>
</div>
</div>
</body>
</html>
