Jump to content

login validation from sql table


saikiranreddy

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>

Link to comment
https://forums.phpfreaks.com/topic/295308-login-validation-from-sql-table/
Share on other sites

Archived

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

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