How to fetch the data from the database with values separated by comma

Question

I tried this code but it only fetch the value of last value in comma

I have in INVOICEVALUE = 1,2

and it only fetch the 2

$INVOICEVALUE = $_REQUEST["INVOICEVALUE"];
$VALUE = explode(',', $INVOICEVALUE);
foreach ($VALUE as $val) {

    $invoiceselected = mysqli_query($link, "select SUM(INVOICE_AMOUNT) as AMOUNT,INVOICE_CODE,INVOICE_STATUS,PAYMENT_STATUS,INVOICE_TRANSACTIONDATE,INVOICE_UNITPRICE,CUSTOMER_ID,CUSTOMER_ID
         from invoice where INVOICE_CODE ='" . $val . "' 
         AND INVOICE_STATUS='CLOSE' AND PAYMENT_STATUS=''
         GROUP BY INVOICE_CODE");
}

you want data for both 1 and 2, i.e. `INVOICE_CODE = 1` or `INVOICE_CODE = 2`? — Raunak Gupta, Apr 30 '17 at 05:55
Also http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php — Ergec, Apr 30 '17 at 06:04

Raunak Gupta · Accepted Answer · 2017-04-30T06:00:44.780

1

If you want to get the result for both INVOICE_CODE = 1 or INVOICE_CODE = 2 then you can use MySQL IN clause

$INVOICEVALUE = $_REQUEST["INVOICEVALUE"];
//$VALUE = explode(',', $INVOICEVALUE);


$invoiceselected = mysqli_query($link, "select SUM(INVOICE_AMOUNT) as AMOUNT,INVOICE_CODE,INVOICE_STATUS,PAYMENT_STATUS,INVOICE_TRANSACTIONDATE,INVOICE_UNITPRICE,CUSTOMER_ID,CUSTOMER_ID
     from invoice where INVOICE_CODE IN (" . $INVOICEVALUE . ") 
     AND INVOICE_STATUS='CLOSE' AND PAYMENT_STATUS=''
     GROUP BY INVOICE_CODE");

Hope this helps!

edited Apr 30 '17 at 06:00

answered Apr 30 '17 at 05:58

Raunak Gupta

9,719
3
49
86

thanks bro really help me with this. – Shermaine Chaingan Apr 30 '17 at 05:59
This query/answer is not ideal because it includes non aggregate columns with `GROUP BY` and also it should be using a prepared statement. – Tim Biegeleisen Apr 30 '17 at 06:10
yes @TimBiegeleisen, thanks for pointing out the `GROUP BY` filed but yes I know that but the question was regarding to get the data from `INVOICE_CODE`, so I did't use that. – Raunak Gupta Apr 30 '17 at 06:18

How to fetch the data from the database with values separated by comma

1 Answers1