File "get_taches.php"

Full Path: /home/analogde/www/Chart burndown/get_taches.php
File size: 952 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";

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