File "get_column_name.php"

Full Path: /home/analogde/www/New folder/get_column_name.php
File size: 1.77 KB
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($_POST['id'])) {
    $id = $_POST['id'];
    $sql_details = "SELECT * FROM table_DB_planning WHERE id = ?";
    $stmt = $conn->prepare($sql_details);
    $stmt->bind_param('i', $id);
    $stmt->execute();
    $result = $stmt->get_result();

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        echo json_encode([$row['column_name']]);
    } else {
        echo json_encode([]);
    }

    $stmt->close();
}
  */  

if (isset($_POST['id'])) {
    $id = intval($_POST['id']); // Assurez-vous que l'ID est un entier pour éviter les injections SQL
    $sql_details = "SELECT * FROM table_DB_planning WHERE id = $id";
    $result = $conn->query($sql_details);

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        echo json_encode([[$row['column_name']]]); // Renvoie un tableau contenant un tableau avec la valeur de column_name
    } else {
        echo json_encode([]);
    }
    $conn->close();
}
/*
    if (isset($_POST['id'])) {
        $id = intval($_POST['id']); // Assurez-vous que l'ID est un entier pour éviter les injections SQL
        $sql_details = "SELECT * FROM table_DB_planning WHERE id = $id";
        $result = $conn->query($sql_details);
    
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            echo json_encode([$row['column_name']]);
        } else {
            echo json_encode([]);
        }
    }

$conn->close();*/

?>