如何访问另一页上的另一个类的mysqli连接？(How to access mysqli conne

我怎样才能打开用户级的数据库连接，在那里我可以做数据库操作？ 为什么需要DBConnection的类定义内置创建功能.. ????

我创造了

1. db.php中
2. user.php的
3. result.php

在db.php中

class DBConnection  
{       
  protected $mysqli;
  private  $db_host="127.0.0.1";
  private  $db_name="test";
  private  $db_username="root";
  private  $db_password="";

  public function __construct()
    {
        $this->mysqli=new mysqli($this->db_host,$this->db_username,
                $this->  db_password,$this->db_name) or die($this->mysqli->error);

         return $this->mysqli;
    }

public function query($query)  // why i need to creat this function
     {
    return $this->mysqli->query($query);
     }

public function real_escape_string($str)
 {
    return $this->mysqli->real_escape_string();
 }


   function __destruct(){
     //Close the Connection
     $this->mysqli->close();
    }
}
?>

在user.php的

<?php
  require "db.php"; 

  class User {  

  public function __construct($conn)
{
    $this->mysqli=$conn;

}

   public function addUser($name,$username,$email,$pwd)
   {
     $query="  ";

     $res=$this->mysqli->query($query);

  //pls chek the query function in DBConnection,what is the need to define query               >       function in DBConnection ?

    return $res;
    }
   }    
?>

在result.php

    <?php

      require "user.php";

      $conn=new DBConnection();

      if(isset($_POST['submit']))
  {

  $name = $conn->real_escape_string(trim(strip_tags($_POST['name']))); $username = $conn->real_escape_string(trim(strip_tags($_POST['username']))); $email = $conn->real_escape_string(trim(strip_tags($_POST['email']))); $password = $conn->real_escape_string(trim(strip_tags($_POST['pass']))); 

//echo $name."".$username."".$email."".$password;
  $uObj=new User($conn);
  $uObj->addUser($name,$username,$email,$password);


echo " hi your name is <I>".$name."</I> and your email ID is <I>".$email."</I>";
        }


?>

Answer 1:

你的DBConnection类将需要一个额外的方法：

public function getLink()
{
    return $this->mysqli;
}

看来，原来的User类是子类DBConnection ，因为mysqli物业DBConnection是protected和User类有一个parent::__construct()调用。

这是更好地使用依赖注入，所以你的User类将收到通过构造其数据库连接：

public function __construct(DBConnection $db)
{
    $this->mysqli = $db->getLink();
}

然后从你的代码可以运行：

$db = new DBConnection;
$uObj = new User($db);

文章来源: How to access mysqli connection in another class on another page?