PHP Class ezSQL_mysqli

Inheritance: extends ezSQL_Base
显示文件 Open project: jv2222/ezsql Class Usage Examples

Public Properties

Property Type Description
$dbhost
$dbname
$dbpassword
$dbport
$dbuser
$encoding
$rows_affected

Public Methods

Method Description
__construct ( $dbuser = '', $dbpassword = '', $dbname = '', $dbhost = 'localhost', $encoding = '' ) ******************************************************************** Constructor - allow the user to perform a quick connect at the same time as initialising the ezSQL_mysqli class
connect ( $dbuser = '', $dbpassword = '', $dbhost = 'localhost', $dbport = false ) ******************************************************************** Try to connect to mySQL database server
disconnect ( ) ******************************************************************** Close the active mySQLi connection
escape ( $str ) ******************************************************************** Format a mySQL string correctly for safe mySQL insert (no mater if magic quotes are on or not)
query ( $query ) ******************************************************************** Perform mySQL query and try to determine result value
quick_connect ( $dbuser = '', $dbpassword = '', $dbname = '', $dbhost = 'localhost', $dbport = '3306', $encoding = '' ) ******************************************************************** Short hand way to connect to mySQL database server and select a mySQL database at the same time
select ( $dbname = '', $encoding = '' ) ******************************************************************** Try to select a mySQL database
sysdate ( ) ******************************************************************** Return mySQL specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()

Method Details

__construct() public method

******************************************************************** Constructor - allow the user to perform a quick connect at the same time as initialising the ezSQL_mysqli class
public __construct ( $dbuser = '', $dbpassword = '', $dbname = '', $dbhost = 'localhost', $encoding = '' )

connect() public method

******************************************************************** Try to connect to mySQL database server
public connect ( $dbuser = '', $dbpassword = '', $dbhost = 'localhost', $dbport = false )

disconnect() public method

******************************************************************** Close the active mySQLi connection
public disconnect ( )

escape() public method

******************************************************************** Format a mySQL string correctly for safe mySQL insert (no mater if magic quotes are on or not)
public escape ( $str )

query() public method

******************************************************************** Perform mySQL query and try to determine result value
public query ( $query )

quick_connect() public method

******************************************************************** Short hand way to connect to mySQL database server and select a mySQL database at the same time
public quick_connect ( $dbuser = '', $dbpassword = '', $dbname = '', $dbhost = 'localhost', $dbport = '3306', $encoding = '' )

select() public method

******************************************************************** Try to select a mySQL database
public select ( $dbname = '', $encoding = '' )

sysdate() public method

******************************************************************** Return mySQL specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()
public sysdate ( )

Property Details

$dbhost public_oe property

public $dbhost

$dbname public_oe property

public $dbname

$dbpassword public_oe property

public $dbpassword

$dbport public_oe property

public $dbport

$dbuser public_oe property

public $dbuser

$encoding public_oe property

public $encoding

$rows_affected public_oe property

public $rows_affected