<?php//連線資料庫$con = mysql_connect("localhost","peter","abc123");if (!$con) { die("Could not connect: " . mysql_error()); }// 建立資料庫if (mysql_query("CREATE DATABASE my_db",$con)) { echo "Database created"; }else { echo "Error creating database: " . mysql_error(); }// 在資料庫 my_db 中建立Persons資料表mysql_select_db("my_db", $con);$sql = "CREATE TABLE Persons (FirstName varchar(15),LastName varchar(15),Age int)";mysql_query($sql,$con);//在資料表Persons中新增兩條資料mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ("Peter", "Griffin", "35")");mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ("Glenn", "Quagmire", "33")");//關閉連結mysql_close($con);?>
<?php//連線資料庫$con = mysql_connect("localhost","peter","abc123");if (!$con) { die("Could not connect: " . mysql_error()); }// 建立資料庫if (mysql_query("CREATE DATABASE my_db",$con)) { echo "Database created"; }else { echo "Error creating database: " . mysql_error(); }// 在資料庫 my_db 中建立Persons資料表mysql_select_db("my_db", $con);$sql = "CREATE TABLE Persons (FirstName varchar(15),LastName varchar(15),Age int)";mysql_query($sql,$con);//在資料表Persons中新增兩條資料mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ("Peter", "Griffin", "35")");mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ("Glenn", "Quagmire", "33")");//關閉連結mysql_close($con);?>