Login page in php ,mysql using using html form (source code)

Login page in php ,mysql using using html form

The  source code of login page in html using php and mysql connection is given below.


<?php
session_start();
include("connection.php");

?>
<form acion="" method="POST">
Username: <input type="text" name="username" value=""/><br><br>
Password: <input type="password" name="password" value=""/><br><br>
<input type="submit" name="submit" value="login"/>
</form>
<?php
if(isset($_POST['submit']))
{
$user=$_POST['username'];
$pwd=$_POST['password'];
$query="SELECT *FROM STUDENT WHERE username='$user' && password='$pwd'";
$data=mysqli_query($conn,$query);
$total=mysqli_num_rows($data);
if( $total==1)
{ $_SESSION['user_name']=$user;
header('location:home.php');
}
else{
echo "login failed";
}
}

?>

Comments

Post a Comment

Popular posts from this blog

how to compile multiple file in java using single command

Some times we need to compile multiple files with a single command. Though most programmer use IDe but sometimes we have command lines only. If your case is like that then you can use any of the following methods- 1. Specify all the files manually javac File1.java File2.java File3.java 2. Compile all .java file in the directory javac *.java This will compile all the Java files in the current directory.
Read more

Ternary operator and Nested Ternary operator

Ternary operator  Ternary operator which is a conditional operator and, as the name suggests, it takes three operands (parts). Ternary operator is available in most languages, like, C, C++, Java, JavaScript, etc  Syntax:-  variable = condition ? expression1_if_true : expression2_if_false Explanation: condition: This is a boolean expression that evaluates to either true or false. expression1_if_true: This is the value or statement that is executed if the condition is true. expression2_if_false: This is the value or statement that is executed if the condition is false.  Ternary operator is nothing, just a concise way of writing an if-else statement, i.e. the same operation can be achieved using an if-else block as shown below.  if(condition){     variable = value_if_true  }else{     variable = value_if_false  } Example 1 :- C program find max number among two given numbers using ternary operator #include <stdio.h> int mai...
Read more

How to pass argument in main function of java program using command line argument

Image
How to pass argument in main function of java program using command line       argument  There are only one way to pass argument in main() function of java program and that is using command  line .Here is the step by step procedure of how to pass argument using command line. As main function have a formal parameter i.e., args[] which is array of String type and accepts number of arguments passed during the run time of program through command line. This is  illustration of program to calculate the sum of number passed by user as argument in main function. public class CommandLine {   public static void main(String []args)    { int sum=o;       for(int i=0;i<args.length;i++)     {sum=sum+Integer.parseInt(args[i]); /* Here the argument accepted from command line are added one by one.But there is problem as command line arguments are of String type ,Hence we need to convert them before adding wh...
Read more