Question 113642 in Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – Passing an array to a query using a WHERE clausee

I want to use array in WHERE clause. But it doesn’t work.

if (count(is_countable($ekkampanyaId) ? $ekkampanyaId : []) > 0) {
        $kampanyadizi = implode("','", $ekkampanyaId);
        $ekkampanyalar = $Panel_Model->urunkampanyalistele($kampanyadizi, date("Y/m/d"));

MY sql side

public function urunkampanyalistele($array , $tarih) {
    $sql = 'SELECT kampanya_ID,kampanya_indirimyuzde FROM flora_kampanya WHERE kampanya_ID IN ("' . $array . '") AND kampanya_aktiflik=1 AND kampanya_baslamatarih<' . $tarih . '<kampanya_bitistarihi';
    return $this->db->select($sql);
}
Tags:

2

Answers


  1. 0

    I think you are missing some quotes

    if (count(is_countable($ekkampanyaId) ? $ekkampanyaId : []) > 0) {
        $kampanyadizi = ",".implode("','", $ekkampanyaId)."'";
        $ekkampanyalar = $Panel_Model->urunkampanyalistele($kampanyadizi, date("Y/m/d"));
    Login or Signup to reply.
  2. 0

    We need to be familiar when to use single and double quotes and escape characters.

    Query string should be:

    $sql = "SELECT kampanya_ID,kampanya_indirimyuzde FROM flora_kampanya WHERE kampanya_ID IN ('" . $array . "') AND kampanya_aktiflik=1 AND kampanya_baslamatarih<'" . $tarih . "'<kampanya_bitistarihi";
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search