MYSQL查询错误 - 检查数据库中的用户

Question

I trying to check if a username is already in use in my db but it's not echoing anything (blank page when i run ) , i want to get a true or false response

<?php

 mysql_connect("localhost", "root", "") or die(mysql_error()); 

 mysql_select_db("data1") or die(mysql_error()); 


$usercheck = "john";

    $sanitizeduser= filter_var($usercheck, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);

    $check = mysql_query("SELECT EXISTS(SELECT 1 FROM users WHERE username = $sanitizeduser)");

    echo $check;

?>

Answer 1

You have shuffled with mysqli_query and mysql_ functions

Try this,

$link = mysqli_connect("localhost","root","","data1") or die("Error " . mysqli_error($link));
$usercheck = "john";

$sanitizeduser= filter_var($usercheck, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);

$result = $link->query("SELECT username FROM users WHERE username = '".$sanitizeduser."' ");

$row_cnt = $result->num_rows;    
if($row_cnt>0){     
    echo "User Exists"; // echo 1;
}else{      
    echo "No User found"; //echo 0;
}