<?php
$con=mysql_connect("localhost","root","");
if(!$con){
die("连接失败".mysql_error);
}
mysql_select_db("school",$con);
$result=mysql_query("SELECT * FROM student
WHERE Sex='man'");
//select中的where语句用于筛选
while($row=mysql_fetch_array($result)){
echo $row['Name']." ".$row['Sex'];
echo "<br/>";
}
mysql_close($con);
?>
![](https://i-blog.csdnimg.cn/blog_migrate/4ab0a8a388373d03aa3ce851c8ad6d8f.jpeg)