mysqli::init

mysqli_init

(PHP 5, PHP 7, PHP 8)

mysqli::init -- mysqli_init — Initialise MySQLi et retourne un objet à utiliser avec mysqli_real_connect()

Description

Style orienté objet

public mysqli::init(): ?bool

Style procédural

mysqli_init(): mysqli|false

Alloue ou initialise un objet MySQL utilisable pour les fonctions mysqli_options() et mysqli_real_connect().

Note:
Tous les appels suivants à n'importe quelle fonction MySQLi (exceptée de mysqli_options() et mysqli_ssl_set()) échoueront en attendant que la fonction mysqli_real_connect() soit appelée.

Liste de paramètres

Cette fonction ne contient aucun paramètre.

Valeurs de retour

mysqli::init() retourne null en cas de succès, ou false si une erreur survient. mysqli_init() renvoie un objet en cas de succès, ou false si une erreur survient.

Historique

Version	Description
8.1.0	La méthode mysqli::init() de style orienté objet a été dépréciée. Remplacez les appels à parent::init() par parent::__construct().

Exemples

Voir mysqli_real_connect().

Voir aussi

mysqli_options() - Définit les options
mysqli_close() - Ferme une connexion
mysqli_real_connect() - Ouvre une connexion à un serveur MySQL
mysqli_connect() - Alias de mysqli::__construct

Improve This Page

Learn How To Improve This Page • Submit a Pull Request • Report a Bug

＋add a note

User Contributed Notes 2 notes

down

Kam.Dab ¶

1 year ago

I wrote support ssl mysqli you don't need change anymore mysqli connect exchange to your own mysqli . Overwrite __construct mysqli with support ssl can be like that: 
<?php class myssl_mysqli extends \mysqli {
        public function __construct($db_host, $db_user, $db_pass, $db_name, $port, $persistent = true, $ssl = false, $certpublic = "") {
            if($ssl) {
        parent::init();
                parent::options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, false);
        parent::ssl_set(NULL, NULL, $certpublic, NULL, NULL);
            parent::real_connect(($persistent ? 'p:' : '') . $db_host, $db_user, $db_pass, $db_name, $port, '', MYSQLI_CLIENT_SSL | MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT );
            } else {
                 parent::__construct($db_host, $db_user, $db_pass, $db_name, $port);
            }
}
$db = new myssl_mysqli('localhost','user', 'pass','db', '3306', true, true, '/home/mypublicowncert.pem'); 
?>
in this example i off the verificate cert by authority ssl, due it own cery created

down

-3

evgen at sysmasters dot net ¶

2 years ago

Correct way to connect db 

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("127.0.0.1", "db_user", "db_pass", "db_name",3306);

$result = $mysqli->query("SELECT somefield1, somefield2 FROM sometable ORDER BY ID LIMIT 3");

/* Close the connection as soon as it becomes unnecessary */
$mysqli->close();

foreach ($result as $row) {
    /* Processing data received from the database */
echo var_dump ($row);
}

＋add a note