PHP - Mysqli连接使用面向对象的方式打开和关闭 - MySQLi

Question

I am trying to find a way which does the following

• Object Oriented way
• Closing the connection efficiently

• closing a connection anyways

  <?php 
  
   define("HOST", "localhost");
   define("USER", "username");
   define("PASS", "password");
   define("DBNM", "database");
  
   class ConnectionTest extends mysqli {
  
      private $link;
  
      function __construct() {
          $this->link = new mysqli(HOST, USER, PASS, DBNM);
      }
  
      function getLink(){
          return $this->link;
      }
  
      function __destruct() {
          mysqli_close($this->link)
      }
   }
  ?>
  

To try to get to my objective

1. Object Oriented way - Used a class
2. closing connection efficiently - defined a function to close the connection
3. closing a connection anyways - set the same function to be destructor of that class

As I am new to PHP, I would like to know:

• Is this technique proper?
• What complications could occur? or what are the disadvantages to this technique?
• Is there any improvement needed in this code?

Answer 1

Frankly, this class of yours makes very little sense as it effectively duplicates mysqli. All the things you want to achieve, are already implemented in mysqli:

1. Object Oriented way - Mysqli is a class already.
2. There is a function in mysqli to close a connection as well
3. Which is closing a connection efficiently.

So I fail to see how is your class any better than mysqli.