File "lecture.php"

Full Path: /home/analogde/www/Design/Dev tableau/lecture.php
File size: 825 bytes
MIME-type: text/x-php
Charset: utf-8

<?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()]);
}
?>