Skip to main content

How to use mysqli_close() if SQL query being executed in a function and function called on some other page ?

By

 <?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();
}



function testFunction1(){
  global $DBConnection;

  $sql = mysqli_query($DBConnection, "SELECT * FROM students");
  print_r(mysqli_fetch_all($sql, MYSQLI_ASSOC));

  mysqli_close($DBConnection);
}


function testFunction2($DBConnection){
  $sql = mysqli_query($DBConnection, "SELECT * FROM students");
  print_r(mysqli_fetch_all($sql, MYSQLI_ASSOC));

  mysqli_close($DBConnection);
}



testFunction1();
//use any of one
testFunction2($DBConnection);





Comments

  1. PankajDecember 16, 2021 at 7:41 AM

    Thanks buddy .
    I think same can be implemented in a ajax page also .

    ReplyDelete

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