PHP 8.0.24 Released!

mysqli::init

mysqli_init

(PHP 5, PHP 7, PHP 8)

mysqli::init -- mysqli_initInitializes MySQLi and returns an object for use with mysqli_real_connect()

Description

Object-oriented style

public mysqli::init(): ?bool

Procedural style

mysqli_init(): mysqli|false

Allocates or initializes a MYSQL object suitable for mysqli_options() and mysqli_real_connect().

Note:

Any subsequent calls to any mysqli function (except mysqli_options() and mysqli_ssl_set()) will fail until mysqli_real_connect() was called.

Parameters

This function has no parameters.

Return Values

mysqli::init() returns null on success, or false on failure. mysqli_init() returns an object on success, or false on failure.

Changelog

Version Description
8.1.0 The object-oriented style mysqli::init() method has been deprecated. Replace calls to parent::init() with parent::__construct().

Examples

See mysqli_real_connect().

See Also

add a note

User Contributed Notes 2 notes

up
0
evgen at sysmasters dot net
7 months 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);
}
up
-18
Dub B.
2 years ago
<?php

$SQL
= new mysqli// create copy class

# optional
//$SQL -> options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, 1);
   
$SQL -> real_connect('127.0.0.1', 'root', 'pass', 'database');
   
$SQL_Err = $SQL->connect_errno;
   
if(
$SQL_Err) // if error
   
exit('Error');

?>
To Top