html input 查询mysql

需要PHP+HTML页面代码，代码，源代码~~~~
现有表1 account，表2 name，其中表1有id user字段，表2有 id、userid、name三个字段。表1的id=表2的userid。现在需要用表1的user字段查询出表2的id和name字段，查询语句如下select b.id,b.name from account a,name b where a.id=b.userid and a.user="$user"因为不会php和html，现在想在html里面有个input框，输入的数据点击查询后在当页显示出查询结果出来，要怎么写，各位大神求帮忙。。对了，数据库连接是 localhost root 123456，库名test

推荐答案 2019-04-08

项目根目录的1文件夹下新建index.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>查询</title>
</head>
<body>
<form method="post">
    <input type="text" name="keyword" value="">
    <input type="submit" value="查询">
</form>
<?php
if (isset($_POST['keyword']) && !empty($_POST['keyword'])) {
$host = "localhost";
$username = "root";
$password = "123456";
$database = "test";
$mysqli = new mysqli($host, $username, $password, $database);
if ($mysqli->connect_errno) {
echo '数据库连接错误';
exit;
}
//设置数据库编码格式
$mysqli->set_charset("UTF8");
/*编写sql获取分页数据 SELECT*FROM 表名 LIMIT 起始位置，显示条数*/

$keyword = $_POST['keyword'];
$sql = "select b.id,b.name from account a,name b where a.id=b.userid and a.user='" . $keyword . "'";
/*把sql语句传送到数据库*/
$query = $mysqli->query($sql);
echo "<table border='#CCF solid 1px'>";
echo "<tr><td>ID</td><td>NAME</td></tr>";
while ($row = $query->fetch_assoc()) {
echo "<tr><td>" . $row['id'] . "</td><td>" . $row['name'] . "</td></tr>";
}
echo "</table>";
$mysqli->close();
}
?>
</body>
</html>

效果