Guest User

Untitled

a guest
Nov 23rd, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.33 KB | None | 0 0
  1. function ajaxFunction(str,id) {
  2. jQuery.ajax({
  3. url: '<?php echo admin_url('admin-ajax.php'); ?>',
  4. type: 'post',
  5. data: {
  6. 'action' : 'my_action',
  7. 'payment_selected': payment_selected,
  8. 'id' : id
  9. },
  10. success: function (response) {
  11. if(response=='success'){
  12. jQuery("#status").html(response);
  13. }
  14. }
  15. });
  16. }
  17.  
  18. add_action( 'wp_ajax_nopriv_my_action', 'my_action' );
  19. add_action( 'wp_ajax_my_action', 'my_action' );
  20.  
  21. function my_action() {
  22. global $wpdb;
  23. $id_selected = $_POST['payment_selected'];
  24. $id = $_POST['id'];
  25. $table_name_payment = $wpdb->prefix . "online_booking_system_model";
  26. $result_pay = $wpdb->query($wpdb->prepare("UPDATE $table_name_payment SET payment_status = $id_selected WHERE id=$id"));
  27. echo "success";
  28. }
  29. ?>
  30.  
  31. <?php foreach ($rows as $row) { ?>
  32. <table>
  33. <tr><td><?php echo $row->payment_status; ?></td>
  34. <select name='payment_select' id="payment_select" onchange="ajaxFunction(this.value,<?php echo $row->id ?>)">
  35. <option value="Payment Due">Payment Due</option>
  36. <option value="Payment completed">Payment Completed</option>
  37. </select>
  38. <?php } ?>
  39. </td></tr>
  40. <table>
  41. <div id="status"></div>
Add Comment
Please, Sign In to add comment