mysql连接怎么在其他php页面使用,如何在另一个页面上的另一个类中访问mysqli连接？...

如何在用户类中打开数据库连接，我可以在其中进行数据库操作？以及为什么需要在DBConnection类中定义内置的已创建函数。

我创造了

db.php

user.php

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中

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

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 ".$name." and your email ID is ".$email."";

}

?>