php读取mysql数据库入门实例
完整代码:
-
-
$hostname = "localhost:3306";
- $username = "root";
- $password = "root";
- $dbname = "test";
-
- $conn = mysqli_connect($hostname, $username, $password, $dbname);
- $conn->query("SET NAMES 'gbk'");
- // 检测数据连接
- if (mysqli_connect_errno()){
- echo "Failed to connect to MySQL: " . mysqli_connect_error();
- }
-
- $sql = "select * from keyword";
- $result = mysqli_query($conn, $sql);
//输出mysql数据查询结果
- while($row = mysqli_fetch_array($result)){
- echo $row['keycId'] . " : " .$row['keycontent'] . " : " . $row['keycause'];
- echo "
";
- }
-
- // 关闭连接
- mysqli_close($conn);
- ?>
-
复制代码
|