wordpress plugin to insert, delete and update data of custom table using ajax

i am developing a wp plugin to insert, delete and update data of custom table. now everything is working fine ie, i can insert, delete and update data of table. But the main thing that i want is when i click (perform ) every action like insert, delete or update, every time i need to refresh the page to see the actual data of my table fields. This is the problem that i want to resolve. I want to see the live data update after every operation without refreshing the page. Please help me to resolve this problem i am new to wp plugin. below is my complete plugin code.
Thanks in advance.

<?php
/**
* Plugin Name: MNM ADMIN
* Plugin URI: http://mnmdating.com
* Description: This is developed specialy for repoting purpose.
* Version: 1.0
* Author: Varinder Kumar
* Author URI: http://URI_Of_The_Plugin_Author
* License: A "Slug" license name e.g. GPL2
*/

  add_action('admin_menu', 'mnm_admin_actions');
  function mnm_admin_actions() 
  {
      add_options_page( 'My Plugin Options', 'MNM ADMIN', 'manage_options', 'my-unique-    identifier', 'mnm_admin', 'mnm_admin');
  }


  function mnm_admin()
  {   
     include 'mnm_config.php';
     $lastname=$_POST['lastname'];
     $id = substr($lastname, 1);
     $operation = substr($lastname, 0, 1);
     switch ($operation) 
     {
       case "i":
          $result = mysql_query("insert into user(email) values('$id')");
          break;
       case "d":
          $result = mysql_query("DELETE FROM user where id ='".$id."'");
          break;
       case "u":
          $result = mysql_query("UPDATE user SET religion='chamar' WHERE id='".$id."'");
          break;
       default:
          echo "Wrong operation";
  }

 if (!current_user_can( 'manage_options' ) )  {
    wp_die( __( 'You do not have sufficient permissions to access this page.' ) );
 }


  wp_enqueue_style('prefix-style', plugins_url('pl-style.css', __FILE__));

  // Register the script like this for a plugin:
  wp_register_script( 'custom-script', plugins_url( '/js/jquery.min.js', __FILE__ ) );

  // For either a plugin or a theme, you can then enqueue the script:
  wp_enqueue_script( 'custom-script' );


  { ?>
  <script type="text/javascript">

  function insert_function(lastname)
  {
  var lastname = lastname;
  var dataString = "lastname=" + lastname;
  $.ajax({
    type: "POST",  
    url: "",  
    data: dataString,
    success: function (data) {

        alert('Operation Successfull');

    return false;
        //run stuff on success here.  You can use `data` var in the 
       //return so you could post a message.  

    }
  });
  } 
  </script>
  <?php }

  echo '<div class="wrap">
  <div id="response"></div>

    <ul class="dash">
     <li class="fade_hover tooltip" title="Add / Edit Assignment">
        <a href="mnm-admin.php?=<?php ?>">
            <img src="'.plugins_url('images/accept.png', __FILE__).'" alt="" />
            <span>Verified Users</span>
        </a>
    </li>
    <li class="fade_hover tooltip" title="Manage Tutors">
        <!--<span class="bubble">3</span> -->
        <a href="show_tutor.php">
            <img src="'.plugins_url('images/help.png', __FILE__).'" alt="" />
            <span>Un Verified Users</span>
        </a>
   </li>

</ul>

    <div style="clear:both;"></div>
    <div class="widget">
    <div class="widget-head"></div>
    <div class="widget-body">
    <table class="table table-bordered table-condensed table-striped table-primary table-vertical-center checkboxs js-table-sortable">
            <thead>
                <tr>
                 <th style="width: 1%;" class="center">No.</th>
                    <th style="width: 20%;">Name / Email</th>
                    <th style="width: 30%;">Mobile</th>
                    <th style="width: 1%;" class="center">City</th>
                    <th style="width: 20%;" class="center">Photo</th>
                    <th style="width: 15%;" class="center">Date Of Birth</th>
                    <th  class="center">Religion</th>
                    <th style="width: 20%;"class="center">Actions</th>
                    <th style="width: 10%;"class="center">Select</th>
                 </tr>
            </thead>
            <tbody>';

               $select = mysql_query("select * from user") ; 
               while($row= mysql_fetch_array($select))
               { $i++; ?> 
                        <tr class="selectable">
                        <td class="center"><?php echo $row['id']; ?></td>
                        <td class="center"><?php echo $row['email']; ?></td>
                        <td class="center"><?php echo $row['mobile']; ?></td>
                        <td class="center js-sortable-handle"><?php echo 'Una'; ?></td>
                        <td class="center"><img style="margin-right:8px;" src="'.plugins_url('images/delete.png', __FILE__).'"></td>
                        <td class="center form-inline small">
                            <?php echo $row['day'].'-'.$row['month'].'-'.$row['year']; ?>
                        </td>
                        <td class="center"><?php echo $row['religion']; ?></td>
                        <td class="center"> 


                            <a href="#" onclick="insert_function('<?php echo 'd'.$row['id']; ?>')"><img style="margin-right:8px;" src="<?php echo plugins_url('images/delete.png', __FILE__); ?>"></a>


                            <a href="#" onclick="insert_function('<?php echo 'i'.$row['id']; ?>')"><img style="margin-right:8px;" src="<?php echo plugins_url('images/edit.png', __FILE__); ?>"></a>


                            <a href="#" onclick="insert_function('<?php echo 'u'.$row['id']; ?>')"><img style="margin-right:8px;" src="<?php echo plugins_url('images/checked.png', __FILE__); ?>"></a>


                        </td>
                        <td class="center"><input type="checkbox"></td>
                </tr>
            <?php   
            }                   
            echo '</tbody>
        </table>
    </div>
   </div> 
 </div>';
}

Related posts

Leave a Reply