可恢复的致命错误:类 PDOStatement 的对象无法转换为字符串 [英] Recoverable fatal error: Object of class PDOStatement could not be converted to string
问题描述
我正在尝试使用 PHP 将数据发送到数据库,但是当我使用 execute()
执行查询时,出现错误提示
I am trying to send data to a database using PHP but when I execute the query using execute()
I get an error that says
可恢复的致命错误:第 12 行 C:\xampp\htdocs\Code Sharing Website\submit_snippet.php 中的类 PDOStatement 的对象无法转换为字符串
Recoverable fatal error: Object of class PDOStatement could not be converted to string in C:\xampp\htdocs\Code Sharing Website\submit_snippet.php on line 12
这是我的代码
include 'includes/db.php';
if(isset($_POST['title']) && isset($_POST['snippet'])) {
$title = $_POST['title'];
$snippet = $_POST['snippet'];
$snippet = $db->prepare("INSERT INTO all_snippets (snippet_name, snippet_body) VALUES (:title, :snippet)");
$snippet->execute(array(
':title' => $title,
':snippet' => $snippet
));
} else {
echo "Error: Please fill out all fields";
}
推荐答案
您正在将 snippet
变量重新分配给 PDO 对象,然后尝试在您的 execute
中使用它.其中一个变量需要重命名.
You are reassigning your snippet
variable to a PDO object and then try to use that in your execute
. One of those variables needs to be renamed.
将 $snippet = $_POST['snippet'];
更改为 $snippetPost = $_POST['snippet'];
和您的 execute
应该可以解决这个问题.
Changing $snippet = $_POST['snippet'];
to $snippetPost = $_POST['snippet'];
and your execute
to this should fix it.
$snippet->execute(array(
':title' => $title,
':snippet' => $snippetPost
));
这篇关于可恢复的致命错误:类 PDOStatement 的对象无法转换为字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!