title: Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)
body: <pre><code>&lt;?php
  
  include 'db_connect.php';
  
  $name = $_REQUEST['sname'];
  $email = $_REQUEST['email'];
  
  $query = "SELECT * FROM info_enrol_student WHERE ES_name = '$name' AND ES_EMAIL = '$email'";
  $in = mysqli_query($conn,$query) or die(mysqli_error($conn));
  $count = mysqli_num_rows($in);
  if (mysqli_num_rows($in) &gt; 0)
  {
  header('location:index.php');
  exit;
  }
  
  ?&gt;
  </code></pre>
  
  <p>I am making a login form and giving data to this php code but getting this error. </p>
  
  <blockquote>
    <p>Illegal mix of collations (ascii_general_ci,IMPLICIT) and
    (latin1_swedish_ci,COERCIBLE) for operation '=' in php</p>
  </blockquote>
  
  <p>I am not able to understand the error because earlier with the same script I was able to login in the system.</p>