湖濱散記部落格的樹心幽徑[login][主頁]
449:20181218mysql資料庫連線查詢網頁程式 a1.php (用來列出selldb資料庫中custs資料表的第1筆資料)

<body bgcolor=cyan>

<img src=dog.png width=100>

<?php

$con = mysqli_connect('localhost', 'root', 'abc123abc123', 'selldb');

$sql= "select id,name,amount,tel from custs";

$query     = mysqli_query($con, $sql);
$row = mysqli_fetch_array($query);

echo  $row['id'] . ":" . $row['name'] . ":" . $row['amount'] . ":" . $row['tel'] . "<br>";

$row = mysqli_fetch_array($query);echo  $row['id'] . ":" . $row['name'] . ":" . $row['amount'] . ":" . $row['tel'] . "<br>";
?>

 

</body>

 


select id,article_id,topic,text from lt_articles_text where article_id =449; ok. update lt_articles set num_reads=num_reads +1 where id=449; ok.