使用pdo php创建的注册页面出现错误

Question

我正在学习oops概念在PHP。我使用PHP PDO创建了登录/注册/dbconfig页面。DBconfig.php工作良好，但注册页面给出以下错误。

致命错误：未捕获错误：调用D:\xampp\htdocs\phpoops\signup中未定义的方法dBase:：prepare（）。php:26堆栈跟踪：#0 D:\xampp\htdocs\phpoops\signup。php（20）：注册-

我以过程的方式创建了相同的代码，它工作得很好。我怎样才能解决这个问题？

这是我的密码：

我ndex.php

<?php  
    require("dbconfig.php");
    $db = new dBase();
    if(isset($_POST['submit'])){
    require_once("signup.php");
    $reg = new signUp($db);
    $reg->register();
   }
?>

<form action="" method="post">          
      <div class="top-row">
        <div class="field-wrap">
          <label>
            First Name<span class="req">*</span>
          </label>
          <input type="text" name="ufname" required autocomplete="off" />
        </div>        
        <div class="field-wrap">
          <label>
            Last Name<span class="req">*</span>
          </label>
          <input type="text" name="ulname" required autocomplete="off"/>
        </div>
      </div>
      <div class="field-wrap">
        <label>
          Email Address<span class="req">*</span>
        </label>
        <input type="email" name="uemail" required autocomplete="off"/>
      </div>          
      <div class="field-wrap">
        <label>
          Set A Password<span class="req">*</span>
        </label>
        <input type="password" name="upass" required autocomplete="off"/>
      </div>          
      <button type="submit" name="submit" class="button button-block"/>Get Started</button>          
      </form>

dbconfig。php

<?php 
class dBase
{
protected $uname;
protected $upass;
protected $host;
protected $dbname;
private   $dbcon;

function __construct()
{
     $this->dbcon  = false;
     $this->dbname = "oopsdb";
     $this->uname  = "root";
     $this->upass  = "";
     $this->host   = "localhost";
     //$this->connect();
     if(!$this->dbcon){
        try{
            $this->dbcon = new PDO('mysql:host='.$this->host.';dbname='.$this->dbname.'',$this->uname,$this->upass);
            $this->dbcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        }
        catch(PDOException $e){
            echo $e->getMessage();
            die();
        }
    }
    return $this->dbcon;    
 }  
}

报名。php

<?php 
   class signUp
  {
   private $fname;
    private $lname;
   private $email;
   private $pass;
    private $db;
   function __construct($db)
   {    
    $this->fname = htmlspecialchars($_POST['ufname']);
    $this->lname = htmlspecialchars($_POST['ulname']);
    $this->email = htmlspecialchars($_POST['uemail']);  
    $this->pass = htmlspecialchars($_POST['upass']);
    $this->db = $db;
    $this->register();
}

function register(){        
    if($_SERVER["REQUEST_METHOD"] == "POST"){
    $sql = "INSERT INTO user(`fname`,`lname`,`email`,`pass`,`usr_update`) VALUES (:fname,:lname,:email,:pass,NOW())";
    $stmt = $this->db->prepare($sql);
    $stmt->bindParam(':fname',$this->fname);
    $stmt->bindParam(':lname',$this->lname);
    $stmt->bindParam(':email',$this->email);
    $stmt->bindParam(':pass',$this->pass);
    $stmt->execute();
    if($stmt == true){
        echo "<script>alert('Successfully Inserted');</script>";
    }else{
        echo "<script>alert('Not Inserted...please check logic once');</script>"; 
    }   

    }
  }
}

Answer 1

我正在学习php中的oops概念。

那很好
然而，OOP并不代表创建尽可能多的类。创建一个新类，前提是您知道它应该用于什么
目前，dBase类没有做任何香草PDO做不到的事情。因此，只需使用PDO即可。

dbconfig。php

 <?php

 $dbname = "oopsdb";
 $uname  = "root";
 $upass  = "";
 $host   = "localhost";
 $charset = "utf8";

 $db = new PDO("mysql:host=$host;dbname=$dbname;charset=$charset",$uname,$upass);
 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

然后删除$db=newdbase（） 并保持其余内容不变