什么是PDO上的bind_result [英] What is the equivalent of bind_result on PDO
问题描述
我正在使用准备好的语句转换为PDO和Im,我想将结果绑定为$stmt->bind_result($email_count);
,因此我可以将其放入if语句中以查看电子邮件是否存在,但是我得到了错误Fatal error: Call to undefined method PDOStatement::bind_result() in /Applications/XAMPP/xamppfiles/htdocs/imanage/insert.php on line 51
与前面的示例有关.
I'm converting to PDO and Im using prepared statements, I want to bind my result as so $stmt->bind_result($email_count);
so i am able to put this into an if statement to see if the e-mail exists however I am getting the error Fatal error: Call to undefined method PDOStatement::bind_result() in /Applications/XAMPP/xamppfiles/htdocs/imanage/insert.php on line 51
which relates to the previous example.
我猜bind_result不是PDO定义的方法,所以可以使用等效方法吗?
I'm guessing bind_result is not a PDO defined method, so is there an equivalent I could use?
下面是我的代码,以防万一:
My code is below in case it helps:
insert.php
insert.php
<?php
include("connect/class.Database.php");
class Users extends Database {
public function insert() {
$stmt = $this->pdo->prepare("SELECT COUNT(*) FROM users WHERE email=:email");
$stmt->bindParam(":email", $_POST['email']);
$stmt->bind_result($email_count);
$stmt->execute();
$stmt->fetch(PDO::FETCH_ASSOC);
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;
$data = array($username, $password, $name, $email);
$stmta = $this->pdo->prepare("INSERT INTO users (username, password, name, email) VALUES (?, ?, ?, ?)");
$stmta->execute($data);
printf("%d Row inserted.\n", $stmta->row_count);
/* 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!';
}
}
?>
推荐答案
您完全不需要带有PDO的难看的bind_result.
但是您也不需要数.请避免不必要的操作-它们只会无故膨胀和混淆您的代码.
You do not need an ugly bind_result with PDO at all.
Yet you don't need to count either. Please, avoid unnecessary actions - they only bloat and obfuscate your code for no reason.
首先考虑一下,查询需要什么?您真的需要数数吗?否.您实际需要的只是一个标志-如果用户存在或不存在.因此,进行查询以返回此类标志.
Think first, what you need from the query? Do you really need to count? No. What you actually need is just a flag - if user exists or no. So, make a query to return such a flag.
$stmt = $this->pdo->prepare("SELECT 1 FROM users WHERE email=?");
$stmt->execute(array($_POST['email']));
$exists = $stmt->fetchColumn();
其他所有代码都一样
//escape the POST data for added protection
您实际上并没有在此代码块中转义"任何数据,也不添加任何保护.但是,我认为插入NULL作为电子邮件绝对没有意义.您确定您确实想要它吗?
You don't actually "escape" any data in this code block and add no protection. Yet I see absolutely no point in inserting NULL as email. Are you sure you really want it?
这篇关于什么是PDO上的bind_result的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!