PHP mysqli_real_connect() Function

In this chapter you will learn:

Definition for PHP mysqli_real_connect() Function
Syntax for PHP mysqli_real_connect() Function
Parameter for PHP mysqli_real_connect() Function
Return for PHP mysqli_real_connect() Function
Example - opens a new connection to the MySQL server

Definition

The mysqli_real_connect() function opens a new connection to the MySQL server.

Syntax

PHP mysqli_real_connect() Function has the following syntax.

mysqli_real_connect(connection,host,username,password,dbname,port,socket,flag);

Parameter

Parameter	Is Required	Description
connection	Required.	MySQL connection to use
host	Optional.	Host name or an IP address
username	Optional.	Username
password	Optional.	Password
dbname	Optional.	Default database to be used
port	Optional.	Port number to the MySQL server
socket	Optional.	Socket or named pipe to be used
flag	Optional.	Connection options.

Possible values for flag option:

Value	Meaning
MYSQLI_CLIENT_COMPRESS	Use compression protocol
MYSQLI_CLIENT_FOUND_ROWS	Return number of matched rows
MYSQLI_CLIENT_IGNORE_SPACE	Allow spaces after function names. Make function names reserved words
MYSQLI_CLIENT_INTERACTIVE	Allow interactive_timeout seconds of inactivity before closing connection
MYSQLI_CLIENT_SSL	Use SSL encryption

Return

It returns TRUE on success and FALSE on failure.

Example

mysqli_real_connect() requires a valid object created by mysqli_init(). It can be used with mysqli_options() to set different options for the connection.


<?php/*j  av a2 s .  c  o  m*/
$con=mysqli_init();
if (!$con){
  die("mysqli_init failed");
}

if (!mysqli_real_connect($con,"localhost","my_user","my_password","my_db")){
  die("Connect Error: " . mysqli_connect_error());
}

mysqli_close($con);
?>

Next chapter...

What you will learn in the next chapter:

Home » PHP Tutorial » PHP MySQLi Functions

PHP mysqli_affected_rows() Function

PHP mysqli_autocommit() Function

PHP mysqli_change_user() Function

PHP mysqli_character_set_name() Function

PHP mysqli_close() Function

PHP mysqli_commit() Function

PHP mysqli_connect() Function

PHP mysqli_connect_errno() Function

PHP mysqli_connect_error() Function

PHP mysqli_data_seek() Function

PHP mysqli_dump_debug_info() Function

PHP mysqli_errno() Function

PHP mysqli_error() Function

PHP mysqli_error_list() Function

PHP mysqli_fetch_all() Function

PHP mysqli_fetch_array() Function

PHP mysqli_fetch_assoc() Function

PHP mysqli_fetch_field() Function

PHP mysqli_fetch_field_direct() Function

PHP mysqli_fetch_fields() Function

PHP mysqli_fetch_lengths() Function

PHP mysqli_fetch_object() Function

PHP mysqli_fetch_row() Function

PHP mysqli_field_count() Function

PHP mysqli_field_seek() Function

PHP mysqli_field_tell() Function

PHP mysqli_free_result() Function

PHP mysqli_get_charset() Function

PHP mysqli_get_client_info() Function

PHP mysqli_get_client_stats() Function

PHP mysqli_get_client_version() Function

PHP mysqli_get_connection_stats() Function

PHP mysqli_get_host_info() Function

PHP mysqli_get_proto_info() Function

PHP mysqli_get_server_info() Function

PHP mysqli_get_server_version() Function

PHP mysqli_info() Function

PHP mysqli_init() Function

PHP mysqli_insert_id() Function

PHP mysqli_kill() Function

PHP mysqli_more_results() Function

PHP mysqli_multi_query() Function

PHP mysqli_next_result() Function

PHP mysqli_num_fields() Function

PHP mysqli_num_rows() Function

PHP mysqli_options() Function

PHP mysqli_ping() Function

PHP mysqli_query() Function

PHP mysqli_real_connect() Function

PHP mysqli_real_escape_string() Function

PHP mysqli_refresh() Function

PHP mysqli_rollback() Function

PHP mysqli_select_db() Function

PHP mysqli_set_charset() Function

PHP mysqli_sqlstate() Function

PHP mysqli_ssl_set() Function

PHP mysqli_stat() Function

PHP mysqli_stmt_init() Function

PHP MySQL mysqli_thread_id() Function

PHP mysqli_thread_safe() Function