[php][mysql]在线数据查询

最新推荐文章于 2023-05-04 21:11:58 发布

捞氘河水怪

最新推荐文章于 2023-05-04 21:11:58 发布

阅读量232

点赞数

分类专栏： MySQL php html 文章标签： php mysql 开发语言

本文链接：https://blog.csdn.net/qq_37301470/article/details/121268949

版权

html 同时被 3 个专栏收录

10 篇文章 1 订阅

订阅专栏

php

8 篇文章 0 订阅

订阅专栏

MySQL

6 篇文章 0 订阅

订阅专栏

php程序 phpmysql.php

<?php
	header("Content-type:text/html;charset=utf-8");
	

	if(empty($_POST)){
		
		echo "<a href='1.html'>你找谁</a>";
	}
	else
	{
		$name=$_POST["name"];
		$link=mysqli_connect("localhost","root","root","test","3307");

		if(empty($link))
		{
			echo "wrong in connecting to database!";

		}
		else
		{
			$sql="select * from web where name ='$name'";
			$result=mysqli_query($link,$sql);
			$res=mysqli_fetch_assoc($result);
			
			if ($res) {
				echo "find it <br>";
				foreach ($res as $name => $i) {
					echo "$i</br>";
				}
				
			}else
			{
				echo "no such guy";

			}
			
		}	
	}

查询页面 index.html

<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<title>select</title>
</head>
<body>
	<form action="phpmysql.php" method="post">
		<input type="text" name="name">
		<input type="submit" value="查询">
		
	</form>
</body>
</html>