20210104用PHP程式列出selldb資料庫的custs資料表的所有資料錄(a1.php)
跳至導覽
跳至搜尋
<body bgcolor=lightyellow>
<img src=dog.png width=50>
<hr color=red>
<?php
$con = mysqli_connect('localhost', 'root', 'abc123abc123', 'selldb');
$sql= "select id,name,amount,tel from custs";
$query = mysqli_query($con, $sql);
while ($row = mysqli_fetch_array($query)){
echo $row['id'] . ":" . $row['name'] . ":" . $row['amount'] . "<br>";
}
mysqli_close ($con);
?>
<hr color=green>
<img src=cat.png width=50>
</body>