Gestionnaire de fichiers - Editer - /home/kridsana/webapp.cm.in.th/663012801/u66301280015/Final/config/database.php
Arrière
<?php // config/database.php class Database { private $host = 'localhost'; private $dbname = 'u66301280015'; private $username = 'u66301280015'; private $password = '@2566'; public $conn; public function getConnection() { $this->conn = null; try { $this->conn = new mysqli($this->host, $this->username, $this->password, $this->dbname); if ($this->conn->connect_error) { throw new Exception("Connection failed: " . $this->conn->connect_error); } $this->conn->set_charset("utf8"); } catch(Exception $e) { die("ไม่สามารถเชื่อมต่อกับฐานข้อมูลได้: " . $e->getMessage()); } return $this->conn; } } // ActivityManager class modified for mysqli class ActivityManager { private $db; public function __construct($db_connection) { $this->db = $db_connection; } // เพิ่มกิจกรรม public function addActivity($name, $description, $start_datetime, $end_datetime, $is_mandatory) { $query = "INSERT INTO activities (activity_name, activity_description, start_datetime, end_datetime, is_mandatory) VALUES (?, ?, ?, ?, ?)"; $stmt = $this->db->prepare($query); $stmt->bind_param("ssssi", $name, $description, $start_datetime, $end_datetime, $is_mandatory); return $stmt->execute(); } // ลบกิจกรรม public function deleteActivity($activity_id) { $query = "DELETE FROM activities WHERE activity_id = ?"; $stmt = $this->db->prepare($query); $stmt->bind_param("i", $activity_id); return $stmt->execute(); } // แก้ไขกิจกรรม public function updateActivity($activity_id, $name, $description, $start_datetime, $end_datetime, $is_mandatory) { $query = "UPDATE activities SET activity_name = ?, activity_description = ?, start_datetime = ?, end_datetime = ?, is_mandatory = ? WHERE activity_id = ?"; $stmt = $this->db->prepare($query); $stmt->bind_param("ssssii", $name, $description, $start_datetime, $end_datetime, $is_mandatory, $activity_id); return $stmt->execute(); } // ดึงข้อมูลกิจกรรมทั้งหมด public function getAllActivities() { $query = "SELECT * FROM activities ORDER BY start_datetime DESC"; $result = $this->db->query($query); $activities = []; while ($row = $result->fetch_assoc()) { $activities[] = $row; } return $activities; } // ดึงข้อมูลกิจกรรมเดียว public function getActivity($activity_id) { $query = "SELECT * FROM activities WHERE activity_id = ?"; $stmt = $this->db->prepare($query); $stmt->bind_param("i", $activity_id); $stmt->execute(); $result = $stmt->get_result(); return $result->fetch_assoc(); } // เพิ่มผู้เข้าร่วมกิจกรรม public function addParticipantToActivity($activity_id, $participant_id, $is_required) { $query = "INSERT INTO activity_participants (activity_id, participant_id, is_required) VALUES (?, ?, ?)"; $stmt = $this->db->prepare($query); $stmt->bind_param("iii", $activity_id, $participant_id, $is_required); return $stmt->execute(); } // ลบผู้เข้าร่วมจากกิจกรรม public function removeParticipantFromActivity($activity_id, $participant_id) { $query = "DELETE FROM activity_participants WHERE activity_id = ? AND participant_id = ?"; $stmt = $this->db->prepare($query); $stmt->bind_param("ii", $activity_id, $participant_id); return $stmt->execute(); } // อัพเดทสถานะการเข้าร่วม public function updateAttendanceStatus($activity_id, $participant_id, $status) { $query = "UPDATE activity_participants SET attendance_status = ?, check_in_time = CURRENT_TIMESTAMP WHERE activity_id = ? AND participant_id = ?"; $stmt = $this->db->prepare($query); $stmt->bind_param("sii", $status, $activity_id, $participant_id); return $stmt->execute(); } // ดึงข้อมูลผู้เข้าร่วมทั้งหมดในกิจกรรม public function getActivityParticipants($activity_id) { $query = "SELECT p.*, ap.attendance_status, ap.is_required FROM participants p JOIN activity_participants ap ON p.participant_id = ap.participant_id WHERE ap.activity_id = ?"; $stmt = $this->db->prepare($query); $stmt->bind_param("i", $activity_id); $stmt->execute(); $result = $stmt->get_result(); $participants = []; while ($row = $result->fetch_assoc()) { $participants[] = $row; } return $participants; } // ดึงข้อมูลผู้เข้าร่วมทั้งหมด public function getAllParticipants() { $query = "SELECT * FROM participants WHERE status = 'active' ORDER BY first_name"; $result = $this->db->query($query); $participants = []; while ($row = $result->fetch_assoc()) { $participants[] = $row; } return $participants; } } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Génération de la page: 0.07 |
proxy
|
phpinfo
|
Réglages