PHP查询数据库数据（单条查询）
<!DOCTYPE html>
<html>
<head>
<meta charset=utf-8"/>
<title></title>
</head>
<body>
<h1>查询员工</h1>
<?php
$db = new MySQLi("localhost","root","123456","study");
$tj = " 1=1 ";
$name = "";
if(!empty($_POST["name"]))
{
$name = $_POST["name"];
$tj = " 工号 like "%{$name}%" ";
}
$tj = " 工号 like"%{$name}%"";
?>
<form action="chaxunwork.php" method="post"><!--指向当前页面并且用post方式传一个值-->
<!--根据一个关键字来查到所有的结果-->
<div>请输入工号：
<input type="text" name="name" />
<input type="submit" value="查询" />
</div>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>工号</td>
<td>姓名</td>
<td>出生日期</td>
<td>年龄</td>
<td>职称</td>
<td>所在部门</td>
<td>月薪</td>
<td>年薪</td>
<td>政治面貌</td>
<td>健康状况</td>
</tr>
<?php
//$db = new MySQLi("localhost","root","123456","study");移到上面了是一样的
//写SQL语句
$sql = "SELECT * FROM `员工信息` where {$tj}";//拼成一个完整的SQL语句
$result = $db->query($sql);
$attr = $result->fetch_all();
foreach($attr as $v)
{
$v[1];
$str = str_replace($name,"<span style="color:red">{$name}</span>",$v[1]);
echo "<tr>
<td>{$v[0]}</td>
<td>{$str}</td>
<td>{$v[2]}</td>
<td>{$v[3]}</td>
<td>{$v[4]}</td>
<td>{$v[5]}</td>
<td>{$v[6]}</td>
<td>{$v[7]}</td>
<td>{$v[8]}</td>
<td>{$v[9]}</td>
</tr>";
}
?>
</table>
</body>
</html>
<html>
<head>
<meta charset=utf-8"/>
<title></title>
</head>
<body>
<h1>查询员工</h1>
<?php
$db = new MySQLi("localhost","root","123456","study");
$tj = " 1=1 ";
$name = "";
if(!empty($_POST["name"]))
{
$name = $_POST["name"];
$tj = " 工号 like "%{$name}%" ";
}
$tj = " 工号 like"%{$name}%"";
?>
<form action="chaxunwork.php" method="post"><!--指向当前页面并且用post方式传一个值-->
<!--根据一个关键字来查到所有的结果-->
<div>请输入工号：
<input type="text" name="name" />
<input type="submit" value="查询" />
</div>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>工号</td>
<td>姓名</td>
<td>出生日期</td>
<td>年龄</td>
<td>职称</td>
<td>所在部门</td>
<td>月薪</td>
<td>年薪</td>
<td>政治面貌</td>
<td>健康状况</td>
</tr>
<?php
//$db = new MySQLi("localhost","root","123456","study");移到上面了是一样的
//写SQL语句
$sql = "SELECT * FROM `员工信息` where {$tj}";//拼成一个完整的SQL语句
$result = $db->query($sql);
$attr = $result->fetch_all();
foreach($attr as $v)
{
$v[1];
$str = str_replace($name,"<span style="color:red">{$name}</span>",$v[1]);
echo "<tr>
<td>{$v[0]}</td>
<td>{$str}</td>
<td>{$v[2]}</td>
<td>{$v[3]}</td>
<td>{$v[4]}</td>
<td>{$v[5]}</td>
<td>{$v[6]}</td>
<td>{$v[7]}</td>
<td>{$v[8]}</td>
<td>{$v[9]}</td>
</tr>";
}
?>
</table>
</body>
</html>
声明：该文观点仅代表作者本人，入门客AI创业平台信息发布平台仅提供信息存储空间服务，如有疑问请联系rumenke@qq.com。
- 上一篇： PHP删除数据库数据
- 下一篇：没有了
