標籤：
先貼代碼
<html> <head> <title>資料庫相關</title> </head><body><?php $con = mysql_connect("localhost","root","root"); //連結資料庫 if(!$con){ die(‘串連失敗！‘ . mysql_error()); //判斷是否成功 } /* if(mysql_query("CREATE DATABASE testdb",$con)){ //通過mysql_query 查詢或者發送命令 echo "建立testdb成功"; } else{ echo "失敗原因：" . mysql_error(); //判斷是否建立成功 }*/ mysql_select_db("testdb",$con); //選擇連結剛剛建立的資料庫 $sql = "CREATE TABLE Persons (personID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(personID), FirstName varchar(15), LastName varchar(15), Age int) "; //Mysql 語句 建立表 mysql_query($sql,$con); //執行sql語句 mysql_close($con); //關閉mysql串連 ?> </body></html>
關鍵內容在於
1、連結資料庫
2、建立表
3、根據需求充實表內容
php與Mysql之間的關係以及一些簡單的操作
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
