Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jul 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation PHP Login/Signup Form Script Issue

    Hello,
    I found this php login/signup form that works really well. Basically you register on the register.php and then login on the login.php page, and once you are logged in you are taken to the admin.php. What I am trying to do is once the user is taken to the admin.php page, I want it to say
    Welcome "username", you are logged in.
    I can't find where the username variable is in this code or how to do it. Can someone help me with this please?
    Thanks

    Here is the code:
    Register.php

    PHP Code:
    <?php require_once('Connections/modulatemedia.php'); ?>
    <?php
    if (!function_exists("GetSQLValueString")) {
    function 
    GetSQLValueString($theValue$theType$theDefinedValue ""$theNotDefinedValue ""
    {
      
    $theValue get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

      
    $theValue function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

      switch (
    $theType) {
        case 
    "text":
          
    $theValue = ($theValue != "") ? "'" $theValue "'" "NULL";
          break;    
        case 
    "long":
        case 
    "int":
          
    $theValue = ($theValue != "") ? intval($theValue) : "NULL";
          break;
        case 
    "double":
          
    $theValue = ($theValue != "") ? "'" doubleval($theValue) . "'" "NULL";
          break;
        case 
    "date":
          
    $theValue = ($theValue != "") ? "'" $theValue "'" "NULL";
          break;
        case 
    "defined":
          
    $theValue = ($theValue != "") ? $theDefinedValue $theNotDefinedValue;
          break;
      }
      return 
    $theValue;
    }
    }

    // *** Redirect if username exists
    $MM_flag="MM_insert";
    if (isset(
    $_POST[$MM_flag])) {
      
    $MM_dupKeyRedirect="register.php";
      
    $loginUsername $_POST['username'];
      
    $LoginRS__query sprintf("SELECT username FROM users WHERE username=%s"GetSQLValueString($loginUsername"text"));
      
    mysql_select_db($database_modulatemedia$modulatemedia);
      
    $LoginRS=mysql_query($LoginRS__query$modulatemedia) or die(mysql_error());
      
    $loginFoundUser mysql_num_rows($LoginRS);

      
    //if there is a row in the database, the username was found - can not add the requested username
      
    if($loginFoundUser){
        
    $MM_qsChar "?";
        
    //append the username to the redirect page
        
    if (substr_count($MM_dupKeyRedirect,"?") >=1$MM_qsChar "&";
        
    $MM_dupKeyRedirect $MM_dupKeyRedirect $MM_qsChar ."requsername=".$loginUsername;
        
    header ("Location: $MM_dupKeyRedirect");
        exit;
      }
    }

    $editFormAction $_SERVER['PHP_SELF'];
    if (isset(
    $_SERVER['QUERY_STRING'])) {
      
    $editFormAction .= "?" htmlentities($_SERVER['QUERY_STRING']);
    }

    if ((isset(
    $_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
      
    $insertSQL sprintf("INSERT INTO users (username, password, email, company, phoneno) VALUES (%s, md5(%s), %s, %s, %s)",
                           
    GetSQLValueString($_POST['username'], "text"),
                           
    GetSQLValueString($_POST['password'], "text"),
                           
    GetSQLValueString($_POST['email'], "text"),
                           
    GetSQLValueString($_POST['company'], "text"),
                           
    GetSQLValueString($_POST['phoneno'], "text"));

      
    mysql_select_db($database_modulatemedia$modulatemedia);
      
    $Result1 mysql_query($insertSQL$modulatemedia) or die(mysql_error());

      
    $insertGoTo "login.php";
      if (isset(
    $_SERVER['QUERY_STRING'])) {
        
    $insertGoTo .= (strpos($insertGoTo'?')) ? "&" "?";
        
    $insertGoTo .= $_SERVER['QUERY_STRING'];
      }
      
    header(sprintf("Location: %s"$insertGoTo));
    }
    ?><!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>Mikala Inc. User Registration</title>
    <style type="text/css">
    <!--
    .style2 {font-size: 10px}
    .style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; }
    .style4 {font-family: Verdana, Arial, Helvetica, sans-serif}
    .style7 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9px; }
    -->
    </style>
    <link rel="stylesheet" type="text/css" href="style.css" />
    <script type="text/javascript">
    <!--
    function MM_validateForm() { //v4.0
      if (document.getElementById){
        var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
        for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=document.getElementById(args[i]);
          if (val) { nm=val.name; if ((val=val.value)!="") {
            if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
              if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
            } else if (test!='R') { num = parseFloat(val);
              if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
              if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
                min=test.substring(8,p); max=test.substring(p+1);
                if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
          } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
        } if (errors) alert('The following error(s) occurred:\n'+errors);
        document.MM_returnValue = (errors == '');
    } }
    //-->
    </script>
    </head>

    <body>
    <form id="form1" name="form1" method="POST" action="<?php echo $editFormAction?>">
      <label></label>
      <table width="241" border="0" align="center">
        <tr>
          <td colspan="2"><h2 class="style4">Registration</h2></td>
        </tr>
        <tr>
          <td width="79"><span class="style3"><strong>
            
          </strong>        
            
          </span>        <span class="style2">
         
          </span>      <div align="right" class="style3"><strong>*Username:</strong></div>      </td>
          <td width="152"><input name="username" type="text" id="username" tabindex="1" maxlength="20" /></td>
        </tr>
        <tr>
          <td><span class="style3"><strong>
           
          </strong>        
            
          </span>        <span class="style2">
          
          </span>     <div align="right" class="style3"><strong>*Password:</strong></div>      </td>
          <td><input name="password" type="password" id="password" tabindex="2" maxlength="20" /></td>
        </tr>
        <tr>
          <td><span class="style3"><strong>
            
          </strong>        
           
          </span>        <span class="style2">
         
          </span>      <div align="right" class="style3"><strong>*Email:</strong></div>      </td>
          <td><input name="email" type="text" id="email" tabindex="3" maxlength="50" /></td>
        </tr>
            <tr>
          <td><span class="style3"><strong>
            
          </strong>        
           
          </span>        <span class="style2">
         
          </span>      <div align="right" class="style3"><strong>*Company Name:</strong></div>      </td>
          <td><input name="company" type="text" id="company" tabindex="4" maxlength="50" /></td>
        </tr>
              <tr>
          <td><span class="style3"><strong>
            
          </strong>        
           
          </span>        <span class="style2">
         
          </span>      <div align="right" class="style3"><strong>*Phone Number:</strong></div>      </td>
          <td><input name="phoneno" type="text" id="phoneno" tabindex="4" maxlength="50" /></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td><input name="submit" type="submit" id="submit" tabindex="4" onclick="MM_validateForm('username','','R');MM_validateForm('password','','R');MM_validateForm('email','','RisEmail');MM_validateForm('company','','R');MM_validateForm('phoneno','','R'); return document.MM_returnValue" value="Register" /></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td><p class="style7"><a href="login.php">login</a></p></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td><span class="style7">*required fields</span></td>
        </tr>
      </table>
      <input type="hidden" name="MM_insert" value="form1" />
    </form>
    </body>
    </html>

    Login.php
    PHP Code:
    <?php require_once('Connections/modulatemedia.php'); ?>
    <?php
    if (!function_exists("GetSQLValueString")) {
    function 
    GetSQLValueString($theValue$theType$theDefinedValue ""$theNotDefinedValue ""
    {
      
    $theValue get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

      
    $theValue function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

      switch (
    $theType) {
        case 
    "text":
          
    $theValue = ($theValue != "") ? "'" $theValue "'" "NULL";
          break;    
        case 
    "long":
        case 
    "int":
          
    $theValue = ($theValue != "") ? intval($theValue) : "NULL";
          break;
        case 
    "double":
          
    $theValue = ($theValue != "") ? "'" doubleval($theValue) . "'" "NULL";
          break;
        case 
    "date":
          
    $theValue = ($theValue != "") ? "'" $theValue "'" "NULL";
          break;
        case 
    "defined":
          
    $theValue = ($theValue != "") ? $theDefinedValue $theNotDefinedValue;
          break;
      }
      return 
    $theValue;
    }
    }
    ?>
    <?php
    // *** Validate request to login to this site.
    if (!isset($_SESSION)) {
      
    session_start();
    }

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

    if (isset(
    $_POST['username'])) {
      
    $loginUsername=$_POST['username'];
      
    $password=md5($_POST['password']);
      
    $MM_fldUserAuthorization "";
      
    $MM_redirectLoginSuccess "admin.php";
      
    $MM_redirectLoginFailed "login.php";
      
    $MM_redirecttoReferrer false;
      
    mysql_select_db($database_modulatemedia$modulatemedia);
      
      
    $LoginRS__query=sprintf("SELECT username, password FROM users WHERE username=%s AND password=%s",
        
    GetSQLValueString($loginUsername"text"), GetSQLValueString($password"text")); 
       
      
    $LoginRS mysql_query($LoginRS__query$modulatemedia) or die(mysql_error());
      
    $loginFoundUser mysql_num_rows($LoginRS);
      if (
    $loginFoundUser) {
         
    $loginStrGroup "";
        
        
    //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 );
      }
    }
    ?>
    <!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>Mikala Inc User Login</title>
    <style type="text/css">
    <!--
    .style2 {font-size: 10px}
    .style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; }
    .style4 {font-family: Verdana, Arial, Helvetica, sans-serif}
    .style5 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9px; }
    -->
    </style>
    <script type="text/javascript">
    <!--
    function MM_validateForm() { //v4.0
      if (document.getElementById){
        var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
        for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=document.getElementById(args[i]);
          if (val) { nm=val.name; if ((val=val.value)!="") {
            if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
              if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
            } else if (test!='R') { num = parseFloat(val);
              if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
              if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
                min=test.substring(8,p); max=test.substring(p+1);
                if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
          } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
        } if (errors) alert('The following error(s) occurred:\n'+errors);
        document.MM_returnValue = (errors == '');
    } }
    //-->
    </script>

    <link rel="stylesheet" type="text/css" href="style.css" />
    <style type="text/css">
    <!--
    .style6 {font-size: 9px}
    -->
    </style>
    </head>

    <body>
    <form ACTION="<?php echo $loginFormAction?>" id="form1" name="form1" method="POST">
      <label></label>
      <table width="241" border="0" align="center">
        <tr>
          <td colspan="2"><h2 class="style4">Login</h2></td>
        </tr>
        <tr>
          <td width="79"><span class="style3"><strong>
            
          </strong>        
            
          </span>        <span class="style2">
         
          </span>      <div align="right" class="style3"><strong>Username:</strong></div>      </td>
          <td width="152"><input name="username" type="text" id="username" tabindex="1" maxlength="20" /></td>
        </tr>
        <tr>
          <td><span class="style3"><strong>
           
          </strong>        
            
          </span>        <span class="style2">
          
          </span>     <div align="right" class="style3"><strong>Password:</strong></div>      </td>
          <td><input name="password" type="password" id="password" tabindex="2" maxlength="20" /></td>
        </tr>

        <tr>
          <td>&nbsp;</td>
          <td><input name="submit" type="submit" id="submit" tabindex="4" onclick="MM_validateForm('username','','R');MM_validateForm('password','','R');MM_validateForm('email','','RisEmail');return document.MM_returnValue" value="Login" /></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td><span class="style4"><a href="register.php" class="style5">register</a><span class="style6"> | <a href="mailto:ashley@mikala.com?subject=Forgot/Lost My Password&body=Please include your Name, Username (if known), Company Name and Phone Number.">forgot passwprd?</a></span></span></td>
        </tr>
      </table>
      
    </form>
    </body>
    </html>

    Admin.php
    PHP Code:
    [CODE]<?php
    //initialize the session
    if (!isset($_SESSION)) {
      
    session_start();
    }

    // ** Logout the current user. **
    $logoutAction $_SERVER['PHP_SELF']."?doLogout=true";
    if ((isset(
    $_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
      
    $logoutAction .="&"htmlentities($_SERVER['QUERY_STRING']);
    }

    if ((isset(
    $_GET['doLogout'])) &&($_GET['doLogout']=="true")){
      
    //to fully log out a visitor we need to clear the session varialbles
      
    $_SESSION['MM_Username'] = NULL;
      
    $_SESSION['MM_UserGroup'] = NULL;
      
    $_SESSION['PrevUrl'] = NULL;
      unset(
    $_SESSION['MM_Username']);
      unset(
    $_SESSION['MM_UserGroup']);
      unset(
    $_SESSION['PrevUrl']);
        
      
    $logoutGoTo "login.php";
      if (
    $logoutGoTo) {
        
    header("Location: $logoutGoTo");
        exit;
      }
    }
    ?>
    <?php
    if (!isset($_SESSION)) {
      
    session_start();
    }
    $MM_authorizedUsers "";
    $MM_donotCheckaccess "true";

    // *** Restrict Access To Page: Grant or deny access to this page
    function isAuthorized($strUsers$strGroups$UserName$UserGroup) { 
      
    // For security, start by assuming the visitor is NOT authorized. 
      
    $isValid False

      
    // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
      // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
      
    if (!empty($UserName)) { 
        
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
        // Parse the strings into arrays. 
        
    $arrUsers Explode(","$strUsers); 
        
    $arrGroups Explode(","$strGroups); 
        if (
    in_array($UserName$arrUsers)) { 
          
    $isValid true
        } 
        
    // Or, you may restrict access to only certain users based on their username. 
        
    if (in_array($UserGroup$arrGroups)) { 
          
    $isValid true
        } 
        if ((
    $strUsers == "") && true) { 
          
    $isValid true
        } 
      } 
      return 
    $isValid
    }

    $MM_restrictGoTo "login.php";
    if (!((isset(
    $_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
      
    $MM_qsChar "?";
      
    $MM_referrer $_SERVER['PHP_SELF'];
      if (
    strpos($MM_restrictGoTo"?")) $MM_qsChar "&";
      if (isset(
    $QUERY_STRING) && strlen($QUERY_STRING) > 0
      
    $MM_referrer .= "?" $QUERY_STRING;
      
    $MM_restrictGoTo $MM_restrictGoTo$MM_qsChar "accesscheck=" urlencode($MM_referrer);
      
    header("Location: "$MM_restrictGoTo); 
      exit;
    }
    ?>
    <!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>Untitled Document</title>
    <style type="text/css">
    <!--
    .style1 {
        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 9px;
    }
    -->
    </style>
    <link rel="stylesheet" type="text/css" href="style.css" />
    </head>

    <body>
    <p>You are logged in!</p>
    <p><span class="style1"><a href="<?php echo $logoutAction ?>">Log out</a></span></p>
    </body>
    </html>
    [/CODE]
    Code:
    
    
    Last edited by amcs76; 07-17-2008 at 04:08 PM.

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,801
    Thanks
    160
    Thanked 2,216 Times in 2,203 Posts
    Blog Entries
    1
    In the Admin.php, have a try by modifying the code like
    Code:
    <body>
    <p>Welcome <?php echo $_SESSION['MM_Username'] ;?>, You are logged in!</p>
    <p><span class="style1"><a href="<?php echo $logoutAction ?>">Log out</a></span></p>
    </body>
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •