PHP+MySQL realizes fuzzy query of employee information function

This article mainly introduces the function of fuzzy query of employee information in PHP MySQL, and analyzes related operation techniques of connecting MySQL database with PHP and using like statement to perform fuzzy query and display based on examples. Friends in need can refer to it

The example of this article describes the function of fuzzy query of employee information using PHP MySQL. Share it with everyone for your reference, the details are as follows:

1. Code

Note two points:

1. When editing with Notepad, format selection: [Encoded Character Set]->[Chinese]->[gb2312]

2,

##

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

conn.php

<?php
$connID=mysql_connect("localhost","root","root");
mysql_select_db("db_database13", $connID);
mysql_query("set names gbk");
?>

index.php

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />




查询企业员工的详细信息


 

  
按照员工的编号查询
  

  

 



 

  
编号
  
姓名
  
电话
  
地址
 
 
 

  

  

  

  

 
 

2. Running results

The encoding selected by the browser is gbk

Related recommendations:

PHP MySQL implements an example of the function of jumping to a specified page by inputting a page number

PHP MYSQL implements detailed practical explanation of reading and writing separation

PHP MYSQL full-text search and full-text search tools

##

The above is the detailed content of PHP+MySQL realizes fuzzy query of employee information function. For more information, please follow other related articles on the PHP Chinese website!