<?php
header('Content-Type: application/json');
$host = "analogdepat.mysql.db";
$dbname = "analogdepat";
$username = "analogdepat";
$password = "Un92pac007";
//$pdo = new PDO('mysql:host=localhost;dbname=ta_base', 'utilisateur', 'mot_de_passe');
$pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
$stmt = $pdo->query("SELECT data_json FROM json_data ORDER BY id DESC LIMIT 1");
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if ($row) {
echo json_encode(['success' => true, 'data_json' => $row['data_json']]);
} else {
echo json_encode(['success' => false]);
}
} catch (Exception $e) {
echo json_encode(['success' => false, 'error' => $e->getMessage()]);
}
?>