Forgot Password ??

PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone

	Registered : 109,027

HOME > PHP Manual > The MySQLi class

ลองใช้ค้นหาข้อมูล

Predefined Constants

mysqli->affected_rows

Mysqli

PHP Manual

The MySQLi class

Introduction

Represents a connection between PHP and a MySQL database.

Class synopsis

MySQLi

class MySQLi {

/* Properties */

int $affected_rows;

string $connect_errno;

string $connect_error;

int $errno;

string $error;

int $field_count;

string $host_info;

string $protocol_version;

string $server_info;

int $server_version;

string $info;

int $insert_id;

string $sqlstate;

int $thread_id;

int $warning_count;

/* Methods */

int mysqli_affected_rows ( mysqli $link )

bool mysqli::autocommit ( bool $mode )

bool mysqli::change_user ( string $user , string $password , string $database )

string mysqli::character_set_name ( void )

bool mysqli::close ( void )

bool mysqli::commit ( void )

int mysqli_connect_errno ( void )

string mysqli_connect_error ( void )

mysqli mysqli_connect ([ string $host [, string $username [, string $passwd [, string $dbname [, int $port [, string $socket ]]]]]] )

bool mysqli::debug ( string $message )

bool mysqli::dump_debug_info ( void )

int mysqli_errno ( mysqli $link )

string mysqli_error ( mysqli $link )

int mysqli_field_count ( mysqli $link )

object mysqli::get_charset ( void )

string mysqli::get_client_info ( void )

int mysqli::get_client_version ( void )

string mysqli_get_host_info ( mysqli $link )

int mysqli_get_proto_info ( mysqli $link )

string mysqli_get_server_info ( mysqli $link )

int mysqli_get_server_version ( mysqli $link )

object mysqli::get_warnings ( void )

string mysqli_info ( mysqli $link )

mysqli init ( void )

int mysqli_insert_id ( mysqli $link )

bool mysqli::kill ( int $processid )

bool mysqli::more_results ( void )

bool mysqli::multi_query ( string $query )

bool mysqli::next_result ( void )

bool mysqli::options ( int $option , mixed $value )

bool mysqli::ping ( void )

mysqli_stmt prepare ( string $query )

mixed mysqli::query ( string $query [, int $resultmode ] )

bool mysqli::real_connect ([ string $host [, string $username [, string $passwd [, string $dbname [, int $port [, string $socket [, int $flags ]]]]]]] )

string mysqli::escape_string ( string $escapestr )

bool real_query ( string $query )

bool mysqli::rollback ( void )

bool mysqli::select_db ( string $dbname )

bool mysqli::set_charset ( string $charset )

void mysqli_set_local_infile_default ( mysqli $link )

bool mysqli_set_local_infile_handler ( mysqli $link , callback $read_func )

string mysqli_sqlstate ( mysqli $link )

bool mysqli::ssl_set ( string $key , string $cert , string $ca , string $capath , string $cipher )

string mysqli::stat ( void )

mysqli_stmt stmt_init ( void )

mysqli_result store_result ( void )

int mysqli_thread_id ( mysqli $link )

bool mysqli_thread_safe ( void )

mysqli_result use_result ( void )

int mysqli_warning_count ( mysqli $link )

}

mysqli->affected_rows — Gets the number of affected rows in a previous MySQL operation
mysqli::autocommit — Turns on or off auto-commiting database modifications
mysqli::change_user — Changes the user of the specified database connection
mysqli::character_set_name — Returns the default character set for the database connection
mysqli::close — Closes a previously opened database connection
mysqli::commit — Commits the current transaction
mysqli->connect_errno — Returns the error code from last connect call
mysqli->connect_error — Returns a string description of the last connect error
mysqli::__construct — Open a new connection to the MySQL server
mysqli::debug — Performs debugging operations
mysqli::dump_debug_info — Dump debugging information into the log
mysqli->errno — Returns the error code for the most recent function call
mysqli->error — Returns a string description of the last error
mysqli->field_count — Returns the number of columns for the most recent query
mysqli::get_charset — Returns a character set object
mysqli::get_client_info — Returns the MySQL client version as a string
mysqli::get_client_version — Get MySQL client info
mysqli->host_info — Returns a string representing the type of connection used
mysqli->protocol_version — Returns the version of the MySQL protocol used
mysqli->server_info — Returns the version of the MySQL server
mysqli->server_version — Returns the version of the MySQL server as an integer
mysqli::get_warnings — Description
mysqli->info — Retrieves information about the most recently executed query
mysqli::init — Initializes MySQLi and returns a resource for use with mysqli_real_connect()
mysqli->insert_id — Returns the auto generated id used in the last query
mysqli::kill — Asks the server to kill a MySQL thread
mysqli::more_results — Check if there are any more query results from a multi query
mysqli::multi_query — Performs a query on the database
mysqli::next_result — Prepare next result from multi_query
mysqli::options — Set options
mysqli::ping — Pings a server connection, or tries to reconnect if the connection has gone down
mysqli::prepare — Prepare a SQL statement for execution
mysqli::query — Performs a query on the database
mysqli::real_connect — Opens a connection to a mysql server
mysqli::real_escape_string — Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection
mysqli::real_query — Execute an SQL query
mysqli::rollback — Rolls back current transaction
mysqli::select_db — Selects the default database for database queries
mysqli::set_charset — Sets the default client character set
mysqli::set_local_infile_default — Unsets user defined handler for load local infile command
mysqli::set_local_infile_handler — Set callback function for LOAD DATA LOCAL INFILE command
mysqli->sqlstate — Returns the SQLSTATE error from previous MySQL operation
mysqli::ssl_set — Used for establishing secure connections using SSL
mysqli::stat — Gets the current system status
mysqli::stmt_init — Initializes a statement and returns an object for use with mysqli_stmt_prepare
mysqli::store_result — Transfers a result set from the last query
mysqli::thread_id — Returns the thread ID for the current connection
mysqli::thread_safe — Returns whether thread safety is given or not
mysqli::use_result — Initiate a result set retrieval
mysqli::warning_count — Returns the number of warnings from the last query for the given link

Predefined Constants

mysqli->affected_rows

Mysqli

PHP Manual

สอน Windows Phone การเขียนโปรแกรม Windows Phone 7 และ 8

สอน Java GUI การเขียนโปรแกรม ภาษา Java GUI

Free Tutorial

	สอน Google Maps Api
	สอน Windows Service
	สอน Entity Framework
	สอน Android
	สอน Java เขียน Java
	Java GUI Swing
	สอน JSP (Web App)
	iOS (iPhone,iPad)
	Windows Phone
	Windows Azure
	Windows Store
	Laravel Framework
	Yii PHP Framework
	สอน jQuery
	สอน jQuery กับ Ajax
	สอน PHP OOP (Vdo)
	Ajax Tutorials
	SQL Tutorials
	สอน SQL (Part 2)
	JavaScript Tutorial
	Javascript Tips
	VBScript Tutorial
	VBScript Validation
	Microsoft Access
	MySQL Tutorials
	-- Stored Procedure
	MariaDB Database
	SQL Server Tutorial
	SQL Server 2005
	SQL Server 2008
	SQL Server 2012
	-- Stored Procedure
	Oracle Database
	-- Stored Procedure
	SVN (Subversion)
	แนวทางการทำ SEO
	ปรับแต่งเว็บให้โหลดเร็ว