day3：php连接数据库，输出数据

1，win10系统安装phpstudy2018

2，php连接数据库，输出数据，我的代码如下：

<?php
header("Content-Type: text/html; charset=UTF-8");
 $servername = "localhost" ;
$username = "username" ;
$password = "密码" ;
$dbname = "test1";
// 创建连接
$conn = new mysqli ($servername ,$username ,$password ,$dbname);
// 检测连接 
if ($conn->connect_error ){die ("false：".$conn->connect_error );
}else { echo "true"."<br>" ;}
$sql = "SELECT * FROM goods" ;
$results = mysqli_query($conn, $sql);
if (mysqli_num_rows($results)>0) { // 输出数据 
    while ($row = mysqli_fetch_assoc($results)){
     echo "   ID：   ".$row["id"]."   名称：   ".$row["name"]."<br>";
    } 
}
else echo "none";
 $conn->close();
?>