PHP SQL - 如果用户存在则无法找到

Question

I'm trying to find if a user exists using this code:

$usercheck = "SELECT * FROM profiles WHERE username = '$user'";
$rs = mysqli_query($con,$usercheck);
$data = mysqli_fetch_array($rs, MYSQLI_NUM);

echo "<script> console.log('data=' + " . $data[0] . " + ''); </script>";

Data always returns 0 despite $user being equal to a name which already exists.

Any ideas?

Answer 1

Try to replace

$data[0]

database field name, like

$data['username']
echo "<script> console.log('data=' + " . $data['username'] . " + ''); </script>";

Hope it will works for you.