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. // Check connection
11. if (mysqli_connect_errno()){
12. echo "Failed to connect to MySQL: " . mysqli_connect_error();
13. } bbs.it-home.org
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. ?>

复制代码