php基本的鏈接mysql數據庫在函數為
$c = mysql_connect("localhost","root","password");連上數據庫后,選擇數據庫
$db = mysql_select_db('you_db'); //數據庫的名稱查詢數據庫,及打印數據
$sql = "select * from you_table ";
$res = mysql_query($sql);
if (!$res) {
die("could get the res:\n" . mysql_error());
}
while ($row = mysql_fetch_assoc($res)) {
print_r($row);
}關閉打開的數據庫
mysql_close($con);
