File "save_mysql.php"

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

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

// Récupérer les données JSON envoyées par la requête POST
$data = file_get_contents('php://input');

// 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 d'insertion
$stmt = $conn->prepare("INSERT INTO xyz_table_agenda (data_content) VALUES (?)");
$stmt->bind_param("s", $data);

if ($stmt->execute()) {
    echo json_encode(["status" => "success", "message" => "Data saved successfully"]);
} else {
    echo json_encode(["status" => "error", "message" => "Error saving data: " . $stmt->error]);
}

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