get_all_array($sort_key = "table_primary_key", $offset = "0", $limit = "10000", $direction = "ASC", $query_string = '', $added_query = '', $added_query_type = 'AND')

Queries the database for all records given the inputted criteria and returns them as an array

If $query_string is set, it'll split the query string (e.g. "term1 term2" or "term1, term2") and make sure each term is found at least once in a non-boolean field

If $added_query is set, it will add to the query "SELECT * FROM table WHERE $added_query" If there is already a WHERE in the query it will work like "SELECT * FROM table WHERE () $added_query_type $added_query"

SEARCHES DO NOT SEARCH "_LOOKUP" VARIABLES

Example:

example.php


<?php
include("lib.php");
load("person");

$results_per_page = 10;
$search_string = $_GET['search_string'];
if (!$offset = (int) $_GET['offset'])   $offset = 0;

$p = new person;
$results = $l->get_all_array("name", $offset, $results_per_page, 'ASC', $search_string);

for($i = 0; $i < count($results); $i++)
    echo $i." ".$results[$i]["name"]."<br>";

?>