Jump to content

Archived

This topic is now archived and is closed to further replies.

saikiranreddy

login validation from sql table

Recommended Posts

i want seperate error messages for username and password ..but in below code i am not getting ..can anybody check this and make changes ...thanks

 

 

 

<html>

<head>

</head>

<body>

<form action='login.php' method='post'>

User name:<input type='text' name='name'/>

Password:<input type='password' name='pwd'/>

<input type='submit' name='submit' value='Submit'/>

</form>

<?php

session_start();

if(isset($_POST['submit']))

{

mysql_connect('localhost','root','saibaba92@');

mysql_select_db('new');

$name=$_POST['name'];

$pwd=$_POST['pwd'];

if($name != '' && $pwd != '')

{

$query=mysql_query("select * from login1 where Name='$name' AND password='$pwd'");

$sql=mysql_fetch_array($query);

if(($sql['Name']==$name)&&($sql['password']==$pwd))

{

$_SESSION['name']=$name;

header("Location:welcome.php");

}

else if(($sql['password']==$pwd)&&($sql['Name']!=$name))

 {

 echo 'username is incorrect';

 }

 else{

 echo 'password is incorrect';

 }

 }

 else

 {

  echo'Enter both username and password';

 }

 }

?>

</body>

</html>

Share this post


Link to post
Share on other sites

 

i want seperate error messages for username and password ..

 

 

No, you really don't want to do that. It just helps hackers by telling them which bit they got correct.

Share this post


Link to post
Share on other sites

×
×
  • 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.