File "read_estimation_001.php"

Full Path: /home/analogde/www/Chart burndown/read_estimation_001.php
File size: 839 bytes
MIME-type: text/x-php
Charset: utf-8

<?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);
?>