php读取mysql数据库入门实例

<?php 
$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 "<br>"; 
}
 
// 关闭连接  
mysqli_close($conn); 
?>