Multiple Select Checkbox To Display The Table Record

I want to filter the table by using multiple select checkbox by selecting multiple Company Name and the table will display the record related to the selected checkbox. It only able

Solution 1:

When you receive multiple-select POST it cames as array, so you should use "IN" operator in your mysql request instead of comparison. Try to change one part of your code:

if(isset ($_POST['COMPANYNAME'])) {
   $COMPANYNAME = $_POST['COMPANYNAME'];
   $COMPANYNAME = is_array($COMPANYNAME) ? $COMPANYNAME : [$COMPANYNAME];

   $companiesParam = '\''. join("', '", $COMPANYNAME) . '\'';
   $fetch = "SELECT sl_iv.DOCDATE, ar_iv.DUEDATE, payment_terms.terms, sl_iv.DOCNO, sl_iv.COMPANYNAME, ar_iv.DOCAMT, ar_iv.PAYMENTAMT FROM `sl_iv` Inner Join `ar_iv` On ar_iv.DOCNO = sl_iv.DOCNO Inner Join `payment_terms` On ar_iv.TERMS = payment_terms.id WHERE sl_iv.COMPANYNAME IN (".$companiesParam.") or sl_iv.DOCDATE <= '".$from."'";
   $result = mysqli_query($conn_connection,$fetch)or die("MySQL error: " . mysqli_error($conn_connection) . "<hr>\nQuery: $fetch");
}