real-connect

mysqli::real_connect

mysqli_real_connect

Opens a connection to the MySQL server

ENTITY

ENTITY

ENTITY

bool

mysqli_real_connect

mysqli

mysql

string

null

hostname

ENTITY

string

null

username

ENTITY

string

null

password

ENTITY

string

null

database

ENTITY

int

null

port

ENTITY

string

null

socket

ENTITY

int

flags

0

Opens a connection to the MySQL database server with optional connection options.

This function differs from mysqli_connect:

• mysqli_real_connect needs a valid object which has to be created by mysqli_init.

• There is a flags parameter.

ENTITY

hostname
Can be either a host name or an IP address. When passing ENTITY, the value is retrieved from mysqli.default_host. When possible, pipes will be used instead of the TCP/IP protocol. The TCP/IP protocol is used if a host name and port number are provided together e.g. localhost:3308.

username
The MySQL username or ENTITY to assume the username based on the mysqli.default_user ini option.

password
The MySQL password or ENTITY to assume the password based on the mysqli.default_pw ini option.

database
The default database to be used when performing queries or ENTITY.

port
The port number to attempt to connect to the MySQL server or ENTITY to assume the port based on the mysqli.default_port ini option.

socket
The socket or named pipe that should be used or ENTITY to assume the socket based on the mysqli.default_socket ini option.

[!NOTE] Specifying the socket parameter will not explicitly determine the type of connection to be used when connecting to the MySQL server. How the connection is made to the MySQL database is determined by the hostname parameter.

flags
With the parameter flags you can set different connection options:

Supported flags {#mysqli.real-connect.flags}

[!NOTE] For security reasons the MULTI_STATEMENT flag is not supported in PHP. If you want to execute multiple queries use the mysqli_multi_query function.

ENTITY

ENTITY

ENTITY ENTITY

ENTITY

ENTITY

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = mysqli_init();

$mysqli->options(MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0');
$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5);

$mysqli->real_connect('localhost', 'my_user', 'my_password', 'my_db', null, null, MYSQLI_CLIENT_COMPRESS|MYSQLI_CLIENT_FOUND_ROWS);

echo 'Success... ' . $mysqli->host_info . "\n";

   

<?php

class foo_mysqli extends mysqli {
    public function __construct($host, $user, $pass, $db)
    {
        parent::__construct();

        parent::options(MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0');
        parent::options(MYSQLI_OPT_CONNECT_TIMEOUT, 5);

        parent::real_connect($host, $user, $pass, $db, null, null, MYSQLI_CLIENT_COMPRESS|MYSQLI_CLIENT_FOUND_ROWS);
    }
}

$db = new foo_mysqli('localhost', 'my_user', 'my_password', 'my_db');

echo 'Success... ' . $db->host_info . "\n";

   

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_init();

mysqli_options($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0');
mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 5);

mysqli_real_connect($link, 'localhost', 'my_user', 'my_password', 'my_db', null, null, MYSQLI_CLIENT_COMPRESS|MYSQLI_CLIENT_FOUND_ROWS);

echo 'Success... ' . mysqli_get_host_info($link) . "\n";

   

Success... MySQL host info: localhost via TCP/IP

ENTITY ENTITY

ENTITY

mysqli_connect, mysqli_init, mysqli_options, mysqli_ssl_set, mysqli_close