Basic Wordpress CRUD Operation

INSERT

<?php

 if($wpdb->insert($wpdb->prefix .'tablename',

            array(

                'id' => $id,

                'name' => $name,

                'email' => $email,         

                'status' => '1'

            ))==false)wp_die('not');

    else $msg="<div class='alert alert-success'>

        <strong>Data Submitted</strong>

        </div>";

 ?>

SELECT

 <?php

 $results = $wpdb->get_results( "SELECT id,name,email, from wp_packages `wp_packages` where status=1");
                  
                    if(!empty($results))
                    {
                        foreach($results as $row){
                         echo $row->name; 

                          echo $row->email;
                        }
                    }

    ?>

DELETE

<?php

if (isset($_POST['delete'])) {
            $id = $_POST['delete'];
            $wpdb->delete( $wpdb->prefix . 'package_detail', array( 'pd_id' => $id ) );

    }

  ?>

 

UPDATE

<?php

if(isset($_POST['update'])){
 
   
    $id = $_POST['update'];
    global $wpdb;
    $table_name  = $wpdb->prefix."package_detail";

    $wpdb->query( $wpdb->prepare("UPDATE $table_name
                SET status = %s
             WHERE pd_id = %s",'0', $id)
    );
} 

?>