php - PHP 中的简单 SQL 查询

Question

我想知道我的查询是否正确编写，因为我认为我在“responsible_internship_teacher=true”处犯了一个错误

public function teacher_responsibility($email_teacher){    $query = "SELECT                      *               FROM                      teachers               WHERE                      email_teacher='$email_teacher' AND                      responsible_internship_teacher=true";    $result = $this->_db->query ($query);    return $result->rowcount();}

感谢您的帮助。

Answer 1

你可以像字符串一样使用 true 然后在字符串周围使用单引号

'真'

"SELECT 
                 * 
          FROM 
                 teachers 
          WHERE 
                 email_teacher='$email_teacher' AND 
                 responsible_internship_teacher='true'";