PHP之查询数据库表

<?php 
$servername = "localhost";
$username = "1_2qky_cn";
$password = "132456";
$dbname = "1_2qky_cn";
 
// 创建连接
$conn = mysqli_connect($servername, $username, $password,$dbname);
 
// 检测连接
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "数据库连接成功";
?>

<?php


$selectdb=mysqli_select_db($conn,"1_2qky_cn");
$res=mysqli_query($conn,"select * from data");
while($myrow=mysqli_fetch_assoc($res)){
    echo $myrow['id'].'-'.$myrow['name'].'<br/>';
}

 ?>