Skip to main content

PHP MySQL close function, mysqli_close, close, MySQLi

By

Hello guy, today we will learn the close function and it is a function of PHP mysqli. And it does close a previously opened database connection.

Here have two types of close functions: 1. Called close() function that is used in the Object-Oriented type of query. 2. Called mysqli_close() function that is used in the Procedural type of query. The close() / mysqli_close() function closes a previously opened database connection. connection: Required. Specifies the MySQL connection to close Return Value: TRUE on success. FALSE on failure PHP Version: 5+






<!DOCTYPE html>
<html>
    <head>
        <title>Object Oriented style</title>
        <style>
            body{ font-size: xx-large; }
        </style>
    </head>
    <body>
        <h3>Object Oriented style</h3>
        <hr>

        <?php

            //DB connection
            // new mysqli(host, user, password, database name);
            $DBConnection = new mysqli("localhost:3308", "bit", "bitbyte", "bit_yt");

            //Check connection
            if($DBConnection->connect_error){
                echo "Failed to connect to MySQL: ". $DBConnection->connect_error;
                exit();
            }

            //Code...
            $DBConnection -> close();
            $sql = $DBConnection -> query("SELECT * FROM students");
            print_r($sql -> fetch_all(MYSQLI_ASSOC));
        ?>

    </body>
</html>





<!DOCTYPE html>
<html>
    <head>
        <title>Procedural style</title>
        <style>
            body{ font-size: xx-large; }
        </style>
    </head>
    <body>
        <h3>Procedural style</h3>
        <hr>

        <?php

            //DB connection
            // new mysqli(host, user, password, database name);
            $DBConnection = mysqli_connect("localhost:3308", "bit", "bitbyte", "bit_yt");

            //Check connection
            if(mysqli_connect_errno()){
                echo "Failed to connect to MySQL: ". mysqli_connect_error();
                exit();
            }
           
            //Code...
            mysqli_close($DBConnection);
            $sql = mysqli_query($DBConnection, "SELECT * FROM students");
            print_r(mysqli_fetch_all($sql, MYSQLI_ASSOC));

        ?>

    </body>
</html>

Comments

Post a Comment

Top Most viewed

How to draw circle, rectangle and triangle by canvas in Android?

By
Hi... friends, welcome to Bit Byte. This video is How to draw circles, rectangles, and triangles by canvas on Android? The Android Canvas provides convenient methods for drawing simple shapes such as circles and rectangles, using drawCircle and drawRect respectively, but beyond these, the majority of shapes require some custom Path logic to draw. Three shapes that I was required to draw were circle, rectangle, and triangle, so I thought I’d share how I accomplished this. And hard copy code is below this link. GitHub - https://github.com/giriArun/AndroidCanvasT1.git
Post a Comment
Read more

Connect to MySQL with PHP in XAMPP or WAMP server || MySQL database connection with PHP

By
This video will discuss how to connect to MySQL with PHP. I'm using PhpMyAdmin and connect MySQL database with PHP using the WAMP server. And you can use this code any php server. . . . WampServer Version 3.1.9 64bit Created by Romain Bourdon (2005) Maintainer / Upgrade to 2.5 by Herve Leclerc Upgrade to 3 by Otomatic (wampserver@otomatic.net) Multi styles for homepage by Jojaba Installer by Inno Setup: http://www.jrsoftware.org/isinfo.php Forum Wampserver: http://forum.wampserver.com/index.php ______________________ Versions used ______________________ Apache 2.4.39 Port 80- PHP 7.2.18 MySQL 5.7.26 Port 3308 PHP 5.6.40 for CLI (Command-Line Interface) CODE:- <?php //DB connection // new mysqli(host, user, password, database name); $connect = new mysqli("localhost:3308", "bit", "bitbyte", "bit_yt"); //Check connection if($connect->connect_error){ echo "Failed to connect to MySQL: ". $connect->connect_error; exit(); } ...
Post a Comment
Read more

AJAX call in jQuery get and post method | ajax call in PHP using jQuery | ajax call with example

By
In this Ajax call video, I'm trying to show how to call Ajax in jQuery using the GET or POST method. And how simple you call Ajax in PHP using jQuery. In this video, I did that with an example. I'm using the GET and POST method, and I called Ajax and got back a return value. AJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.
Post a Comment
Read more