Submit a Pull Request Report a Bug

    mysqli::init

    mysqli_init

    (PHP 5, PHP 7, PHP 8)

    mysqli::init -- mysqli_init — Initializes 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
    1 year 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.
    3 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');

    ?>
    ＋add a note
    To Top