29 February 2020

How to fetch data (messages) in every second with ajax (setinterval) from mysql (PHP) in wordpress?

Fetch data (messages) in every second with ajax (setinterval) from mysql (PHP) in wordpress.


In main file

<script>

jQuery(document).ready(function($){



var own_id = $("#own_id").val();
var user_id = $("#user_id").val();
alert('helo');


function sandeep(){

var data = {
'action':'fetch_message',
'own_id':own_id,
'user_id':user_id,
}


$.post(myajax.ajaxurl,data,function(response){
//$("#response").html(response);
$("#jassi").html(response);
console.log(response);
});


}


setInterval(function(){ sandeep(); }, 500);
});

</script>



<div id="jassi">



</div>


In Funtion.php file 




function fetch_message(){
$msg_content = $_POST['msg_content'];
$own_id = $_POST['own_id'];
$user_id = $_POST['user_id'];
echo $user_id;
global $wpdb;
$table_name13 = $wpdb->prefix . "user_chats";
$results = $wpdb->get_results("select * from $table_name13 where sender_id ='$own_id' AND receiver_id='$user_id'");
$total = count($results);

foreach($results as $result){
echo $result->msg_content."<br>";




}
die();
}

add_action('wp_ajax_nopriv_fetch_message','fetch_message');
add_action('wp_ajax_fetch_message','fetch_message');

No comments:

Post a Comment

How to add re-captcha v3 on all Elementor forms using coding?

 Add re-captcha v3 on all Elementor forms using coding add_action('wp_footer',function(){     ?> <script src="https://www...