Skip to main content

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');

Comments

Popular posts from this blog

How to use inner html value or data in php from javascript(innerHTML)?

 use inner html value or data in php from javascript(innerHTML)? <html> <body> <p id="demo">use inner html value in php(innerhtml)</p> <script>   var jassi = document.getElementById("demo").innerHTML;   //document.write(jassi); </script> <?php $jassi = '<script>document.write(jassi);</script>'; echo $jassi; ?> </body> </html>

How to build a tree from a flat array in PHP>

Build a tree from a flat array in PHP   $hello = array   (   array("ID" => "1","student" => "Jassi","marks" => "80","parent_id" => ""),   array("ID" => "2","student" => "Golu","marks" => "80","parent_id" => "1"),   array("ID" => "3","student" => "Jassi","marks" => "80","parent_id" => "1"),   array("ID" => "4","student" => "Jai","marks" => "90","parent_id" => "1"),   array("ID" => "5","student" => "Jassi","marks" => "85","parent_id" => "1"),   array("ID" => "6","student" => "Ravinder","

How to create remove and add more inputs functionality with input type file and text in Laravel?

Create remove and add more inputs functionality with input type file and text in Laravel Blade file code       <form action="{{ route('storeDocuments') }}" method="post" enctype="multipart/form-data">         @csrf         <div id="inputFields">             @if(!empty($documents[0]))             @php $counter = 1000; @endphp                 @foreach($documents as $document)                     <input type="hidden" id="document_id" name="documents[{{$counter}}][document_id]" value="{{$document->id}}">                     <div class="field">                         <label for="title">Title:</label>                         <input type="text" id="title" class="title_input" name="documents[{{$counter}}][title]" value="{{$document->title}}" required>                         <label for=&