• Accueil
• MySQL

PHP Class MySQL

Afficher le fichier Open project: kimai/kimai Class Usage Examples

Méthodes publiques

Свойство	Type	Description
$ThrowExceptions		Determines if an error throws an exception
$mysql_link		class-internal variables - do not change

Méthodes publiques

Méthode	Description
AutoInsertUpdate ( string $tableName, array $valuesArray, array $whereArray ) : boolean	Automatically does an INSERT or UPDATE depending if an existing record exists in a table
BeginningOfSeek ( ) : boolean	Returns true if the internal pointer is at the beginning of the records
BuildSQLDelete ( string $tableName, array $whereArray = null ) : string	[STATIC] Builds a SQL DELETE statement
BuildSQLInsert ( string $tableName, array $valuesArray ) : string	[STATIC] Builds a SQL INSERT statement
BuildSQLSelect ( string $tableName, array $whereArray = null, array/string $columns = null, array/string $sortColumns = null, boolean $sortAscending = true, integer/string $limit = null ) : string	Builds a simple SQL SELECT statement
BuildSQLUpdate ( string $tableName, array $valuesArray, array $whereArray = null ) : string	[STATIC] Builds a SQL UPDATE statement
BuildSQLWhereClause ( array $whereArray ) : string	[STATIC] Builds a SQL WHERE clause from an array.
Close ( ) : object	Close current MySQL connection
DeleteRows ( string $tableName, array $whereArray = null ) : boolean	Deletes rows in a table based on a WHERE filter (can be just one or many rows based on the filter)
EndOfSeek ( ) : boolean	Returns true if the internal pointer is at the end of the records
Error ( ) : string	Returns the last MySQL error as text
ErrorNumber ( ) : integer	Returns the last MySQL error as a number
GetBooleanValue ( mixed $value ) : boolean	[STATIC] Converts any value of any datatype into boolean (true or false)
GetColumnComments ( string $table ) : array	Returns the comments for fields in a table into an array or NULL if the table has not got any fields
GetColumnCount ( string $table = "" ) : integer	This function returns the number of columns or returns FALSE on error
GetColumnDataType ( string $column, string $table = "" ) : string	This function returns the data type for a specified column. If the column does not exists or no records exist, it returns FALSE
GetColumnID ( string $column, string $table = "" ) : integer	This function returns the position of a column
GetColumnLength ( string $column, string $table = "" ) : integer	This function returns the field length or returns FALSE on error
GetColumnName ( string $columnID, string $table = "" ) : integer	This function returns the name for a specified column number. If the index does not exists or no records exist, it returns FALSE
GetColumnNames ( string $table = "" ) : array	Returns the field names in a table or query in an array
GetHTML ( boolean $showCount = true, string $styleTable = null, string $styleHeader = null, string $styleData = null ) : string	This function returns the last query as an HTML table
GetJSON ( ) : string	Returns the last query as a JSON document
GetLastInsertID ( ) : integer	Returns the last autonumber ID field from a previous INSERT query
GetLastSQL ( ) : string	Returns the last SQL statement executed
GetTables ( ) : array	This function returns table names from the database into an array. If the database does not contains any tables, the returned value is FALSE
GetXML ( ) : string	Returns the last query as an XML Document
HasRecords ( string $sql = "" ) : boolean	Determines if a query contains any rows
InsertRow ( string $tableName, array $valuesArray ) : integer	Inserts a row into a table in the connected database
IsConnected ( ) : boolean	Determines if a valid connection to the database exists
IsDate ( date/string $value ) : boolean	[STATIC] Determines if a value of any data type is a date PHP can convert
Kill ( $message = "" )	Stop executing (die/exit) and show last MySQL error message
MoveFirst ( ) : boolean	Seeks to the beginning of the records
MoveLast ( ) : boolean	Seeks to the end of the records
Open ( string $database = null, string $server = null, string $username = null, string $password = null, string $charset = null, boolean $pcon = false ) : boolean	Connect to specified MySQL server
Query ( string $sql ) : object	Executes the given SQL query and returns the records
QueryArray ( string $sql, integer $resultType = MYSQLI_BOTH ) : array	Executes the given SQL query and returns a multi-dimensional array
QuerySingleRow ( string $sql ) : object	Executes the given SQL query and returns only one (the first) row
QuerySingleRowArray ( string $sql, integer $resultType = MYSQLI_BOTH ) : array	Executes the given SQL query and returns the first row as an array
QuerySingleValue ( string $sql ) : mixed	Executes a query and returns a single value. If more than one row is returned, only the first value in the first column is returned.
QueryTimed ( string $sql ) : object	Executes the given SQL query, measures it, and saves the total duration in microseconds
Records ( ) : object	Returns the records from the last query
RecordsArray ( integer $resultType = MYSQLI_BOTH ) : Records	Returns all records from last query and returns contents as array or FALSE on error
Release ( ) : boolean	Frees memory used by the query results and returns the function result
Row ( integer $optional_row_number = null ) : object	Reads the current row and returns contents as a PHP object or returns false on error
RowArray ( integer $optional_row_number = null, integer $resultType = MYSQLI_BOTH ) : array	Reads the current row and returns contents as an array or returns false on error
RowCount ( ) : integer	Returns the last query row count
SQLBooleanValue ( mixed $value, mixed $trueValue, mixed $falseValue, string $datatype = self::SQLVALUE_TEXT ) : string	[STATIC] Converts a boolean into a formatted TRUE or FALSE value of choice
SQLFix ( string $value ) : string	Returns string suitable for SQL NOTE: This is no longer a static call because of a conflict with mysqli_real_escape_string.
SQLValue ( mixed $value, string $datatype = self::SQLVALUE_TEXT ) : string	[STATIC] Formats any value into a string suitable for SQL statements (NOTE: Also supports data types returned from the gettype function)
Seek ( integer $row_number ) : object	Sets the internal database pointer to the specified row number and returns the result
SeekPosition ( ) : integer	Returns the current cursor row location
SelectDatabase ( string $database, string $charset = "" ) : boolean	Selects a different database and character set
SelectRows ( string $tableName, array $whereArray = null, array/string $columns = null, array/string $sortColumns = null, boolean $sortAscending = true, integer/string $limit = null ) : boolean	Gets rows in a table based on a WHERE filter
SelectTable ( string $tableName ) : boolean	Retrieves all rows in a specified table
TimerDuration ( integer $decimals = 4 ) : Float	Returns last measured duration (time between TimerStart and TimerStop)
TimerStart ( )	Starts time measurement (in microseconds)
TimerStop ( )	Stops time measurement (in microseconds)
TransactionBegin ( ) : boolean	Starts a transaction
TransactionEnd ( ) : boolean	Ends a transaction and commits the queries
TransactionRollback ( ) : boolean	Rolls the transaction back
TruncateTable ( string $tableName ) : boolean	Truncates a table removing all data
UpdateRows ( string $tableName, array $valuesArray, array $whereArray = null ) : boolean	Updates rows in a table based on a WHERE filter (can be just one or many rows based on the filter)
__construct ( boolean $connect = true, string $database = null, string $server = null, string $username = null, string $password = null, string $charset = null )	Constructor: Opens the connection to the database
__destruct ( )	Destructor: Closes the connection to the database

Private Methods

Méthode	Description
BuildSQLColumns ( $columns, boolean $addQuotes = true, boolean $showAlias = true ) : string	[STATIC] Builds a comma delimited list of columns for use with SQL
ResetError ( )	Clears the internal variables from any error information
SetError ( string $errorMessage = "", integer $errorNumber )	Sets the local variables with the last error information

Method Details

Property Details