PHP连接数据库

 

//连接mysql服务器
$conn=@mysqli_connect("localhost","root","123456") or die("连接服务器失败")
.mysqli_connect_error();
//选择mysql数据库
$select=mysqli_select_db($conn,'teacher');
//设置数据库编码格式
mysqli_query($conn,"set names utf8");
//执行sql语句
$result=mysqli_query($conn,"select * from teach_info");
echo "<table border=1>";
echo "<tr><td>教师编号</td><td>教师姓名</td><td>教师所教班级</td><td>教师电话号码</td></tr>";

while($arr=mysqli_fetch_array($result)){
    echo "<tr><td>$arr[teachid]</td><td>$arr[teachname]</td><td>$arr[teachclass]</td><td>$arr[teachtel]</td></tr>";
}
echo "</table>";
mysqli_free_result($result);
mysqli_close($conn);