I can't add OR operator inside my sql query

Question

My code look like this:

$database->update($campaign_table, $data_nga_posti , array("AND" => ["codice_pod" => $data_nga_posti['codice_pod'],("codice_pdr" =>NULL) ]));

So this is when my query execute:

UPDATE `field` SET `columnname` = 'data',`anothercm` = 'data',WHERE `codice_pod` = 'IT001E35563561' AND `codice_pdr` IS NULL

I want to my query look like this.

UPDATE `field` SET `columnname` = 'data',`anothercm` = 'data',WHERE `codice_pod` = 'IT001E35563561' AND (`codice_pdr` IS NULL OR `codice_pdr` ="")

but I dont know how to put OR(operator ) inside this code.

Could you possibly just use mysqli and a connection and then build the query yourself instead of using the update function? — Nived, Apr 17 '15 at 11:31
we have not complete information about update method of $database object please show us your method and how it works — babak faghihian, Apr 17 '15 at 11:42
Guys im using a class called (class medoo)/http://medoo.in/api/where to get data from a Form data. — Mr Alb, Apr 17 '15 at 11:50

score 3 · Accepted Answer · answered Apr 17 '15 at 12:14

I have never used this before, and have nothing to test with but the closted example posted in the documentation is:

$database->has("account", [
    "AND" => [
        "OR" => [
            "user_name" => "foo",
            "email" => "foo@bar.com"
        ],
        "password" => "12345"
    ]
]);

So I think this would work for you:

$database->update($campaign_table, $data_nga_posti, [
    "AND" => [
        OR => [
            "codice_pdr" =>NULL, 
            "codice_pdr" => ""
        ],
        "codice_pod" => $data_nga_posti['codice_pod']
    ]
]);

Yeah,this works for me,sure with some changes.So Thank you very much for your answers,its my first question and maybe im not very clear with my question,anyway the first is the first... Good Luck :) — Mr Alb, Apr 17 '15 at 15:15

score 0 · Answer 2 · answered Apr 17 '15 at 11:40

0

try this:

array("AND" => ["codice_pod" => $data_nga_posti['codice_pod'],"OR" => ["codice_pdr" =>NULL,`codice_pdr` ="" ] ])

answered Apr 17 '15 at 11:40

mohsenJsh

2,048
3
25
49

1

How can you possibly now this will work? He hasn't even posted his `update()` method yet. – Daan Apr 17 '15 at 11:40

I can't add OR operator inside my sql query

2 Answers2