File "get_json_data.php"

Full Path: /home/analogde/www/Resize_Quashai/New folder/get_json_data.php
File size: 925 bytes
MIME-type: text/x-php
Charset: utf-8

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

$conn = new mysqli($host, $username, $password, $dbname);

// Vérification de la connexion
if ($conn->connect_error) {
    die("Erreur de connexion : " . $conn->connect_error);
}

if (isset($_GET['column_name'])) {
    $columnName = $_GET['column_name'];
    $sql = "SELECT column_name FROM table_DB_planning WHERE column_name = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("s", $columnName);
    $stmt->execute();
    $result = $stmt->get_result();

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        echo json_encode($row);
    } else {
        echo json_encode(["error" => "Aucun enregistrement trouvé."]);
    }

    $stmt->close();
} else {
    echo json_encode(["error" => "Paramètre manquant."]);
}

$conn->close();
?>