医院科研管理系统

<?php

// 连接数据库

$conn = mysqli_connect("localhost", "username", "password", "database_name");

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// 获取表单提交的数据

$title = $_POST['title'];

$author = $_POST['author'];

$institution = $_POST['institution'];

// 插入数据到数据库

$sql = "INSERT INTO results (title, author_id, institution_id) VALUES ('$title', (SELECT id FROM authors WHERE name='$author'), (SELECT id FROM institutions WHERE name='$institution'))";

if (mysqli_query($conn, $sql)) {

echo "记录插入成功";

} else {

echo "Error: " . $sql . "
" . mysqli_error($conn);

融合服务门户

}

mysqli_close($conn);

?>