php连接数据库

最新推荐文章于 2024-09-17 20:18:24 发布

喵俺第一专栏

最新推荐文章于 2024-09-17 20:18:24 发布

阅读量233

点赞数

分类专栏： Php知识点练习文章标签： php 数据库 postman

本文链接：https://blog.csdn.net/dengfengling999/article/details/124527281

版权

PHP MySQL 数据库连接数据查询表格展示

关键词由CSDN通过智能技术生成

Php知识点练习专栏收录该内容

8 篇文章 5 订阅

订阅专栏

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>Document</title>
</head>
<body>
	<?php
	 $server='localhost';
	 $username='root';
	 $pwd='123456';
	 $dbName='library';
	 
	$connID=mysqli_connect($server,$username,$pwd);

	 if (mysqli_select_db($connID,$dbName)) {
	 	echo "<script>alert('数据库连接成功')</script>";
	 }
	 else{
	 	echo "<script>alert('数据库连接失败')</script>";
	 }
	?>


	<?php
	mysqli_query($connID,'set names utf8');
    $result=mysqli_query($connID,"select * from bookinfo");
	 while ($myrow=mysqli_fetch_object($result)) {
	?>
	 	<tr>
	 		<td align="center"><span><?php echo $myrow->id;?></span></td>
	 		<td align="center"><span><?php echo $myrow->bookname;?></span></td>
	 		<td align="center"><span><?php echo $myrow->bookprice;?></span></td>
	 		<td align="center"><span><?php echo $myrow->bookdate;?></span></td>
	 		<td align="center"><span><?php echo $myrow->booktype;?></span></td>
	 	</tr>
	<?php
	 }
	?>
</body>
</html>