php读取mysql入门实例

<?php 
$hostname = "localhost:3306"; 
$username = "root"; 
$password = "root"; 
$dbname = "test"; 
 
$conn = mysqli_connect($hostname, $username, $password, $dbname); 
$conn->query("SET NAMES 'gbk'");   
// Check connection 
if (mysqli_connect_errno()){ 
  echo "Failed to connect to MySQL: " . mysqli_connect_error(); 
}  www.jb200.com
 
$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); 
?>