<?php

// 这是一个简单的示例代码，用于展示如何创建一个科研管理平台的基本功能。

class ResearchManagementPlatform {

private $db;

public function __construct($host, $username, $password, $database) {

$this->db = new mysqli($host, $username, $password, $database);

if ($this->db->connect_error) {

die("连接失败: " . $this->db->connect_error);

}

}

public function addResearchProject($projectName, $principalInvestigator, $startDate, $endDate) {

$sql = "INSERT INTO research_projects (name, principal_investigator, start_date, end_date) VALUES ('$projectName', '$principalInvestigator', '$startDate', '$endDate')";

if ($this->db->query($sql) === TRUE) {

echo "新记录插入成功";

} else {

echo "Error: " . $sql . "
" . $this->db->error;

}

}

public function getResearchProjects() {

$sql = "SELECT * FROM research_projects";

$result = $this->db->query($sql);

return $result->fetch_all(MYSQLI_ASSOC);

}

}

// 示例使用

$platform = new ResearchManagementPlatform('localhost', 'root', '', 'research_management');

$platform->addResearchProject('智慧城市研究', '张三', '2023-01-01', '2024-12-31');

$projects = $platform->getResearchProjects();

print_r($projects);

?>