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

 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);

            $.ajax({
                data : send,
                type : "POST",
                url : "backii.php",
                processData : false,
                contentType : false,
                success :function(response) 
                {
                    console.log(response);
                }

            })    
        } 
    </script>
</body>
</html>


backii.php(Backend Code)


<?php
//testing successfull
// echo "successfull Shuvadeep";

$conn = mysqli_connect("localhost","root","","practice_ajax");
    if (!$conn) 
    {
        echo "ERROR in Data Insertion";
    }


    $v_name = $_POST["u_name"];
    $v_mob = $_POST["u_mob"];

    // echo $v_name;
    // echo $v_mob;
    // exit();


$query = "INSERT INTO ajax_table (DB_name,DB_password) VALUES('$v_name','$v_mob')";
$connection = mysqli_query($conn, $query);

if ($query)
{
    echo "inserted";
}else{
    echo "not Inserted";
}
?>

Database Screenshot





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

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