or_where query |
Hi,
Having great fun with new release of CI4! Great job guys! I'm trying to run a query that fetches 1 row where either of fields (name or name1) equals "$name". PHP Code: return $this->asArray() Call to a member function first() on null How can I use or_where? Thanks!
found the answer here (p. 320) using Query builder :
https://www.procoversfx.com/download/cod...beta.1.pdf $db = $this->builder(); $query = $db->select('id, nom') ->where('name', $name) ->orWhere('name1', $name) ->get(); return count($query->getResult()); |
Welcome Guest, Not a member yet? Register Sign In |