Function.mysqli-real-connect

Aus PHP-Wiki

Wechseln zu: Navigation, Suche
Rechtschutzversicherung und Rechtsschutzversicherung Vergleichen Online - Schadensabwicklung, Haftpflichtversicherung- Abgrenzungen zu den anderen Haftpflichtversicherungen . Autoversicherung Vergleichen Online - Kostenloser Autoversicherungsvergleich

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

Inhaltsverzeichnis

Description

Procedural style

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

Object oriented style (method)

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

mysql_real_connect() attempts to establish a connection to a MySQL database engine running on host.

This function differs from function.mysqli-connect:

  • mysqli_real_connect() needs a valid object which has to be created by function function.mysqli-init

  • With function function.mysqli-options you can set various options for connection.

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


    Tabelle 1. Supported flags

    <THEAD ></THEAD ><TBODY ></TBODY >
    NameDescription
    MYSQLI_CLIENT_COMPRESSUse compression protocol
    MYSQLI_CLIENT_FOUND_ROWSreturn number of matched rows, not the number of affected rows
    MYSQLI_CLIENT_IGNORE_SPACEAllow 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_SSLUse SSL (encryption)

    Anmerkung: For security reasons the MULTI_STATEMENT flag is not supported in PHP. If you want to execute multiple queries use the function.mysqli-multi-query function.


Return values

Gibt bei Erfolg TRUE zurück, im Fehlerfall FALSE.


Siehe auch

function.mysqli-connect, function.mysqli-init, function.mysqli-options, function.mysqli-ssl-set, function.mysqli-close.


Example


Beispiel 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();
?>

Beispiel 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
Von „http://php-wiki.de/index.php/Function.mysqli-real-connect“
Persönliche Werkzeuge