Fungsi PHP mysqli real_connect()

Contoh - Gaya Berorientasi Objek

Buka koneksi baru ke server MySQL, dengan opsi koneksi tambahan:

<?php
$mysqli = mysqli_init();
if (!$mysqli) {
die("mysqli_init failed");
}

// Specify connection timeout
$con -> options(MYSQLI_OPT_CONNECT_TIMEOUT, 10);

// Specify read options from named file instead of my.cnf
$con -> options(MYSQLI_READ_DEFAULT_FILE, "myfile.cnf");

$con -> real_connect("localhost","my_user","my_password","my_db");
?>

Lihatlah contoh gaya prosedural di bagian bawah.

Definisi dan Penggunaan

Fungsi real_connect() / mysqli_real_connect() membuka koneksi baru ke server MySQL.

Fungsi ini berbeda dari connect() dengan cara berikut:

real_connect() membutuhkan objek valid yang dibuat oleh init()
real_connect() dapat digunakan dengan options() untuk mengatur pilihan yang berbeda untuk koneksi
real_connect() memiliki parameter flag

Sintaksis

Gaya berorientasi objek:

$mysqli -> real_connect(host, username, password, dbname, port, socket, flag)

Gaya prosedural:

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

Nilai Parameter

Parameter	Description
connection	Required. Specifies the MySQL connection to use
host	Optional. Specifies a host name or an IP address
username	Optional. Specifies the MySQL username
password	Optional. Specifies the MySQL password
dbname	Optional. Specifies the default database to be used
port	Optional. Specifies the port number to attempt to connect to the MySQL server
socket	Optional. Specifies the socket or named pipe to be used
flag	Optional. Specifies different connection options. Possible values: MYSQLI_CLIENT_COMPRESS - Use compression protocol MYSQLI_CLIENT_FOUND_ROWS - Return number of matched rows (not affected 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 MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT

Detail Teknis

Nilai Kembali:	BENAR pada kesuksesan. SALAH pada kegagalan
Versi PHP:	5+
Log Perubahan PHP:	PHP 5.6: Menambahkan tanda MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT

Contoh - Gaya prosedural

Buka koneksi baru ke server MySQL, dengan opsi koneksi tambahan:

<?php
$con = mysqli_init();
if (!$con) {
die("mysqli_init failed");
}

// Specify connection timeout
mysqli_options($con, MYSQLI_OPT_CONNECT_TIMEOUT, 10);

// Specify read options from named file instead of my.cnf
mysqli_options($con, MYSQLI_READ_DEFAULT_FILE, "myfile.cnf");

mysqli_real_connect($con,"localhost","my_user","my_password","my_db");
?>

Referensi PHP MySQLi

Tutorial PHP

Formulir PHP

PHP Lanjutan

PHP OOP

Database MySQL

PHP XML

PHP - AJAX

Contoh PHP

Referensi PHP