PHP small practical recommendation: PHP+mysql implementation of login and query function code examples

This article mainly introduces the methods of PHP MYSQL to implement login and fuzzy query functions. The login function and query function are very practical functions and are necessary in the website. Below, our PHP Chinese website will bring practical implementation cases for beginners. We hope it will be helpful to everyone's understanding and learning.

Related mysql video tutorial recommendations: "mysql tutorial"

There are also related practical tutorial recommendations on our PHP Chinese website:PHP login registration page tutorial

Related links://m.sbmmt.com/course/120.html

Related video tutorials:PHP user registration login system video Teaching

Related links: //m.sbmmt.com/course/192.html

1. PHPMYSQL implementation Login

contains a total of two files:login.phpandlogincheck.php;
Form code:

 Yonghu: 
 Mima: 
  zhuce: 

Background processing code:

alert('请输入用户名或密码！'); history.go(-1);"; } else { $link= mysqli_connect('localhost', 'sa', '123456','account');//链接数据库 mysqli_select_db($link,"account"); mysqli_query($link,'setname utf8'); $sql= "selectuser from zhanghu where user = '$_POST[username]'"; $result=mysqli_query($link,$sql)or die("Failed".mysql_error()); if($num=mysqli_num_rows($result)) { $row= mysqli_fetch_array($result); //将数据以索引方式储存在数组中 echo"welcome "; echo$row[0]; } else { echo""; } } } else { echo""; } ?>

Account database content:

2. PHPMYSQL implements fuzzy query

Query database (only for PHP code):

connect("localhost","sa", "123456"); if(mysqli_connect_errno()) { printf("Failllllll:%s\n", mysqli_connect_error()); exit(); } $mysqli->select_db("booklib"); $mysqli->query("SETNAMES utf8"); $rsbooks= $mysqli->query("select * from books where Name like'%$_POST[bookname]%'"); $row_rsbooks = $rsbooks->fetch_assoc(); $totalRows_rsbooks = $rsbooks->num_rows; ?> Totel books; fetch_assoc()); ?> 
 
 
Name
 
ISBN
 
Store
 
Do
 
  
 
 
 
 
rent
 
 
 close(); $mysqli->close(); ?>

The contents of the database table are as follows:

Query:

Result:

The above is the entire content of this article, I hope it will be helpful to everyone learning PHP programming.

Related recommendations:

1.php uses object-oriented to implement user login authentication function