php实现数据查询

<?php
    // 创建连接
    $con = new mysqli("localhost","root","root", "mydb1");
    // 检测连接
    if ($con->connect_error) {
        die("连接失败: " . $con->connect_error);
    }
    //查询语句
    $sql = "SELECT name FROM User";
    $result = $con ->query($sql);
    //输出数据
    if($result->num_rows>0){
        while($row =$result->fetch_assoc()){
            echo $row["name"]."<br>";
        }
    }
    $con->close();
?>