• 홈
• DBmysql

PHP 클래스 DBmysql, glpi

파일 보기 프로젝트 열기: glpi-project/glpi 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
$connected		Is connected to the DB ?
$dbdefault		! Default Database
$dbh		! Database Handler
$dbhost		! Database Host - string or Array of string (round robin)
$dbpassword		! Database Password
$dbuser		! Database User
$error		! Database Error
$first_connection		Is it a first connection ? Indicates if the first connection attempt is successful or not if first attempt fail -> display a warning which indicates that glpi is in readonly
$slave		Slave management

공개 메소드들

메소드	설명
__construct ( $choice = NULL ) : nothing	Constructor / Connect to the MySQL Database
affected_rows ( ) : number	Get number of affected rows in previous MySQL operation
checkForCrashedTables ( ) : an	Check for crashed MySQL Tables
close ( ) : TRUE	Close MySQL connection
connect ( $choice = NULL ) : nothing	Connect using current database settings
data_seek ( $result, $num ) : boolean	Move current pointer of a Mysql result to the specific row
errno ( ) : error	Returns the numerical value of the error message from previous MySQL operation
error ( ) : error	Returns the text of the error message from previous MySQL operation
escape ( $string ) : String	Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection
fetch_array ( $result ) : result	Fetch array of the next row of a Mysql query Please prefer fetch_row or fetch_assoc
fetch_assoc ( $result ) : result	Fetch assoc of the next row of a Mysql query
fetch_row ( $result ) : result	Fetch row of the next row of a Mysql query
field_flags ( $result, $field ) : flags	Get flags of a field of a mysql result
field_name ( $result, $nb ) : name	Give name of a field of a Mysql result
free_result ( $result ) : Returns	Free result memory
getInfo ( ) : Array	Get information about DB connection for showSystemInformations
getLock ( $name ) : boolean	Get a global DB lock
insert_id ( ) : item	Give ID of the last insert item by Mysql
isMySQLStrictMode ( &$msg )
isSlave ( ) : boolean	is a slave database ?
list_fields ( $table, $usecache = true ) : list	List fields of a table
list_tables ( $table = "glpi_%" ) : list	List tables in database
num_fields ( $result ) : number	Give number of fields of a Mysql result
numrows ( $result ) : number	Give number of rows of a Mysql result
optimize_tables ( $migration = NULL, $cron = false ) : number	Optimize sql table
prepare ( $query ) : a	Prepare a MySQL query
query ( $query ) : Query	Execute a MySQL query
queryOrDie ( $query, $message = '' ) : Query	Execute a MySQL query
releaseLock ( $name ) : boolean	Release a global DB lock
request ( $tableorsql, $crit = "", $debug = false ) : DBIterator	Instanciate a Simple DBIterator
result ( $result, $i, $field ) : Value	Give result from a mysql result
runFile ( $path ) : boolean	Execute all the request in a file

메소드 상세

프로퍼티 상세