Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Chart burndown
:
get_taches.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php // Paramètres de connexion à la base de données $servername = "analogdepat.mysql.db"; $username = "analogdepat"; $password = "Un92pac007"; $dbname = "analogdepat"; // Création de la connexion $conn = new mysqli($servername, $username, $password, $dbname); // Vérification de la connexion if ($conn->connect_error) { die(json_encode(['status' => 'error', 'message' => 'Connexion échouée : ' . $conn->connect_error])); } // Requête pour récupérer toutes les tâches $sql = "SELECT id, task_index, task_name, task_duration, created_at, updated_at FROM tasks_DB ORDER BY created_at DESC"; $result = $conn->query($sql); $taches = []; if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $taches[] = $row; } } // Fermeture de la connexion $conn->close(); // Retour des données au format JSON header('Content-Type: application/json'); echo json_encode($taches); ?>