All geek questions in one place

SQL DELETE not working

Good morning everyone

I have a problem with my script I cannot figure out how to make a function. I will explain: I use the appearance API. I get my letters, send them to my bdd in the inbox table. Then I have some buttons that allow me to send my letters to another table (do / Urgent / Archive). The problem is that I want to delete incoming message data when I send an email to another table.

I have a file of the form (I don’t attach it, I don’t think it is useful) File with my AJAX request:

window.onload = function(item){
      
      console.log("********************TEST_INSERT*********************");
   
   
      for($i = 0; $i <= 2; $i++){
          console.log("after for");
          console.log($i);
   $thisInput = document.getElementsByClassName('from_1')[$i].textContent;
   $thisSub = document.getElementsByClassName('subject_1')[$i].textContent;
   $thisRecei = document.getElementsByClassName('received_1')[$i].textContent;
   $thisPreview = document.getElementsByClassName('bodypreview_1')[$i].textContent;
   $thisBody_2 = document.getElementsByClassName('body_2')[$i].textContent;
    console.log("*********************");
    console.log($thisInput);
    console.log($thisSub);
    console.log($thisRecei);
    console.log($thisPreview);
    console.log($thisBody_2);
    console.log("*********************");
    
    
      



    console.log("**********************");
    console.log("******STOCK************");
    console.log("**********************");
    
      
//var $input = $(item).closest(".emailBody").find(".from_1")[0].innerHTML;
//var $sub = $(item).closest(".emailBody").find(".subject_1")[0].innerHTML;
//var $recei = $(item).closest(".emailBody").find(".received_1 em")[0].innerHTML;
//var $preview= $(item).closest(".emailBody").find(".bodypreview_1 em")[0].innerHTML;
//var $body_2 = $(item).closest(".emailBody").find(".body_2 em")[0].innerHTML;
$.ajax({url: '../../wp-content/plugins/game_plugin/process_general.php',
    type: 'POST',
    data: {info: 'stock_mail_inbox', input: $thisInput, sub: $thisSub, recei: $thisRecei, preview: $thisPreview, body : $thisBody_2},
    success: function() {
        console.log("OK");
    }
});
};
 $.ajax({url: '../../wp-content/plugins/game_plugin/process_general.php',
    type: 'POST',
    dataType: 'html',
    data: {info: 'display_mail'},
    success: function(html) {
        console.log("OKok");
        
        $('#display_mail').html(html);
   
    
    }
});

}; 



function btn_a_faire(item){
   
  
   
    console.log("**********************");
    console.log("******ajax A FAIRE************");
    console.log("**********************");
var $thisInput = $(item).closest(".emailBody").find(".from_1")[0].innerHTML;
var $thisSub = $(item).closest(".emailBody").find(".subject_1")[0].innerHTML;
var $thisRecei = $(item).closest(".emailBody").find(".received_1 em")[0].innerHTML;
var $thisPreview = $(item).closest(".emailBody").find(".bodypreview_1 em")[0].innerHTML;
var $thisBody_2 = $(item).closest(".emailBody").find(".body_2 em")[0].innerHTML;
console.log($thisBody_2);
$.ajax({url: '../../wp-content/plugins/game_plugin/process_general_2.php',
    type: 'POST',
    data: {info: 'insert_to_db_a_faire', input: $thisInput, sub: $thisSub, recei: $thisRecei, preview: $thisPreview, body : $thisBody_2},
    success: function() {
        console.log("OK");
    }
});

};


function btn_urgent(item){
    console.log("**********************");
    console.log("******ajax URGENT************");
    console.log("**********************");
var $thisInput = $(item).closest(".emailBody").find(".from_1")[0].innerHTML;
var $thisSub = $(item).closest(".emailBody").find(".subject_1")[0].innerHTML;
var $thisRecei = $(item).closest(".emailBody").find(".received_1 em")[0].innerHTML;
var $thisPreview = $(item).closest(".emailBody").find(".bodypreview_1 em")[0].innerHTML;
var $thisBody_2 = $(item).closest(".emailBody").find(".body_2 em")[0].innerHTML;
$.ajax({url: '../../wp-content/plugins/game_plugin/process_general_3.php',
    type: 'POST',
    data: {info: 'insert_to_db', input: $thisInput, sub: $thisSub, recei: $thisRecei, preview: $thisPreview, body : $thisBody_2},
    success: function() {
        console.log("OK");
    }
});
}


function btn_archive(item){
    console.log("**********************");
    console.log("******ajax URGENT************");
    console.log("**********************");
var $thisInput = $(item).closest(".emailBody").find(".from_1")[0].innerHTML;
var $thisSub = $(item).closest(".emailBody").find(".subject_1")[0].innerHTML;
var $thisRecei = $(item).closest(".emailBody").find(".received_1 em")[0].innerHTML;
var $thisPreview = $(item).closest(".emailBody").find(".bodypreview_1 em")[0].innerHTML;
var $thisBody = $(item).closest(".emailBody").find(".body_2 em")[0].innerHTML;
$.ajax({url: '../../wp-content/plugins/game_plugin/process_general_4.php',
    type: 'POST',
    data: {info: 'insert_to_db_archive', input: $thisInput, sub: $thisSub, recei: $thisRecei, preview: $thisPreview, body : $thisBody_2},
    success: function() {
        console.log("OK");
    }
});
}
Run codeHide result

And I have 4 files that handle INSERT in my bdd (proccess_general. Php / proccess_general_2 ...):

Proccess_general.php:

 $info = $_POST['info'];
$thisInput= $_POST['input'];
$thisRecei= $_POST['recei'];
$thisSub= $_POST['sub'];
$thisPreview= $_POST['preview'];
$thisBody= $_POST['body'];
 stock_mail_inbox($thisInput, $thisSub, $thisRecei, $thisPreview, $thisBody);
  function stock_mail_inbox($thisInput, $thisSub, $thisRecei, $thisPreview, $thisBody){

  
 
     
global $wpdb;

         $wpdb->insert(
                    'inbox', //table name
                    array(
                'id' => '',
                'from_mail' => $thisInput,
                'subject'  =>$thisSub,
                'recei' => $thisRecei,
                'preview' =>$thisPreview,
                'body'  => $thisBody,
                
                    ), //columns
                    array(
                '%d',
                '%s',
                '%s',
                '%s',
                '%s',
                '%s',
                    )
            );

     
  }
Run codeHide result

proccess_general_2.php:

$info = $_POST['info'];
$thisInput= $_POST['input'];
$thisRecei= $_POST['recei'];
$thisSub= $_POST['sub'];
$thisPreview= $_POST['preview'];
$thisBody= $_POST['body'];
 insert_to_db_a_faire($thisInput, $thisSub, $thisRecei, $thisPreview, $thisBody);
  function insert_to_db_a_faire($thisInput, $thisSub, $thisRecei, $thisPreview, $thisBody){

  
 
     
global $wpdb;

         $wpdb->insert(
                    'a_faire', //table name
                    array(
                'id' => '',
                'from_mail' => $thisInput,
                'subject'  =>$thisSub,
                'recei' => $thisRecei,
                'preview' =>$thisPreview,
                'body'  => $thisBody,
                
                    ), //columns
                    array(
                '%d',
                '%s',
                '%s',
                '%s',
                '%s',
                '%s',
                    )
            );

    $wpdb->prepare('DELETE FROM `inbox` WHERE recei = $thisRecei');
  }
Run codeHide result

proccess_general_2 DELETE, . phpmyadmin, , . , , . .

+4
1

- execute( ). ( , , )

$wpdb->prepare('DELETE FROM `inbox` WHERE recei = $thisRecei');
$wpdb->execute();
+1

Source: https://habr.com/ru/post/1693400/

More articles:


All Articles