展开全部
项目根62616964757a686964616fe59b9ee7ad9431333431346338目录的1文件夹下新建index.phphtml>
查询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 "
echo "
IDNAME";while ($row = $query->fetch_assoc()) {
echo "
" . $row['id'] . "" . $row['name'] . "";}
echo "
";$mysqli->close();
}
?>
效果