Why username doesn't show during login

Discussion in 'PHP' started by gilgalbiblewheel, Jun 12, 2010.

  1. #1
    Why isn't the username showing when I login?
    <?php
        # login.php
        
    if ($_SERVER['REQUEST_METHOD'] == 'POST'){
    	session_start();
    	$_SESSION['logged_in'] = true;
    	
    	header('HTTP/1.1 303 See Other');
    }
    header('Location: index.php');
    ?> 
    PHP:
    <?php
    # index.php
    session_start();
    $logged_in = isset($_SESSION['logged_in']);
    include("../dbconnection.php");
    //say goodbye to magic_quotes_gpc! no false security.
    
    $errors = array();
    
    if($_SERVER['REQUEST_METHOD'] == "POST"){
    	if(empty($_POST['username'])){
    		$errors[] = "username was empty";
    	}
    	if(empty($_POST['password'])){
    		$errors[] = "password was empty";
    	}
    	if(empty($_POST['email'])){
    		$errors[] = "e-mail was empty";
    	}
    	if(count($errors) == 0){
    		//fix magic_quotes_gpc() being on
    		if(get_magic_quotes_gpc()){
    			foreach($_GET as $k => $v){
    				$_GET[$k] = stripslashes($v);
    			}
    			foreach($_POST as $k => $v){
    				$_POST[$k] = stripslashes($v);
    			}
    			foreach($_COOKIE as $k => $v){
    				$_COOKIE[$k] = stripslashes($v);
    			}
    		}
    		//Checks if there is a login cookie
    		if(isset($_COOKIE['ID_my_site'])){ //if there is, it logs you in and directs you to the members page
    		$myusername = $_COOKIE['ID_my_site'];
    		$pass = $_COOKIE['Key_my_site'];
    		$admin = $_COOKIE['Admin_my_site'];
    		$user = $_COOKIE['User_my_site'];    
    		$sql = "SELECT * FROM ";
    		if($admin=="yes"){
    			$sql .= $dbTable2;
    		}else{
    			$sql .= $dbTable;
    		}
    		$sql .= " WHERE username = '".mysql_real_escape_string($myusername)."'";
    		$check = mysql_query($sql)or die(mysql_error());
    		while($info = mysql_fetch_array( $check )){
    			if($pass == $info['password']){
    				$writeusername = "Welcome ".$myusername."! <br />Visit your <a href=\"member.php\">member's stat</a> <br /><a href=\"login/logout.php\">Logout</a>";
    			}
    		}
    	}
    	//variable to keep track of whether to show the user the login form or not
    	$showlogin = true; //we show the form by default, -unless- we know they have logged in
    
    	//if the login form is submitted
    	if (isset($_POST['submit'])){ // if form has been submitted
    		if(!$_POST['username'] || !$_POST['pass']) {// makes sure they filled it in
    			$writeemptyfield = "<tr><td colspan=\"2\" style=\"text-align: left; color: red;\">You did not fill in a required field.</td></tr>";
    		}// checks it against the database
    		$_POST['email'] = mysql_real_escape_string($_POST['email']);
    		$db['username'] = mysql_real_escape_string($_POST['username']);
    		$sql = "SELECT * FROM ";
    		if($admin=="yes"){
    			$sql .= $dbTable2;
    		}else{
    			$sql .= $dbTable;
    		}
    		$sql .= " WHERE username = '".$db['username']."'";
    		$check = mysql_query($sql) or die(mysql_error());
    		//Gives error if user dosen't exist
    		$check2 = mysql_num_rows($check);
    		if ($check2 == 0) {
    			$writeusernoexist = "<tr><td colspan=\"2\" style=\"text-align: left; color: red;\">That user does not exist in our database.</td></tr>";
    		}
    		while($info = mysql_fetch_array( $check )){
    			$_POST['pass'] = md5($_POST['pass']);
    				//gives error if the password is wrong
    				if ($_POST['pass'] != $info['password']){
    					$writewrongpassword = "<tr><td colspan=\"2\" style=\"text-align: left; color: red;\">Incorrect password, please try again.</td></tr>";
    				}else{
    					// if login is ok then we add a cookie
    					$hour = time() + 3600;
    					setcookie("ID_my_site", $_POST['username'], $hour);
    					setcookie("Key_my_site", $_POST['pass'], $hour);
    					
    					//they are logged in. no need to show the login form
    					$showlogin = false;
    					if($_POST["admin"]=="yes"){
    						setcookie("Admin_my_site", $_POST['admin'], $hour);
    					}else{
    						setcookie("User_my_site", $_POST['admin'], $hour);
    					}
    					header("Location: login.php");
    				}
    			}
    		}
    	}
    }
    
    //$_SESSION['logged_in'] = 1;    
    ?>
    
    <!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>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Login</title>
    </head>
    
    <body>
    <?php if ($logged_in): ?>
    <form action="<?php echo "logout.php";//$_SERVER['PHP_SELF'];?>" method="POST">
    <span style="float: left; text-align: left; padding: 5px 5px 5px 5px;">
      Welcome <span id="myusername"><?php echo $writeusername; ?> </span>!<br />
      Visit your <a style="text-decoration: none;" href="member.php" onmouseover="this.style.textDecoration='underline';" onmouseout="this.style.textDecoration='none';" >member's stat</a><br />
      <input type="submit" style="float: left; border: 1px solid #7C7C7C; background-color: #7C7C7C; color: #ffffff; font: 9pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-weight: bold; width: 100px; height: 20px;" name="submit" onMouseOver="this.style.backgroundColor='#B4B3A9'" onMouseOut="this.style.backgroundColor='#7C7C7C'" value="Logout" />
    </span>
    </form>
    
    <?php else: ?>
    
    <form action="<?php echo "login.php";//$_SERVER['PHP_SELF'];?>" method="POST">
    <table border="0">
            <tr>
                <td>Administrator:</td><td><input type="checkbox" id="adminid" name="admin" style="float: left; border: 1px solid #7C7C7C; background-color: #7C7C7C;" value="no" onClick="if(this.value=='no'){this.value='yes'; document.getElementById('register').style.display = 'none';} else{this.value='no';document.getElementById('register').style.display = 'block';};" /></td>
           </tr>
    <?php echo $writeemptyfield; ?>
    <?php echo $writeusernoexist; ?>
            <tr>
                <td>Username:</td>
                <td><input type="text" name="username" id="username" style="float: left; border: 1px solid #7C7C7C; font: 9px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; width: 100px; height: 15px;" value="User Name" onBlur="if (this.value == '') this.value = 'User Name';" onFocus="if (this.value == 'User Name') this.value = '';" /></td>
           </tr>
    <?php echo $writewrongpassword; ?>        
            <tr>
                <td>Password:</td><td><input type="password" style="float: left; border: 1px solid #7C7C7C; font: 9pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; width: 100px; height: 15px;" name="pass" id="pass" /></td></tr>
            <tr>
                <td><a id="register" href="login/register.php" style="float: left; display: block; background-color: #7C7C7C; text-align: left; padding: 0px 0px 0px 5px; width: 80px; height: 20px; text-decoration: none; color: #ffffff; border: 1px solid #7C7C7C; font-weight: bold;" onMouseOver="this.style.backgroundColor='#B4B3A9'" onMouseOut="this.style.backgroundColor='#7C7C7C'">Register</a></td><td align="right"><input type="submit" style="float: left; border: 1px solid #7C7C7C; background-color: #7C7C7C; color: #ffffff; font: 9pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-weight: bold; width: 100px; height: 20px;" name="submit" onMouseOver="this.style.backgroundColor='#B4B3A9'" onMouseOut="this.style.backgroundColor='#7C7C7C'" value="Login" /></td>
            </tr>
        </table>
    </form>
    <?php endif; ?> 
    </body>
    </html>
    
    PHP:

     
    gilgalbiblewheel, Jun 12, 2010 IP
  2. ketting00

    ketting00 Well-Known Member

    Messages:
    782
    Likes Received:
    28
    Best Answers:
    3
    Trophy Points:
    128
    #2
    Where do you show the logged-in user's name. Looking through your codes get me headache.
    I use this little snippet and it works, but it's not good coding.

    <?php
    if(isset($_SESSION['userid'])) {
    $username = $_SESSION['username'];
    $query = mysql_query("SELECT * FROM users WHERE username='$username'") or die(mysql_error());
    $row = mysql_fetch_array($query);

    echo $row['username'];

    ?>

    You can adapt to your liking.
     
    ketting00, Jun 15, 2010 IP
  3. webria

    webria Peon

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Please see, if as shown below works fine. Then simlarly just test the cookie part in your code.
    May be you will be able to know where is the issue.
    page1.php
    <?php
    session_start();
    $_SESSION['logged_in'] = true;
    $_SESSION['username']='lovein'
    ?>

    page2.php
    <?
    session_start();
    $logged_in = isset($_SESSION['logged_in']);

    if($logged_in){
    print $_SESSION['username'];
    }
    ?>
     
    webria, Jun 15, 2010 IP