Simple login form using PHP and MySQL.

The login form is very much essential in every kind of web application so here we are explaining a simple and best way of doing login system. which mainly includes 
1. Connecting to Database
2. Login(Session Start)
3. Logout(Session End)
4. Session Check
5. Login Form
6. CSS

1. Connecting to Database

$DatabaseServer = "localhost";
$DatabaseUsername = "root";
$DatabasePassword = "root";
$DatabaseName = "demo";

$Connection = mysqli_connect($DatabaseServer, $DatabaseUsername, $DatabasePassword, $DatabaseName);

if ($Connection === false) {
    die("ERROR: Could not connect. " . mysqli_connect_error());
}



2. Login

session_start();
if (isset($_POST['username']) and isset($_POST['password'])) {
   
    $Username = $_POST['username'];
    $Password = $_POST['password'];
    $query = "SELECT * FROM `user` WHERE FirstName='$Username' and Password='$Password'";
    $result = mysqli_query($Connection, $query) or die(mysqli_error($connection));
    $count = mysqli_num_rows($result);

    if ($count == 1) {
        $_SESSION['username'] = $
Username;
    } else {
        $fmsg = "Invalid Login Credentials.";
    }
}


3. Logout

session_start();
session_destroy();
header('Location: login.php');


4. Session Check

if (isset($_SESSION['username'])) {
    
    echo "<div class='session-box'>";
    echo 'Welcome Mr.'.$Username = $_SESSION['username'];
    echo "<br><a href='logout.php'>Logout</a>";
    echo "</div>";
}else{
    
    echo "<div class='session-box'>";
    echo "You are logged out.";
    echo "</div>";

}

5. Login Form

<form method="POST" class="login-box">

    <div class="form-header">Please Login</div>

    <div class="col-md-12">  
        <label>Username</label>
        <input type="text" name="username" class="form-control" placeholder="Username" required>
    </div>

    <div class="col-md-12">
        <label>Password</label>
        <input type="password" name="password" class="form-control" placeholder="Password" required>
    </div>

    <div class="col-md-6">
        <button class="btn btn-primary" type="submit">Login</button>
    </div>

</form>

6.CSS

 <head>
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
        <style>
            .login-box{
                position: absolute;
                width: 300px;
                height: 270px;
                z-index: 15;
                top: 50%;
                left: 50%;
                margin: -100px 0 0 -150px;
                border: 1px solid #8080804a;
                border-radius: 5px;
                background: #8080804a;
            }
            .session-box{
                position: absolute;
                width: 300px;
                height: 100px;
                z-index: 15;
                top: 10%;
                left: 50%;
                margin: 0px 0 0 -150px;
                border: 1px solid #8080804a;
                border-radius: 5px;
                background: #8080804a;
                padding: 30px;
            }
            .form-control{
                padding: 10px;
                margin-top: 5px;
            }
            .btn-primary{
                margin-top: 20px;
            }
            .form-header{
                width: 299px;
                height:40px;
                background: #004f61;
                color:white;
                text-align: center;
                font-size: 20px;
                margin-bottom: 20px;
                padding: 5px;
            }
        </style>

    </head>

Create Database Table

CREATE TABLE `user` (
  `UserID` int(12) NOT NULL,
  `FirstName` varchar(48) NOT NULL,
  `LastName` varchar(48) NOT NULL,
  `Email` varchar(128) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `City` varchar(48) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `user` (`UserID`, `FirstName`, `LastName`, `Email`, `Password`, `City`) VALUES
(7, 'Rahul', 'Rajshekaran', 'Rahul@zzz.xxx', 'Rahul@123', 'Pune'),
(8, 'Mahesh', 'Krishna', 'Mahesh@xxx.xxx', 'Mahesh@123', 'Delhi');







Result




45 comments:

  1. You can actively talk with our experts through Staples Chat Support. They will help you 24/7 to address all your device problems.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Book Flights to Nashville. Get Cheap flights to Nashville Guaranteed on a huge option of flights deals to Nashville. Grab this attractive offer now.

    ReplyDelete
  4. Wonder in the new place full of museums and parks by taking Flights From New York to Las Vegas. Get your bookings done with our travel agents and make your next journey adventurous. Book soon to get early bird offers.

    ReplyDelete
  5. Extremely common to handle banking errors like QuickBooks Error code 9999. When such an error takes place, the machine tends to freeze for a couple of seconds on repeat. This example can obviously affect business awfully. If you want to Fix QuickBooks Error 9999 then you may contact our ProAdvisors.

    ReplyDelete
  6. You are able to download Office.com/setup com setup on the internet for receiving the benefits of word, excel and other utilities that are extremely helpful for documentation and also for company purposes. We give you online assistance for each and every sort of problems and assistance from Office.
    Office.com/setup

    ReplyDelete
  7. Hi there, just became aware of your blog through Google, and found that it's really informative. I’m going to watch out for brussels. I will be grateful if you continue this {in future}. Many people will be benefited from your writing. Cheers! nature's way Singapore

    ReplyDelete
  8. Air China Airlines Customer Service is available 24*7 to help you. Reach experts at Air China Airlines Customer Service Phone Number now for queries.

    ReplyDelete
  9. This is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. app development services

    ReplyDelete
  10. Wow! Thank you! I always needed to write on my website something like that. Can I implement a part of your post to my site? events backdrop

    ReplyDelete
  11. Sweet blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I've been trying for a while but I never seem to get there! List of Accounting & Tax Companies in Singapore

    ReplyDelete
  12. Best Deals at Safemartshop, an international prescription service provider, which contracts with International dispensaries and USA pharmacies, is a leader in referring orders for prescription and non-prescription medications on behalf of customers throughout the world
    Safemartshop
    buy hydrocodone online
    buy oxycodone online
    buy oxycontin online
    buy percocet online
    buy vicodin online
    buy norco online
    buy adderall online
    buy xanax online

    ReplyDelete
  13. If you are QuickBooks user and getting QuickBooks error 2107 then you can read the post and fix it or Call Quickbooks Helpline Number 1-800-242-0792.
    QuickBooks error 2107

    Fix QuickBooks error

    Quickbooks Helpline Number

    Quickbooks Support Number

    ReplyDelete
  14. If you suddenly find yourself in Facebook jail and you don't even know how this happened, then here you will get detailed information on how to get yourself out of Facebook jail.

    blocked from posting on Facebook
    Facebook Jail
    how long does Facebook block you
    get out from Facebook Jail

    ReplyDelete
  15. Intuit has recommended some solutions which could correct the error with expert guidance from QuickBooks Error 15243 ProAdvisors. Stick to the resolution steps within the given sequence so your best results can be obtained.

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete
  17. QuickBooks Error 6175 is an easy and trustworthy program for almost any business now each day. QuickBooks program can handle data that is employed by every business to produce their venture, track their records and in addition tracks their transaction.

    ReplyDelete
  18. There are various other reasons as well that are mentioned below. Methods to resolve the QuickBooks Error 83 are mentioned you'll want to opt in accordance with the reason associated with problem.

    ReplyDelete
  19. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.

    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    The Nodejs Projects Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete
  20. Using QuickBooks software, the user can simply create invoices in QuickBooks and invoice tax payments with the filing invoice tax returns of the organizations. So get proper and complete guidance on how to create many types of invoices by connecting to our amazing QuickBooks Support Phone Numberr services.

    ReplyDelete
  21. Despite being a technological invention, Big Data Analytics is an art that handled correctly can drive your business to success. Although it could be the most preferable and reliable way of taking important decisions there are challenges such as cultural barrier. data science course syllabus

    ReplyDelete
  22. Best Deals at buyonlinekart, an international prescription service provider, which contracts with International dispensaries and USA pharmacies, is a leader in referring orders for prescription and non-prescription medications on behalf of customers throughout the world
    buyonlinekart

    ReplyDelete
  23. Best place to buy hydrocodone online Hydrocodone is used to relieve severe pain. Again, hydrocodone is only used to treat people who are expected to need medication to relieve severe pain around-the-clock for a long time and who cannot be treated with other medications or treatments. Call Now 1-805-335-6339.
    buy hydrocodone online

    ReplyDelete
  24. Buy Oxycontin Online. OxyContin (oxycodone HCl) is indicated for the management of pain severe enough to require daily, around-the-clock, long-term opioid treatment and for which alternative treatment options are inadequate. Limitations of Use. Call Now 1-805-335-6339.
    buy oxycontin online

    ReplyDelete
  25. Buy Percocet Online which is used to help relieve moderate to severe pain. It contains a opioid (narcotic) pain reliever (oxycodone) and a non-opioid pain reliever (acetaminophen). Oxycodone works in the brain to change how your body feels and responds to pain. Call Now 1-805-335-6339.
    buy percocet online

    ReplyDelete
  26. In the event that you are hoping to buy Vicodin online or you want Vicodin for sale, Our online drug store is the ideal asset for individuals to get their medications without remedy or any issues or ponderousness. We endeavor to profit each time you shop with us. For the reason that At our online store, you save money and get more. Call Now 1-805-335-6339.
    buy vicodin online

    ReplyDelete
  27. Buy Norco online Buy Norco online-without prescription,without any hassle with securepharma . We have best panel of doctors registered with us,who is taking care of all formalities like valid doctor’s prescription and all.To buy Norco online please make an order on our website or you can also call our executive. Call Now 1-805-335-6339.
    buy norco online

    ReplyDelete
  28. Buy Adderall online for Adults and children now without prescription, only at heyleel.com It is a time-released drug so that its effects and benefits are given throughout the day and people who need it can perform well without symptoms from their condition. Call Now 1-805-335-6339.
    buy adderall online

    ReplyDelete
  29. Buy Xanax online Alprazolam , sold as the trade name Xanax among others, is a short-acting benzodiazepine. It is most commonly used in short term management of anxiety disorders, specifically panic disorder or generalized anxiety disorder . Call Now 1-805-335-6339.
    buy xanax online

    ReplyDelete
  30. At percocetonline, you can safely and secure buy percocet online without prescription. Products are of the best quality from FDA Approved facilities. The packaging is safe and shipping is 100% discreet and delivery is very fast.
    Buy Percocet Online
    Buy Ambien Online
    Buy Norco Online
    Buy Adderall Online
    Buy Xanax Online

    ReplyDelete
  31. Best Sellers Prime Customer Service New Releases Today's Deals Find a Gift Books Gift Cards Kindle Books Fashion Pharmacy Amazon Basics Toys & Games Sell Amazon Home Computers Coupons Video Games Home Improvement Automotive #FoundItOnAmazon ... we offer a number of options for customer support.
    Amazon customer service phone number
    Amazon prime customer support phone number
    Amazon prime customer service
    Nowwiz

    ReplyDelete
  32. Best Deals at buyonlinekart, an international prescription service provider, which contracts with International dispensaries and USA pharmacies, is a leader in referring orders for prescription and non-prescription medications on behalf of customers throughout the world
    buyonlinekart
    buy hydrocodone online
    buy oxycodone online
    buy oxycontin online
    buy percocet online
    buy vicodin online
    buy norco online
    buy adderall online
    buy xanax online

    ReplyDelete
  33. Buy Online medicines without prescription, overnight delivery via FedEx at a discounted price in the United States. Top-quality Medicines

    buy Percocet online

    ReplyDelete
  34. Order Xanax overnight delivery in USA

    Xanax is a medicine used to treat anxiety, panic disorders and depression induced anxiety. It is known to produce a calming effect on the brain and the nerves by normalizing the imbalance in certain nerves. It works on by reducing nervousness and thus improves energy levels as well. Misuse of this drug can lead to addiction, overdose & even death in some cases due to complications hence it is really necessary to read all about it before you buy xanax online for use.

    Visit - Tramadol100mg.org

    Order - Buy Xanax Online

    ReplyDelete
  35. Oxycodone is a synthetic opioid used for the treatment of mild to moderate pain. This opioid is used for around the clock treatment of pain and should not be used otherwise or it can prove to be very severe. Misuse of this medication may result in drug dependency.
    Buy Xanax Online
    Buy Adderall Online
    Buy Oxycodone Online

    ReplyDelete
  36. Adderall is a combination of medicine that is used to cure ADHD and sleeping disorders. It belongs to a class of drugs known as stimulants. It helps to increase the ability to pay attention, keep a check on behavioral problems, and focusing on an activity.

    Buy Adderall Online
    Buy Xanax Online
    Buy Tramadol online

    ReplyDelete

  37. Online Medz Pharmacy is a website that provides various types of medications. We help the persons who are suffering from some severe diseases like sleep disorder, ADHD, Weight loss, pain relief and anxiety disorder by providing them Xanax, Vicodin, Tramadol, and other drugs. We have all types of Generics and brands of medications with several strengths.

    Ambien 10mg Online
    Buy Methadone Online
    Buy Oxycontin Online
    Buy Percocet Online
    Buy Adderall Online
    Buy Xanax Online

    ReplyDelete
  38. thanks!
    Adipex , is also known as Phentermine is a drug that is used for the purpose of weight loss. It is a medicine that has to be issued under the proper guidance of a doctor or a physician. Adipex 375mg helps in the process of losing weight. It is necessary for you to keep a check on your diet for the results can achieve as soon as possible.

    Buy Adipex 375mg Online
    Buy Adderall XR 5mg Online

    ReplyDelete

  39. Online Medz Pharmacy is a website that provides various types of medications. We help the persons who are suffering from some severe diseases like sleep disorder, ADHD, Weight loss, pain relief and anxiety disorder by providing them Xanax, Vicodin, Tramadol, and other drugs. We have all types of Generics and brands of medications with several strengths.

    Buy Ativan 1mg Online
    Buy Oxycontin Online
    Buy Percocet Online
    Buy Adderall Online
    Buy Xanax Online

    ReplyDelete
  40. Medical Pharmacy USA
    * No Prescription Required (NO RX)
    * Buy Direct and Save Time with Cryptocurrency
    * Reshipment is offered if the package does not get to location or refunds
    * High-Quality Pharmacy Grade Medicines.
    * Best and Affordable prices

    Buy Adderall Online | Buy Alprazolam 2mg Online | Buy Ambien 10mg Online | Buy Ativan Online Overnight Delivery | Buy Cheap Carisoprodol Online | Diazepam for Sale USA | Buy generic Fioricet Online | Best Place to Buy hydrocodone Online | Buy Lortab Online Legally | Buy Soma pills Online | Buy Cheap Xanax Online
    Buy Medicine Online

    ReplyDelete
  41. Welcome to Research Chem Lab We are USA and Euro based company specializing in retails wholesale distribution of the best pain medications. Note: We don’t manufacture this products we buy them from a network of highly qualify and trusted manufacturers.

    buy xanax 2mg online, buy Xanax online,Xanax For Sale On The Internet, Xanax For Sale   
    buy adderall 30mg online   
    buy rohypnol 2mg online   
    buy Valium 10mg online   
    buy percocet online   
    buy hydrocodone online    
    buy oxycodone online  
    buy klonopin online

    ReplyDelete

Labels

php (35) javascript (31) phpjavascript (30) jquery (23) html (20) mysql (14) database (9) codeigniter (4) json (4) bar chart (2) calendar (2) column chart (2) framework (2) google maps (2) query (2) tables (2) url (2) dropdown (1)

Popular Posts