問題描述
如何在用戶類中打開數據庫連接，在那里進行數據庫操作?以及為什么需要在 DBConnection 類中定義內置的創建函數..????
我已經創建了
- db.php
- user.php
- result.php
在 db.php
class DBConnection{受保護的 $mysqli;私人 $db_host="127.0.0.1";私人 $db_name="測試";私人 $db_username="root";私人 $db_password="";公共函數 __construct(){$this->mysqli=new mysqli($this->db_host,$this->db_username,$this->db_password,$this->db_name) 或 die($this->mysqli->error);返回 $this->mysqli;}public function query($query)//為什么我需要創建這個函數{返回 $this->mysqli->query($query);}公共函數 real_escape_string($str){返回 $this->mysqli->real_escape_string();}函數 __destruct(){//關閉連接$this->mysqli->close();}}?>在 User.php
mysqli=$conn;}公共函數 addUser($name,$username,$email,$pwd){$query="";$res=$this->mysqli->query($query);//請查一下DBConnection中的查詢函數，需要定義什么查詢>DBConnection 中的函數?返回 $res;}}?>在 result.php
<塊引用>
$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=新用戶($conn);$uObj->addUser($name,$username,$email,$password);echo "你好，你的名字是<I>".$name."</I>并且你的電子郵件ID是<I>".$email."</I>";}?>你的 DBConnection 類需要一個額外的方法:
公共函數getLink(){返回 $this->mysqli;}看來您原來的 User 類是 DBConnection 的子類，因為 DBConnection 上的 mysqli 屬性是protected 和 User 類有一個 parent::__construct() 調用.
最好使用依賴注入，這樣您的 User 類將通過構造函數接收其數據庫連接:
公共函數__construct(DBConnection $db){$this->mysqli = $db->getLink();}然后你可以從你的代碼運行:
$db = 新的 DBConnection;$uObj = 新用戶($db)；How can I open a database connection in user class , where I can do database operation? and why need to define inbuilt created functions in DBConnection class ..????
I have created
- db.php
- user.php
- result.php
in 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();
}
}
?>
in 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;
}
}
?>
in 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>";
}
?>
Your DBConnection class would need an additional method:
public function getLink()
{
return $this->mysqli;
}
It seems that your original User class was a subclass of DBConnection, because mysqli property on DBConnection is protected and User class has a parent::__construct() call.
It's better to use dependency injection, so your User class will receive its database connection via the constructor:
public function __construct(DBConnection $db)
{
$this->mysqli = $db->getLink();
}
Then from your code you can run:
$db = new DBConnection;
$uObj = new User($db);
這篇關于如何訪問另一個頁面上另一個類中的mysqli連接?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！