PHP：PHP7连接数据库读取数据

最新推荐文章于 2021-03-19 05:19:08 发布

hahahafree

最新推荐文章于 2021-03-19 05:19:08 发布

阅读量2.2k

点赞数 1

分类专栏： PHP 数据库 Web 文章标签： PHP

本文链接：https://blog.csdn.net/weixin_43731793/article/details/98479151

版权

PHP 同时被 3 个专栏收录

138 篇文章 1 订阅

订阅专栏

Web

80 篇文章 0 订阅

订阅专栏

数据库

64 篇文章 0 订阅

订阅专栏

PHP连接数据库

<?php 
$servername = "localhost";
$username = "root";
$password = "0000012";
$dbname = "myweb";
 
// 创建连接
$conn = mysqli_connect($servername, $username, $password,$dbname);
 
// 检测连接
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "连接成功";

$sql = "select * from user";
$rst = mysqli_query($conn,$sql);
 ?>
<!doctype html>
<html>
<head>
	<meta charset="UTF-8">
	<title>index</title>
	<style>
		*{
			font-family: 微软雅黑;
		}
	</style>
	<link rel="stylesheet" href="bs/css/bootstrap.min.css">
	<script src='bs/js/jquery.min.js'></script>
	<script src='bs/js/bootstrap.min.js'></script>
</head>
<body>
	<div class="container">
		<h2 class='page-header'>查看用户:</h2>
		<table class='table table-bordered table-hover'>
			<tr>
				<th>编号</th>
				<th>用户名</th>
				<th>密码</th>
				<th>删除</th>
			</tr>
			<?php 
			while($row=mysqli_fetch_assoc($rst)){
				echo "<tr>";
				echo "<td>{$row['id']}</td>";
				echo "<td>{$row['usename']}</td>";
				echo "<td>{$row['password']}</td>";
				
				echo "</tr>";
			}
			 ?>
		</table>
	</div>	
</body>

</html>

测试删除ID脚本

<?php 
$servername = "localhost";
$username = "root";
$password = "133nubia022";
$dbname = "myweb";
 
// 创建连接
$conn = mysqli_connect($servername, $username, $password,$dbname);
 


$sql = "select * from user";
$rst = mysqli_query($conn,$sql);
 ?>
<!doctype html>
<html>
<head>
	<meta charset="UTF-8">
	<title>index</title>
	<style>
		*{
			font-family: 微软雅黑;
		}
	</style>
	<link rel="stylesheet" href="bs/css/bootstrap.min.css">
	<script src='bs/js/jquery.min.js'></script>
	<script src='bs/js/bootstrap.min.js'></script>
</head>
<body>
	<div class="container">
		<h2 class='page-header'>查看用户:</h2>
		<table class='table table-bordered table-hover'>
			<tr>
				<th>编号</th>
				<th>用户名</th>
				<th>密码</th>
				<th>删除</th>
			</tr>
			<?php 
			while($row=mysqli_fetch_assoc($rst)){
				echo "<tr>";
				echo "<td>{$row['id']}</td>";
				echo "<td>{$row['usename']}</td>";
				echo "<td>{$row['password']}</td>";
				echo "<td><a href='javascript:' class='del' id='{$row['id']}'>删除</a></td>";
				echo "</tr>";
			}
			 ?>
		</table>
	</div>	
</body>
<script>
$('.del').click(function(){
    id=this.id;
    console.warn(id);
});
</script>