记我的第一个php代码

之前用go写了webservers的接口，想看看前端web如何调用api，将我需要的数据实时展示在前端web上，查了html的资料，查了javascript的资料，又了解了下php，花了很多时间配置php-apache-masql环境（前文），尝试了下php差我本地mysql的代码，很简单，记录下我的第一个php代码

<?php
echo "开始连接数据库...\n";
   $host = "localhost";
   $username  = "root";
   $passwd = "123456";
   $dbname = "analysis_test";

   //建立连接
   $con = mysqli_connect($host, $username, $passwd, $dbname);

   if($con){
      print("已成功建立连接\n");
   }else{
      print("连接失败\n ");
   }
   $sql = "SELECT * FROM websites";
if($result = mysqli_query($con, $sql)){
    if(mysqli_num_rows($result) > 0){
        echo "<table>";
            echo "<tr>";
                echo "<th>id</th>";
                echo "<th>name</th>";
                echo "<th>url</th>";
                echo "<th>country</th>";
            echo "</tr>\n";
        while($row = mysqli_fetch_array($result)){
            echo "<tr>";
                echo "<td>" . $row['id'] . "</td>";
                echo "<td>" . $row['name'] . "</td>";
                echo "<td>" . $row['url'] . "</td>";
                echo "<td>" . $row['country'] . "</td>";
            echo "</tr>\n";
        }
        echo "</table>\n";
        // 释放结果集
        mysqli_free_result($result);
    } else{
        echo "找不到与您的查询匹配的记录。";
    }
} else{
    echo "错误：无法执行 $sql. " . mysqli_error($con);
}
 
//关闭连接
mysqli_close($con);
?>

开始连接数据库...
已成功建立连接
<table><tr><th>id</th><th>name</th><th>url</th><th>country</th></tr>
<tr><td>1</td><td>Google</td><td>https://www.google.cm/</td><td>USA</td></tr>
<tr><td>2</td><td>??</td><td>https://www.taobao.com/</td><td>CN</td></tr>
<tr><td>3</td><td>????</td><td>http://www.runoob.com/</td><td>CN</td></tr>
<tr><td>4</td><td>??</td><td>http://weibo.com/</td><td>CN</td></tr>
<tr><td>5</td><td>Facebook</td><td>https://www.facebook.com/</td><td>USA</td></tr>
</table>

下面看看将数据显示到web及html配合控件输出
细心地同学也许发现上面中文乱码了，有空研究