php读取mysql数据库入门实例

php读取mysql数据库入门实例

完整代码：

3. $hostname = "localhost:3306";

4. $username = "root";
5. $password = "root";
6. $dbname = "test";
8. $conn = mysqli_connect($hostname, $username, $password, $dbname);
9. $conn->query("SET NAMES 'gbk'");
10. // 检测数据连接
11. if (mysqli_connect_errno()){
12. echo "Failed to connect to MySQL: " . mysqli_connect_error();
13. }
15. $sql = "select * from keyword";
16. $result = mysqli_query($conn, $sql);

17. //输出mysql数据查询结果

18. while($row = mysqli_fetch_array($result)){
19. echo $row['keycId'] . " : " .$row['keycontent'] . " : " . $row['keycause'];
20. echo "
    ";
21. }
23. // 关闭连接
24. mysqli_close($conn);
25. ?>