php操作mysql数据库，返回结果展示在表格里

mysqli_connect()连接数据库
mysqli_select_db()选择库；
mysqli_query()操作语句
mysql_fetch_array()循环执行语句
例子：

<?php
	$conn=mysqli_connect("localhost","php","");
	mysqli_select_db($conn,"php");
	//mysqli_query($conn,"set names utf8");
	//$sql="insert into php.php values(2,'jcy',88,15);";
    
	
	//$sql="insert into php.php values((2,'jcy',88,15)),(3,'dmy',77,15),(1,'wyd',97,16),(4,'zhx',75,15))";
	
	//mysqli_query($conn,$sql);
	$result = mysqli_query($conn,"select * from php");
	echo "<table border='1'>
	<tr>
	<th>id</th>
	<th>name</th>
	<th>score</th>
	<th>grade</th>
	</tr>";
	while($row=mysqli_fetch_array($result)){
		echo "<tr>";
		echo "<td>".$row['id']."</td>";
		echo "<td>".$row['name']."</td>";
		echo "<td>".$row['score']."</td>";
		echo "<td>".$row['grade']."</td>";
		echo "</tr>";
	}
	echo "</table>";
	mysqli_close($conn);
?>

结果：