File "load_mysql.php"

Full Path: /home/analogde/www/DOSSIER/Json/load_mysql.php
File size: 778 bytes
MIME-type: text/x-php
Charset: utf-8

<?php
$servername = "analogdepat.mysql.db";
$dbname = "analogdepat";
$username = "analogdepat";
$password = "Un92pac007";

// Connexion à la base de données
$conn = new mysqli($servername, $username, $password, $dbname);

// Vérifier la connexion
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Préparer et exécuter la requête de sélection
$stmt = $conn->prepare("SELECT data_content FROM xyz_table_agenda ORDER BY id DESC LIMIT 1");
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    echo $row['data_content'];
} else {
    echo json_encode(["status" => "error", "message" => "No data found"]);
}

$stmt->close();
$conn->close();
?>