报错:mysqli_affected_rows() expects parameter 1 to be mysqli, object given in
mysqli_affected_rows($link);
$link是连接,不是返回结果;
即
$link = mysqli_connect("","","","",3306);
if ($link == false){
echo "database link failed";
}
$sql = <<<SQL
select * from `user` where `user_name` = '$username' and `user_password` = '$userPassword'
SQL;
$query = mysqli_query($link,$sql);
$num = mysqli_affected_rows($link);