我试图在php文件中创建一个简单的sql语句,将两个值插入数据库。它抛出了我为无效sql语句实现的错误,我相信这是因为VALUES( )
部分是错误的。如何连接sql语句的单引号?数据库值应为varchars。
$sql = "INSERT INTO visitor_log_marcusw1(email_user, email_provider) "
. "VALUES ('".$email_user."' , '".$email_provider."')";
mysqli_query($con, $sql);
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
if (mysqli_query($conn, $sql)) {
将其替换为
if (mysqli_query($con, $sql)) {
$con不是$conn
试试这个:
$sql = "INSERT INTO visitor_log_marcusw1 (email_user, email_provider) VALUES ('{$email_user}' , '{$email_provider}')";
此外,连接名称中似乎有一个拼写错误($conn与$con)。
使用mysql函数mysql_real_sescape_string($php_variable)
$sql = "INSERT INTO visitor_log_marcusw1(email_user, email_provider) n"
. "VALUES (mysql_real_escape_string($email_user) , mysql_real_escape_string($email_provider)";