PDO bind_param是未定义的方法 [英] PDO bind_param is undefined method
问题描述
我正在远离mysql和mysqli，因为许多stackoverflow上的用户一直在说些好话.
I'm moving away from mysql and mysqli as many users on stackoverflow are constantly saying good things about it.
我已经建立了一个数据库类并进行了测试，这可以很好地连接到数据库.我试图更新我准备的语句以使其匹配，但是我在陌生的领域中并最终得到以下错误:
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:\xampp\htdocs\imanage\insert.php on line 50
反映了这一行:
$stmt->bind_param("s", $_POST['email']);
关于这一点，我也获得了数据库连接成功和返回的关闭语句以及致命错误，例如:
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:
Successfully connected to the database!Successfully connected to the database!Successfully disconnected from the database!
我将解释我要实现的目标:
I'll explain what I am trying to achieve:
- 在注册用户之前检查数据库中是否存在电子邮件
- 如果这样告诉用户该电子邮件存在
- 如果没有匹配项，则将用户插入用户表并加密密码
下面是相关代码，如果有人可以给我一些指导，则将不胜感激.
The relevant code is below and would appreciate if anyone could give me some guidance on this.
index.php
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>
insert.php
insert.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.\n", $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示例
具有绑定参数的示例
$stmt = $this->pdo->prepare("SELECT COUNT(*) FROM users WHERE email=:email");
$stmt->bindParam(":email", $_POST['email']);
$stmt->execute();
$stmt->fetch(PDO::FETCH_ASSOC);
数组示例
$data = array($username, $password, $name, $email);
$stmta = $this->pdo->prepare("INSERT INTO users (username, password, name, email) VALUES (?, ?, ?, ?)");
$stmta->execute($data);
这篇关于PDO bind_param是未定义的方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
