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:20px;

            font-size:22px;

            background-color:red;

            border:20px solid black;

            font-style: italic;

            }

        form input{

            padding:6px;

            border-radius:10px;

            margin:6px;

            }

        h1{

            text-align:center;

            font-size:50px;

            background-color:green;

            font-style: italic;

            }

        button{

            background-color:black;

            color:white;

            border:none;

            padding:12px;

            font-size:12px;

            border-radius:20px;

        }

        

    </style>

</head>

<body>

    <h1>Employee record</h1>

    <form method="POST">

        Name :<input type="text" name="username"><br>

        Employee :<input type="text" name="useremployee"><br>

        salary :<input type="text" name="usersalary"><br>

        Male :<input type="radio" name="gender" value="male" checked><br>

        female :<input type="radio" name="gender" value="female"><br>


        <button type="submit" name="usersubmit">Click Here</button>

    </form>

</body>

</html> 


TABLE FILE



<?php
include "conn.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>Document</title>
</head>
<body> 
    <table border="2">
        <tr>
            <th>Sl No</th>
            <th>Name</th>
            <th>Employee</th>
            <th>Salary</th>
            <th>Gender</th>
            <th>Action</th>
        </tr>
        <?php
            $tableprint =  "SELECT * FROM dbemployeelist";
            $tableconnect = mysqli_query($conn,$tableprint);
            $increment = 0;
            while ($v = mysqli_fetch_array($tableconnect)) 
            {
                $increment++;
        ?>
        <tr>
            <td><?php echo $increment;?></td>
            <td><?php echo $v["dbname"]?></td>
            <td><?php echo $v["dbemployee"]?></td>
            <td><?php echo $v["dbsalary"]?></td>
            <td><?php echo $v["dbgender"]?></td>
            <td>
            <a href="edit.php?edit_id=<?php echo $v['dbid']?>"><button type="button" style="background-color:green;">Edit</button></a>
            <a href="deletefile.php?delete_id=<?php echo $v['dbid'] ?>"><button type="button" style="background-color:yellow;">Delete</button></a>
            </td>
        </tr>
        <?php
            }
        ?>
    </table>
</body>
</html>


EDIT FILE.PHP



<?php 
include "conn.php";

if (isset($_GET["edit_id"])) 
{
    $edit_id = $_GET["edit_id"];
    
    $view_qry = "SELECT * FROM dbemployeelist WHERE dbid='$edit_id'";
    $view_qry_a = mysqli_query($conn, $view_qry);
    $view_qry_b = mysqli_fetch_array($view_qry_a);
    $gender = $view_qry_b["dbgender"];
}
if (isset($_POST["usersubmit"])) 
{
    $ids = $_POST["ids"];
    $vrname = $_POST["username"];
    $vremployee = $_POST["useremployee"];
    $vrsalary = $_POST["usersalary"];
    $vrgender = $_POST["gender"];
    
    // echo $vrname;
    // echo $vremployee;
    // echo $vrsalary;
    // echo $vrgender;
    // exit();

    $updating = "UPDATE dbemployeelist SET dbname='$vrname',dbemployee='$vremployee',dbsalary='$vrsalary',dbgender='$vrgender' WHERE dbid = '$ids'";
    $connecting = mysqli_query($conn,$updating);
    if ($connecting) 
    {
        header("Location:table.php");
    }  
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <title>Document</title>
</head>
<body>
    <h1>Employee record</h1>
    <form method="POST">
        <input type="hidden" name="ids" value="<?php echo $view_qry_b['dbid']?>"><br>
        Name :<input type="text" name="username" value="<?php echo $view_qry_b['dbname']?>"><br>
        Employee :<input type="text" name="useremployee" value="<?php echo $view_qry_b['dbemployee']?>"><br>
        salary :<input type="text" name="usersalary" value="<?php echo $view_qry_b['dbsalary']?>"><br>
<?php
switch($gender)
{
    case 'male':
        echo 'Male :<input type="radio" name="gender" value="male" checked><br>
        female :<input type="radio" name="gender" value="female"><br>';
    break;
    case 'female':
        echo 'Male :<input type="radio" name="gender" value="male" ><br>
        female :<input type="radio" name="gender" value="female" checked><br>';
    break;
    default:
        echo 'Male :<input type="radio" name="gender" value="male" ><br>
        female :<input type="radio" name="gender" value="female">';
}
?>
        <button type="submit" name="usersubmit" style="background-color:black; color:white;">Edit</button>
    </form>
</body>
</html>


DELETE FILE.PHP


<?php
include "conn.php";

if (isset($_GET["delete_id"])) 
{
    $deletee = $_GET["delete_id"];
    
    $dele = "DELETE FROM dbemployeelist WHERE dbid = '$deletee'";
    $deleta = mysqli_query($conn,$dele);

        if ($deleta) 
        {
            header("Location:table.php");
        }
}
?>


DATABASE CONNECTION CODE (conn.php)




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

    

            
    

Comments

Post a Comment

Popular posts from this blog

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

Ajax Crud Oparetion (Only Insert Code "create") | PHP | Jquery | Ajax | CODE

Image
 index.php(Frontend & ajax) <!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>Document</title> </head> <body>     <form id="aj">     Name :<input type="text" name="u_name">     Mobile :<input type="text" name="u_mob">     <button type="button" onclick="user_submit();">SEND</button >     <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>     <script>         function user_submit()          {             var send = new FormData(aj);             // console.log(send);   ...
Read more