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 create video slider with cuncks of videos without download all videos?

 Create video slider with cuncks of videos without download all videos function custom_video_slider_shortcode() { $slider_id = 'vide...