How to Delete record using PHP Ajax

-

index.php

 
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
<!DOCTYPE html>
<html>
<head>
    <title></title>
</head>
<body>
 
<?php
 
    $connection = mysqli_connect("localhost","root","","db_2018") or die(mysqli_error());
 
    $ReadSql = "SELECT * FROM `crud`";
    $res = mysqli_query($connection, $ReadSql);
 ?>
 
 <table>
    <tr>
        <th>name</th>
        <th>Last Name</th>
        <th>email id</th>
        <th>gender</th>
        <th>age</th>
        <th>Action</th>
    </tr>
 
    <?php while($fetch = mysqli_fetch_array($res)) {
 
        extract($fetch);
 
 
 
 
?>
 
<tr>
    <td><?php echo $fetch['first_name']; ?></td>
    <td><?php echo $fetch['last_name']; ?></td>
    <td><?php echo $fetch['email_id']; ?></td>
    <td><?php echo $fetch['gender']; ?></td>
    <td><?php echo $fetch['age']; ?></td>
    <!-- <input type="hidden" name="" id="v" value="<?php //echo $fetch['id']; ?> "> -->
    <td><a href="javascript:;" class='delete' id='<?php echo $fetch['id']; ?>'>Delete</a></td>
</tr>
 
        <?php } ?>
 </table>
 
 
 
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript">
    $(document).ready(function(){
 
 
        $(".delete").click(function (){
 
            var id= $(this).attr("id");
 
            $.get("delete.php",{id:id},function(data){
                     
                    alert('deleted successfully');
 
                });
 
        });
 
    });
     
 
 
 
</script>
</body>
</html>
 
 

<!DOCTYPE html>
<html>
<head>
    <title></title>
</head>
<body>

<?php 

    $connection = mysqli_connect("localhost","root","","db_2018") or die(mysqli_error());

    $ReadSql = "SELECT * FROM `crud`";
    $res = mysqli_query($connection, $ReadSql);
 ?>

 <table>
    <tr>
        <th>name</th>
        <th>Last Name</th>
        <th>email id</th>
        <th>gender</th>
        <th>age</th>
        <th>Action</th>
    </tr>

    <?php while($fetch = mysqli_fetch_array($res)) {

        extract($fetch);




?>

<tr>
    <td><?php echo $fetch['first_name']; ?></td>
    <td><?php echo $fetch['last_name']; ?></td>
    <td><?php echo $fetch['email_id']; ?></td>
    <td><?php echo $fetch['gender']; ?></td>
    <td><?php echo $fetch['age']; ?></td>
    <!-- <input type="hidden" name="" id="v" value="<?php //echo $fetch['id']; ?> "> -->
    <td><a href="javascript:;" class='delete' id='<?php echo $fetch['id']; ?>'>Delete</a></td>
</tr>

        <?php } ?>
 </table>



<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript">
    $(document).ready(function(){


        $(".delete").click(function (){

            var id= $(this).attr("id");

            $.get("delete.php",{id:id},function(data){
                    
                    alert('deleted successfully');

                });

        });

    });
    



</script>
</body>
</html>

delete.php

 
01
02
03
04
05
06
07
08
09
10
11
<?php
       
$con = mysqli_connect("localhost","root","","db_2018");
     
        $id=$_GET['id'];
     
    $del_query=mysqli_query($con,"delete from crud where id='$id'") or die(mysqli_error($con));
     
 
 
?>
 
 

<?php
      
$con = mysqli_connect("localhost","root","","db_2018");
    
        $id=$_GET['id'];
    
    $del_query=mysqli_query($con,"delete from crud where id='$id'") or die(mysqli_error($con)); 
    


?>

Comments

  1. Unknown21 August 2018 at 00:03

    Your blog is so nice, and the article is very good it helps to so many people.
    PHP Training in Hyderabad

    ReplyDelete
  2. Sameer Shahni18 January 2019 at 21:27

    Want to get ranked your business on the top? Contact Shahni Digital Media, one of the fastest growing Digital Marketing Company in India. We provide web development solution, orm, ppc, smm, sem etc.
    Digital Marketing Company Bhopal
    Website Designing Company Bhopal
    SEO Company in Bhopal
    ORM Company India

    ReplyDelete
  3. Shriyanka5 September 2019 at 23:29

    Thanks for sharing such an informative blog.
    PHP Classes in Bangalore
    Web Designing Training in Bangalore
    UI/UX Design Courses in Bangalore

    ReplyDelete
  4. Sangita25 March 2020 at 23:38

    I need to to thank you for this excellent read!! I absolutely loved every bit of it. I have you saved as a favorite to look at new things you post…
    UI Development Training in Bangalore
    Reactjs Training in Bangalore

    ReplyDelete
  5. Jackrichard27 June 2020 at 09:58

    I undoubtedly welcome the way wherein you continue posting such shocking and huge articles and continue empowering your blog with most recent bearing. Keep up this goliath work. Keep framing. Dedicated hosting reviews

    ReplyDelete
  6. IICT Technologies28 July 2020 at 09:14

    Thank you for sharing this post.
    SAP Training in Chennai
    Hardware and Networking Training in Chennai
    Cloud Computing Training in Chennai
    Pearson Vue Exam Center in Chennai
    Oracle Training in Chennai
    .Net Training in Chennai
    Java Training in Chennai
    Software Testing Training in Chennai
    AWS Training in Chennai
    CCNA Training in Chennai

    ReplyDelete
  7. aravind6 August 2020 at 22:29

    Great Article ,I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    DevOps Training in Chennai

    DevOps Online Training in Chennai

    DevOps Training in Bangalore

    DevOps Training in Hyderabad

    DevOps Training in Coimbatore

    DevOps Training

    DevOps Online Training

    ReplyDelete
  8. lavanya13 August 2020 at 19:32

    Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign.thanks lot!!

    Java training in Chennai

    Java Online training in Chennai

    Java Course in Chennai

    Best JAVA Training Institutes in Chennai

    Java training in Bangalore

    Java training in Hyderabad

    Java Training in Coimbatore

    Java Training

    Java Online Training

    ReplyDelete
  9. surya17 August 2020 at 05:06

    thank you for the information. it is useful and informative



    angular js training in chennai

    angular training in chennai

    angular js online training in chennai

    angular js training in bangalore

    angular js training in hyderabad

    angular js training in coimbatore

    angular js training

    angular js online training

    ReplyDelete
  10. radhika23 August 2020 at 03:58


    Thanks for your interesting ideas.the information's in this blog is very much useful for me to improve my knowledge.

    AWS Course in Chennai

    AWS Course in Bangalore

    AWS Course in Hyderabad

    AWS Course in Coimbatore

    AWS Course

    AWS Certification Course

    AWS Certification Training

    AWS Online Training

    AWS Training


    ReplyDelete
  11. vivekvedha23 August 2020 at 23:24

    I need to to thank you for this excellent read!! I absolutely loved every bit of it. I have you saved as a favorite to look at new things you post…
    acte reviews

    acte velachery reviews

    acte tambaram reviews

    acte anna nagar reviews

    acte porur reviews

    acte omr reviews

    acte chennai reviews

    acte student reviews

    ReplyDelete
  12. rocky26 August 2020 at 01:45

    I need to to thank you for your time due to this fantastic read!! I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
    python training in bangalore

    python training in hyderabad

    python online training

    python training

    python flask training

    python flask online training

    python training in coimbatore
    python training in chennai

    python course in chennai

    python online training in chennai

    ReplyDelete
  13. Revathi28 August 2020 at 04:40

    JavaScript will remain a very popular language for years to come. it would be suicide to your career as a web developer not to know it. It's foreseeable that JavaScript will not only conserve but extend its hold of the overall software industry during the coming years.keep up!!

    Android Training in Chennai

    Android Online Training in Chennai

    Android Training in Bangalore

    Android Training in Hyderabad

    Android Training in Coimbatore

    Android Training

    Android Online Training


    ReplyDelete
  14. shiva10 September 2020 at 01:46

    I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
    | Certification | Cyber Security Online Training Course | Ethical Hacking Training Course in Chennai | Certification | Ethical Hacking Online Training Course | CCNA Training Course in Chennai | Certification | CCNA Online Training Course | RPA Robotic Process Automation Training Course in Chennai | Certification | RPA Training Course Chennai | SEO Training in Chennai | Certification | SEO Online Training Course

    ReplyDelete
  15. Wordpress Bloger13 November 2020 at 02:04

    Si Contact Form Plugin using for captcha to setup contact form in get it proper way it make properly

    ReplyDelete
  16. Wordpress Bloger18 November 2020 at 20:51

    Woocommerce Floating Cart setup in woocommerce side cart in your ecommerce website

    ReplyDelete
  17. Wordpress Bloger22 November 2020 at 21:49

    fast secure contact form for setup contact form with captcha and secure in your wordpress site

    ReplyDelete
  18. Disha patel27 November 2020 at 02:54

    Calculated Fields Form WordPress Plugin In Calculate Field to each other we can use wordpress plugin for calculation. let We explain you how to make Calculation Field in wordpress.

    ReplyDelete
  19. Disha patel27 November 2020 at 02:54

    Calculated Fields Form WordPress Plugin In Calculate Field to each other we can use wordpress plugin for calculation. let We explain you how to make Calculation Field in wordpress.

    ReplyDelete
  20. Unknown28 June 2021 at 01:23

    Thank you for discussing this very useful article. I heard something new from you. Keep blogging. php training in jalandhar

    ReplyDelete
  21. Anonymous28 June 2021 at 22:17

    This comment has been removed by the author.

    ReplyDelete
  22. Anonymous28 June 2021 at 22:25

    visit our website

    ReplyDelete
  23. Anonymous28 June 2021 at 22:28

    Thanks for sharing such types of articles on your website. I have read the complete article that you have explained properly. Thanks a lot for this article. For any kind of website development in the PHP Language,
    visit our website

    ReplyDelete
  24. Writers22 October 2021 at 00:15

    Thanks for providing awesome lecture about PHP. I hope you will keep it up.

    ReplyDelete
  25. Akhil C27 October 2021 at 04:42

    It is nice post and I found some interesting information on this blog, keep it up. Thanks for sharing. . .
    Hire PHP framework in India

    ReplyDelete
  26. sam kirubakar22 December 2021 at 23:44

    Thanks for sharing..

    AWS solution Architect job available in Chennai

    ReplyDelete

Post a Comment

Popular posts from this blog

How to seperate character from string in php

-
?   1 2 3 4 5 6 7 8 9 $string = "abcdef" ; $result =[]; $strlen = strlen ( $string ); for ( $i =0; $i < $strlen ; $i ++) {      $result [ $i ]= $string [ $i ];   } print_r( $result );     $string = "abcdef"; $result=[]; $strlen = strlen($string); for($i=0;$i<$strlen;$i++) { $result[$i]=$string[$i]; } print_r($result);
Read more

Uploads Only 10 files in month step by step

-
?   01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 <?php        $con = mysqli_connect( "localhost" , "root" , "" , "demo" );   date_default_timezone_set( 'Asia/Kolkata' );        $date = Date ( "Y-m-d" );                  if (isset( $_POST [ 'submit' ]))      {          extract( $_POST );            $name1 = $_FILES [ 'photo' ][ 'name' ];    $type = $_FILES [ 'photo' ][ 'type' ];    $size = $_FILES [ 'photo' ][ 'size' ];    $temp = $_FILES [ 'photo' ][ 'tmp_name' ];    if ( $name1 ){   $upload = "posts/" ;              $imgExt = strtolower ( pathinfo ( $name1 , PATHINFO_EXTENSION));              $valid_ext = array ( 'jpg' , 'png' , 'jpeg' );
Read more