我们提供统一消息系统招投标所需全套资料,包括统一消息系统介绍PPT、统一消息系统产品解决方案、
统一消息系统产品技术参数,以及对应的标书参考文件,详请联系客服。
CREATE TABLE student (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
age INT,
gender CHAR(1),
major VARCHAR(100)
);
CREATE TABLE teacher (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
department VARCHAR(100)
);
CREATE TABLE course (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
teacher_id INT,
FOREIGN KEY (teacher_id) REFERENCES teacher(id)
);
]]>
$conn = new mysqli('localhost', 'username', 'password', 'unified_info_platform');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM student";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "Name: " . $row["name"]. " - Age: " . $row["age"]. "
";
}
} else {
echo "0 results";
}
$conn->close();
?>
]]>