How does php determine that the username does not exist
First get the username through "$_POST"; then use PDO to query the username Obtain the user information of the user name; finally obtain the number of returned data through the "count()" function to determine if it is less than 1, the user name does not exist.
$username = $_POST['username']; try{ //连接数据库 $pdo=new PDO('dsn', 'username', 'password'); } catch(\PDOException $e) { exit("连接错误:$e->getMessage()"); } //查询 $sql = "select * from user where username=? limit 1"; //准备sql模板 $stmt = $pdo->prepare($sql); //绑定参数 $stmt->bindValue(1, $usenname); //执行预处理语句 $stmt->execute(); //推荐这种方式来获取查询结果 $data = $stmt->fetch(PDO::FETCH_ASSOC); if (count($data) < 1) { echo "用户名不存在!"; } //释放查询结果 $stmt = null; //关闭连接 $pdo = null;
The above is the detailed content of How to determine if username does not exist in php. For more information, please follow other related articles on the PHP Chinese website!