PHP mysqli Entry Application implementation

By default mysqli is not open in PHP and we need to
To use mysqli extensions in PHP, you need to add the following settings to the configuration file php.ini:

The code is as follows	Copy Code
Extension=php_mysqli.dll

If the configuration file already has the above settings, make sure the extension is not preceded by ";" or remove it. Here's how to use the mysqli extension to access the database.

The code is as follows	Copy Code
<?php $db _host= "localhost"; The server address of the connection $db _user= "root"; User name to connect to database $db _psw= "root"; Password to connect to the database $db _name= "Sunyang"; Database name of the connection $mysqli =new mysqli (); $mysqli->connect ($db _host, $db _user, $db _psw, $db _name); ?>

Shut down the connection to the MySQL server by calling the close () method with the Mysqli object, for example:
$mysqli->close ();

The code is as follows	Copy Code
<?php $connection = Mysqli_connect ("localhost", "root", "root", "Sunyang"); if ($connection) { echo "Database connection succeeded"; }else { echo "Database connection failed"; } ?>

Data query

The code is as follows

Copy Code

<?php $mysqli =new mysqli ("localhost", "root", "root", "Sunyang"); Instantiation of Mysqli $query = "SELECT * FROM Employee"; $result = $mysqli->query ($query); if ($result) { if ($result->num_rows>0) {//Determine if the number of rows in the result set is greater than 0 while ($row = $result->fetch_array ()) {//Loops output records in a result set Echo ($row [0]). " <br> "; Echo ($row [1]). " <br> "; Echo ($row [2]). " <br> "; Echo ($row [3]). " <br> "; echo "} } }else { echo "Query failed"; } $result->free (); $mysqli->close (); ?>

Other like data save wait

Member methods in the Mysqli class

__construct (): Constructs a method to create a Mysqli object, or to establish a connection.

Autocommit (): Turn on or off database modification autocommit.

Change_user (): Changes the user specified by the database connection.

Character_set_name (): Returns the database connection default character set.

Close (): Closes a previously opened connection.

Commit (): Commit the current thing.

Connect (): Open a new connection to the MySQL database server.

Debug (): Perform debugging operations.

Dump_debug_info (): Dumps debugging information.

Get_client_info (): Returns the client version.

Get_host_info (): Returns a String representing the type of connection used, such as: Localhost via UNIX socket

Get_server_info (): Returns the MySQL server version.

Get_server_version (): Returns the MySQL server version in integer form.

Init (): Initializes a mysqli and returns a resource.

Info (): Retrieves the most recently executed query.

Kill (): kills a MySQL thread.

Multi_query (): Executes multiple query statements.

More_results (): Retrieves any more query results from a multiple query statement.

Next_result (): reads the next result from the currently executing multiple query.

Options (): Sets the option.

Ping (): Ping a server to connect or reconnect if there is no connection.

Prepare (): Prepares the execution of an SQL statement, returning the Mysqli_stmt object.

Query (): Interaction with a database is done through a query that sends a query to the database to execute, and the execution fails to return false.

Real_connect (): Attempting to open a connection to the MySQL database server.

Escape_string (): A string that escapes special characters.

Rollback (): Rolls back the current transaction.

select_db (): Select a default database for the database query.

Set_charset (): Sets the default client character set.

Ssl_set (): Use SSL to establish a secure connection.

Stat (): Gets the current system state.

Stmt_init (): Initializes a declaration that returns a Mysql_stmt object.

Store_result (): Transfer the result set from the last query.

Thread_safe (): whether to consider returning a secure thread.

member properties in the MySQL class

$affected _rows: The number of rows affected in the previous MySQL operation.

$client _info:mysql Client version (string).

$client _version:mysql Client version (integer).

$errno: The error code for the most recent function call.

$error: The error message string for the most recent function call.

$field _count (): The number of columns fetched by the query.

$host _info: The connection type is used (a string).

$info: Recently executed query.

$insert _id: The number that was automatically generated by the last query.

$protocol the version used by the _version:mysql protocol.

$sqlstate: The last error containing the SQLSTATE error code.

$thread _id: Current connection thread ID.

$warning _count: The number of warnings generated during the execution of the previous SQL statement.