PHP를 사용하여 WeChat 애플릿의 호텔 예약 기능을 구현하는 방법은 무엇입니까?

CREATE TABLE hotels ( id INT(11) PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, address VARCHAR(255) NOT NULL, description TEXT, price DECIMAL(10, 2) NOT NULL ); CREATE TABLE bookings ( id INT(11) PRIMARY KEY AUTO_INCREMENT, hotel_id INT(11) NOT NULL, check_in_date DATE NOT NULL, check_out_date DATE NOT NULL, guest_name VARCHAR(100) NOT NULL, guest_email VARCHAR(100) NOT NULL, FOREIGN KEY (hotel_id) REFERENCES hotels(id) ON DELETE CASCADE );

        

         로그인 후 복사
        
       

connect_errno) { die("Failed to connect to MySQL: " . $conn->connect_error); }

query("SELECT * FROM hotels"); if ($result->num_rows > 0) { $hotels = array(); while ($row = $result->fetch_assoc()) { $hotels[] = $row; } echo json_encode($hotels); } else { echo json_encode(array()); } $conn->close();

prepare("INSERT INTO bookings (hotel_id, check_in_date, check_out_date, guest_name, guest_email) VALUES (?, ?, ?, ?, ?)"); $stmt->bind_param("issss", $hotel_id, $check_in_date, $check_out_date, $guest_name, $guest_email); if ($stmt->execute()) { echo "Booking created successfully"; } else { echo "Failed to create booking"; } $stmt->close(); $conn->close();

// 获取酒店列表 wx.request({ url: 'https://your-domain.com/index.php', success: function(res) { console.log(res.data); // TODO: 处理酒店列表数据 } }); // 创建酒店预订 wx.request({ url: 'https://your-domain.com/create_booking.php', method: 'POST', data: { hotel_id: 1, check_in_date: '2021-01-01', check_out_date: '2021-01-05', guest_name: 'John Doe', guest_email: 'johndoe@example.com' }, success: function(res) { console.log(res.data); // TODO: 处理预订结果数据 } });