php mysql資料庫操作教程

//串連mysql資料庫

代碼如下	複製代碼
$link = mysql_connect("localhost", "mysql_user", "mysql_password")         or die("could not connect: " . mysql_error());     print ("connected successfully");     mysql_close($link);

 
//查詢mysql欄位名

代碼如下	複製代碼
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); $fields = mysql_list_fields("database1", "table1", $link); $columns = mysql_num_fields($fields); for ($i = 0; $i < $columns; $i++) {     echo mysql_field_name($fields, $i) . " "; }

//查詢資料

代碼如下	複製代碼
$conn=mysql_connect("localhost","phpdb","phpdb")         or die("不能串連資料庫伺服器： ".mysql_error()); mysql_select_db("test",$conn) or die ("不能選擇資料庫: ".mysql_error());  $result = mysql_query("select * from user",$conn); while($row=mysql_fetch_array($result)){  print "name:".$row[1];  print " address:".$row[3];  print " tel:".$row[4];  print " email:".$row[5]; echo

"<br>";
}