Ömer Sezer
Researcher & Software Engineer, github.com/omerbsezer
Menu Close
  • About Me
  • Publications
  • Certificates of ML
  • Blog

php

0

Implementation of Login Page With Php and Mysql

Posted on April 1, 2016 by omersezer

There is a login page (login.php) that is coded html form (includes username and password textboxes). The implementation of login page (php-mysql) is shown below:

//php code begins
if (!isset($_SESSION)) {
session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
   $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['username'])) {  //from form username textbox
   $loginUsername=$_POST['username'];
   $password=$_POST['password'];
   $MM_fldUserAuthorization = "access_level"; // from db user access-level
   $MM_redirectLoginSuccess = "login_success_page.php";
   $MM_redirectLoginFailed = "login_failed_page.php";
   $MM_redirecttoReferrer = false;
   mysql_select_db($DB_NAME, $DB_LINK);

   $Login_query=sprintf("SELECT username,password, access_level FROM tbl_user WHERE username=%s AND password=%s",
   GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text"));

   $Login = mysql_query($Login_query, $DB_LINK) or die(mysql_error());
   $loginFoundUser = mysql_num_rows($Login);
   
   if ($loginFoundUser) {

      $loginStrGroup  = mysql_result($Login,0,'access_level');

      if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}
      //declare two session variables and assign them
      $_SESSION['MM_Username'] = $loginUsername;
      $_SESSION['MM_UserGroup'] = $loginStrGroup;

      if (isset($_SESSION['PrevUrl']) && false) {
         $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
      }
      header("Location: " . $MM_redirectLoginSuccess );
   }
   else {
      header("Location: ". $MM_redirectLoginFailed );
   }
}
//php code ends
Back End login page, mysql, php

Recent Posts

  • GPU (Cuda) Configuration for Deep Learning Frameworks (Tensorflow, Pytorch)
  • Reinforcement Learning (RL) Tutorial
  • Neural Style Transfer Implementation
  • What is Transfer Learning? Transfer Learning With Keras (ResNet50)
  • Sentiment Analysis Using LSTM and GLoVe Word Embedding

Archives

  • March 2019
  • December 2018
  • August 2018
  • May 2018
  • April 2016
  • February 2015
  • December 2014
  • November 2014
  • July 2014
  • June 2014
© 2021 Ömer Sezer. All rights reserved.
Theme by Modern WP Themes