Question

php $conn->query数据添加不进去

<?php
session_start();
require_once ("db.inc.php");
require_once ("allfuns.php");
?>
<?php
$email =@$_POST['email'];
$passwd =@$_POST['pwd'];
try {
$conn=db_connect();
$reslust =$conn->query("insert into user(email,password) valuse ('$email','$passwd') ");
echo $reslust;

if($reslust)
{
echo "yes";
}
else {
echo "no";

}

}catch(Exception $e)
{
$conn->close();
require_once('header.php');
require_once('foot.php');
exit();
}

?>

Answer 1

因为代码不全，只能就已知代码说下原因，貌似是SQL语法错误：

insert into user(email,password) valuse ('$email','$passwd') "

应该是

insert into user(email,password) values ('$email','$passwd') "

即 valuse 单词拼写错误，应该是 values

Answer 2

$conn=new db_connect();

Answer 3

你的values写错了