Home > Article > Backend Development > How to write a simple online consultation system through PHP
How to write a simple online consultation system through PHP
With the continuous development of Internet technology, more and more medical services have begun to shift online. As one of the forms, the online consultation system gives patients and doctors a more convenient and efficient way to communicate. This article will introduce how to write a simple online consultation system through PHP and provide specific code examples.
Development environment preparation
Before starting development, we need to prepare the corresponding development environment. First, you need a server equipped with a PHP interpreter. It is recommended to use Apache or Nginx as the web server. Secondly, we need to install MySQL as a database to store patient and doctor information and consultation records. Finally, we need a code editor, it is recommended to use Sublime Text or Visual Studio Code.
Create database
Create a database named "online_consultation" in MySQL and create the following three tables:
The following is the SQL sample code to create a table:
CREATE TABLE patients ( id INT(11) AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT(3) NOT NULL, gender ENUM('male', 'female') NOT NULL ); CREATE TABLE doctors ( id INT(11) AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, title VARCHAR(50) NOT NULL, specialty VARCHAR(100) NOT NULL ); CREATE TABLE consultations ( id INT(11) AUTO_INCREMENT PRIMARY KEY, patient_id INT(11) NOT NULL, doctor_id INT(11) NOT NULL, consultation_time DATETIME NOT NULL, content TEXT NOT NULL );
Write PHP code
First, create a file named "index.php " file serves as the entry file of the system. In this file, we can add some public HTML and CSS code to beautify the page.
<!DOCTYPE html> <html> <head> <title>在线问诊系统</title> <style> /* 添加一些自定义的样式 */ </style> </head> <body> <h1>在线问诊系统</h1> <!-- 页面内容 --> </body> </html>
Next, we write PHP code to implement the core functions of the consultation system. Here we take patient registration and appointment consultation as an example.
<?php // 数据库连接配置 $host = 'localhost'; $username = 'root'; $password = 'password'; $database = 'online_consultation'; try { // 连接数据库 $conn = new PDO("mysql:host=$host;dbname=$database", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // 患者注册 if ($_SERVER['REQUEST_METHOD'] === 'POST' && !empty($_POST['patient_name']) && !empty($_POST['patient_age']) && !empty($_POST['patient_gender'])) { $name = $_POST['patient_name']; $age = $_POST['patient_age']; $gender = $_POST['patient_gender']; $stmt = $conn->prepare("INSERT INTO patients (name, age, gender) VALUES (:name, :age, :gender)"); $stmt->bindParam(':name', $name); $stmt->bindParam(':age', $age); $stmt->bindParam(':gender', $gender); $stmt->execute(); } // 患者预约问诊 if ($_SERVER['REQUEST_METHOD'] === 'POST' && !empty($_POST['doctor_id']) && !empty($_POST['patient_id']) && !empty($_POST['consultation_time']) && !empty($_POST['content'])) { $doctorId = $_POST['doctor_id']; $patientId = $_POST['patient_id']; $consultationTime = $_POST['consultation_time']; $content = $_POST['content']; $stmt = $conn->prepare("INSERT INTO consultations (patient_id, doctor_id, consultation_time, content) VALUES (:patient_id, :doctor_id, :consultation_time, :content)"); $stmt->bindParam(':patient_id', $patientId); $stmt->bindParam(':doctor_id', $doctorId); $stmt->bindParam(':consultation_time', $consultationTime); $stmt->bindParam(':content', $content); $stmt->execute(); } } catch(PDOException $e) { echo "数据库连接失败: " . $e->getMessage(); } ?>
Create front-end pages
In the "index.php" file, we can add some front-end pages to interact with users. For example, you can add a patient registration form and a consultation appointment form.
<h2>患者注册</h2> <form method="POST" action=""> <input type="text" name="patient_name" placeholder="姓名" required> <input type="number" name="patient_age" placeholder="年龄" required> <select name="patient_gender" required> <option value="male">男</option> <option value="female">女</option> </select> <button type="submit">注册</button> </form> <h2>预约问诊</h2> <form method="POST" action=""> <input type="number" name="doctor_id" placeholder="医生ID" required> <input type="number" name="patient_id" placeholder="患者ID" required> <input type="datetime" name="consultation_time" placeholder="问诊时间" required> <textarea name="content" placeholder="问诊内容" required></textarea> <button type="submit">预约</button> </form>
System Test
After completing the writing of the above code, save and upload it to the Web server. Enter the server address in the browser to access the online consultation system and register and make an appointment for consultation.
Through the above method, we can write a simple online consultation system through PHP. Of course, this is just a basic implementation, and there are many functions that can be further improved, such as adding management of doctor information, patient rescheduling and cancellation, etc. I hope this article can bring you some inspiration and help you start developing your own online consultation system.
The above is the detailed content of How to write a simple online consultation system through PHP. For more information, please follow other related articles on the PHP Chinese website!