問題描述

我正在遠(yuǎn)離 mysql 和 mysqli，因為 stackoverflow 上的許多用戶一直在說好話.

I'm moving away from mysql and mysqli as many users on stackoverflow are constantly saying good things about it.

我制作了一個數(shù)據(jù)庫類并對此進(jìn)行了測試，這可以很好地連接到數(shù)據(jù)庫.我試圖更新我準(zhǔn)備好的語句以匹配但是我在陌生的領(lǐng)域并最終收到以下錯誤:

I've made a database class and have tested this, this connects fine to the database. I've tried to update my prepared statements to match however I am in unfamiliar territory and have ended up getting the following error:

Fatal error: Call to undefined method PDOStatement::bind_param() in E:xampphtdocsimanageinsert.php on line 50

這反映了這一行:

$stmt->bind_param("s", $_POST['email']);

另外，關(guān)于這個，我得到了數(shù)據(jù)庫連接成功和關(guān)閉語句返回給我以及致命錯誤，例如:

Also in regards to this I am getting the database connection success and close statements returned to me as well as the fatal error e.g:

連接數(shù)據(jù)庫成功！連接數(shù)據(jù)庫成功！斷開數(shù)據(jù)庫連接成功！

我將解釋我想要實現(xiàn)的目標(biāo):

I'll explain what I am trying to achieve:

• 在注冊用戶之前檢查數(shù)據(jù)庫中是否存在電子郵件
• 如果是，請告訴用戶此電子郵件存在
• 如果不匹配，則將用戶插入到用戶表中并加密密碼

相關(guān)代碼如下，如果有人能給我一些指導(dǎo)，我將不勝感激.

The relevant code is below and would appreciate if anyone could give me some guidance on this.

index.php

        <form id="loginForm" method="POST" action="class.Login.php">
        <input type="text" id="email" name="email" placeholder="E-mail">
        <input type="password" id="password" name="password" placeholder="Password" class="showpassword"> 
        <input type="submit" name="submit" value="Log in"></form>

插入.php

public function insert() {

                    $stmt = $this->pdo->prepare("SELECT COUNT(*) FROM users WHERE email=?");
                    $stmt->bind_param("s", $_POST['email']);
                    $stmt->execute();
                    $stmt->bind_result($email_count);
                    $stmt->fetch();//fecth
                    $stmt->close();     

                    if ($email_count > 0) {
                        echo "email exisits! click here to try <a href='register'>again</a>";
                        } else {
                            //escape the POST data for added protection
                            $username = isset($_POST['username']) ? $_POST['username'] : null;
                            $cryptedPassword = crypt($_POST['password']);
                            $password = $cryptedPassword;
                            $name = isset($_POST['name']) ? $_POST['name'] : null;
                            $email = isset($_POST['email']) ? $_POST['email'] : null;
                            $stmta = $this->pdo->prepare("INSERT INTO users (username, password, name, email) VALUES (?, ?, ?, ?)");
                            //var_dump($this->pdo->error);
                            $stmta->bind_param('ssss', $username, $password, $name, $email); // bind strings to the paramater

                                /* execute prepared statement */
                                $stmta->execute();
                                printf("%d Row inserted.
", $stmta->affected_rows);
                                /* close statement and connection */
                                $stmta->close();
                } // end email_count and insert to table
            } // end function

connect/class.Database.php

connect/class.Database.php

<?php

// Database connection PDO

class Database {

    public function __construct() {
        // Connection information
        $host   = 'localhost';
        $dbname = 'imanage';
        $user   = 'root';
        $pass   = '';

        // Attempt DB connection
        try
        {
            $this->pdo = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
            $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            echo 'Successfully connected to the database!';
        }
        catch(PDOException $e)
        {
            echo $e->getMessage();
        }

    }

     public function __destruct()
    {
        // Disconnect from DB
        $this->pdo = null;
        echo 'Successfully disconnected from the database!';
    }


}

$run = new Database();
?>

推薦答案

一些 PDO 示例

綁定參數(shù)示例

$stmt = $this->pdo->prepare("SELECT COUNT(*) FROM users WHERE email=:email");
$stmt->bindParam(":email", $_POST['email']);
$stmt->execute();
$stmt->fetch(PDO::FETCH_ASSOC);

數(shù)組示例

$data = array($username, $password, $name, $email); 
$stmta = $this->pdo->prepare("INSERT INTO users (username, password, name, email) VALUES (?, ?, ?, ?)");
$stmta->execute($data);

PDO教程

這篇關(guān)于PDO bind_param 是未定義的方法的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！