<?php
// 示例代码：创建一个简单的数据库连接类
class Database {
private $host = "localhost";
private $db_name = "university_portal";
private $username = "root";
private $password = "";
private $conn;
public function connect() {
$this->conn = null;
try {
$this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);
$this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $exception) {
echo "Connection error: " . $exception->getMessage();
}
return $this->conn;
}
}
// 示例代码：创建一个工程学院信息表
function createEngineeringSchoolTable($conn) {
$sql = "CREATE TABLE IF NOT EXISTS engineering_school (
id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
faculty VARCHAR(255) NOT NULL,
course VARCHAR(255) NOT NULL,
enrollment INT(11) NOT NULL
)";
if ($conn->query($sql) === TRUE) {
echo "Table engineering_school created successfully";
} else {
echo "Error creating table: " . $conn->error;
}
}
// 主函数
function main() {
$database = new Database();
$conn = $database->connect();
createEngineeringSchoolTable($conn);
}
main();
?>