<?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) > 0)
{
header('location:index.php');
exit;
}
?>
I am making a login form and giving data to this php code but getting this error.
Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' in php
I am not able to understand the error because earlier with the same script I was able to login in the system.