Jump to content

my login.php did not select from mysql

ephdee

By ephdee
in PHP Coding Help

 Share

Recommended Posts

ephdee Member

ephdee

Posted
Posted

Hi am new to php and am facing some difficulty concerning the login.php. My register.php is inserting to the database but when i try to select it so i can login it keeps showing me the errmsg. These are the codes..

<?php
 ob_start();
 session_start();
 require_once 'dbconnect.php';
 
 // it will never let you open index(login) page if session is set
 if ( isset($_SESSION['user'])!="" ) {
  header("Location: home.php");
  exit;
 }
 
 $error = false;
 
 if( isset($_POST['btn-login']) ) { 
  
  // prevent sql injections/ clear user invalid inputs
  $userlogin = trim($_POST['userlogin']);
  $userlogin = strip_tags($userlogin);
  $userlogin = htmlspecialchars($userlogin);
  
  $pass = trim($_POST['pass']);
  $pass = strip_tags($pass);
  $pass = htmlspecialchars($pass);
  // prevent sql injections / clear user invalid inputs
  
  if(empty($userlogin)){
   $error = true;
   $userloginError = "Please enter your loginid.";
  } 
  
  if(empty($pass)){
   $error = true;
   $passError = "Please enter your password.";
  }
  
  // if there's no error, continue to login
  if (!$error) {
   
   $usepassword = hash('sha256', $pass); // password hashing using SHA256
  
   $res=mysql_query("SELECT `id`, `loginid`, `firstname`, `middlename`, `lastname`, `phone`, `email`, `password`, `cpassword`, `answer` FROM icpl WHERE userlogin='$userlogin' AND usepassword='$usepassword'");
   $row=mysql_fetch_array($res);
   $count = mysql_num_rows($res); // if uname/pass correct it returns must be 1 row
   
    
   
   
   if( $count == 1 && $row['password']==$usepassword && $row['loginid']==$userlogin ) {
	  $_SESSION['user'] =true;
    $_SESSION['user'] = $row['loginid'];
	
	
	
   
	
    header("Location: home.php");
   } 
   
   
   else {
    $errMSG = "Incorrect Credentials, Try again...";
	
   }
    
  }
  
 }
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Coding Cage - Login & Registration System</title>
<link rel="stylesheet" href="login-registration-php-new/assets/css/bootstrap.min.css" type="text/css"  />
<link rel="stylesheet" href="style.css" type="text/css" />
<style type="text/css">
#apDiv1 {
	position: absolute;
	width: 200px;
	height: 115px;
	z-index: 1;
	left: 236px;
	top: 139px;
}
#apDiv2 {
	position: absolute;
	width: 200px;
	height: 115px;
	z-index: 1;
	left: 501px;
	top: -17px;
}
.container #login-form form .col-md-12 .form-group #apDiv2 .form-group h2 {
	color: #F00;
}
</style>
</head>
<body>


<div class="container">

 <div id="login-form">
    <form method="post" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" autocomplete="off">
    
     <div class="col-md-12">
        
         <div class="form-group">
             <div id="apDiv2">
               <div class="form-group">
                 <h2 class="">Sign In.</h2>
               </div>
               <div class="form-group">
                 <div class="form-group"><span class="text-danger"><?php echo $passError; ?></span></div>
                 <span class="text-danger"><?php echo $userloginError; ?></span>
                 <hr />
                 <?php
   if ( isset($errMSG) ) {
    
    ?>
               </div>
               <div class="form-group">
                 <div class="alert alert-danger"> <span class="glyphicon glyphicon-info-sign"></span> <?php echo $errMSG; ?></div>
               </div>
               <?php
   }
   ?>
               <div class="form-group">
                 <div class="input-group"> <span class="input-group-addon"><span class="glyphicon glyphicon-user"></span></span>
                   <input type="text" name="userlogin" class="form-control" placeholder="Your LoginId" value="<?php 
				   echo $userlogin; ?>" maxlength="40" />
                 </div>
               </div>
               <div class="form-group">
                 <div class="input-group"> <span class="input-group-addon"><span class="glyphicon glyphicon-lock"></span></span>
                   <input type="password" name="pass" class="form-control" placeholder="Your Password" maxlength="15" />
                 </div>
               </div>
               <div class="form-group">
                 <hr />
               </div>
               <div class="form-group">
                 <button type="submit" class="btn btn-block btn-primary" name="btn-login">Sign In</button>
               </div>
               <div class="form-group">
                 <hr />
               </div>
               <div class="form-group"> <a href="../../register.php">Sign Up Here...</a></div>
             </div>
             <h2 class=""> </h2>
        </div>
</div>
  
    </form>
    </div> 

</div>

</body>
</html>
<?php ob_end_flush(); ?>
Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.