How to get data using an array in PHP when ajax call sending

Question

I created a simple searching function in php. Its working when im not using ajax to that script. But when i use ajax, my implode function disappear.

Here how my codes looks like.

$searchtag = filter_var($_GET['search'], FILTER_SANITIZE_STRING);
$searchtagrlce = str_replace("+", " ", $searchtag);

$searchTermsis = explode(' ', $searchtagrlce);

    $searchTermBitsis = array();
    foreach ($searchTermsis as $terms) {
        $terms = trim($terms);
        if (!empty($terms)) {
            $searchTermBitsis[] = "tbale_row1 LIKE '%$terms%' OR tbale_row12 LIKE '%$terms%' OR tbale_row13 LIKE '%$terms%'";

        }
    }




     $getdataquerystores = "SELECT `tbale_row1`, `tbale_row2`, `tbale_row3`, `tbale_row4`, `tbale_row5`, `tbale_row6` FROM `tablename` WHERE ".implode(' AND ', $searchTermBitsis). " ORDER BY tbale_row1 DESC LIMIT $limit, 10";
      $getdataquerystoress = mysqli_query($connection, $getdataquerystores);

when i echo or print the above codes without ajax, im getting this

SELECT `tbale_row1`, `tbale_row2`, `tbale_row3`, `tbale_row4`, `tbale_row5`, `tbale_row5` FROM `tablename` WHERE tbale_row1 LIKE '%a%' OR tbale_row2 LIKE '%a%' OR tbale_row3 LIKE '%a%' ORDER BY tbale_row1 DESC LIMIT 0, 10

but when i use ajax and print the above same code, im getting this (AFTER WHERE FUNCTION DATA HAS BEEN DISAPPEAR)

SELECT `tbale_row1`, `tbale_row2`, `tbale_row3`, `Logo_croped_554`, `tbale_row5, `tbale_row6` FROM `tablename` WHERE ORDER BY tbale_row1 DESC LIMIT 10, 10

here it is my ajax code

$(window).scroll(function ()
    {
   if($(document).height() <= $(window).scrollTop() + $(window).height())
   {
  loadmore();
   }
    });

    function loadmore()
    {
      var val = $("#row_no").val();
      $.ajax({
      type: 'post',
      url: '/myproject/data/alldata.php',
      data: {
       getresult:val
      },
   beforeSend:function(){
     $(".loading-data").fadeIn("slow");
   },
   
   uploadProgress:function(){
    
    $(".loading-data").fadeIn("slow");
   },
      success: function (response) {
   var content = document.getElementById("dsdplasdy_sdtres");
      content.innerHTML = content.innerHTML+response;
 
      
      document.getElementById("row_no").value = Number(val)+10;
   },
   complete:function() {
     $(".loading-data").fadeOut("slow");
    
   }
   
      });
    }

here it is the value im getting from tne hidden field

 <input type="hidden" id="row_no" value="10" />

Please any ex[ert may help me. Any help much appreciated. Thanks.

Answer 1

To pass arrays over the internet, or any other data for that matter, the data needs to be properly serialized and encoded on the senders end and un-serialized and decoded on the receivers end. There are many ways to serilize the data but the defaults that are supported by PHP directly are application/x-www-form-urlencoded or multipart/form-data which will populate the $_POST superglobal variable if the POST request method is used. The data can also be passed as URL parameters where the query portion of the URL is "application/x-www-form-urlencoded" encoded and populates the $_GET superglobal variable in PHP.

Note: Use $_POST or $_GET superglobals to get data. If you have register globals on you should turn it off, it is no longer supported as of version 5.4 http://php.net/manual/en/security.globals.php

For your specific case you are not passing the search parameter from your AJAX request.

url: '/myproject/data/alldata.php',

should be

url: '/myproject/data/alldata.php?search='+encodeURI(searchTerms),

You will need to populate the searchTerms variable with your search terms or replace searchTerms with your actual search terms. If you don't know how to get the search terms see How to retrieve GET parameters from javascript?

Answer 2

Thank you everyone who answered above. I been trying to figure this. It wan't something with the ajax as i mentioned.I was about how php forget variables data when it is passing through ajax. There for i used hidden field to store the data and then i sent it to the sript later using ajax.

<input type = "hidden" value= "<?php search parameter ?>"