Mysql
class Mysql implements IDatabase
MySql Database Class
Properties
protected bool | $_isConnected | Database connection state | |
protected Mysqli | $_db | MySql Database object | |
static protected Mysql | $_instance | Database Singleton | |
Mysql | $mysqlResult | Mysql Result | |
string | $host | Can be either a host name or an IP address. | |
string | $user | The MySQL user name. | |
string | $password | If not provided or NULL, the MySQL server will attempt to authenticate the user against those user records which have no password only. | |
string | $name | If provided will specify the default database to be used when performing queries. |
Methods
Singleton
No description
(non-PHPdoc)
Destruct
(non-PHPdoc)
Turns on or off auto-committing database modifications
Performs a query on the database
Commits the current transaction
Rolls back current transaction
Prepare an SQL statement for execution
Returns the mysqli object
(non-PHPdoc)
Fetch
Mysql Update or Delete
Sqlite Insert
(non-PHPdoc)
Set Options
(non-PHPdoc)
Update Row
Delete Insert Row
Name Set Support
Character Set Support
Details
at line 95
static Mysql
getInstance()
Singleton
at line 104
__wakeup()
at line 114
connect(array $options = null)
(non-PHPdoc)
at line 135
__destruct()
Destruct
at line 147
close()
(non-PHPdoc)
at line 158
boolean
autocommit(boolean $mode)
Turns on or off auto-committing database modifications
at line 169
mixed
tquery(string $query)
Performs a query on the database
at line 179
boolean
commit()
Commits the current transaction
at line 189
boolean
rollback()
Rolls back current transaction
at line 199
mysqli_stmt|boolean
prepare()
Prepare an SQL statement for execution
at line 209
mysqli
DB()
Returns the mysqli object
at line 219
query($query, array $options = null, $isTransaction = false)
(non-PHPdoc)
at line 284
protected multitype:array
_fetch(string $query, string $return = "assoc")
Fetch
at line 318
protected number|boolean
_exec(string $query)
Mysql Update or Delete
at line 338
protected number|boolean
_insert(string $query)
Sqlite Insert
at line 356
bool
isConnected()
(non-PHPdoc)
at line 366
setOptions(array $options = null)
Set Options
at line 396
string
escapeString($query)
(non-PHPdoc)
at line 409
Mysql
insertRow(object $obj, string $table, array $ignores = null)
Insert Row
at line 472
Mysql
updateRow(object $obj, string $table, string|array $key, string|array $value, array $ignores = null)
Update Row
at line 560
Mysql
deleteRow(object $obj, string $table, string|array $key, string|array $value)
Delete Row
at line 621
Mysql
deleteInsertRow(object $obj, string $table, string|array $key, string|array $value, array $ignores = null)
Delete Insert Row
at line 635
setCharset(string $encoding = 'utf8')
Name Set Support
at line 645
setNames(string $encoding = 'utf8')
Character Set Support