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
:
read_estimation_001.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"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die(json_encode(["error" => "Connection failed: " . $conn->connect_error])); } // Requête pour récupérer toutes les tâches $sql = "SELECT task_index, task_name, task_duration FROM tasks_DB"; $result = $conn->query($sql); if ($result === false) { die(json_encode(["error" => "Query failed: " . $conn->error])); } $tasks = []; while ($row = $result->fetch_assoc()) { $tasks[] = [ 'index' => $row['task_index'], 'name' => $row['task_name'], 'duration' => $row['task_duration'] ]; } $conn->close(); echo json_encode($tasks); ?>