$_session in php/ login form/ signup form and with backend.php (dashboard.php/ logout.php) CODE

 

DATABASE 

Connection.php

<?php
$db_server = "localhost";
$db_username = "root";
$db_password = "";
$db_name = "projectone";
$conn = mysqli_connect($db_server, $db_username, $db_password, $db_name);
// if (!$conn)
// {
//     die("connection failed:".mysqli_connect_error());
// }
// echo "connected Successfully";  
?>


Login.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>login</title>
</head>
<body>
    <h1>Log In</h1>
<form method="POST" action="loginbackend.php">
    <label>Email :</label>
    <input type="text" name="user_email" placeholder="Enter Email"><br>

    <label>Password :</label>
    <input type="password" name="user_password" placeholder="Enter Password"><br>

    <button type="submit" name="user_submit">Login</button>    
</form>    
</body>
</html>

Loginbackend.php

<?php
include "conn.php";

if(isset($_POST["user_submit"])) 
{
    $vremail = $_POST["user_email"];
    $vrpassword = $_POST["user_password"];

    //testing sucessfully done
    // echo "$vremail";
    // echo "$vrpassword";

    $query = "SELECT * FROM projecttable WHERE dbemail='$vremail' AND dbpassword='$vrpassword'";
    $query_1 = mysqli_query($conn,$query);
    $no_of_data = mysqli_num_rows($query_1);
    echo $no_of_data."<br>";
    // exit(); mysqli_num_rows testing sucessfully done
    if ($no_of_data > 0) 
    {
        session_start();
        $_SESSION['projecttable']="projec   ttable";
        header("location:dashbord.php");
        echo "login sucessfull";
    }else {
        echo "wrong credential";
    }
}
?>

SignUp.php


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>sign up</title>
</head>
<body>
<h1>Sign Up</h1>
<form method="POST" action="signup_backend.php">
    <label>User Name :</label>
    <input type="text" name="client_username" placeholder="Enter Username"><br>

    <label>Email :</label>
    <input type="email" name="client_email" placeholder="Enter Email ID"><br>

    <label>Password :</label>
    <input type="password" name="client_password" placeholder="Enter Password"><br>

    <label>Role</label>
    <input type="text" name="client_role" placeholder="Enter Role"><br>

    <label>Mobile :</label>
    <input type="text" name="client_mobile" placeholder="Enter Mobile No"><br>

    <label>Gender :</label>
    <label>Male :</label>
    <input type="radio" name="client_gender" value="male">

    <label>Female :</label>
    <input type="radio" name="client_gender" value="female"><br>
    
    <button type="submit" name="client_submit">Sign Up</button>
</form>    
</body>
</html>

signupbackend.php


<?php
include "conn.php";

if (isset($_POST["client_submit"])) 
{
    $vrusername = $_POST["client_username"];
    $vremail = $_POST["client_email"];
    $vrpassword = $_POST["client_password"];
    $vrrole = $_POST["client_role"];
    $vrmobile = $_POST["client_mobile"];
    $vrgender = $_POST["client_gender"];

    //testing sucessfully done!!!
    // echo $var_username."<br>";
    // echo $var_email."<br>";
    // echo $var_password."<br>";
    // echo $var_role."<br>";
    // echo $var_mobile."<br>";
    // echo $var_gender;
    // exit();
    
    $inserting = "INSERT INTO projecttable(dbusername, dbemail, dbpassword, dbrole, dbmobile,  dbgender) 
    VALUES('$vrusername', '$vremail', '$vrpassword', '$vrrole', '$vrmobile', '$vrgender')";
    $result = mysqli_query($conn,$inserting);
    
    //testng sucessfully done!!!
    // if ($result) 
    // {
    //     echo "data insert into database";
    // }else {
    //     echo "all field are required";
    // }
}
?>

dashboard.php


<?php
echo "welcome to dashboard";
session_start();
if (!isset($_SESSION['projecttable'])) 
{
    header("location:login.php");
}
echo $_SESSION['projecttable']."<br>";
?>
<a href="logout.php"><button>LOGOUT</button></a>


logout.php

<?php
session_start();
session_destroy();
header("location:login.php");
?>



Comments

Post a Comment

Popular posts from this blog

C.R.U.D Oparetion in (PHP Code)

C.R.U.D Oparetion   index.php <?php include "conn.php"; if (isset($_POST["usersubmit"]))  {     $vrname = $_POST["username"];     $vremployee = $_POST["useremployee"];     $vrsalary = $_POST["usersalary"];     $vrgender = $_POST["gender"];     //testing sucessfully complete     // echo $vrname;     // echo $vremployee;     // echo $vrsalary;     // echo $vrgender;     // exit();     $inserting = "INSERT INTO dbemployeelist(dbname, dbemployee, dbsalary, dbgender) VALUES('$vrname', '$vremployee', '$vrsalary', '$vrgender')";     $connecting = mysqli_query($conn,$inserting); } ?> <!DOCTYPE html> <html lang="en"> <head>     <title>Document</title>     <style>         form{             text-align:center;             padding:2...
Read more

Search Dropdown - jQuery

Image
<select name="vehicle_no" id="vehicle_no" class="form-control select" >   <option value="" >Select Vehicle</option>      <?php //echo $vchVehicleNumber;exit;?>           @foreach($vehiclesData as $data)              <option {{(isset($vchVehicleNumber) && $vchVehicleNumber == $data['vehicleno'])?'selected':''}} value="{{ $data['vehicleno'] }}" >{{ $data['vehicleno'] }}</option>              @endforeach </select> // jQuery:- you have to add CDN of select2 jquery $("#vehicle_no").select2({   minimumResultsForSearch: Infinity }); $('#vehicle_no').select2({    minimumInputLength: 0  });
Read more

Laravel - Dependent Drop Down Using Ajax

Image
  Resources\View\ index.blade.php: <h1> Dependent Drop Down </h1>     <select name="country" id="country">         <option hidden>Select Country</option>         @foreach($country as $list)         <option value="{{$list->id}}">{{$list->country}}</option>         @endforeach     </select>     <select name="state" id="state">         <option hidden>Select State</option>         <option value=""></option>     </select>     <select name="city" id="city">         <option hidden>Select City</option>         <option value=""></option>     </select> </body> <script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJ...
Read more