Docs For Class abook

Description

Address book in a database backend

Backend for personal/shared address book stored in a database, accessed using the DB-classes in PEAR or PDO, the latter taking precedence if available..

IMPORTANT: If PDO is not available (it should be installed by default since PHP 5.1), then the PEAR modules must be in the include path for this class to work.

An array with the following elements must be passed to the class constructor (elements marked ? are optional):

   dsn       => database DNS (see PEAR for syntax, but more or
                less it is:  mysql://user:pass@hostname/dbname)
   table     => table to store addresses in (must exist)
   owner     => current user (owner of address data)
 ? name      => name of address book
 ? writeable => set writeable flag (true/false)
 ? listing   => enable/disable listing

The table used should have the following columns: owner, nickname, firstname, lastname, email, label The pair (owner,nickname) should be unique (primary key).

NOTE. This class should not be used directly. Use the "AddressBook" class instead.

Three settings that control PDO behavior can be specified in config/config_local.php if needed: boolean $disable_pdo SquirrelMail uses PDO by default to access the user preferences and address book databases, but setting this to TRUE will cause SquirrelMail to fall back to using Pear DB instead. boolean $pdo_show_sql_errors When database errors are encountered, setting this to TRUE causes the actual database error to be displayed, otherwise generic errors are displayed, preventing internal database information from being exposed. This should be enabled only for debugging purposes. string $pdo_identifier_quote_char By default, SquirrelMail will quote table and field names in database queries with what it thinks is the appropriate quote character for the database type being used (backtick for MySQL (and thus MariaDB), double quotes for all others), but you can override the character used by putting it here, or tell SquirrelMail NOT to quote identifiers by setting this to "none"

Located in /functions/abook_database.php (line 89)

addressbook_backend
   |
   --abook_database

Variable Summary

string $bname

string $btype

resource $dbh

string $dsn

string $identifier_quote_char

bool $listing

string $owner

string $table

bool $writeable

Method Summary

abook_database abook_database (array $param)

abook_database __construct (array $param)

bool add (array $userdata)

void close ()

string get_field_name (integer $field)

array list_addr ()

array lookup (string $value, [integer $field = SM_ABOOK_FIELD_NICKNAME])

bool modify (string $alias, array $userdata)

bool open ([bool $new = false])

bool remove (string $alias)

array search (string $expr)

Variables

string $bname = 'database' (line 99)

Backend name

Redefinition of:

addressbook_backend::$bname

string $btype = 'local' (line 94)

Backend type

Redefinition of:

addressbook_backend::$btype

resource $dbh = false (line 130)

Database Handle

string $dsn = '' (line 105)

Data Source Name (connection description)

string $identifier_quote_char = '' (line 112)

Character used to quote database table

and field names

bool $listing = true (line 140)

Enable/disable address book listing

string $owner = '' (line 125)

Owner name

Limits list of database entries visible to end user

string $table = '' (line 118)

Table that stores addresses

bool $writeable = true (line 135)

Enable/disable writing into address book

Redefinition of:

addressbook_backend::$writeable

Inherited Variables

Inherited from addressbook_backend

addressbook_backend::$bnum
addressbook_backend::$error
addressbook_backend::$sname

Methods

Constructor abook_database (line 198)

Constructor (PHP4 style, kept for compatibility reasons)

abook_database abook_database (array $param)

array $param: address book backend options

Constructor __construct (line 148)

Constructor (PHP5 style, required in some future version of PHP)

abook_database __construct (array $param)

array $param: address book backend options

add (line 579)

Add address

bool add (array $userdata)

array $userdata: added data

Redefinition of:

addressbook_backend::add()

close (line 294)

Close the file and forget the filehandle

void close ()

get_field_name (line 315)

Determine internal database field name given one of the SquirrelMail SM_ABOOK_FIELD_* constants

return: The desired field name, or the string "ERROR" if the $field is not understood (the caller is responsible for handing errors)

string get_field_name (integer $field)

integer $field: The SM_ABOOK_FIELD_* contant to look up

list_addr (line 512)

List all addresses

return: search results

array list_addr ()

Redefinition of:

addressbook_backend::list_addr()

lookup (line 444)

Lookup by the indicated field

return: search results

array lookup (string $value, [integer $field = SM_ABOOK_FIELD_NICKNAME])

string $value: Value to look up
integer $field: The field to look in, should be one of the SM_ABOOK_FIELD_* constants defined in functions/constants.php (OPTIONAL; defaults to nickname field) NOTE: uniqueness is only guaranteed when the nickname field is used here; otherwise, the first matching address is returned.

Redefinition of:

addressbook_backend::lookup()

modify (line 709)

Modify address

bool modify (string $alias, array $userdata)

string $alias: modified alias
array $userdata: new data

Redefinition of:

addressbook_backend::modify()

open (line 207)

Open the database.

bool open ([bool $new = false])

bool $new: new connection if it is true

remove (line 645)

Delete address

bool remove (string $alias)

string $alias: alias that has to be deleted

Redefinition of:

addressbook_backend::remove()

search (line 339)

Search the database

return: search results

array search (string $expr)

string $expr: search expression

Redefinition of:

addressbook_backend::search()

Inherited Methods

Inherited From addressbook_backend

addressbook_backend::add()
addressbook_backend::list_addr()
addressbook_backend::lookup()
addressbook_backend::modify()
addressbook_backend::remove()
addressbook_backend::search()
addressbook_backend::set_error()

Class abook_database

Inherited Variables

Inherited Methods