Follow the select string:
$resultado = mysqli_query($conn, "SELECT COUNT(*) FROM conta WHERE username:usuario AND userpassword:senha";
Follow the select string:
$resultado = mysqli_query($conn, "SELECT COUNT(*) FROM conta WHERE username:usuario AND userpassword:senha";
The count(*)
is inside the string, so no problem, to get its value and get more readable too, I suggest assigning an alias to it eg: select count(*) as total from ...