Welcome Guest, Not a member yet? Register   Sign In
Update issue (Query Builder Class)
#6

I couldn't figure out how to disable escaping and it might not be wise to do so anyway.

The solution might be to not use Query Builder and fall back to good old 'query()' with bindings instead.

PHP Code:
$binds = [$valA$valB$valC$acct_id$id,];

$sql "UPDATE table1 
    JOIN table2 ON table1id = table2id 
    JOIN table3 ON table2id = table3id 
    SET colA = ?, colB = ?, ColC = ?
    WHERE table2acct_id = ?
    AND table1id = ?
    AND enabled = 1
    AND checkin_close_time >= UTC_TIMESTAMP()"
;

$result $this->db->query($sql$binds);
echo 
$results "It worked""Did not work"
Reply


Messages In This Thread
Update issue (Query Builder Class) - by ogomez - 07-05-2018, 05:59 PM
RE: Update issue (Query Builder Class) - by dave friend - 07-06-2018, 11:44 AM



Theme © iAndrew 2016 - Forum software by © MyBB