PHP MySQLi::Close Examples

Programming Language: PHP

Class/Type: MySQLi

Method/Function: Close

Examples at hotexamples.com: 1

The mysqli_close function is used to explicitly close a previously opened database connection. It takes a single parameter, which is the connection object returned by mysqli_connect() or mysqli_init(). When executed, the connection is closed and the memory associated with it is freed.

Example 1: Close mysqli connection

$con = mysqli_connect("localhost", "username", "password", "dbname");

// perform database operations here

mysqli_close($con);

In this example, the connection to the MySQL database is opened using mysqli_connect(). After performing some database operations, the connection is explicitly closed using mysqli_close().

Package library: mysqli

Example 2: Close multiple mysqli connections using a for loop

$connections = array();

for ($i = 0; $i < 10; $i++) {
    $connections[$i] = mysqli_connect("localhost", "username", "password", "dbname");
}

// perform database operations here

foreach ($connections as $con) {
    mysqli_close($con);
}

In this example, an array is created to store 10 MySQLi connection objects. The connections are opened using mysqli_connect() inside a for loop. After performing some database operations, each connection is explicitly closed using a foreach loop and mysqli_close(). Package library: mysqli

PHP MySQLi::Close - 1 examples found. These are the top rated real world PHP examples of MySQLi::Close extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

query(30)

real_escape_string(26)

close(24)

prepare(23)

set_charset(18)

__construct(18)

select_db(9)

checkString(5)

escape_string(5)

multi_query(5)

more_results(4)

ping(4)

real_connect(4)

options(4)

next_result(4)

connect(3)

store_result(3)

ssl_set(3)

init(3)

rollback(2)

autocommit(2)

commit(2)

stmt_init(2)

use_result(2)

real_query(1)

select(1)

update(1)

Close(1)

Query(1)

get_warnings(1)

getParams(1)

getInstance(1)

formatDate(1)

fetchOne(1)

fetchAll(1)

escape(1)

describeTable(1)

delete(1)

insert(1)

Example #1

Show file

File: api.php Project: Javicorso/sqlite2web

        $msg->error = 'No parece tener un IMEI válido, pruebe con un dispositivo real.';
    } else {
        $sql = new MySQLi("server", "user", "password", "db");
        $sql->Query("SET NAMES 'utf8'");
        $d = json_decode($_POST['sqlite']);
        //recibimos en formato JSON
        $msg->remotes = array();
        if (!empty($d) && is_object($d)) {
            foreach ($d as $k) {
                if (empty($k->correo)) {
                    continue;
                }
                //verificamos si existe
                $e = $sql->Query("SELECT id FROM sqlite WHERE localid='" . __($k->id) . "' AND imei='" . __($_POST['me']) . "'");
                if ($e->num_rows > 0) {
                    $e = $e->fetch_object();
                    $msg->remotes[__($k->id)] = $e->id;
                } else {
                    $q = "INSERT INTO sqlite (id,localid,imei,correo,cumple) VALUES(null,'" . __($k->id) . "','" . __($_POST['me']) . "', '" . __($k->correo) . "', '" . __($k->nacimiento) . "')";
                    $sql->Query($q);
                    if ($sql->error && !empty($sql->error)) {
                        $msg->error = $sql->error;
                    }
                    $msg->remotes[__($k->id)] = $sql->insert_id;
                }
            }
        }
        $sql->Close();
    }
}
echo json_encode($msg);