Problem displaying another page without using a link

bakarre · #1 (**permalink**) 11-02-07, 10:36 AM

Good day, the code below in "loginn.php" is to query the databse for a valid userid and password, if it exists, I want to view another page "sespage.php" if the query is successful, without using a link, if not successful, I want it to display another page - wrong userid/password.

I dont want "loginn.php" page to appear for either the query is successful or not.

Please see the code "loginn.php"( it can query database sucessfully but I can display what I want without using a link)

PHP Code:


			
<?php 
 session_start();
 
$db = mysql_connect("localhost","root","******") or die(mysql_error()); 
mysql_select_db("fdp",$db) or die(mysql_error()); 

if(isset($_POST['userid']) && isset($_POST['passwd']))
$userid = $_POST['userid'];
$passwd = $_POST['passwd'];
if(isset($_POST['fdplog']))

{

    $sql = "SELECT * FROM fdp_luser WHERE userid = '$userid' and passwd = '$passwd'";
    $result = mysql_query($sql);
    mysql_query($sql) or die('<hr />MySQL Error: ' .mysql_error(). '<hr />');
    $myrow = mysql_fetch_array($result);
    if($myrow) {
    $_SESSION['valid_user'] = $userid;
    echo 'You are logged in as : '.$_SESSION['valid_user'].' <br>';
    echo '<a href= "sespage.php"> Sespage </a><br />';
}
else{
echo 'Wrong UserName or Password'; 
}    
}
?>
<html>
<body>

<style type="text/css">
<!--
body {
    margin-left: 20%;
    margin-top: 10%;
    
}

-->
</style>
<form name="form1" method="post" action="">
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>
    <label>SIGN IN <br>
    </label>
  <table width="760" height="27" border="5">
    <tr>
      <td width="714" bgcolor="#009966" scope="row">&nbsp;</td>
    </tr>
  </table>
    <label for="textfield"><br>
    <br>
    <br>
   
     <br>
   User Name :
  <input name="userid" type="Text" class="anytg15" value="<?php echo $userid ?>">
  <br>
   Password :
  <input name="passwd" type="password" class="any14" value="<?php echo $passwd ?>">
 
  <p>&nbsp;</p>
  <table width="760" height="27" border="5">
    <tr>
      <td width="714" bgcolor="#009966" scope="row">&nbsp;</td>
    </tr>
  </table>
  <p align="center">
    <label for="Submit"></label>
    <input type="Submit" name="fdplog" value="Sign In" id="Submit">
  </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</form>
</body>
</html>

Thank

Bakare

Jay6390 · #2 (**permalink**) 11-02-07, 03:23 PM

PHP Code:


			
<?php 
 session_start();
 
$db = mysql_connect("localhost","root","****") or die(mysql_error()); 
mysql_select_db("fdp",$db) or die(mysql_error()); 

if(isset($_POST['userid']) && isset($_POST['passwd']))
$userid = $_POST['userid'];
$passwd = $_POST['passwd'];
if(isset($_POST['fdplog']))

{

    $sql = "SELECT * FROM fdp_luser WHERE userid = '$userid' and passwd = '$passwd'";
    $result = mysql_query($sql);
    mysql_query($sql) or die('<hr />MySQL Error: ' .mysql_error(). '<hr />');
    $myrow = mysql_fetch_array($result);
    if($myrow) {
    $_SESSION['valid_user'] = $userid;
    header("Location: sespage.php");
}
else{
header("Location: error.php");
}    
}
?>
<html>
<body>

<style type="text/css">
<!--
body {
    margin-left: 20%;
    margin-top: 10%;
    
}

-->
</style>
<form name="form1" method="post" action="">
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>
    <label>SIGN IN <br>
    </label>
  <table width="760" height="27" border="5">
    <tr>
      <td width="714" bgcolor="#009966" scope="row">&nbsp;</td>
    </tr>
  </table>
    <label for="textfield"><br>
    <br>
    <br>
   
     <br>
   User Name :
  <input name="userid" type="Text" class="anytg15" value="<?php echo $userid ?>">
  <br>
   Password :
  <input name="passwd" type="password" class="any14" value="<?php echo $passwd ?>">
 
  <p>&nbsp;</p>
  <table width="760" height="27" border="5">
    <tr>
      <td width="714" bgcolor="#009966" scope="row">&nbsp;</td>
    </tr>
  </table>
  <p align="center">
    <label for="Submit"></label>
    <input type="Submit" name="fdplog" value="Sign In" id="Submit">
  </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</form>
</body>
</html>

Try that

I would also suggest you learn about making your login code more secure. A great place to start is http://www.ilovejackdaniels.com/php/writing-secure-php/

Jay

job0107 · #3 (**permalink**) 11-02-07, 11:53 PM

Here is another way.

You can keep everything on one page using a SWITCH.

PHP Code:


			
<?php session_start(); ?>
<html>
<head>
<style type="text/css">
<!--
body {margin-left: 20%;margin-top: 10%;}
-->
</style>
</head>
<body>
<?php
$sw = "";
if(isset($_POST['fdplog']))
{
 $userid = $_POST['userid'] != "" ? $_POST['userid'] : "";
 $passwd = $_POST['passwd'] != "" ? $_POST['passwd'] : "";
 if($userid && $passwd)
 {
  $db = mysql_connect("localhost","root","******") or die(mysql_error());
  mysql_select_db("fdp",$db) or die(mysql_error());
  $sql = "SELECT * FROM fdp_luser WHERE userid = '$userid' and passwd = '$passwd'";
  $result = mysql_query($sql);
  mysql_query($sql) or die('<hr />MySQL Error: ' .mysql_error(). '<hr />');
  $myrow = mysql_fetch_array($result);
  if($myrow){$_SESSION['valid_user'] = $userid;$sw = 1;}
  else{$sw = 2;}
  }
 if(!$sw){echo "<span style='font-size:20px;text-decoration:underline;color:#ff0000;'>Please enter the required information.</span>";}
 }
SWITCH($sw)
{
 case 1:
  echo "<span style='font-size:20px;text-decoration:underline;color:#000000;'>You are logged in as : ".$_SESSION['valid_user']."</span><br>";
  require "sespage.php";
  break;
 case 2:
  echo "<span style='font-size:20px;text-decoration:underline;color:#000000;'>Wrong UserName or Password !!!</span>";
  break;
 default:
?>
 <form name="form1" method="post" action="" style="margin:0px;">
   <p>
    <label>SIGN IN <br>
    </label>
   <table width="760" height="27" border="5">
    <tr>
      <td width="714" bgcolor="#009966" scope="row">&nbsp;</td>
    </tr>
   </table>
    <label for="textfield"><br>
    <br>
    <br>
    <br>
     User Name :
     <input name="userid" type="Text" class="anytg15" value="<?php echo $userid ?>">
    <br>
     Password :
     <input name="passwd" type="password" class="any14" value="<?php echo $passwd ?>">
    <p>&nbsp;</p>
    <table width="760" height="27" border="5">
     <tr>
      <td width="714" bgcolor="#009966" scope="row">&nbsp;</td>
     </tr>
    </table>
    <p align="center">
    <label for="Submit"></label>
     <input type="Submit" name="fdplog" value="Sign In" id="Submit">
    </p>
  </form>
<?php
  break;
  }
?>
</body>
</html>

bakarre · #4 (**permalink**) 11-05-07, 07:18 AM

Thanks alot, it works.
You can buy experience.

Bakarre