find

Syntax
array|bool find(
  string $where
  optional string $bindarr=false,
  optional string $pkeysArr=false,
  optional array $extra=array()
  )

Description

This function locates records the match the where string in any portion of the database record and returns an array of results.

If no results are returned the method returns false

It is part of both Extended Active Record and Active Record

Parameters

$where

An SQL string (not including WHERE to match a subset of records

$bindarr

An optional array of bind variables if required by the where statement

$pkeysArr

$extra

$extra provides an optional set of parameters

ParameterDescription
limit Select Record Limit
offset Select Record Offset

Usage

This example finds all entries in the persons table whose birth date is less than 2019-01-01 

$person = new Person;
$person->find('birth_date<2019-01-01');