PHP和MySQL是今天Web开发中最常用的技术之一。而使用"like"关键字，可以非常迅速地完成搜索功能。如需使用这项功能，MySQL中的WHERE子句是不可或缺的。在本文中，我们将介绍如何使用PHP和MySQL的"like"功能，并进行相关举例说明。
为了创建一个搜索功能，我们需要创建一个HTML表单、PHP文件和MySQL数据库。作为示例，我们将使用以下的HTML表单：
<form action="search.php" method="post">
<input type="text" name="search" placeholder="搜索">
<input type="submit" value="搜索">
</form><?php
$host='localhost';
$username='root';
$password='';
$database='test';
$conn=mysqli_connect($host,$username,$password,$database);
if(mysqli_connect_errno()){
die("连接失败：" . mysqli_connect_error());
}
if($_SERVER['REQUEST_METHOD'] == 'POST'){
$search=$_POST['search'];
$sql="SELECT * FROM myTable WHERE name LIKE '{$search}%'";
$result=mysqli_query($conn,$sql);
while($row=mysqli_fetch_assoc($result)){
echo $row['id']. " | ". $row['name'] . "<br>";
}
}
?><?php
$host='localhost';
$username='root';
$password='';
$database='test';
$conn=mysqli_connect($host,$username,$password,$database);
if(mysqli_connect_errno()){
die("连接失败: " . mysqli_connect_error());
}
if($_SERVER['REQUEST_METHOD'] == 'POST'){
$search=$_POST['search'];
$stmt=mysqli_prepare($conn,"SELECT * FROM myTable WHERE name LIKE ?");
$searchValue='%'.$search.'%';
mysqli_stmt_bind_param($stmt,'s',$searchValue);
mysqli_stmt_execute($stmt);
$result=mysqli_stmt_get_result($stmt);
while($row=mysqli_fetch_assoc($result)){
echo $row['id']. " | ". $row['name'] . "<br>";
}
}
mysqli_close($conn);
?>