get_one($query_string = '', $added_query = '', $added_query_type = 'AND')

Searches the table for exactly one record that matches the currently set variables. Class variables that aren't set are not used.

If more than one record is returned, the function will return false

Sets the class variables based on the returned record

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"

RUN pg_escape_string() ON ANY USER-GENERATED DATA IN $added_query

SEARCHES DO NOT SEARCH "_LOOKUP" VARIABLES

Example:

example.php


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

$p = new person();
$p->set_address('1234 anywhere st');
$p->set_city('Metropolis');
$p->set_state('NY');
$p->get_one(null, '(age > 12 AND age < 18)');

echo $p->name;
?>