Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
MDPH
/
Json
:
load_mysql.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?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(); ?>