[autocrud] element index

activerecord.inc.php

activerecord.inc.php in activerecord.inc.php

addAlias

AutoCRUD_CRUD::addAlias() in crud.inc.php

Used to add a new alias for the CRUD object

addRelationship

AutoCRUD_CRUD::addRelationship() in crud.inc.php

Used to setup a new relationship with another table

affected_rows

AutoCRUD::affected_rows() in autocrud.php

Raw MySQL function

affected_rows

AutoCRUD_MySQL::affected_rows() in mysql.inc.php

Returns the number of rows affected by the last query

AutoCRUD

AutoCRUD in autocrud.php

AutoCRUD Main Class

AutoCRUD

AutoCRUD::AutoCRUD() in autocrud.php

It's possible to immediately pass the mysql info to the constructor to setup a connection

AutoCRUD_ActiveRecord

AutoCRUD_ActiveRecord in activerecord.inc.php

AutoCRUD ActiveRecord Class

AutoCRUD_ActiveRecord

AutoCRUD_ActiveRecord::AutoCRUD_ActiveRecord() in activerecord.inc.php

Use the constructor to pass the right CRUD object

AutoCRUD_CRUD

AutoCRUD_CRUD::AutoCRUD_CRUD() in crud.inc.php

Sets the table name of the CRUD object

AutoCRUD_CRUD

AutoCRUD_CRUD in crud.inc.php

AutoCRUD CRUD Class

AutoCRUD_Error

AutoCRUD_Error in error.inc.php

AutoCRUD Error Class

AutoCRUD_Error

AutoCRUD_Error::AutoCRUD_Error() in error.inc.php

The constructor will also immediately add the object to the error stack

autocrud_is_error

autocrud_is_error() in error.inc.php

Used to check if a variable hold an error object or not

AutoCRUD_MySQL

AutoCRUD_MySQL in mysql.inc.php

AutoCRUD MySQL Class

autocrud.php

autocrud.php in autocrud.php

AutoCRUD_Relationship

AutoCRUD_Relationship::AutoCRUD_Relationship() in relationship.inc.php

Used to pass in the owner CRUD object and the CRUD object of the other table

AutoCRUD_Relationship

AutoCRUD_Relationship in relationship.inc.php

AutoCRUD_Relationship Class

$currentpage

AutoCRUD_CRUD::$currentpage in crud.inc.php

Current Page

close

AutoCRUD_MySQL::close() in mysql.inc.php

Used to close the MySQL connection

close

AutoCRUD::close() in autocrud.php

Raw MySQL function

connect

AutoCRUD_MySQL::connect() in mysql.inc.php

Used to setup a connection with the MySQL server

connect

AutoCRUD::connect() in autocrud.php

Setups up a connection with the MySQL database

createReverseRelationship

AutoCRUD_Relationship::createReverseRelationship() in relationship.inc.php

Used to add a relationship on the other CRUD object type (in reverse)

crud.inc.php

crud.inc.php in crud.inc.php

$database

AutoCRUD::$database in autocrud.php

Database Name

$database

AutoCRUD_MySQL::$database in mysql.inc.php

Database Name

delete

AutoCRUD_CRUD::delete() in crud.inc.php

Used to delete an existing record, like this:

$crud->table->delete (23);

delete

AutoCRUD_ActiveRecord::delete() in activerecord.inc.php

Used to delete a record

doJoin

AutoCRUD_Relationship::doJoin() in relationship.inc.php

Used to get related records of a result set

error.inc.php

error.inc.php in error.inc.php

$fields

AutoCRUD_CRUD::$fields in crud.inc.php

Fields Array

generate

AutoCRUD::generate() in autocrud.php

Used to create all the necessary CRUD objects for each table. This or the include_crud function must always be called before you can use the library

get

AutoCRUD_CRUD::get() in crud.inc.php

Used to get a single record, like this:

$record = $crud->table->get(23);

getCode

AutoCRUD_Error::getCode() in error.inc.php

Used to retrieve an error code

getMessage

AutoCRUD_Error::getMessage() in error.inc.php

Used to retrieve an error message

getName

AutoCRUD_CRUD::getName() in crud.inc.php

Returns the name of the CRUD object (mainly used with aliases)

getOther

AutoCRUD_Relationship::getOther() in relationship.inc.php

Returns the other CRUD object

getOtherField

AutoCRUD_Relationship::getOtherField() in relationship.inc.php

Returns the field of the other table

getOwner

AutoCRUD_Relationship::getOwner() in relationship.inc.php

Returns the owner CRUD object

getOwnerField

AutoCRUD_Relationship::getOwnerField() in relationship.inc.php

Returns the field of the owner table

getParent

AutoCRUD_CRUD::getParent() in crud.inc.php

Returns the parent of the CRUD object

getRelationship

AutoCRUD_CRUD::getRelationship() in crud.inc.php

Returns a relationship object with another table

getRelationships

AutoCRUD_CRUD::getRelationships() in crud.inc.php

Returns all the relationships that have been set with other table

getReverseType

AutoCRUD_Relationship::getReverseType() in relationship.inc.php

Returns the reverse relationship type (e.g. many-to-one when the relationship type is one-to-many)

getTablePrefix

AutoCRUD::getTablePrefix() in autocrud.php

Returns the table prefix that has been set

getType

AutoCRUD_Relationship::getType() in relationship.inc.php

Returns the relationship type

get_last_errcode

AutoCRUD_Error::get_last_errcode() in error.inc.php

Alias of the get_last_errno() function

get_last_errmsg

AutoCRUD_Error::get_last_errmsg() in error.inc.php

Used to get the message of the last error that happened

get_last_errno

AutoCRUD_Error::get_last_errno() in error.inc.php

Used to get the code of the last error that happened

get_last_error

AutoCRUD_Error::get_last_error() in error.inc.php

Used to get the last error that happened

halt

AutoCRUD_MySQL::halt() in mysql.inc.php

Used to return an error (mainly used internally)

halt

AutoCRUD::halt() in autocrud.php

Raw MySQL function

$indexes

AutoCRUD_CRUD::$indexes in crud.inc.php

Indexes

include_crud

AutoCRUD::include_crud() in autocrud.php

Include an external CRUD definition file to create the CRUD objects. Can be used to increase performance of the AutoCRUD library, because the database itself isn't inspected at runtime.

insert

AutoCRUD_CRUD::insert() in crud.inc.php

Used to insert a new record, like this:

insert_id

AutoCRUD_MySQL::insert_id() in mysql.inc.php

Used to get the record ID of the last inserted record

insert_id

AutoCRUD::insert_id() in autocrud.php

Raw MySQL function

isConnected

AutoCRUD::isConnected() in autocrud.php

Whether there is a connection or not

isLoaded

AutoCRUD_ActiveRecord::isLoaded() in activerecord.inc.php

Used to check whether a record has been loaded or not

isSetup

AutoCRUD::isSetup() in autocrud.php

Whether CRUD objects have been setup or not

is_connected

AutoCRUD_MySQL::is_connected() in mysql.inc.php

Can be used to check whether there is a connection or not

join

AutoCRUD_CRUD::join() in crud.inc.php

Used to get related records from another table when selecting

joinMany2Many

AutoCRUD_Relationship::joinMany2Many() in relationship.inc.php

Used to get related records of a result set in a Many-to-Many relationship

$key

AutoCRUD_CRUD::$key in crud.inc.php

Primary Key Field

load

AutoCRUD_ActiveRecord::load() in activerecord.inc.php

Used to load an existing record from the table

mysql.inc.php

mysql.inc.php in mysql.inc.php

$name

AutoCRUD_CRUD::$name in crud.inc.php

Object Name

$numeric

AutoCRUD_CRUD::$numeric in crud.inc.php

Numeric Fields

$orderby

AutoCRUD_CRUD::$orderby in crud.inc.php

Custom ORDER BY

$paging

AutoCRUD_CRUD::$paging in crud.inc.php

Paginate Results

$password

AutoCRUD::$password in autocrud.php

MySQL Password

$password

AutoCRUD_MySQL::$password in mysql.inc.php

MySQL Password

$perpage

AutoCRUD_CRUD::$perpage in crud.inc.php

Records Per Page

queries

AutoCRUD_MySQL::queries() in mysql.inc.php

Returns an array of all the queries that have been executed

queries

AutoCRUD::queries() in autocrud.php

Raw MySQL function

query

AutoCRUD_MySQL::query() in mysql.inc.php

Used to execute a query on the database

query

AutoCRUD::query() in autocrud.php

Raw MySQL function

query_first

AutoCRUD_MySQL::query_first() in mysql.inc.php

Used to select a single record

query_first

AutoCRUD::query_first() in autocrud.php

Raw MySQL function

query_num

AutoCRUD::query_num() in autocrud.php

Raw MySQL function

query_num

AutoCRUD_MySQL::query_num() in mysql.inc.php

Returns the number of queries that have been executed

quote

AutoCRUD_MySQL::quote() in mysql.inc.php

Used to prevent SQL injection, will escape all the 'dangerous' characters and put quotes around it

quote

AutoCRUD_CRUD::quote() in crud.inc.php

Raw MySQL Function

quote

AutoCRUD::quote() in autocrud.php

Raw MySQL function

quoteInto

AutoCRUD_MySQL::quoteInto() in mysql.inc.php

Used to quote multiple variables into one statement

quoteInto

AutoCRUD::quoteInto() in autocrud.php

Raw MySQL function

quoteInto

AutoCRUD_CRUD::quoteInto() in crud.inc.php

Raw MySQL Function

$required

AutoCRUD_CRUD::$required in crud.inc.php

Required Fields

relationship_exists

AutoCRUD_CRUD::relationship_exists() in crud.inc.php

Used to check whether a relationship with another table exists

relationship.inc.php

relationship.inc.php in relationship.inc.php

reset

AutoCRUD_ActiveRecord::reset() in activerecord.inc.php

Used to reset all the values of the record when you've made any changes

$server

AutoCRUD_MySQL::$server in mysql.inc.php

MySQL Host

$server

AutoCRUD::$server in autocrud.php

MySQL Host

save

AutoCRUD_ActiveRecord::save() in activerecord.inc.php

Used to save the record (insert or update)

select

AutoCRUD_CRUD::select() in crud.inc.php

Used to select a list of records, like this:

$records = $crud->table->select();

select_db

AutoCRUD_MySQL::select_db() in mysql.inc.php

Used to select a database you want to use

setCode

AutoCRUD_Error::setCode() in error.inc.php

Used to set an error code

setFields

AutoCRUD_Relationship::setFields() in relationship.inc.php

Used to set the fields used in the relationship

setMessage

AutoCRUD_Error::setMessage() in error.inc.php

Used to set an error message

setParent

AutoCRUD_CRUD::setParent() in crud.inc.php

setTablePrefix

AutoCRUD::setTablePrefix() in autocrud.php

When you are using table prefixes, set the prefix using this function, and the library will automatically create aliases for the tables without prefix

setType

AutoCRUD_Relationship::setType() in relationship.inc.php

Used to set the type of relationship

set_parent

AutoCRUD_CRUD::set_parent() in crud.inc.php

Sets the parent of this CRUD object

sql_query

AutoCRUD::sql_query() in autocrud.php

Raw MySQL function

sql_query

AutoCRUD_MySQL::sql_query() in mysql.inc.php

Used to select a list of records

stack

AutoCRUD_Error::stack() in error.inc.php

Used to get an array of all the errors that have happened

$table

AutoCRUD_CRUD::$table in crud.inc.php

Table Name

$totalpages

AutoCRUD_CRUD::$totalpages in crud.inc.php

Total Pages

$totalrecords

AutoCRUD_CRUD::$totalrecords in crud.inc.php

Total Records

$usepconnect

AutoCRUD_MySQL::$usepconnect in mysql.inc.php

Use Persistant Connections

$user

AutoCRUD::$user in autocrud.php

MySQL User

$user

AutoCRUD_MySQL::$user in mysql.inc.php

MySQL User

unique_error

AutoCRUD_CRUD::unique_error() in crud.inc.php

Used to check if a unique error happened

update

AutoCRUD_CRUD::update() in crud.inc.php

Used to update an existing record, like this:

$where

AutoCRUD_CRUD::$where in crud.inc.php

Custom WHERE