我的SQL语句不起作用...
这是我的变量:
$email="test@test.com";
这些语句不起作用:
$sql = "SELECT * FROM table WHERE email = $email";
$sql = 'SELECT * FROM table WHERE email = ' . $email;
1064 您的 SQL 语法有錯誤;請檢查與您的 MySQL 伺服器版本相對應的手冊,了解在第 1 行「@test.com」附近使用正確的語法
但是如果我使用字符串而不是变量,它可以工作:
$sql = "SELECT * FROM table WHERE email = 'test@test.com'";
我的陈述有什么问题?谢谢!
请在 MySQL 中转义字符串
$sql = "SELECT * FROM table WHERE email = $email";
$sql = 'SELECT * FROM table WHERE email = ' . $email;
这应该有效
$sql = "SELECT * FROM table WHERE email = '$email'";
表是一个关键字,所以可以这样写
$sql = "SELECT * FROM `table` WHERE email='$email'";
$this->db->where('email', $this->input->post('email'));
$query =$this->db->get($this->user);
//$sql = "SELECT * FROM user WHERE email = '$email'";
if($query->num_rows == 1)
{
return true;
}
else
{
return false;
}
}}