PHP Login Page With Database Connection

-

 

In order to create a login page using php and html, several steps must be taken.

Step 1:

First we need to create database_connection.php page

database_connection.php

<?php

    $Server_name="localhost";

    $Username="root";

    $Password="";

    $Database="details_db";

    $link=mysqli_connect($Server_name,$Username,$Password,$Database);

?>


Step 2:

Make a table called details_db,and create a tale called admin_tbl.

The table has four columns:admin_id,username,password,and created_date(its an optional).


Step 3:

Login_page.html

<html>

    <head>

        <title>PHP LOGIN PAGE WITH DATABASE CONNECTION<title>

    </head>

    <body>

        <center>ADMIN LOGIN <br><br>

        <form action="Login_process.php" method="POST">

            Enter Username <input type="text" name="username" ><br><br>

            Enter Password <input type="password" name="pass"><br><br>

            <input type="submit" value="Login">

        </form>

</center>

    </body>

</html>




Step 4:

Login_process.php

<?php

    include("database_connection.php");

    $user_name=$_POST['username'];

    $password=$_POST['pass'];

    $true_flag=0;

    $query="Select * from admin_tbl where username='$user_name' and password='$password'";

    $result=$link->query($query);

    while ($row=mysqli_fetch_array($result))

        {

            $true_flag=1;

        }

        if($true_flag==0)

        {

            echo "Login Failed";

        }else{

            echo "Successful";

        }

?>












Comments

Post a Comment

Popular posts from this blog

Validation Code For Phone Number Using preg_match() in Php

-
Image
Phone Number Validation Using preg_match() Below code shows validation of Phone Number 1)Checking whether user input (Phone Number) contains an alphabet in Phone Number          <?php         $mobile_no="123fdgdg890";        if(preg_match("/[a-z][A-Z]/i", $mobile_no))        {   echo "Invalid Phone Number!";        }else{                echo "Valid Phone Number!";        }      ?> Output :Invalid Phone Number! Syntax preg_match("/[a-z][A-Z]/i", $mobile_no) The above syntax will verify whether given phone number is well-formed or not.if it is not, it will show an error message. The    preg_match()  function helps to find whether a given variable is valid or not. 2 )Checking whether user input (Phone Number) contains 10 digits in Phone Number      <?php...
Read more

Writing data to a file using Python

-
  Writing data to a file using Python Writing data to a file in Python can be done in a variety of ways, depending on the file type and how you want to save the data. Here's a general guide to common formats. 1. Writing Text to a Plain Text File # Writing text data data = "This is some text data." # Open a file in write mode ('w') and write data with open("output.txt", "w") as file:     file.write(data) 2. Writing Data to a CSV File import csv # Data to write data = [     ["Name", "Age", "City"],     ["Rajesh", 25, "India"],     ["Shaun", 30, "San Francisco"],     ["Afzal", 35, "Chicago"] ] # Writing to a CSV file with open("output.csv", "w", newline="") as file:     writer = csv.writer(file)     writer.writerows(data) 3. Writing Data to a JSON File import json # Data to write data = {     "Name": "Alice", ...
Read more

Update and Delete Record Using PHP and MySQL

-
Update and Delete Record Using PHP and MySQL UPDATE  Query :  To Update data in your Database Syntax: UPDATE Table_name SET column=value WHERE other_column = other_value DELETE Query To delete the record from your Database To delete the data frothe m database you should use the DELETE query, the syntax is given below: DELETE  FROM Table_name WHERE column = value                                                                                                                                                      HAPPY CODING😍
Read more