PHP 手冊
上一頁 |  | 下一頁

# mysqli_real_connect

(PHP 5)

mysqli_real_connect

(no version information, might be only in CVS)

mysqli->real_connect -- Opens a connection to a mysql server

## Description

Procedural style

bool mysqli_real_connect ( object link [, string hostname [, string username [, string passwd [, string dbname [, int port [, string socket [, int flags]]]]]]])

Object oriented style (method)

class mysqli {
bool real_connect ( [string hostname [, string username [, string passwd [, string dbname [, int port [, string socket [, int flags]]]]]]])
}

mysqli_real_connect() attempts to establish a connection to a MySQL database engine running on hostname.

This function differs from mysqli_connect():

- mysqli_real_connect() needs a valid object which has to be created by function mysqli_init()

- With function mysqli_options() you can set various options for connection.

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

  表格 1.Supported flags

  Name | Description
  --- | ---
  MYSQLI_CLIENT_COMPRESS | Use compression protocol
  MYSQLI_CLIENT_FOUND_ROWS | return number of matched rows, not the number of affected rows
  MYSQLI_CLIENT_IGNORE_SPACE | Allow spaces after function names. Makes all function names reserved words.
  MYSQLI_CLIENT_INTERACTIVE | Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection
  MYSQLI_CLIENT_SSL | Use SSL (encryption)

  > 備注: 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.

## Return values

成功回傳`TRUE`失敗回傳`FALSE`。

## 參考

mysqli_connect(), mysqli_init(), mysqli_options(), mysqli_ssl_set(), mysqli_close().

## Example

示範 1.Object oriented style
`<?php /* create a connection object which is not connected */ $mysqli = mysqli_init(); /* set connection options */ $mysqli->options(MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=0"); $mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5); /* connect to server */ $mysqli->real_connect('localhost', 'my_user', 'my_password', 'world'); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } printf ("Connection: %s\n.", $mysqli->host_info); $mysqli->close(); ?>`

示範 2.Procedural style
`<?php /* create a connection object which is not connected */ $link = mysqli_init(); /* set connection options */ mysqli_options($link, MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=0"); mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 5); /* connect to server */ mysqli_real_connect($link, 'localhost', 'my_user', 'my_password', 'world'); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } printf ("Connection: %s\n.", mysqli_get_host_info($link)); mysqli_close($link); ?>`

The above examples would produce the following output:

    Connection: Localhost via UNIX socket

上一頁 | 最開頭 | 下一頁
mysqli_query | 上一層 | mysqli_real_escape_string